https://bugs.documentfoundation.org/show_bug.cgi?id=160985
--- Comment #13 from ady <[email protected]> --- (In reply to raal from comment #12) > this is not problem with csv import. Correct – please read my comments above. The import problem was solved already for LO version 5.1 (see comment 8). The problem in LO Dev 24.8 alpha is when _exporting_ to XLSX format, which started _after_ LO 3.3 but before (or in) LO 4.0. > this is not problem with csv import. Try open new calc sheet and paste value > 2000000528764739. Then, after export to xlsx is number rounded. ODS is > correct. Tested with excel2010 - after paste number 2000000528764739 is > number 2000000528764730 in the cell. So I assume this is limitation of xlsx > format and not a bug. > As a workaround for csv case you can import column as text in import dialog. As you demonstrated by pasting the plain value 2000000528764739 to a new empty spreadsheet and saving as XLSX fie, there is no need to workaround the CSV import case. Considering that the export to XLSX of the same 2000000528764739 value used to work _correctly_ in LO Calc 3.3, there might be a way to avoid the export problem in new versions. Moreover, exporting to XLS works correctly, so there should be a way to avoid the problem when exporting to XLSX too. -- You are receiving this mail because: You are the assignee for the bug.
