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...
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.)
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20170929
problem still exists in 5.3.6.1 x64
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.
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?
(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.)
(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...
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.
Created attachment 140785 [details] screenshot of conditional format sequence pretty obvious
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)
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
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
Actually there is a solid argument on having that list manually sort-able to apply a custom order for more structured (and overlapping) set of rules. See https://bugs.documentfoundation.org/show_bug.cgi?id=126047 My proposal is to close this bug since it's superseded by the above bug. *** This bug has been marked as a duplicate of bug 126047 ***
My request is not covered by bug number 126047 which addresses the sorting/ordering of rules within a condition. 105325 is for sorting the list of conditions by column number so that they appear as A, B, C....Z AA, AB....AZ BA....... which makes it easier to find the conditions when you know the column name BA and you scroll down to whatever follows AZ.
Hi! Even if that bug is not addressing the fact that the ordering is "broken" as you explained in this bug, Bug 126047 is actually covering this problem too (it's also in the title "Allow Changing Order of **Outer** Conditional Formats"). As you can see in the description it's all about enabling the user to re-arrange the order of the *outer* conditions list to enable actual "logics" on conditional formatting. A column name based order of the rules impedes this functions (even MS Excel allows that). Please try to read the Bug 126047 again and if it's clear re-set this bug to duplicated and resolved. In case there is any doubt, please ask.
Dear Aprax, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug