XLR8: formulas disappear in xlsx template file

[Ilkka72]

I read a xlsx template file with formulas. When I add data about a different sheet and save the file with a different name so the formulas have disappeared this new file. How can I fix this?

[Ilkka72]

In template file formula was =IF(MeasuringData!B2;MeasuringData!B2;""). This removes the formula in saved files if value is empty.

Formula =MeasuringData!B2 work ok. But now empty value are 0.0.

[Hans-Joachim]

Hello IIkka72,

i tried to reproduce your problem exactly how you descriped and i see the problem in the format .xlsx!

A current workaround would be to use the .xls format which works but i don´t know if you are able to use it!

I will have to investigate this problem!

Thanks for your Feedback!

Greetings,

Hajo