[Libreoffice-bugs] [Bug 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=38343 Jean-Baptiste Faure changed: What|Removed |Added Resolution|--- |WORKSFORME Status|NEW |RESOLVED --- Comment #23 from Jean-Baptiste Faure --- According to comments #19 and #21, closing as WorksForMe. Please feel free to reopen if you disagree. Best regards. JBF -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=38343 --- Comment #22 from QA Administrators --- Dear Georg Hörmann, 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=38343 --- Comment #21 from Xavier Van Wijmeersch --- I agree with comment19 "I am not sure if this is really a bug or only a misunderstanding of what are relative and absolute references. Indeed, in the test case provided by Sasha, if you change the references in B3:B10 from relative to absolute, then the filter works as expected." My opinion its a misunderstanding off relative and absolute references. I think it can be closed as WFM Best regards -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=38343 --- Comment #20 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=38343 Jean-Baptiste Faure changed: What|Removed |Added CC||markus.mohrhard@googlemail. ||com --- Comment #19 from Jean-Baptiste Faure --- I am not sure if this is really a bug or only a misunderstanding of what are relative and absolute references. Indeed, in the test case provided by Sasha, if you change the references in B3:B10 from relative to absolute, then the filter works as expected. @Markus, please could you give your developer point of view? Is it the intended behavior to copy the cell content (formula if it is a formula) instead of the value of the cell? Best regards. JBF -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=38343 --- Comment #18 from tommy27 --- ** 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.5 or 5.1.2 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 If 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: 2016-04-16 -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=38343 --- Comment #17 from fury...@arcor.de --- Uhh, that's a very professional representation of your organisation, Joel. LO is deleted from my PC and won't be advocated any more at my customers. There are quite a few alternatives who can presumably react on feedback appropriately. Please, delete my account with your organization right away. Have a nice day, fury -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=38343 Joel Madero changed: What|Removed |Added Severity|normal |minor -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=38343 --- Comment #16 from Joel Madero --- @ Fury - Couple points here: 1. First warning - next one you will be banned at least temporarily from using bugzilla for violating The Document Foundation bugzilla rules (swearing and being verbally abusive towards community members); 2. The priority/severity literally has no real impact on getting the bug resolved, we use it internally only for general guidance - setting this to an ultra mega blocker is not going to convince a volunteer to fix the bug. You have admitted there are workarounds - by definition if there is a workaround we usually place the bug as minor, if it prevents high quality work, it's a normal bug, if it crashes and results in loss of data, then it's major or above - clearly this does not result in loss of data or crashes. 3. For more information on how our FRIENDLY community works please read the following: http://joelmadero.wordpress.com/2014/10/11/user-expectations-and-the-reality-of-our-community/ 4. I should have reverted it back to minor which I am doing now (and again, this literally has no impact on whether a volunteer looks at the bug or not, it's simply giving us accurate information as to what the bug does) 5. For more information feel free to join our chat (so long as you're going to be productive and not an interruption to our meritocratic community): http://webchat.freenode.net/?channels=libreoffice-qa Best, Joel -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=38343 --- Comment #15 from fury...@arcor.de --- (In reply to Joel Madero from comment #13) > @Fury - > http://joelmadero.wordpress.com/2014/10/11/user-expectations-and-the-reality- > of-our-community/ "manipulating priorities", LO-developers will avoide the bug completely!? Are you crazy??? If you had spent a second on the history of this bug, you would have recognized that it is known since nearly 4 years. If you had thought about the meaning of the bug you would have recognized that for LO-users using advanced filters this IS a blocker. As there had nothing been done on this bug since it was mentioned at first it is obvious that nobody pays any attention to it. As I am interested in having this bug fixed I am trying to tell this in my post. I am begging for sb to have a glance at the problem and to confirm that a solution is easy. As you may have overread I am explaining my willingness to come up with a testcase. As you evenly have overread sb (it was you yourself over 2 years ago, btw) has asked for one. Instead you have preferred to send me your knee-jerk reaction of this link to a lengthy text suggesting that I have a dishonest behaviour. Joel, stop sending bullshit like this to people. Better start working on the problem and start thinking before reflex-like sending affronts to strangers. Nonetheless and without any personal history in this forum or with LO, I confess, I suggest a more tight relation in regard to priorities of developers and users. Priorities are about talking, about understanding and about familiar relationships: Priorities are good! Kind regards and thank you to everybody working in their spare time on this wonderful product, fury -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=38343 --- Comment #14 from raal --- *** Bug 89479 has been marked as a duplicate of this bug. *** -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=38343 --- Comment #13 from Joel Madero --- @Fury - http://joelmadero.wordpress.com/2014/10/11/user-expectations-and-the-reality-of-our-community/ -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=38343 fury...@arcor.de changed: What|Removed |Added CC||fury...@arcor.de --- Comment #12 from fury...@arcor.de --- Hi all, this is totally wrong, must easily be corrected and has great importance to every user who is analyzing a big bunch of data! There is no conceptual work related to eliminating this bug. It's simply about copying values instead of formulas when using special/advanced filtering because adjusted cell pointers in new places never work. Any workaround is a long work around this bug. So, please, as we are all waiting since 2011, can somebody please have a look to it. For those affected by this bug, the importance is nearly a blocker! I can supply a testcase if you are in need. Many thanks. Regards, fury -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.freedesktop.org/show_bug.cgi?id=38343 Jean-Baptiste Faure changed: What|Removed |Added Status|RESOLVED|UNCONFIRMED CC||jbfa...@libreoffice.org Resolution|DUPLICATE |--- --- Comment #11 from Jean-Baptiste Faure --- This bug is not a duplicate of bug 45146. Indeed, even if the status of bug 45146 is not clear, the behavior described in it changed with the changes in sorting with reference provided by bug 81309 and bug 81633. This one is about copying formula instead of the data in advanced filter and nothing changed after bug 81309 in LO 4.4. Set status back to NEW. Best regards. JBF -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.freedesktop.org/show_bug.cgi?id=38343 Jean-Baptiste Faure changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.freedesktop.org/show_bug.cgi?id=38343 Joel Madero changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |DUPLICATE --- Comment #10 from Joel Madero --- I agree that the root of this is the same as 45146 - in general we would mark that one as a duplicate of this one as this one is older BUT since that one has already been confirmed, just going to mark this as a dupe. @Georg - if you disagree please let us know @mohican - thanks for pointing in the direction of that dupe, I was pretty sure I had confirmed a similar one at some point :) *** This bug has been marked as a duplicate of bug 45146 *** -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.freedesktop.org/show_bug.cgi?id=38343 --- Comment #9 from mohican --- With respect to sorting, it may be the same issue as in bug 45146 -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.freedesktop.org/show_bug.cgi?id=38343 sasha.libreoff...@gmail.com changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.freedesktop.org/show_bug.cgi?id=38343 --- Comment #8 from sasha.libreoff...@gmail.com --- Created attachment 70418 --> https://bugs.freedesktop.org/attachment.cgi?id=70418&action=edit Test case for sorting and filtering with formula problem This attachment contains explanations how to use Sort and Advanced filter and test results. Function Sort mentioned here because it is more simply and more frequently used. But appears that suffers from the same problem. IMHO we may use it for testing instead of Advanced filter Reproduced in 3.6.3 on RFR 17 64 bit Expected: correct values or formulas Actually: only zeros -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.freedesktop.org/show_bug.cgi?id=38343 Joel Madero changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||jmadero@gmail.com Ever confirmed|0 |1 --- Comment #7 from Joel Madero --- Can you attach a document and give precise steps on how to reproduce? I just did a really simple test and used a filter and it did copy the formulas but it copied them correctly so no #Null values were given. I think it makes more sense to have formulas copied/sorted correctly rather than just copy the value (many people would still want the formula). Marking as NEEDINFO until document and steps are attached. Please reopen as UNCONFIRMED once this is done. Apologies for the long delay, we're working on a big backlog. Thanks for your patience -- 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 38343] Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas
https://bugs.freedesktop.org/show_bug.cgi?id=38343 sasha.libreoff...@gmail.com changed: What|Removed |Added Summary|Behaviour of Advanced |Behaviour of Advanced |Filter in Calc/Spreadsheet |Filter in Calc/Spreadsheet ||is incorrect. Produced not ||working formulas -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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