Problem executing calculate method two times.
Posted: Tue Feb 06, 2018 8:24 pm
If I execute a code like this:
Obviuously, this is a very simple sample of a tool of my project. But the problem is that whe I try execute Calculate morte than one time, the formula values gets 0. Somebody knows what's the problem? is it a bug? Thank you
Code: Select all
with TXLSReadWriteII5.Create(nil) do
try
LoadFromFile('c:\tmp.xls');
Sheet[0].AsFloat[1,1]:=12;
Calculate;
//Shows the C2 formula content, and is a correct value
ShowMessage(FloatToStr(Sheet[0].AsFloatRef['C2']));
Calculate;
//Shows the C2 formula content, and is not correct. The value is 0
ShowMessage(FloatToStr(Sheet[0].AsFloatRef['C2']));
finally
Free;
Free;