See meta bug 70798 for details.
Basically, this is ODFF1.2 function SUBTOTAL with some added functions and options to make it complicated...
Is it okay to change this to 'enhancement'? This to me is an enhancement rather than a bug.
(In reply to comment #2) > Is it okay to change this to 'enhancement'? This to me is an enhancement > rather than a bug. I have no objection, but the original bug report about missing Excel 2010 functions was filed as a bug (non-compatibility or something). BTW I hope to fix this one soon, so that 70798 can be closed too :-)
Created attachment 97532 [details] xlsx document used for testing AGGREGATE function
I'll change this to enhancement. This will help me keep my list of bugs smaller when I run my bugzilla query. Thanks a lot for your help.
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=29c9712b042e410e93e92dead15f353f6ca1e263 fdo#73148 (partial patch) Add Excel 2010 function AGGREGATE The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9c78e71903146acec47e0d32b23b9e5cc3e021a1 return early once we pushed an error, fdo#73148 related The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ee75263f6c942c0a8f59beb84c21a98c141bc7f1 we need to push a return value in any case, fdo#73148 related The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Created attachment 99153 [details] xlsx document for unit tests of AGGREGATE function Attached document is to be used as unit test (separate or included in existing unit test document for Excel 2010 functions). In the mean time I would like to use the document to verify the functionality when I add option (filters) support. The document has been produced with Calc, so the reference block (C37:U45) contains mostly incorrect data. The verify block verifies cells, columns, rows and th complete block.
(In reply to comment #9) > Created attachment 99153 [details] > xlsx document for unit tests of AGGREGATE function > > Attached document is to be used as unit test (separate or included in > existing unit test document for Excel 2010 functions). > In the mean time I would like to use the document to verify the > functionality when I add option (filters) support. > > The document has been produced with Calc, so the reference block (C37:U45) > contains mostly incorrect data. > > The verify block verifies cells, columns, rows and th complete block. @Eike, Could you have a look at the attachment and convert it to an Excel written document? And of course add useful comments? I intend to support option 0 and 4 first (the easy ones). With 19 functions and 7 options it will take some time to support all, including modifying SUBTOTAL()...
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=08e3e6c223c266874a4acf3885997ea6426aa9bd fdo#73148 add options to Calc function AGGREGATE The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
This bug fix comes with LibreOffice 4.4 (release notes https://wiki.documentfoundation.org/ReleaseNotes/4.4) Added AGGREGATE spreadsheet function for Excel interoperability.
Created attachment 112700 [details] aggregate bug or somthing bug
(In reply to sevan from comment #13) > Created attachment 112700 [details] [review] > aggregate bug or somthing > > bug @sevan: If you want to report a bug, could you please create a new bug report and include a description of the bug (as well as attachment in this case)? Could you please include me in the cc? This bug report is about adding a new function and is closed. Thank you.