https://bugs.documentfoundation.org/show_bug.cgi?id=172294
Bug ID: 172294
Summary: Indentation of right-aligned cell blocked if the
adjacent cell to the left is right-aligned
Product: LibreOffice
Version: 26.2.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
There is something screwy with indentation of right-aligned cells. The toolbar
lets you indent a right-aligned cell, but the Format Cells dialog box disables
Alignment → Text Alignment → Indent if the Horizontal setting is set to Right.
There is a clear disagreement over whether this feature is meant to exist or
not.
There is also a bug with some kind of formatting leakage. Under certain
circumstances, unclear at present, a cell set to both right alignment and with
indentation does not get indented. The cell to its left being right-aligned is
a verified trigger. This bug vanishes if either cell (the offending cell or the
one to its left) has certain other formatting applied (font colour, background
colour, bold, italic and underline are all confirmed to restore indentation).
Steps to Reproduce:
Set up the number cells:
1. set C2 = 1, C3 = 23, C4 = 456
2. select column C, and from the toolbar, click Align Right (Ctrl+R) and then
Increase Indent
The three cells should now be right-aligned and indented away from their right
edge, for legibility against labels in column D
Set up the text captions:
3. add the word “test” to each of B2, B3 and B4
4. select column B, and from the toolbar, click Align Right (Ctrl+R)
Actual Results:
Observe that the indentation vanishes from the cells in column D.
To restore the indentation of any of C2–C4, you can:
a) delete the text in the column B cell to its left (e.g. to re-indent C3,
empty B3)
b) apply any of font colour, background colour, bold, underline or italic style
to a cell in C2–C4
c) remove the left alignment from the column B cell to its left (e.g. to
re-indent C3, left-align B3)
d) apply any of font colour, background colour, bold, underline or italic style
to a cell in B2–B4
Expected Results:
Honestly I do not know, as the program cannot decide whether it is legal to
have indentation and right-alignment at once. Either this should always work,
or never work, but not get confused and break.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 26.2.3.2 (X86_64)
Build ID: 70e089b17412e4cb7773e41413306b17a2328c34
CPU threads: 16; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster;
VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.