[Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 Xisco Faulí changed: What|Removed |Added CC||[email protected] Status|NEW |ASSIGNED Assignee|[email protected] |[email protected] |desktop.org | -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 --- Comment #4 from Jeremy Clark --- (In reply to Óvári from comment #2) > 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 I was happy to see the proposal to add the TEXTSPLIT function to Calc, which would improve compatibility with MS Excel. This would not only improve usability but also make it easier for users to manipulate data. Hopefully the development team will implement this feature soon! -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 Óvári changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||0878 -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 --- Comment #3 from Óvári --- 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 -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 Buovjaga changed: What|Removed |Added See Also|https://bugs.documentfounda | |tion.org/show_bug.cgi?id=16 | |3044| -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 Buovjaga changed: What|Removed |Added See Also|https://bugs.documentfounda | |tion.org/show_bug.cgi?id=16 | |3045| -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 Buovjaga changed: What|Removed |Added See Also|https://bugs.documentfounda | |tion.org/show_bug.cgi?id=16 | |3046| -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 Óvári changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||9129 -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 --- Comment #2 from Óvári --- 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 -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 Óvári changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=16 ||3046, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||0867, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||0868, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||0879, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||0880, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||0881, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||0999, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||1000, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||1001 -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 Óvári changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=16 ||3045 -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 Óvári changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=16 ||3044 -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 --- Comment #1 from Óvári --- 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 -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 Óvári changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||0865 -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 Óvári changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||0864 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 Michael Warner changed: What|Removed |Added Blocks|108827 |150900 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108827 [Bug 108827] [META] Calc functions bugs and enhancements https://bugs.documentfoundation.org/show_bug.cgi?id=150900 [Bug 150900] [META] Excel Functions -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 raal changed: What|Removed |Added CC||[email protected] Status|UNCONFIRMED |NEW Ever confirmed|0 |1 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 Regina Henschel changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=97 ||101 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150866] Add TEXTSPLIT function to Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=150866 Roman Kuznetsov <[email protected]> changed: What|Removed |Added Blocks||108827 CC||[email protected] Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108827 [Bug 108827] [META] Calc functions bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
