Hi!
I am using then new XLSReadWriteII 5.1 but I am having problems saving values as float:
The Delphi code below results in a 'Floating point invalid operation' in function TXLSCellMMU.EncodeNumber:
var
ExcelFile : TXLSReadWriteII5;
begin
ExcelFile := TXLSReadWriteII5.Create(nil);
ExcelFile.Filename := 'C:\output.xlsx';
ExcelFile.Sheets[0].InsertRows(0,0);
ExcelFile.Sheets[0].AsFloat[0, 0] := 10000000; <-
ExcelFile.Write;
end.
Please help.
Thanks d3nton
Floating point invalid operation when using Sheets.asFloat
Re: Floating point invalid operation when using Sheets.asFloat
Hello
The problem is the delphi RoundTo function that is buggy. The behaivor of RoundTo has also changed in recent Delphi versions. When this exception happends, stop at the source code and change RoundTo to XLSRoundTo, or if you have XLSRoundTo, change to RoundTo.
The problem is the delphi RoundTo function that is buggy. The behaivor of RoundTo has also changed in recent Delphi versions. When this exception happends, stop at the source code and change RoundTo to XLSRoundTo, or if you have XLSRoundTo, change to RoundTo.
Lars Arvidsson, Axolot Data
Re: Floating point invalid operation when using Sheets.asFloat
Okay thank you!
I see that you have already fixed this in the newest version
I see that you have already fixed this in the newest version