Description: Rows and row headers are not aligned, which causes the first row to hide part of the text and difficult to select the correct cell with the mouse. Steps to Reproduce: 1. Open the attached spreadsheet file. 2. See that the first row hides part of the text. 3. Try to select any cell from row 2 or lower using the mouse. 4. See that the formula bar is not the same as the highlighted cell, and that in some rows even the cell highlight is not aligned to the cell. Actual Results: Incorrect selection of cells using the mouse. Expected Results: Select the correct cell. Reproducible: Always User Profile Reset: No Additional Info: Tested on: Version: 7.3.5.2 (x64) / LibreOffice Community Build ID: 184fe81b8c8c30d8b5082578aee2fed2ea847c01 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: pt-BR (pt_BR); UI: pt-BR Calc: threaded Jumbo
Created attachment 181795 [details] Test file that shows the bug
Created attachment 181796 [details] Screenshot that shows the bug
Created attachment 181797 [details] Graphic test results
Created attachment 181798 [details] LibreOffice's main user profile settings I discovered that erasing all Calc related settings from this file (located at %AppData%\LibreOffice\4\user) fixes this bug, so I have sent my previous version of the file with all the Calc settings intact, so the developers can figure out what is the problematic setting.
If you want to replicate this bug, just copy the attachment at https://bugs.documentfoundation.org/attachment.cgi?id=181798 to your %AppData%\LibreOffice\4\user folder.
I did tests and discovered that is this setting that activates the bug: <item oor:path="/org.openoffice.Office.Calc/Defaults/Sheet"><prop oor:name="JumboSheets" oor:op="fuse"><value>true</value></prop></item> This setting is related to enabling very large spreadsheets, but it doesn't appear on the LibreOffice version I use (7.3.5.2) at the location Menu Tools -> Options -> Libre Office Calc -> Defaults: Enable very large spreadsheets. It also appears that others also had problems with Calc when trying to open spreadsheets created without this option when this option is enabled (see https://renenyffenegger.ch/notes/development/Software/LibreOffice/Calc/index and search for "Enable large spreadsheets").
No repro using Version: 7.4.0.3 (x64) / LibreOffice Community Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL Jumbo
The file opened correctly for me in Version: 7.3.5.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 12; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 1:7.3.5-0ubuntu0.22.04.1 Calc: threaded
(In reply to Rafael Lima from comment #8) Note that the problem appears with experimental options and jumbo sheets enabled. And it definitely repro using Version: 7.3.0.3 (x64) / LibreOffice Community Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3 CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL Jumbo
(In reply to Mike Kaganski from comment #9) > Note that the problem appears with experimental options and jumbo sheets > enabled. Indeed, with the Jumbo sheets I get the error. Version: 7.3.5.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: pt-BR Ubuntu package version: 1:7.3.5-0ubuntu0.22.04.1 Calc: threaded Jumbo Setting this to NEW
(In reply to Rafael Lima from comment #10) > Setting this to NEW (In reply to Mike Kaganski from comment #7) > No repro using Version: 7.4.0.3 (x64) It is WORKSFORME.