CalcBuilder Forum

Excel Spreadsheet

User nashm 2017-07-12 20:04:04

I have imported excel spreadsheet with iterative calculations, so several of my input cells have the same value (example, row cells from F5 to P5 will have the same value). Is there a way that I can, in mu calculator, define cell F5 as an input and somehow populate other cells with the same value of F5 without importing all of them into the calculator?

Moonsoft support 2017-07-13 08:29:21

Hi,
not sure if we've understood properly the question, sorry. If you want to 'send' same input value from the page form to several cells of the spreadsheet you can do it at the mapping section

myvalue -> F5
myvalue -> G5
..etc

but if you don't want to use this mapping, you can copy that value at the spreadsheet instead, including only the first mapping

myvalue -> F5

and then at the excel sheet you can spread/copy this same value using formulas

G5 =F5
H5 =F5

etc..

not sure if this solves your question, please let us know further details in case you need additional help

Regards

...
Support/development 40 hours

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

Buy now!
...
Support/development

Perfect for small code changes or to correct any bug at your site

Buy now!