Bug 131470 - Swapping columns across multiple sheets works correctly only on the active sheet
Summary: Swapping columns across multiple sheets works correctly only on the active sheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Management
  Show dependency treegraph
 
Reported: 2020-03-21 19:32 UTC by kostas.margiavicius
Modified: 2023-08-31 19:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description kostas.margiavicius 2020-03-21 19:32:05 UTC
Description:
When multiple sheets are selected swapping columns on the active sheet works correctly, but columns' behavior on the other sheet is incorrect.

Steps to Reproduce:
1.On Sheet1 and Sheet2 add information on cells located on ColumnA and ColumnB
2. Switch to any of the Sheets
3. Select both sheets by their tabs (ctrl- or shift- select)
4. Select A or B column by its tag.
5. Alt-drag the column to the other column's place


Actual Results:
1. On the active sheet the columns swapped places.
2. But on the other sheet the non-selected column(the one supposed to move its place) disappears.

Expected Results:
The columns on other sheets should swap the same way as they do on the active sheet


Reproducible: Always


User Profile Reset: No



Additional Info:
In case you have multiple columns and want to swap 2 of them, then they do swap correctly on the active sheet, but the columns on the other sheet(-s) is unpredictable. One of the columns disappears, but others move their position. I couldn't understand the actual algorithm.
Comment 1 Oliver Brinzing 2020-03-22 06:26:25 UTC
reproducible with:

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4

Version: 7.0.0.0.alpha0+ (x64)
Build ID: 900e29250fba8aff807b99e684fdd4f73f866132
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: threaded
Comment 2 QA Administrators 2022-03-23 03:38:27 UTC Comment hidden (obsolete)
Comment 3 Kira Tubo 2023-08-31 19:27:43 UTC
The issue is still reproducible:

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 695ae365dcab7c7dd59b39411299c5c200081885
CPU threads: 6; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded