Description: Add XMATCH function in Calc https://support.office.com/en-us/article/xmatch-function-d966da31-7a6b-4a13-a1c6-5a33ed6a0312 Steps to Reproduce: - Actual Results: - Expected Results: - Reproducible: Always User Profile Reset: No Additional Info: -
Moving to NEW
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b36ecef07a4933c0943b27ea937f31e1df2e77cd tdf#128425 Add Excel2021 function XMATCH to Calc It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
(In reply to Commit Notification from comment #2) > Balazs Varga committed a patch related to this issue. > It has been pushed to "master": > > https://git.libreoffice.org/core/commit/ > b36ecef07a4933c0943b27ea937f31e1df2e77cd > > tdf#128425 Add Excel2021 function XMATCH to Calc > > It will be available in 24.8.0. > > The patch should be included in the daily builds available at > https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More > information about daily builds can be found at: > https://wiki.documentfoundation.org/Testing_Daily_Builds > > Affected users are encouraged to test the fix and report feedback. Added to LibreOffice 24.8 Release Notes at https://wiki.documentfoundation.org/ReleaseNotes/24.8#Calc Please update as required. Hopefully it will enable more people to be aware of the function and can start testing and providing any feedback. Thank you
(In reply to Óvári from comment #3) > (In reply to Commit Notification from comment #2) > > Balazs Varga committed a patch related to this issue. > > It has been pushed to "master": > > > > https://git.libreoffice.org/core/commit/ > > b36ecef07a4933c0943b27ea937f31e1df2e77cd > > > > tdf#128425 Add Excel2021 function XMATCH to Calc > > > > It will be available in 24.8.0. > > > > The patch should be included in the daily builds available at > > https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More > > information about daily builds can be found at: > > https://wiki.documentfoundation.org/Testing_Daily_Builds > > > > Affected users are encouraged to test the fix and report feedback. > Added to LibreOffice 24.8 Release Notes at > https://wiki.documentfoundation.org/ReleaseNotes/24.8#Calc > > Please update as required. > > Hopefully it will enable more people to be aware of the function and can > start testing and providing any feedback. > > Thank you I will add it next week. :)
> I will add it next week. :) The RN for 24.8 already have the relevant item, but hidden for now.
Sorry for the misunderstanding. It was understood that if an issue status is marked FIXED, then it is ready for adding to the Release Notes and promoting more generally. Should the status be changed to ASSIGNED until all the known issues are resolved? Thank you
(In reply to Balázs Varga (allotropia) from comment #4) > I will add it next week. :) https://wiki.documentfoundation.org/Talk:ReleaseNotes/24.8
(In reply to Óvári from comment #7) > (In reply to Balázs Varga (allotropia) from comment #4) > > I will add it next week. :) > > https://wiki.documentfoundation.org/Talk:ReleaseNotes/24.8 ATM we have more than a month for freeze/alpha1, and another month after that for beta1. In the meantime, there are enough developing tasks that deserve and require much more attention from Balázs (and from other developers) that must be actually ready before those points. I assure you that the RN page will be ready. The important thing is to actually (alpha) test under diverse conditions and report feedback if needed.
(In reply to Óvári from comment #7) > (In reply to Balázs Varga (allotropia) from comment #4) > > I will add it next week. :) > > https://wiki.documentfoundation.org/Talk:ReleaseNotes/24.8 Thanks for adding these to the release notes. :) Very soon will continue to work on the remaining new functions and will finish those before freeze/alpha1, and beta1. :) In the meantime alpha testing (for the newly implemented functions) in progress by the users I guess. :)
(In reply to Balázs Varga (allotropia) from comment #9) > Very soon will continue to work on the remaining new functions > and will finish those before freeze/alpha1, and beta1. Thank you for your comment. When will the implementation of dynamic arrays be available for the functions which require them for feature parity with other software implementations? Thank you
(In reply to Óvári from comment #10) > (In reply to Balázs Varga (allotropia) from comment #9) > > Very soon will continue to work on the remaining new functions > > and will finish those before freeze/alpha1, and beta1. > Thank you for your comment. > > When will the implementation of dynamic arrays be available for the > functions which require them for feature parity with other software > implementations? Thank you Probabaly parallel with the remaining functions. (hopefully in April&May) :) This dynamic array needed especially for the Filter (already implemented), Unique and Sequence functions which result array size can dynamiclly change.
(In reply to Óvári from comment #10) > When will the implementation of dynamic arrays be available for the > functions which require them for feature parity with other software > implementations? Thank you @Óvári, you can start testing the newly implemented functions already (please do!) even without dynamic arrays. At a minimum, you could take xlsx files that have been created in other tools and compare the results in Calc. Actual testing of XMATCH() depends on users and has real impact. The rest is just noise.
In release notes: https://wiki.documentfoundation.org/ReleaseNotes/24.8#Calc
Another link for testers: https://bettersolutions.com/excel/functions/xmatch-function.htm
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/c9245c153d349ee414fdd4f878fd10cbd8471cff Related: tdf#128425 tdf#127293 - Extend function wizard description It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
ODF proposal is here: https://issues.oasis-open.org/browse/OFFICE-4155