[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 Andreas Heinisch changed: What|Removed |Added Status|NEW |ASSIGNED Assignee|libreoffice-b...@lists.free |andreas.heini...@yahoo.de |desktop.org | -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 --- Comment #25 from Rob --- Selection list looks great as presented in attachment 170178. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 --- Comment #24 from Andreas Heinisch --- Is the proposed solution enough or should we add some kind of grey block/underlining etc.? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 --- Comment #23 from Andreas Heinisch --- Created attachment 170178 --> https://bugs.documentfoundation.org/attachment.cgi?id=170178=edit Proposed solution using quotes -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 --- Comment #22 from Rob --- Re-tested: environment: Version: 6.3.3.2 Build ID: a64200df03143b798afd1ec74a12ab50359878ed CPU-threads: 4; Besturingssysteem: Mac OS X 10.15; UI-render: standaard; VCL: osx; Locale: nl-NL (nl_NL.UTF-8); UI-taal: nl-NL Calc: threaded Problems still not resolved: Using the original uploaded file from Mark Bourne (attachment 103367): 1- In AutoFilter column B select 'Not empty' Only box 'Empty' is autmatically ticked. This is wrong. It ahould be the only box NOT ticked, while all other boxes (in thes case aaa and bbb) should be ticked. Using testfile uploaded in attachment 137320: The problemn described in comment 20 still exists. The weird thing is that it should be real easy to resolve: either: - Indicate the string length by putting quates around the whole string, e.g. " "", "aaa ", "aaa "," aaa ". - In indicate leading and trailing spaces with a grey block -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 --- Comment #21 from QA Administrators --- Dear wilkusz, 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 --- Comment #20 from Rob --- LO: Version: 6.0.6.2 Build ID: 0c292870b25a325b5ed35f6b45599d2ea4458e77 CPU threads: 4; OS: Mac OS X 10.13.6; UI render: default; Locale: nl-NL (en_NL.UTF-8); Calc: group Re-tested- Last described problem about 'impossible to destinguish between cells with unequal amount of spaces is still a problem. The attachment "screenshot of remaining issue" shows the problem. The same is true if a cell contains aaa and another "aaa ". Apparently we don't want to go the MS Excel way of trimming all cell contents (in that case empty includes 'spaces') To slove this we either need to an indication on the length of the string (eg light grey square or a very thin line box around the string) or we need quotes around the string. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 --- Comment #19 from QA Administrators --- ** 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 --- Comment #18 from Rob--- Sorry, forgot environment: Version: 5.4.0.3 Build ID: 7556cbc6811c9d992f4064ab9287069087d7f62c CPU threads: 4; OS: Mac OS X 10.12.6; UI render: default; Locale: en-US (en_NL.UTF-8); Calc: group -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 --- Comment #17 from Rob--- As can be seen from the uploaded files the selection issues are resolved, but the discrimination between fiels containing a various amount of spaces is not. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 --- Comment #16 from Rob--- Created attachment 137321 --> https://bugs.documentfoundation.org/attachment.cgi?id=137321=edit screenshot of remaining issue As cann be seen is this screenshot, there is no distinction between fields with 1 space and fields with more spaces (in this case 4 spaces. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 --- Comment #15 from Rob--- Created attachment 137320 --> https://bugs.documentfoundation.org/attachment.cgi?id=137320=edit testfile for the 'spaces' issue -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 --- Comment #14 from QA Administrators--- ** 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 Kevin Suochanged: What|Removed |Added Blocks||103512 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=103512 [Bug 103512] [META] Auto Filter related bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 Kevin Suochanged: What|Removed |Added Status|REOPENED|NEW -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 Robchanged: What|Removed |Added Status|RESOLVED|REOPENED Resolution|WORKSFORME |--- -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 --- Comment #13 from Rob--- I retested LO 5.2.0.4, on OS X- Things are improved. Solution is close but not completely OK. I created a test file with in col A the following: --- Heading (empty) bbb (1 space) ccc (4 spaces) ddd --- Then I ceate an autofilter. Findings: 1- When I select 'not empty' the sheet shows all but row 2 (which is empty). The tickboxes however only show (empty) ticked. This is wrong. 2- In the ticklist there are 2 ticks showing exactly the same (for row 4 [1 space] and row 6 [4spaces]). This is not very clear. MS trims the values, so become the same as . This wou;d solve the problem (at the expense of not being able to file on a string of a specified amount of spaces). Alternatively, the sting of spaces could be made viible by surrounding quotes in the ticklist. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 Kevin Suochanged: What|Removed |Added Status|NEW |RESOLVED CC||suokunl...@126.com Resolution|--- |WORKSFORME --- Comment #12 from Kevin Suo --- Set as WORKSFORME as I do not reproduce with the latest version. Please set back to NEW if you do reproduce. Thanks. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick "all" if each individual value is selected (blanks should be omitted)
https://bugs.documentfoundation.org/show_bug.cgi?id=46062 --- Comment #11 from QA Administrators--- ** 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 on a currently supported version of LibreOffice (5.0.4 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) 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: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-12-20 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick all if each individual value is selected (blanks should be omitted)
https://bugs.freedesktop.org/show_bug.cgi?id=46062 Rob r...@famjasper.nl changed: What|Removed |Added See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=65505 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick all if each individual value is selected (blanks should be omitted)
https://bugs.freedesktop.org/show_bug.cgi?id=46062 Rob r...@famjasper.nl changed: What|Removed |Added See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=68406 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick all if each individual value is selected (blanks should be omitted)
https://bugs.freedesktop.org/show_bug.cgi?id=46062 Rob r...@famjasper.nl changed: What|Removed |Added See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=44895 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick all if each individual value is selected (blanks should be omitted)
https://bugs.freedesktop.org/show_bug.cgi?id=46062 Joel Madero jmadero@gmail.com changed: What|Removed |Added Hardware|Other |All Status|UNCONFIRMED |NEW Severity|normal |minor Priority|medium |low Summary|FILTER: Autofilter |Autofilter should not tick |automatically selects All |all if each individual |if only one category and|value is selected (blanks |empty cells exist |should be omitted) Ever confirmed|0 |1 --- Comment #9 from Joel Madero jmadero@gmail.com --- My test system: Bodhi 2 (built on Ubuntu 12.04) x64 LibreOffice 4.2.6 rc Confirmed (see notes below) New - confirmed Minor - can slow down professional quality work but will not prevent it Low - the workaround is pretty straight forward (select not empty) Using the filters in column B (2 values + blanks), which has more than one unique value in addition to some empty cells: - Filter on aaa shows only rows containing aaa (not bbb or empty) - Filter on bbb shows only rows containing bbb (not aaa or empty) - Filter on Empty shows only rows with empty cell (not aaa or bbb) - Filter on All shows all rows (aaa, bbb and empty) - Attempting to filter for aaa or bbb automatically selects All, and includes the empty cells. Assuming the last is attempt to filter for aaa AND bbb not or (or works fine if you select just one as that's just step 1 and 2 above) Perhaps the tick boxes should all be greyed out if they can't accurately reflect the current filter? Even better, if (Empty) could be made one of the tick box options (without confusion with a possible value of Empty in a cell), it would be possible to select e.g. aaa and bbb without (Empty), or even aaa and (Empty) without bbb. Not a fan of graying out anything, you do it once or twice and you learn how to workaround it. It's a pretty small issue but an issue none the less. Changing title to better reflect the issue as this isn't dependent on only one category existing, it's if you select all categories available (whether that is one or ten) then all is automatically ticked. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 46062] Autofilter should not tick all if each individual value is selected (blanks should be omitted)
https://bugs.freedesktop.org/show_bug.cgi?id=46062 --- Comment #10 from Rob r...@famjasper.nl --- This bug is related to (but not the same as): [Bug 81577] - FILTER: Can't switch a filter of if only one value except NULL. I agree with you that graying out is not a very elegant solution. I repeat the suggested solution from [Bug 81577] since that solves both bugs in one go: --- 1- Add 'Empty' to the ticklist, and remove it from the text selection 2- Make clear 'not empty' has been selected (a tick after the text will do) 3- Make 'not empty' and 'All' mark appropriate list boxes 4- Mark 'not empty' if all boxes except 'Empty' are marked FYI: Excel marks that are blank, and fields solely consisting of spaces as (blanks). Excel in fact trims all fields, so for the tick boxes 'a' is the same as ' a '. --- -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs