Description: Summary : When I update a former report that was properly setup, I get extra columns. Details: I start from a former release of a report, under ODF format and had to update it. The former report did show properly 25 columns. This report has : 1°) a page header, including a long label as report title with 25 labels as column headers underneath the long label, 2°) a detail section that contains the 25 fields. I relocated the 22nd column in the 4th place and added-up a new one as 7th place. All labels have the same width and x-position as their related columns. The result is not easily legible as there is an extra blank cell between the 6th and the 7th column and from then, every label is displayed in a two-cells fused cell. For the data fields, no extra cell between the 6th and the 7th column but every data is displayed in a two-cells fused cell. So the column header and the data are not aligned under each other and when I try to copy and paste the data in a neatly formatted sheet with conditional formatting, the data do not fit in the right place. Thanks in advance for your help. Michel Steps to Reproduce: 1.open a former report 2.move some columns header and some columns data fields to the right 3.add-up columns in the new created gap 4. move the moved columns back the left Actual Results: 1. A new cell appear in the header row 2. The header cells at the right of this extra cell join 2 cells (no loss of header but header row width is almost doubled) 3. The data rows contain cells that join 2 cells (no loss of data but data rows width is almost doubled) 4. Data are aligned in their columns but not with their related headers (due to the extra cell described in 1. 5. Copy and paste to a display spreadsheet with nice formatting is almost impossible unless to be done one data column at a time. Expected Results: 1. No extra cell in header row 2. Each header or data in a single cell in a compact table with no extra row. Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Version: 6.0.7.3 Build ID: 1:6.0.7-0ubuntu0.18.04.10 Threads CPU : 4; OS : Linux 5.3; UI Render : par défaut; VCL: gtk3; Locale : fr-FR (fr_FR.UTF-8); Calc: group ~$ glxinfo | grep OpenGL OpenGL vendor string: Intel Open Source Technology Center OpenGL renderer string: Mesa DRI Intel(R) HD Graphics 5500 (Broadwell GT2) OpenGL core profile version string: 4.5 (Core Profile) Mesa 19.2.8 OpenGL core profile shading language version string: 4.50 OpenGL core profile context flags: (none) OpenGL core profile profile mask: core profile OpenGL core profile extensions: OpenGL version string: 3.0 Mesa 19.2.8 OpenGL shading language version string: 1.30 OpenGL context flags: (none) OpenGL extensions: OpenGL ES profile version string: OpenGL ES 3.1 Mesa 19.2.8 OpenGL ES profile shading language version string: OpenGL ES GLSL ES 3.10 OpenGL ES profile extensions: This bug is open on the advice given in https://ask.libreoffice.org/en/question/236378/base-odf-report-odd-colums/
Created attachment 159288 [details] Odd column report
Could you please add a example-database, which will show the problem in a simple way? The attached Calc-file is only the output a report of a database. Don't load up data, which are private data. The data could be seen by everybody in the www.
Created attachment 159296 [details] Database with no personal data
The database from which the report is extracted is appended. The report is called Rp_Centrales_Très_sommaires_>31kW The report is based on the request R_Centrales_Très_sommaires_>31kW
The changes in the header or data cells arrangement have been made one cell at a time, without grouping the whole block of cells to be moved and with no specific order between header cells and data cells.
Did you try with a recent LO? Last stable one is 6.3.5 and brand new one is 6.4.2 You can find them I suppose on LO PPA.
LO updated : Version : 6.4.2.2 Build ID : 1:6.4.2-0ubuntu0.18.04.3 Threads CPU : 4; OS : Linux 5.3; UI Render : par défaut; VCL: gtk3; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded Result is the same using the new database : the report is corrupted. Copying the old proper report and adding-up some columns in-between, like I did when I got the corrupted report, provides a clean report with no extra cells. Many thanks for the advice of upgrading my LO.
Thank you for your feedback! Let's put this one to WFM since there was no patch to fix this.