Description: Add TEXTSPLIT function to Calc for interoperability with MS Excel https://support.microsoft.com/en-us/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7 Steps to Reproduce: - Actual Results: Calc doesn't support TEXTSPLIT function Expected Results: Calc supports TEXTSPLIT function Reproducible: Always User Profile Reset: No Additional Info: -
What's new in Office 2024 and Office LTSC 2024 ============================================== https://support.microsoft.com/office/what-s-new-in-office-2024-and-office-ltsc-2024-baadecbe-a8fc-4435-8cb8-70e93fd08b56 Text and array functions ------------------------ There are now 14 new text and array functions in Excel 2024 that are designed to help you manipulate text and arrays in your worksheets. These functions make it easier to extract and split text strings and enable you to combine, reshape, resize, and select arrays with ease. TextBefore() - TEXTBEFORE function Returns text that’s before delimiting characters https://support.microsoft.com/office/textbefore-function-d099c28a-dba8-448e-ac6c-f086d0fa1b29 TextAfter() - TEXTAFTER function Returns text that’s after delimiting characters https://support.microsoft.com/office/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4 TextSplit() - TEXTSPLIT function Splits text into rows or columns using delimiters https://support.microsoft.com/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7 VStack() - VSTACK function Stacks arrays vertically https://support.microsoft.com/office/vstack-function-a4b86897-be0f-48fc-adca-fcc10d795a9c HStack() - HSTACK function Stacks arrays horizontally https://support.microsoft.com/office/hstack-function-98c4ab76-10fe-4b4f-8d5f-af1c125fe8c2 ToRow() - TOROW function Returns the array as one row https://support.microsoft.com/office/torow-function-b90d0964-a7d9-44b7-816b-ffa5c2fe2289 ToCol() - TOCOL function Returns the array as one column https://support.microsoft.com/office/tocol-function-22839d9b-0b55-4fc1-b4e6-2761f8f122ed WrapRows() - WRAPROWS function Wraps a row array into a 2D array https://support.microsoft.com/office/wraprows-function-796825f3-975a-4cee-9c84-1bbddf60ade0 WrapCols() - WRAPCOLS function Wraps a column array into a 2D array https://support.microsoft.com/office/wrapcols-function-d038b05a-57b7-4ee0-be94-ded0792511e2 Take() - TAKE function Returns rows or columns from array start or end https://support.microsoft.com/office/take-function-25382ff1-5da1-4f78-ab43-f33bd2e4e003 Drop() - DROP function Drops rows or columns from array start or end https://support.microsoft.com/office/drop-function-1cb4e151-9e17-4838-abe5-9ba48d8c6a34 ChooseRows() - CHOOSEROWS function Returns the specified rows from an array https://support.microsoft.com/office/chooserows-function-51ace882-9bab-4a44-9625-7274ef7507a3 ChooseCols() - CHOOSECOLS function Returns the specified columns from an array https://support.microsoft.com/office/choosecols-function-bf117976-2722-4466-9b9a-1c01ed9aebff Expand() - EXPAND function Expands an array to the specified dimensions https://support.microsoft.com/office/expand-function-7433fba5-4ad1-41da-a904-d5d95808bc38
What's new in Office 2024 and Office LTSC 2024 ============================================== https://support.microsoft.com/office/what-s-new-in-office-2024-and-office-ltsc-2024-baadecbe-a8fc-4435-8cb8-70e93fd08b56 Text and array functions ------------------------ There are now 14 new text and array functions in Excel 2024 that are designed to help you manipulate text and arrays in your worksheets. These functions make it easier to extract and split text strings and enable you to combine, reshape, resize, and select arrays with ease. TextBefore() - TEXTBEFORE function Returns text that’s before delimiting characters https://support.microsoft.com/office/textbefore-function-d099c28a-dba8-448e-ac6c-f086d0fa1b29 TextAfter() - TEXTAFTER function Returns text that’s after delimiting characters https://support.microsoft.com/office/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4 TextSplit() - TEXTSPLIT function Splits text into rows or columns using delimiters https://support.microsoft.com/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7 VStack() - VSTACK function Stacks arrays vertically https://support.microsoft.com/office/vstack-function-a4b86897-be0f-48fc-adca-fcc10d795a9c HStack() - HSTACK function Stacks arrays horizontally https://support.microsoft.com/office/hstack-function-98c4ab76-10fe-4b4f-8d5f-af1c125fe8c2 ToRow() - TOROW function Returns the array as one row https://support.microsoft.com/office/torow-function-b90d0964-a7d9-44b7-816b-ffa5c2fe2289 ToCol() - TOCOL function Returns the array as one column https://support.microsoft.com/office/tocol-function-22839d9b-0b55-4fc1-b4e6-2761f8f122ed WrapRows() - WRAPROWS function Wraps a row array into a 2D array https://support.microsoft.com/office/wraprows-function-796825f3-975a-4cee-9c84-1bbddf60ade0 WrapCols() - WRAPCOLS function Wraps a column array into a 2D array https://support.microsoft.com/office/wrapcols-function-d038b05a-57b7-4ee0-be94-ded0792511e2 Take() - TAKE function Returns rows or columns from array start or end https://support.microsoft.com/office/take-function-25382ff1-5da1-4f78-ab43-f33bd2e4e003 Drop() - DROP function Drops rows or columns from array start or end https://support.microsoft.com/office/drop-function-1cb4e151-9e17-4838-abe5-9ba48d8c6a34 ChooseRows() - CHOOSEROWS function Returns the specified rows from an array https://support.microsoft.com/office/chooserows-function-51ace882-9bab-4a44-9625-7274ef7507a3 ChooseCols() - CHOOSECOLS function Returns the specified columns from an array https://support.microsoft.com/office/choosecols-function-bf117976-2722-4466-9b9a-1c01ed9aebff Expand() - EXPAND function Expands an array to the specified dimensions https://support.microsoft.com/office/expand-function-7433fba5-4ad1-41da-a904-d5d95808bc38 New IMAGE function ------------------ Now in Excel 2024, you can add pictures to your workbooks using copy and paste or you can use the IMAGE function to pull pictures from the web. You can also easily move, resize, sort, and filter within an Excel table without the image moving around. Image() - IMAGE function https://support.microsoft.com/office/image-function-7e112975-5e52-4f2a-b9da-1d913d51f5d5
The Document Foundation blog entitled “Lox365 extension: XLOOKUP (and more) for LibreOffice Calc” https://blog.documentfoundation.org/blog/2022/09/23/lox365-extension-xlookup-and-more-for-libreoffice-calc/ GitHub repository “Lox365: XLOOKUP for LibreOffice” https://github.com/goosepirate/lox365?tab=readme-ov-file#textsplit Perhaps this can help with implementing the TEXTSPLIT function? Thank you