Axolot Data

Hi!
The following code produces negative values in the excel output file when compiling with 64bit:

var
ExcelFile5 : TXLSReadWriteII5;
begin
ExcelFile5 := TXLSReadWriteII5.Create(nil);
ExcelFile5.Filename := 'D:\output.xlsx';
ExcelFile5.Sheets[0].AsFloat[0,0] := 2937958862; <- is -1357008434 in the output file

ExcelFile5.Write;
end.

The issue exists also when exporting to a xls file.

Hello

Caused by the buggy RoundTo function. Fixed in version 5.10.09

Hello

With V5.10.09 it seems to be vice versa.
On 64bit it works well but now I get a negative value if compiling the code above in 32bit.

Using version 5.10.10 with D7 the problem persist.

ExcelFile.Sheets[0].AsFloat[0, 0] := 123456789.12; yields -5392229,76 in the output.xlsx file.

No problem for integer values though.

Hello

D7 64-bit?

D7 64 bit. That would be something.
Sorry, just appending on an existing thread. Same problem, but 32 bit Delphi.
Thx for looking.

Hello

This was another error than the first mentioned in this thread. Will be fixed in the next update, 5.10.11, probably ready april 2.