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)
Version:
(earliest affected)
7.3.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro
  Show dependency tree / graph
 
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:

Attachments
Explains the bug in detail (45.20 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-05-01 18:21 UTC, Igor 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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 
Description:
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: 7.4.0.0.alpha0+ (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)