Download it now!
Bug 105325 - Sorting of Conditional Formatting Ranges in the manage dialog should be by column order instead of alphabetically
Summary: Sorting of Conditional Formatting Ranges in the manage dialog should be by co...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.7.2 release
Hardware: x86-64 (AMD64) All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Conditional-Formatting-Managing
  Show dependency treegraph
 
Reported: 2017-01-14 05:02 UTC by Aprax
Modified: 2019-03-31 10:29 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
shows incorrect sort sequence (23.46 KB, image/png)
2017-09-29 17:35 UTC, Aprax
Details
Conditional format sorting wrong - A, AA, AB, B, ....Z (29.94 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-03-21 11:45 UTC, Aprax
Details
screenshot of conditional format sequence (20.92 KB, image/png)
2018-03-21 11:50 UTC, Aprax
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Aprax 2017-01-14 05:02:35 UTC
Sorting of Ranges has been restored, great news.

However they are still sorted by:

A....
AA....
B

when they should be sorted by:

A...
B...
AA...

This could be accomplished by creating a new, temporary column containing the interger for each column and sort the temporary column.

1 A...
2 B...
26 AA...

with the result displayed as 

A...
B...
AA...

When a Range contains multiple ranges such as:

AA...., H...., M....

the same technique could be applied to give:

H..., M..., AA...
Comment 1 Xisco Faulí 2017-03-08 11:45:00 UTC
Hello Aprax,

Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 2 QA Administrators 2017-09-29 08:57:39 UTC Comment hidden (obsolete)
Comment 3 Aprax 2017-09-29 17:32:21 UTC
problem still exists in 5.3.6.1 x64
Comment 4 Aprax 2017-09-29 17:35:41 UTC
Created attachment 136630 [details]
shows incorrect sort sequence

columns AA and AB follow column Z in the sheet and should follow Z in the sorted sequence of Conditional Formatting rather than in between columns A and B.
Comment 5 Aprax 2018-03-06 14:43:40 UTC
Well CF has been improved but it still creates extra rows and those rows have exactly the same rules as the original, how stupid is that?
Comment 6 Xisco Faulí 2018-03-21 11:07:20 UTC
(In reply to Xisco Faulí from comment #1)
> Hello Aprax,
> 
> Thank you for reporting the bug. Please attach a sample document, as this
> makes it easier for us to verify the bug. 
> I have set the bug's status to 'NEEDINFO'. Please change it back to
> 'UNCONFIRMED' once the requested document is provided.
> (Please note that the attachment will be public, remove any sensitive
> information before attaching it. 
> See
> https://wiki.documentfoundation.org/QA/
> FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help
> on how to do so.)
Comment 7 Xisco Faulí 2018-03-21 11:07:38 UTC
(In reply to Xisco Faulí from comment #1)
> Hello Aprax,
> 
> Thank you for reporting the bug. Please attach a sample document, as this
> makes it easier for us to verify the bug. 
> I have set the bug's status to 'NEEDINFO'. Please change it back to
> 'UNCONFIRMED' once the requested document is provided.
> (Please note that the attachment will be public, remove any sensitive
> information before attaching it. 
> See
> https://wiki.documentfoundation.org/QA/
> FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help
> on how to do so.)

Please attach a sample document...
Comment 8 Aprax 2018-03-21 11:45:35 UTC
Created attachment 140784 [details]
Conditional format sorting wrong - A, AA, AB, B, ....Z

You could have created an ods yourself to demonstrate the sequence but here it is.
Comment 9 Aprax 2018-03-21 11:50:00 UTC
Created attachment 140785 [details]
screenshot of conditional format sequence

pretty obvious
Comment 10 Buovjaga 2018-03-27 15:35:20 UTC
Repro with document.

Arch Linux 64-bit
Version: 6.1.0.0.alpha0+
Build ID: b5c28d34a2697ccc22faea2c5c6db99a1798338d
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on March 27th 2018

Arch Linux 64-bit
Version 3.6.7.2 (Build ID: e183d5b)
Comment 11 QA Administrators 2019-03-28 04:20:18 UTC Comment hidden (obsolete)
Comment 12 Aprax 2019-03-31 10:29:50 UTC
column AA still sorts before column B in LO 6.2.2.2 x64 which indicates that this hasn't been corrected.

A
AA
B

should be 
A
B
AA