Description: If the rows are fixed with "uno:FreezePanes", the value of SplitRow is incorrect. Steps to Reproduce: 1. Open New Calc. 2. Select [B2]. 3. Excecute "Freeze Rows an Columns". .uno:FreezePanes ( Menu Alt + V ; O or Icon) 4. Execute the following macro. Sub show_split_row msgbox ThisComponent.CurrentController.SplitRow End Sub Actual Results: 5. "2" will be displayed. 1 more value is displayed. Expected Results: 5. "1" will be displayed. Reproducible: Always User Profile Reset: No Additional Info: "SplitColumn" values appear to be correct. Reproducible with Version: 7.3.7.2 (x64) / LibreOffice Community Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f CPU threads: 4; OS: Windows 10.0 Build 10240; UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL Reproducible with Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 3ee53d75d253fb7fe2eb8db44afca95fda7f156d CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 10240); UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: threaded
Created attachment 195745 [details] sample file
confirmed! looks like …splitRow counts 1…2…3…4 instead 0…1…2…3
I placed the cursor in cell B2 and executed "Freeze Rows and Columns". Then running: Sub show_split_row msgbox ThisComponent.CurrentController.SplitRow msgbox ThisComponent.CurrentController.SplitColumn End Sub Returns 1 for both SplitRow and SplitColumn Is this not correct? System info Version: 24.2.4.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 4:24.2.4-0ubuntu0.24.04.2 Calc: threaded
Created attachment 195767 [details] here the SplitRow index is ok
Created attachment 195768 [details] and here a file with wrong SplitRow -index
Its weird, on some …ods it counts wrong on others it counts right! please compare the three attached files! I have absolutly no clue about the reasons! there is also the very same behavior with both: ___ Version: 24.2.5.2 (AARCH64) / LibreOffice Community Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59 CPU threads: 4; OS: Linux 6.6; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: en-US Flatpak Calc: threaded _____ and ____ Version: 7.4.7.2 / LibreOffice Community Build ID: 40(Build:2) CPU threads: 4; OS: Linux 6.6; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: de-DE Debian package version: 4:7.4.7-1+deb12u4 Calc: threaded
(In reply to Werner Tietz from comment #6) > Its weird, on some …ods it counts wrong on others it counts right! > > please compare the three attached files! I got 1 and 1 on both files. Version: 24.2.4.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 4:24.2.4-0ubuntu0.24.04.2 Calc: threaded Also with master Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: ec32d49e88d4ec731ca986558759fd5d6f364aca CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Calc: CL threaded I have no idea what can be going on.