Negative size values when exporting to 64bit (V5.10.08)

[d3nton]

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.

[larsa]

Hello

Caused by the buggy RoundTo function. Fixed in version 5.10.09

[d3nton]

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.

[Chipman]

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.

[larsa]

Hello

D7 64-bit?

[Chipman]

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

[larsa]

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.