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).
6 cells selected
3 cell selected
User Profile Reset: No
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.
Created attachment 179877 [details]
Explains the bug in detail
Instructions are in the attached file.
Version: 18.104.22.168.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
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