[Libreoffice-bugs] [Bug 147224] LibreOffice without the Filter function
https://bugs.documentfoundation.org/show_bug.cgi?id=147224 QA Administrators changed: What|Removed |Added Whiteboard| QA:needsComment| -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147224] LibreOffice without the Filter function
https://bugs.documentfoundation.org/show_bug.cgi?id=147224 Mike Kaganski changed: What|Removed |Added Resolution|--- |DUPLICATE Status|UNCONFIRMED |RESOLVED --- Comment #2 from Mike Kaganski --- *** This bug has been marked as a duplicate of bug 126573 *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147224] LibreOffice without the Filter function
https://bugs.documentfoundation.org/show_bug.cgi?id=147224 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147224] LibreOffice without the Filter function
https://bugs.documentfoundation.org/show_bug.cgi?id=147224 m.a.riosv changed: What|Removed |Added Severity|normal |enhancement -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147224] LibreOffice without the Filter function
https://bugs.documentfoundation.org/show_bug.cgi?id=147224 --- Comment #1 from David Leal --- The idea is not to use macros. There's no turning back, the Filter function is ideal for making the dropBox searchable! I did the following experiment just now: I opened excel from outlook.com and made a small table using the filter function. Then I downloaded this file to my PC and opened it with version 7.2.5 of Calc, to see if there is any similar function. The return was: =_xlfn._xlws.filter(A2:A9;B2:B9="A";"Not Found") The same return appeared in OnlyOffice with this difference =_XLWS.FILTER(A2:A9;B2:B9= "A";"Not Found"); with the difference that OnlyOffice was the only one capable of putting it into action! Calc was not able to! Now imagine you have an Excel database using this function. You will not have that file working in Calc. This function must be implemented in Calc. It opens up many avenues for advanced research. -- You are receiving this mail because: You are the assignee for the bug.