CalcBuilder Forum

Excel Spreadsheet

Usuario 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

...
CalcBuilder

Create dynamic calculators

Buy now!
...
List Manager

Build different lists for your site

Buy now!