Description: Calc,API:queryContentCells(23) incorrectly recognizes outside Used Area. Steps to Reproduce: 1. Open Attached File 2. Select the empty cells on the right after columns [ D1:D31 ]. (A button for selection is placed in column B) ex. Select [ E8:E15 ] 3. Execute the macro from the button in A1. Examine the contents of the cells by queryContentCells(23). Actual Results: 4. A message will be displayed indicating that column C contains the result of the selection. ex. Indicates that C13 and C14 have values. Expected Results: 4. displays the results of the selected range. ex. Shows that all are empty. Reproducible: Always User Profile Reset: No Additional Info: It appears that queryContentCells(23) is searching the last column of Used Area. It appears to be resolved by entering something in the cell to the right of the last column of Used Area. For example, [D1]. --- Not Reproduced 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: 7.4.7.2 (x64) / LibreOffice Community Build ID: 723314e595e8007d3cf785c16538505a1c878ca5 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: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 90b12c9bad55e8f50b75a6d7b68caa27d82cc2b9 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 threaded
Created attachment 191621 [details] sample file
Reproducible with Version: 7.4.0.3 (x64) / LibreOffice Community Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a 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
Thank you for the report and easy steps! Reproduced as described in: Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 3cb1ed4339fc9aec414c0f112a69705a7a4d9cc6 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded and in 7.4.7.2, but not in 7.3.7.2 -> regression. Bibisected with linux-64-7.4 repo to first bad build [d14c498f036bf5f6f99503115eeec2a72bd1ba83] which points to: commit 9e2d48b9e04f7ea895fb095699c32ed8a44eb129 author Luboš Luňák Wed Mar 30 11:58:04 2022 +0200 committer Luboš Luňák Thu Apr 28 05:51:53 2022 +0200 reduce Calc's INITIALCOLCOUNT to 1 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/133311 Root cause could be the same as bug 157211?