https://bugs.documentfoundation.org/show_bug.cgi?id=160985
Eike Rathke changed:
What|Removed |Added
Assignee|libreoffice-b...@lists.free |er...@redhat.com
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
--- Comment #19 from Eike Rathke ---
This happens already during save to .xlsx, the value 200528764739 is saved
as 200528764740 in the XML file. It does not happen when saving to .ods or
.csv (.xls stores the binary value anyway)
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
--- Comment #18 from ady ---
Simplest STR:
In a new spreadsheet, paste the numeric value:
200528764739
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
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
Stéphane Guillou (stragu) changed:
What|Removed |Added
CC||er...@redhat.com,
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
--- Comment #16 from ady ---
(In reply to raal from comment #15)
> See this
> https://learn.microsoft.com/en-us/office/troubleshoot/excel/last-digits-
> changed-to-zeros
> Excel therefore stores only 15 significant digits in a number and
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
--- Comment #15 from raal ---
See this
https://learn.microsoft.com/en-us/office/troubleshoot/excel/last-digits-changed-to-zeros
Excel therefore stores only 15 significant digits in a number and changes
digits after the fifteenth place to
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
ady changed:
What|Removed |Added
Version|5.1.0.3 release |4.0.0.3 release
--- Comment #14 from ady
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
--- Comment #13 from ady ---
(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
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
raal changed:
What|Removed |Added
CC||r...@post.cz
--- Comment #12 from raal
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
ady changed:
What|Removed |Added
CC||xiscofa...@libreoffice.org
--- Comment
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
--- Comment #10 from Andrey ---
I created a csv document with 50 lines and 50 columns, saved this document as
xlsx and gave it to the customer. in the xlsx document, there were incorrect
values in 5 cells that I didn't notice right away.
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
--- Comment #9 from ady ---
The original problem (exporting to XLSX) might be triggered before LO 4.0
already, together with the importing problem.
The import issue was resolved for LO 5.1, but not the export to XLSX.
So, the bibisect
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
ady changed:
What|Removed |Added
Keywords||bibisectRequest
--
You are receiving
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
ady changed:
What|Removed |Added
Version|24.2.3.2 release|5.1.0.3 release
--- Comment #8 from ady
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
--- Comment #7 from ady ---
(In reply to ady from comment #6)
> While I can reproduce the behavior, I am not sure this can be considered a
> bug.
I should clarify that. The length of the value in cell B3 is 16 digits [1]. IDK
whether
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
ady changed:
What|Removed |Added
Ever confirmed|0 |1
OS|macOS (All)
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
Andrey changed:
What|Removed |Added
Status|NEEDINFO|UNCONFIRMED
Ever confirmed|1
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
--- Comment #4 from Andrey ---
Created attachment 194024
--> https://bugs.documentfoundation.org/attachment.cgi?id=194024=edit
Screenshot of two files
Look last digits of selected cells
--
You are receiving this mail because:
You
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
ady changed:
What|Removed |Added
Status|UNCONFIRMED |NEEDINFO
Ever confirmed|0
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
--- Comment #2 from Andrey ---
Created attachment 194023
--> https://bugs.documentfoundation.org/attachment.cgi?id=194023=edit
Result file
--
You are receiving this mail because:
You are the assignee for the bug.
https://bugs.documentfoundation.org/show_bug.cgi?id=160985
--- Comment #1 from Andrey ---
Created attachment 194022
--> https://bugs.documentfoundation.org/attachment.cgi?id=194022=edit
Original file
--
You are receiving this mail because:
You are the assignee for the bug.
21 matches
Mail list logo