Documentation for SPLIT function is wrong

[sequba]

Description

It should say:

SPLIT(Text, Index) - divides the provided text using space character as a separator and returns the substring at zero-based position specified by the second argument.
E.g.:
- SPLIT("Lorem ipsum dolor", 0) -> "Lorem"
- SPLIT("Lorem ipsum dolor", 1) -> "ipsum"
- SPLIT("Lorem ipsum dolor", 2) -> "dolor"
- SPLIT("Lorem ipsum dolor", 3) -> #VALUE

Also, add it to the known-limitations page as it is different from Google Sheets implementation. Consider renaming it.

Links

• https://github.com/handsontable/hyperformula/issues/857
• https://handsoncode.slack.com/archives/C031GBX62SE/p1658825517285939 (internal discussion)

Type of issue

• [ ] Missing documentation
• [x] Error in the documentation
• [ ] Request for a demo
• [ ] Request for a tutorial, guide etc.
• [ ] Other issues, suggestions or ideas

[sequba]

Closing as released in version 2.1.0.