Bug 158918

Summary: Calc,API:queryContentCells(23) returns wrong results outside Used Area
Product: LibreOffice Reporter: nobu <tac725>
Component: BASICAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: stephane.guillou
Priority: high Keywords: bibisected, bisected, regression
Version: 7.4.0.0 alpha0+   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=157211
Whiteboard:
Crash report or crash signature: Regression By: Luboš Luňák
Bug Depends on:    
Bug Blocks: 107659, 158550    
Attachments: sample file

Description nobu 2023-12-29 07:36:39 UTC 
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
Comment 1 nobu 2023-12-29 07:37:37 UTC 
Created attachment 191621 [details]
sample file
Comment 2 nobu 2024-01-12 14:18:03 UTC 
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
Comment 3 Stéphane Guillou (stragu) 2024-01-12 16:20:28 UTC 
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?