https://bugs.freedesktop.org/show_bug.cgi?id=52578
--- Comment #5 from Owen Genat <[email protected]> --- Created attachment 80256 --> https://bugs.freedesktop.org/attachment.cgi?id=80256&action=edit Example cell border widths (ODS/XLSX) showing incrementing values. The bug as-is appears to raise two distinct issues: 1) non-OOXML-standard cell border value are changed to OOXML-standard cell border values when saving in XLSX format; 2) some cell border values are subsequently incremented after each re-save to XLSX. (1) is not a bug it is a compatibility feature. There are a limited number of valid cell border widths under OOXML. ECMA-376 4th Ed, ยง18.18.3 offers "hair" (0.05pt), "thin" (1.00pt), "medium" (2.50pt), and "thick" (4.00pt). The LO implementation has been altered (circa v3.5) to support this. The referred bug #52257 probably needs to be RESOLVED as NOTABUG as per bug #51178. (2) is a separate issue and this bug needs its title changed to reflect this fact. I can confirm repeated saving of an XLSX under GNU/Linux TDF/LOv4.0.3.3 results in initial incrementation of the cell border value as described. That is, the initial save from ODS to XLSX results in the four OOXML border widths being set. A subsequent edit and save of the XLSX (using LO) results in cell borders using the "thin" and "medium" values being set to "thick". Repeated saving then has no effect with all cells set to either "hair" or "thick". This is possibly related to bug #53287 as indicated by Roman in comment #3 but I am uncertain. To reproduce this issue: 1. Open attached ODS. 2. Export to PDF (or compare with included PDF). 3. Save as XLSX (this is *_1st.xlsx). 4. Close file. 5. Open *_1st.xlsx 6. Export to PDF (or compare with included PDF). 7. Save as XLSX (this is *_2nd.xlsx). 8. Close file. 9. Open *_2nd.xlsx 10. Export to PDF (or compare with included PDF). 11. Save as XLSX (this is *_3rd.xlsx). 12. Close file. 13. Open *_3rd.xlsx 14. Export to PDF (or compare with included PDF). At step 5-6 note all four different cell border widths exist. At step 9-10 note only two different cell border widths exist ("hair" and "thick"). At step 13-14 note the same two cell border widths exist. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
