If you set a solid border for table cells in Calc, they show as dotted lines in xlsx. Steps to Reproduce: 1) New spreadsheet 2) Select some cells and add solid line border 3) After saving to xlsx format, close the document 4) Open the document with Microsoft office, the solid line border becomes dotted line Actual Results: The solid line border becomes dotted line Expected Results: Show solid line border Additional Info: edition 6.4.4.2 (x64) Regional language: zh CN (zh CN)_ Cn); UI Language: zh cn
Created attachment 162283 [details] FILEOPEN XLSX borders are not compatible If you set a solid border for table cells in Calc, they show as dotted lines in xlsx. Steps to Reproduce: 1) New spreadsheet 2) Select some cells and add solid line border 3) After saving to xlsx format, close the document 4) Open the document with Microsoft office, the solid line border becomes dotted line
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 162820 [details] Example file Hi, Xisco Faulí This is the document that has been saved from Lo as MSO. Open it with MSO to see the effect directly.
Created attachment 162821 [details] Example file Hi, Xisco Faulí This is the document that has been saved from Lo as MSO. Open it with MSO to see the effect directly.
Hello, Could you please create the document from scratch and save it as ODS and attach it ?
Created attachment 162950 [details] Example file
(In reply to Xisco Faulí from comment #5) > Hello, > Could you please create the document from scratch and save it as ODS and > attach it ? Hi, Xisco Faulí Created attachment 162950 [details] Save this attachment as xlsx, open it again, and you will find that the solid line box becomes a dotted line box
I think, that is mainly a problem of Excel not of LibreOffice. The dotted line is the way Excel renders a hairline. Excel has only a fixed set of line styles. These line styles include already the thickness, there exist no separate setting for thickness. LibreOffice uses a mapping between LO styles and Excel styles, see https://opengrok.libreoffice.org/xref/core/sc/source/filter/excel/xestyle.cxx?r=b7ed6de5#1608 In this case the line is 0.06pt and therefore falls into case hairline. Details about mapping are in https://opengrok.libreoffice.org/xref/core/sc/qa/unit/data/README.cellborders?r=6777720c Nevertheless one might consider to change the mapping to base it mainly on style and not on thickness.
(In reply to Regina Henschel from comment #8) > I think, that is mainly a problem of Excel not of LibreOffice. The dotted > line is the way Excel renders a hairline. Excel has only a fixed set of line > styles. These line styles include already the thickness, there exist no > separate setting for thickness. > LibreOffice uses a mapping between LO styles and Excel styles, see > https://opengrok.libreoffice.org/xref/core/sc/source/filter/excel/xestyle. > cxx?r=b7ed6de5#1608 > In this case the line is 0.06pt and therefore falls into case hairline. > Details about mapping are in > https://opengrok.libreoffice.org/xref/core/sc/qa/unit/data/README. > cellborders?r=6777720c > > Nevertheless one might consider to change the mapping to base it mainly on > style and not on thickness. Hi, Regina Henschel I agree with you , Please help me change the status of this bug