[Libreoffice-bugs] [Bug 130104] FILESAVE XLSX: cell indent ("stylesheet -> cellXfs -> xf -> alignment: indent") is increased each time when re-save as xlsx document (see comment 17)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130104

Kevin Suo <suokunlong at 126.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
           Assignee|libreoffice-bugs at lists.free |suokunlong at 126.com
                   |desktop.org                 |
             Status|NEW                         |RESOLVED

--- Comment #24 from Kevin Suo <suokunlong at 126.com> ---
Big thanks to Mike Kaganski who has helped me fix this. With the patch merged
above now the indent upon roundtrip is reserved. 

However, as stated on the commit message, the UI part need to be improved, so
that after xlsx import, if the user hit the "Increase Indent" or "Decrease
Indent" toolbar icon to change the indent, Calc should be able to detect that
we are operating in an xlsx file, thus the "increment" should be 3 * width of
space char, rather than the current SC_INDENT_STEP. Also, the if the user
changes the default font of the xlsx document, then Calc should recalculate the
indent for each cell to reflect the possible change in width of space char. I
will open a new bug for this issue.

In addition, on xlsx import of the file tdf130104_indent.xlsx, the default font
(i.e. font for the "Normal" style) is "Times New Roman". However, when the UI
locale is set to Simplified Chinese and "Asian" option is enabled in Tools ->
Options -> Language Settigns -> Languages -> "Default Languages for Documents",
upon resave as xlsx, the default font for the document is changed to "Noto Sans
CJK SC" on my system, which causes the space-width detected on export to be
different from the width detected on xlsx import. This seems to be bug 131349.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20211008/8ff68c05/attachment.htm>