https://bugs.documentfoundation.org/show_bug.cgi?id=170461
Bug ID: 170461
Summary: Calc,API: Cells function only enumerates cells in the
first sheet
Product: LibreOffice
Version: 7.5.9.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: [email protected]
Reporter: [email protected]
Description:
Cells function only enumerates cells in the first sheet.
Steps to Reproduce:
1. Open sample Calc file.
'File contains following basic macro
Sub Cells_Test()
Dim sels As Object, cell As Object
sels = ThisComponent.CurrentSelection
MsgBox sels.AbsoluteName & Chr(10) & sels.Count
For Each cell In sels.Cells
MsgBox cell.AbsoluteName
Next cell
End Sub
2. Select two sheets (AAAA and BBBB) and select Cell A1.
3. Run Macro.
Actual Results:
4. The first message confirms that cells from both sheets have been retrieved,
but the subsequent message only lists cells from the first sheet.
Expected Results:
4. All selected cells will be listed.
Reproducible: Always
User Profile Reset: No
Additional Info:
Reproducible
[2026-01-24]
Version: 26.8.0.0.alpha0+ (X86_64)
Build ID: 680(Build:0)
CPU threads: 4; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster;
VCL: win
Locale: ja-JP (ja_JP); UI: en-US
Calc: CL threaded
Reproducible
Version: 7.5.9.2 (X86_64) / LibreOffice Community
Build ID: cdeefe45c17511d326101eed8008ac4092f278a9
CPU threads: 4; OS: Windows 10.0 Build 26100; UI render: default; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
