I am trying to write the random formula (“=rand()”) in an Excel cell…fetching this formula from the config file.
The formula is correctly written into the cell, but it is not “activated”.
When i click into the cell and hit enter, it works. Can someone help:
Can i do this without having to activate the cell?
If not, what is the most convenient way to do so (also considering that one may have to activate many many cells)?
these are the screenshots (not necessarily in the order of execution).
the formula is written correctly in the Excel cells - only are they not “activated”. E.g. when i use " '=2+2 " as formula in the config file, it works fine.