Floating point invalid operation when using Sheets.asFloat
Posted: Wed Feb 27, 2013 10:21 am
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
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