Sugestion

[the-moog]

Just had a thought. I am new to Calc as part of an attempt at moving away from Windows. This project saved the day!!

I tried to use Calc instead of Excel for a task, but I found some of the new functions in Excel are missing. Then I found the tickets related to this, e.g. https://bugs.documentfoundation.org/show_bug.cgi?id=150866), so I can see it will be fixed some time. I found Calc already has a REGEX function, which makes processing text fields so much easier than in Excel. But I see my issue in that it does not (yet) have textsplit - though it does have textjoin - hmm odd. Anyway I found this project as a way to remedy this omission - yay! I would expect that means the resolution to most of those bugs could be be this very project if it is not already? If so a resolution is not far off?

I've no idea how to lobby LibreOffice to pass on ideas, though I thought perhaps this project might? If so perhaps the following implementation suggestion could go one step beyond what Excel now has, with complete compatibility of course.

Suggestion:
If built in REGEX or an alternate REGEXA in this project were to optionally return an array of match groups rather than just a given match or replacement, (i.e. just as regex does in most other languages) then there would be a common way to generate most of the new Excel text manipulation functions. They would be just pre-defined regex patterns. But taking that one step further, it could be used to make Calc more powerful than Excel, as this would also permit regex patterns as a parameter to the various functions and allow both array and range, as well a reference inputs.
Now we would then be able to process a list of items in one line. Perhaps (as afaik Excel never had named arguments??), implemented as named function variants just as Excel has for other functions e.g. RREPLACE/RREPLACEA instead of REPLACE.