Delphi export to Excel (.xlsx)

Question

When export to xls there is no error when export to xlsx there is error into cell " the number in this cell is formatted as text or preceded by an apostrophe" but there is no apostrophe

why strange behavior happening?

Update: I using QExport4XLS, QExport4Xlsx, kbmMemTable - datasource.

MemTable.FieldDefs.Add('Price', db.ftFloat, 0, False)
...
MemTable.FieldByName('Price').AsFloat := Value
...
QExport4X*.DataSet := MemTable;
...
QExport4X*.Execute;

Answer 1

I using v4.0 so it was component problem as according their bug fix tracker after v4.2 they did fix.