| Summary: | Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Georg Hörmann <ghoermann> |
| Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | CC: | jbfaure, jmadero.dev, mohican, sasha.libreoffice |
| Version: | 3.4.0 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| i915 platform: | i915 features: | ||
| Attachments: |
Screenshot of error message
Test case for sorting and filtering with formula problem |
||
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian problem with copying formulas instead of data reproduced in 3.3.4 and 3.6.1 on Fedora 64 bit in Data->Filter->Standard Filter and in Data->Filter->Advanced Filter I agree that copying formulas instead of data is strange. And formulas become not working in result. IMHO should added option to force copying results of formulas instead of formulas itself. Or problem with copying incorrect formulas should be fixed. Or changed default behaviour to copying results of formulas instead of formulas. 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 Created attachment 70418 [details]
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
With respect to sorting, it may be the same issue as in bug 45146 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 *** 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 |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 47994 [details] Screenshot of error message Hello, the behavior of the advanced filter is very strange. Please see the attached screenshot. An advanced filter copies the *formulas* and not the *values*, this leads to the error messages in the screenshot (columns UVW) because the formulas frequently loose their context after copying. In Excel only the values are copied - this is something I would also suggest for Libreoffice, also because imported xls files (like the one from the attached screenshot) produce errors when the filter is applied.