Created attachment 124654 [details]
base for help text CONCAT and TEXTJOIN
CONCAT, TEXTJOIN, IFS, SWITCH, MINIFS and MAXIFS will be added to Calc (bug 97831).
CONCAT and TEXTJOIN are the first two that have been pushed.
Created attachment 124679 [details]
base for help text for IFS and SWITCH
(IFS and SWITCH are not yet available at the moment of uploading, but in gerrit.)
IFS and SWITCH will be in version 5.2.0.
MINIFS and MAXIFS are currently being reviewed.
These functions are just like the existing SUMIFS, AVERAGEIFS and COUNTIFS, with the only difference that they produce the minimum respectively maximum value of the resulting range. I don't think I need to providee a separate help text for these two functions.
*** Bug 100796 has been marked as a duplicate of this bug. ***
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":
tdf#99517 help for CONCAT, TEXTJOIN, IFS, SWITCH
*** Bug 124502 has been marked as a duplicate of this bug. ***
*** Bug 123001 has been marked as a duplicate of this bug. ***