https://bugs.documentfoundation.org/show_bug.cgi?id=159615
--- Comment #7 from ady <adylo811...@gmail.com> --- Just a comment regarding the Wrap Text cell attribute, FWIW. The Wrap Text changes the height of the cell, depending on the column width and the content (length) of the cell, *at the moment the Wrap Text attribute is applied*. If the IF() function changes the result of the cell (depending on whichever condition), the height of the cell remains as it was at the time the WT was initially applied. IOW, changing the result of the cell (depending on the condition for the IF() function) will not _automatically_ recalculate the height. Now, if you have a cell with text, and you manually edit the text and make it longer, then the cell's height can be extended; it might depend on others factors, especially related to the same row. OTOH, if you reduce the amount of text, the height of the cell is not automatically reduced. Setting Wrap Text OFF and then ON again on the cell, the height will be adapted again, according to the content of the cell at that moment. Using IF() means that the cell is not being edited, but instead its result changes according to the condition for that IF(). This is not the same as editing the content of the cell. In addition to this behavior, I believe that LO 24.2 improved/solved (at least partially) the behavior regarding Optimal Row Height and Optimal Column Width calculations. There are still things being improved for 24.2.1. Whether any of these changes might have some influence regarding Wrap Text behavior, IDK. I am not saying what should happen. I am just describing the behavior in Calc. Besides this behavior, there is the matter of whether the WT attribute is correctly saved as ods (or exported to xls(x) file format), which is the main question in this bug report. -- You are receiving this mail because: You are the assignee for the bug.