https://bugs.documentfoundation.org/show_bug.cgi?id=117372
Bug ID: 117372
Summary: can't sort columns across blank row
Product: LibreOffice
Version: 6.0.3.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Here's a sample spreadsheet:
A B C
1 x y z
2 a b c
3 <blank row>
4 q w e
5 d e f
If you sort on column B, keeping all of the data together, it should end up
looking like this:
A B C
1 <blank row>
2 a b c
3 d e f
4 q w e
5 x y z
Try to sort it by selecting column B and then menu item Data->Sort. It should
ask if you want to sort the other columns with column B to keep them together.
Steps to Reproduce:
1. Here's a sample spreadsheet:
A B C
1 x y z
2 a b c
3 <blank row>
4 u v w
5 d e f
2. I want to sort on column B, but keep the data all together, so it ends up
like this:
A B C
1 <blank row>
2 a b c
3 d e f
4 u v w
5 x y z
2. so select column B, then menu item Data -> Sort
3. it asks the following:
"The cells next to the current selection also contain data....
Do you want to extend the sort range to A1:C2 or sort the
currently selected range B1:B1048576?"
[extend selection] [current selection] [cancel]
4. We don't want 'current selection', e.g. just column B, because we want
all the data in each row to remain in the row. So 'extend selection'
is the only choice. But A1:C2 is wrong and you can see that it's wrong, because
it has highlighted the A1:C2 block. It should extend the block to include
all columns, e.g. A1:C1048576. Instead it has stopped after row 2, because
there is a <blank row> there. That's the problem. The selection has stopped on
a blank row.
5. Click [extend selection] and on the next box, leave the settings as they are
and click [Ok]
6. as expected, it only sorts A1:C2 and the result is:
A B C
1 a b c
2 x y z
3 <blank row>
4 u v w
5 d e f
It only sorted rows 1-2, leaving 3-5 as is.
Actual Results:
Sort this table on column B:
A B C
1 x y z
2 a b c
3 <blank row>
4 u v w
5 d e f
Actual result is:
A B C
1 a b c
2 x y z
3 <blank row>
4 u v w
5 d e f
Expected Results:
A B C
1 <blank row>
2 a b c
3 d e f
4 u v w
5 x y z
Reproducible: Always
User Profile Reset: No
Additional Info:
Even if I manually select the row data by cells, e.g. the B1:B5 block and do
the same operation, it still only 'extends' it to A1:C2, stopping selection
again on the blank row.
I can't see any workaround to this bug, e.g. no way to sort the entire
spreadsheet on a column and keep the adjacent columns synched' with the sort
key in the sort column.
Version:
Version: 6.0.3.2 (x64)
Build ID: 8f48d515416608e3a835360314dac7e47fd0b821
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: en-US (en_US); Calc: group
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; TBTE; rv:11.0)
like Gecko
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
