Bug 159771 - [LOCALHELP] Add Help page for Calc function XMATCH
Summary: [LOCALHELP] Add Help page for Calc function XMATCH
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
24.8.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Olivier Hallot
URL:
Whiteboard: target:24.8.0 inReleaseNotes:24.8
Keywords:
Depends on:
Blocks: HelpGaps-NewFeatures
  Show dependency treegraph
 
Reported: 2024-02-19 10:09 UTC by Olivier Hallot
Modified: 2024-05-18 01:41 UTC (History)
1 user (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 Olivier Hallot 2024-02-19 10:09:06 UTC
Following resolution of Bug#128425, write the help page of the function.

Tasks
1) Create the file source/text/scalc/01/func_xmatch.xhp
2) add it to git
3) add entry in makefile in AllLangHelp_scalc.mk
4) fill XHP contents.

Source 
https://bugs.documentfoundation.org/show_bug.cgi?id=128425

Other spreadsheet product in the industry but contents shall not be copied and must be written in own words.

https://help.libreoffice.org/master/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3158407

5) Test
6) submit patch
Comment 1 Commit Notification 2024-02-19 22:31:33 UTC
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/help/commit/7d1418f79a28f5e38f65054b27f7062f77952e94

tdf#159771 Add XMATCH help page
Comment 2 Óvári 2024-05-16 07:37:44 UTC
In release notes:
https://wiki.documentfoundation.org/ReleaseNotes/24.8#LibreOffice_Help
Comment 3 Óvári 2024-05-18 01:41:54 UTC
1. Should `-1 - Exact match` and `1 - Exact match` be changed to `-1 - Closest match` and `1 - Closest match`, respectively?
2. Should `MatchType` be changed to `MatchMode`?
3. Should links be added, such as:
```
* For the Microsoft documentation refer to [support.microsoft.com](https://support.microsoft.com/en-us/office/xmatch-function-d966da31-7a6b-4a13-a1c6-5a33ed6a0312)
* For the Google documentation refer to [support.google.com](https://support.google.com/docs/answer/12406049)
```

Inspiration from:
https://bettersolutions.com/excel/functions/xmatch-function.htm

Thank you