Currently in our Spreadsheet, when wrap is applied to a
cell, the system checks the width of each character in the cell’s value based
on the applied style. The time taken for this operation may vary depending on
the characters involved.
Therefore, if we apply wrap fucntionality for the large dataset by selecting all cells using the Select All option, there will be performance lag in our Spreadsheet.
However, this needs to be optimized by caching previously
calculated text widths, which would help avoid redundant calculations and
improve row height updates. And it needs to be thoroughly validated across other
features such as resizing, selection, and more to ensure stability.
In the sample shared below, applying wrap to 108 rows and 36 columns takes more than 13 seconds, highlighting the need for performance improvements.
And we need to
enhancing the wrap functionality to better handle larger datasets efficiently.
Bold BI
Bold Reports
BoldDesk