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.