https://bugs.freedesktop.org/show_bug.cgi?id=80794
Priority: medium
Bug ID: 80794
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FORMATTING: Right Align with indentation
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: reportingbugs...@gmail.com
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.3.0.1 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 102119
--> https://bugs.freedesktop.org/attachment.cgi?id=102119&action=edit
image showing various formats
Aligning numbers and text to the right of cells then indenting them using
increase indent button works inconsistently
Steps to reproduce:
In cell A1 enter 1, click align right, click increase indent
This works as expected
In cells A1 to A4 enter numbers 1 to 4
Select the cells, click align right click increase indent
Cells A1 and A2 show the indent A3 and A4 do not.
enter numbers as before but for cells A1 to B4 (2x4 grid), A1 and B1 show
indents but others do not. (Example 1 in attached picture) after saving the
document B1 didn’t show the indentation but A4 did
now for the strange part which might lead the root of the problem, on the 2x4
grid of numbers select column A or just the cells with numbers, set the
alignment to anything other than align right, so set as align left, centre or
justified. now the numbers in column B will show the correct indentation with
the alignment. (Example 2 in attached picture)
This can be expanded by filling A1 to E4 with single numbers and applying align
right and increase indent to all cells, now only cell A1 and B1 show the
indent. If you change any of the columns to a different alignment the following
column will show the correct formatting then the one after that will revert
back to the incorrect formatting. (Example 3). if the final column is set to
any alignment then back to default, the first column will show the correct
indentation.
Its is also not possible to set an indent when right align is set from right
click> format cells > Alignment, it will show the indentation but it is greyed
out.
I know that a workaround is to set the cell borders to different values to
simulate an indentation on the required cells with the required alignment,
Changing the cells to RTL a previously mentioned fix in this case hasn’t helped
either, although having to go though tools > options >language settings
>languages >CTL just to enable some formatting seams a stretch too far
Setting the right align with indent from cell styles is only possible by first
selecting the correctly formatted cells then new style from selection, due to
the indentation been greyed out, but is still shows the problems as above
Now im hesitant to say but Microsoft office supports aligning right with an
indentation, its was from importing an xlsx file that one of my users first
found this problem
File created with 4.3.0.1 on windows 7
4.0.6.2 on linux shows not indentation at all with the example file
4.2.5.2 on linux initial showed perfect formatting for example 1 after opening
the file but after minimised and maximised example 1 reverted to as seen in the
picture
Operating System: Windows 7
Version: 4.3.0.1 rc
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
