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
Created attachment 187448 [details] File in which the indent right is broken - done using steps to repate
(In reply to pauloffner from comment #1) > Created attachment 187448 [details] > File in which the indent right is broken - done using steps to repate Minor correction - while the solution to see the issue go away is indeed to change the font size and/or color, the suggested workaround of changing fontsize by an increment of 0.01 does not actually work. Font-size must change by at least 0.1 which results in visible changes once multiple styles are added to the workbook
Reproducible with the sample file Version: 7.5.3.2 (X86_64) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: f4c24da1e7f11664e0d2f688d2531f068e4a3bc0 CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Pasting the format from A5 to A6, changes A6:A7, but just curious, a hard-recalc shows fine to the end A10. But it doesn't happen to me with a file from scratch.
(In reply to m.a.riosv from comment #3) > Reproducible with the sample file > Version: 7.5.3.2 (X86_64) / LibreOffice Community > Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 > CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: > win > Locale: es-ES (es_ES); UI: en-US Calc: CL threaded > Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community > Build ID: f4c24da1e7f11664e0d2f688d2531f068e4a3bc0 > CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: > win > Locale: es-ES (es_ES); UI: en-US Calc: CL threaded > > Pasting the format from A5 to A6, changes A6:A7, but just curious, a > hard-recalc shows fine to the end A10. > > But it doesn't happen to me with a file from scratch. Hi and thanks for your message, Yes copying a5 over a6 does do some sort of a full refresh which fixes some cells, but basically all cells affected need a full refresh to fix them (ie. clicking in them and clicking enter). This is not possible for a production spreadsheet, nor a very large one. It is also impossible if the cells in question are locked formula cells (as in the use case of a financial template with total cells which need to be aligned) I am attaching a video of me creating the error from scratch by changing the data type of cell A6 to currency, on a column of numbers with indent right set to one increment. You can see the numbers underneath have the indents removed. The indents are still set in the cell properties, but appear and disappear when scrolling at the end of the video
Created attachment 187450 [details] Recording of me recreating the issue from scratch
Also, is there a way of removing email addresses which bugzilla seems to put on each comment? I wasn't aware that these were made public.
Reproducible Version: 7.5.3.2 (X86_64) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: f4c24da1e7f11664e0d2f688d2531f068e4a3bc0 CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
(In reply to pauloffner from comment #6) > Also, is there a way of removing email addresses which bugzilla seems to put > on each comment? I wasn't aware that these were made public. Go to your preferences, 'Account information', and in 'Your real name', set up on, so it is the name visible here.