Description: Add WRAPROWS function to Calc for interoperability with MS Excel https://support.microsoft.com/en-us/office/wraprows-function-796825f3-975a-4cee-9c84-1bbddf60ade0 Steps to Reproduce: - Actual Results: Calc doesn't support WRAPROWS function Expected Results: Calc supports WRAPROWS 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 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
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/5f8a15382610e5d537d2e0fb338fffe33f8f4c09 tdf#150880: Add support for WRAPROWS function It will be available in 25.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Thank you for implementing the function. Added to Release Notes/25.8 https://wiki.documentfoundation.org/ReleaseNotes/25.8#Calc Updated "Unique Spreadsheet functions" in "Feature Comparison: LibreOffice - Microsoft Office" https://wiki.documentfoundation.org/Feature_Comparison:_LibreOffice_-_Microsoft_Office#Desktop_Spreadsheet_applications:_LibreOffice_Calc_vs._Microsoft_Excel Thank you