Does the new version bring the Filter function? It will be interesting to add it for the possibilities. I leave a demo video
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.
*** This bug has been marked as a duplicate of bug 126573 ***