[Libreoffice-bugs] [Bug 144991] New: EDITING: The "Increase Indent" and "Decrease Indent" increment step should be the width of 3 space chars (using the default style font) when working in an xlsx document

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144991
           Summary: EDITING: The "Increase Indent" and "Decrease Indent"
                    increment step should be the width of 3 space chars
                    (using the default style font) when working in an xlsx
                    document
           Product: LibreOffice
           Version: 7.3.0.0 alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: suokunlong at 126.com

With the fix of bug 130104 by commit 6b93ee72df1aa42d1a3482ffc396bd0c23134f8b
(Mon Oct 04 23:11:30 2021 +0800), now in both xlsx import and export the cell
indent is correctly set as the width of 3 space chars. However, now if the user
modifies the indent value on the Calc UI using "Increase Indent" and "Decrease
Indent" toolbar buttons, the increment step is currently 10pt (200 twips) as
defined by SC_INDENT_STEP in sc/inc/global.hxx. This causes the user unable to
set a proper indent value to be interoperable with other applications such as
Excel. 

Steps to Reproduce:

1. Open attachment 175572 with a LibreOffice version with the commit
6b93ee72df1aa42d1a3482ffc396bd0c23134f8b.

2. Observe that the indent is 7pt for cell A2 and 15pt for cell A3.

3. Put cursor in cell A2, then hit once the "Increase Indent" toolbar button.
Expected: the indent for cell A2 should change to 15pt (i.e., the same as cell
A3).
Current: the indent for cell A2 is changed to 17pt (different from cell A3)

4. Put cursor in cell A11, then hit once the "Decrease Indent" toolbar button.
Expected: the indent for cell A11 should change to 67pt (i.e., the same as cell
A10).
Current: the indent for cell A11 is changed to 65pt (different from cell A10).

5. Undo all changes, then change the font size of the Default style to 28pt
(for both the Western and Asian font in case you have enabled Asian language),
then save as another xlsx file.
Expected: the indent for each cell need to be updated to be the new width of
3-space chars when the default font family or size is udpated, thus upon resave
the correct cell indent is exported into xlsx file.
Current: when the font for default style is updated, the cell indent is not
updated. This causes the indent exported to xlsx file is wrong (now if you
reopen the exported xlsx file, the indent for cell A2 changed to zero rather
than 1 excel indent unit).

-- 
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/1bc7336b/attachment-0001.htm>