https://bugs.documentfoundation.org/show_bug.cgi?id=160985

--- Comment #18 from ady <adylo811...@gmail.com> ---
Simplest STR:
In a new spreadsheet, paste the numeric value:
2000000528764739

Save as ODS and as XLS, then reload > same value.

Save as XLSX, then reload:
* LO 3.3: same value
* LO 4.0 and newer (but maybe older versions too): 2000000528764740

Excel: see comment 15.

Calc could (potentially) still save the value accurately and leave Excel's
behavior to Excel. Pros and cons, see comment 16. If Excel would perform
calculations with these (different) values differently than Calc (would it?),
maybe users won't like that, thus, "pros and cons".

As for the original case presented in this report (i.e. to share accurate
values with other parties), there are alternative methods, but that's a
different issue.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to