https://bugs.documentfoundation.org/show_bug.cgi?id=166014
--- Comment #9 from Mike Kaganski <[email protected]> --- On further reading, I fail to follow the logic in the statements in comments 3 and 4. (In reply to brian from comment #3) > <c r="A46" s="29" t="n"> | <c r="A46" s="196" t="n"> > <v>45454.9618055556</v> | <v>45454.96180555555</v> > </c> | </c> > > The XML on the left was written by LibreCalc. The XML on the right was > originally written by LibreCalc but has subsequently been read and then > rewritten with OpenPyXL Hmm, so Calc wrote 45454.9618055556 (15 decimals), and OpenPyXL wrote 45454.96180555555 (16 decimals, *different* number)? This contradicts with > ... developers of OpenPyXL has suggested that the XLSX file format specifies > a 15 digit precision but it seems that LibreCalc is using 16 digit precision. I second the request from comment 2: > Please attach a sample file ... and tell what exactly can be done to convert left sample into right sample. -- You are receiving this mail because: You are the assignee for the bug.
