https://bugs.documentfoundation.org/show_bug.cgi?id=158918
Bug ID: 158918
Summary: Calc,API:queryContentCells(23) incorrectly recognizes
outside Used Area
Product: LibreOffice
Version: 7.4.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: tac...@hotmail.co.jp
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
--
You are receiving this mail because:
You are the assignee for the bug.
