Bug 148880 - Range duplication in case of multi-sheet ranges when selecting them
Summary: Range duplication in case of multi-sheet ranges when selecting them
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Macro
  Show dependency treegraph
Reported: 2022-05-01 18:20 UTC by Igor
Modified: 2022-05-07 19:43 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:

Explains the bug in detail (45.20 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-05-01 18:21 UTC, Igor

Note You need to log in before you can comment on or make changes to this bug.
Description Igor 2022-05-01 18:20:12 UTC
If you try to select ranges from different sheets, they would be doubled (duplicated) after selection.

Steps to Reproduce:
See the file attached
1. Call Test_GetCellCollection
2. Sheet1.A1 will be added after the empty cells (Sheet1.B4:C4).
3. First 3 cells will be listed and then 6 (bug).

Actual Results:
6 cells selected

Expected Results:
3 cell selected

Reproducible: Always

User Profile Reset: No

Additional Info:
Pay attention not to the order of the cells (this is not the main thing here), but to the doubling of the cells after selection.
Comment 1 Igor 2022-05-01 18:21:43 UTC
Created attachment 179877 [details]
Explains the bug in detail
Comment 2 Igor 2022-05-01 18:22:35 UTC
Instructions are in the attached file.
Comment 3 Andreas Heinisch 2022-05-04 19:04:02 UTC
Repro in:
Version: (x64) / LibreOffice Community
Build ID: a58701650c2dd7ad8514752d571aa2569690fe37
CPU threads: 6; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: CL
Comment 4 Igor 2022-05-07 19:43:06 UTC
Let me explain the attached example:
  1. Input ranges:
     Multi-sheet (CellCount = 3): Sheet1.B4:C4;Sheet2.A1
  2. Select input ranges.
  3. Selected (CellCount = 6): Sheet1.A1;Sheet1.B4:C4;Sheet2.A1;Sheet2.B4:C4
Comment 5 Igor 2022-05-07 19:43:23 UTC Comment hidden (obsolete)