https://bugs.documentfoundation.org/show_bug.cgi?id=155441
Bug ID: 155441
Summary: Rendering bug for indent right in Libre Office Calc -
ODS and XLSX
Product: LibreOffice
Version: 7.3.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: pauloff...@yahoo.com.au
Description:
Libre office has some strange bugs with indenting on the right hand side in
programmatically generated XLSX files (Apache poi 3.17 to 5.2.3 tested). Bug is
also present if ODS file created from scratch in Calc GUI. Steps to reproduce
if file created from scratch in Calc are included in the report at steps to
reproduce.
If we style cells in a column with cell border bottom of a certain color and
thickness, data type as currency (or any other type) and indent right of 1 (or
any number), then create a few other cells in the column with a different style
that is almost identical but changes the border-bottom color, or thickness, or
the data type (any different to the first style), then the right hand indent
will be wiped out for some cells intermittently. Indent is not wiped out if
horizontal alignment is set to the left. Indent is fixed if the user enters the
cell and clicks enter to refresh the cell (but this is not available if the
cell is protected and locked)
This rendering bug is also somehow affected by wrap text e.g. if wrapping is
true, then the right indent will be permanent, but if wrapping is false,
scrolling the affected cells in and out of the viewport will make the error go
away then come back each time the affected cell goes in and out of the view.
Changing the zoom level or maximising the window will remove the indenting as
well, until the user scrolls the affected cell out of view, then back into
view.
The only repeatable solution to fixing this issue I have found, is to set a new
font for the styles on which we have changed only border thickness/color or
data format. As we would normally want to use the same font color and size, a
workaround is to just change the font size from 11 to 11.01 or some other
variation. This doesn't seem to result in any difference in final font size in
Libre office or Excel. Tested in libre office 7.3.5.2 (Win 10 64 bit) and
7.4.7.2 (Windows 7 64bit)
Steps to Reproduce:
1.Enter values in cells A1-10.
2.Set border bottom of any thickness and to black (A1-10)
3.Change styles or a1-10 to currency and indent right of 1 increment
5. Change A6 to orange border bottom
Actual Results:
Cell a6 and a7 have indent right wiped out.
A7 indent comes back when you scroll out of viewport. A6 does not
Expected Results:
Indent should be maintained
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version 7.3.5.2 x64 windows 10 - also tested on a newer version where bug is
still present version 7.4.7.2
Tried fresh install on new machine. Issue not fixed
--
You are receiving this mail because:
You are the assignee for the bug.
