Bug 128425 - Add XMATCH function in Calc
Summary: Add XMATCH function in Calc
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Balázs Varga (allotropia)
URL: https://issues.oasis-open.org/browse/...
Whiteboard: target:24.8.0 inReleaseNotes:24.8
Keywords:
Depends on:
Blocks: Excel-Functions
  Show dependency treegraph
 
Reported: 2019-10-28 10:03 UTC by Roman Kuznetsov
Modified: 2024-11-03 19:12 UTC (History)
12 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2019-10-28 10:03:48 UTC
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:
-
Comment 1 Xisco Faulí 2019-11-15 12:06:01 UTC
Moving to NEW
Comment 2 Commit Notification 2024-02-18 22:13:32 UTC
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.
Comment 3 Óvári 2024-02-25 10:21:14 UTC
(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
Comment 4 Balázs Varga (allotropia) 2024-02-25 15:29:18 UTC
(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. :)
Comment 5 ady 2024-02-25 19:41:29 UTC
> I will add it next week. :)

The RN for 24.8 already have the relevant item, but hidden for now.
Comment 6 Óvári 2024-02-25 22:10:59 UTC
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
Comment 7 Óvári 2024-04-02 20:34:41 UTC
(In reply to Balázs Varga (allotropia) from comment #4)
> I will add it next week. :)

https://wiki.documentfoundation.org/Talk:ReleaseNotes/24.8
Comment 8 ady 2024-04-02 23:06:55 UTC
(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.
Comment 9 Balázs Varga (allotropia) 2024-04-03 10:06:27 UTC
(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. :)
Comment 10 Óvári 2024-04-03 10:19:15 UTC
(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
Comment 11 Balázs Varga (allotropia) 2024-04-03 10:42:29 UTC
(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.
Comment 12 ady 2024-04-03 14:12:12 UTC
(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.
Comment 13 Óvári 2024-05-16 07:46:09 UTC
In release notes:
https://wiki.documentfoundation.org/ReleaseNotes/24.8#Calc
Comment 14 Óvári 2024-05-18 01:44:12 UTC
Another link for testers:
https://bettersolutions.com/excel/functions/xmatch-function.htm
Comment 15 Commit Notification 2024-06-04 10:10:33 UTC
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.
Comment 16 Óvári 2024-06-09 04:17:39 UTC
ODF proposal is here:
https://issues.oasis-open.org/browse/OFFICE-4155