[Libreoffice-bugs] [Bug 125205] Spreadsheet cell Horizontal alignment (Left) indent is not saved/preserved round trip to OOXML
https://bugs.documentfoundation.org/show_bug.cgi?id=125205 --- Comment #7 from stde...@gmail.com --- I know you'll hate my response - but add a converting function maybe? Libre opens X file, converts it (if needed) to a "standard" format in-memory, and, if needed, writing it in Excel units on save? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 125205] Spreadsheet cell Horizontal alignment (Left) indent is not saved/preserved round trip to OOXML
https://bugs.documentfoundation.org/show_bug.cgi?id=125205 Kevin Suo changed: What|Removed |Added CC||suokunl...@126.com Resolution|--- |DUPLICATE See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||0104 Status|NEW |RESOLVED --- Comment #6 from Kevin Suo --- That is because in Excel (xls, xlsx, OOXML) the cell indent is measured using "1", "2", "3"... units, where the "1" represent the width of 3 space chars (using the default style font) (the values must be integers not float numbers such as 1.5 or 1.01 etc), while in ODF we use pt to measure the indent (indent can be 1pt, 1.01pt, 2.5pt, 15pt...) As a result, if we set the cell indent to 1pt in LibreOffice, and assume the width of 3 space char is e.g. 10pt (i.e. "1" Excel indent unit), then upon filesave what value should it be? Round-down to zero? Round-up to 1 excel unit? Neither approach is correct. I my opinion the only possible approach should be: 1. LibreOffice change its way to handle the cell indent to be consistent with Excel, for interoperability with Excel. I think no one will agree with this - why should we give up using pt as measurement and use the non-sense 1,2,3 units? 2. Or, LibreOffice detects to see if we are editing an Excel file, and if yes, when the user hit the "Increase Indent" or "Decrease Indent" toolbar icon, one-click will increase or decrease the indent by the width of 3 space character using the Normal (western) font. This is what I have proposed in bug 144991. However, the headache under this approach is that, what if we create a new Calc file, set the indent, then save it as XLSX/XLS? Or, what if we open an ODS file which already contains some indent settings in some cells, then save as xlsx/xls? Seems like a WONTFIX under such conditions. As a result I mark this as a duplicate of bug 144991, and add bug 130104 as SEE ALSO. *** This bug has been marked as a duplicate of bug 144991 *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 125205] Spreadsheet cell Horizontal alignment (Left) indent is not saved/preserved round trip to OOXML
https://bugs.documentfoundation.org/show_bug.cgi?id=125205 --- Comment #5 from Camden Kevin --- I did work on the OOXML code last year and do some changes according to the requirements that work fine for me. I pick some quick tips from https://www.rushmyessay.com/ at that time as well. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 125205] Spreadsheet cell Horizontal alignment (Left) indent is not saved/preserved round trip to OOXML
https://bugs.documentfoundation.org/show_bug.cgi?id=125205 --- Comment #4 from alexandrepe...@gmail.com --- The bug persists on 6.4.0. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 125205] Spreadsheet cell Horizontal alignment (Left) indent is not saved/preserved round trip to OOXML
https://bugs.documentfoundation.org/show_bug.cgi?id=125205 V Stuart Foote changed: What|Removed |Added Summary|Spreadsheet cell padding is |Spreadsheet cell Horizontal |not saved/preserved |alignment (Left) indent is ||not saved/preserved round ||trip to OOXML -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs