CalcBuilder Forum

Formulas when exporting to Excel?

User TheFencepedia 2026-02-04 02:09:35

Hi there,

I am thinking of building some "done for you" Excel sheets for our users, but I wanted to know if the output would have the formulas on them, as long as I map the output fields to the output layout?

I want the user to be able to enter some prices and automatically calculate something.

Thanks!

Moonsoft support 2026-02-04 09:47:00

Hi,
you can't use the default export to excel function as an 'spreadsheet generator'. If you enable this function, your users will get an excel with the list of inputs, and the outputs (of course, calculated using your formulas, either from the php or your spreadsheet), and it will output the results already calculated. In other words, the excel will contain the calculated results, but not the formulas, not sure if this is what you're looking for.

If it's not the case, as it always happens with calcbuilder, you could build any specific function inside the php section, maybe creating/saving a working excel with formulas at your server, and then output the link for users to download. Some more advanced php knowledge would be needed to build this custom code, please let us know if you need further help.

Best regards
Silvia Martín
Moonsoft Team

...
CalcBuilder

Create dynamic calculators

Buy now!
...
Support/development 40 hours

With the peace of mind of having a professional team at your service (20% discount)

Buy now!