https://bugs.documentfoundation.org/show_bug.cgi?id=131944
--- Comment #10 from ady <[email protected]> --- ATM, in Calc, the size of the cell is expanded when the cell has the Wrap Text attribute and you (directly) introduce some text. At that instant, the size of the cell can be expanded. Continuing from that status (i.e. "size of the cell expanded, according to some rather long text within it"), changing the content of the cell in order to have a text that is shorter than the prior one, will not automatically shrink the cell's size. You will have to resize it (manually, for example to the new "optimal" size) after the new (shorter) text is introduced. Calc ATM does not automatically change the size of the cell according to the (text) result of a formula. I don't recall this was ever the case (but I will be happy to be misremembering). IMO, in comment 2 the confirmation of the behavior is rather partial. IOW, the confirmation is about the behavior, but not about the existence of a bug. So, again I ask... Is there any Help Content, or documentation, or Guide, or some tutorial, or some other case **in Calc** that would suggest that this was already the expected behavior? Could you provide a link to such Help Content (or similar)? >From your comment 9, my impression is that this is not a bug report, but rather a request for enhancement. In other words, you seem to be expecting a certain behavior, but there is no indication or some base to suggest that Calc was already supposed to behave in that way. Moreover, while I can understand the desire for the described behavior under certain conditions, I am sure that such change would be also disruptive and unwanted for some other cases. A user might not want to have the size of cells constantly changing depending on the varying results of formulas. Forcing such change for every cell that has the Wrap Text attribute without any other condition might not be welcome by many users with valid use-cases. Some other/additional attribute would have to be set in order to trigger the described (requested) behavior. Perhaps something related to automatically recalculating the "Optimal height"? (I have not tried it myself.) As a side note, there are alternatives to the request, although the result is not exactly the same. One possibility is to have the initial size of the cell to be the biggest possible (according to the longest possible text). Every shorter text will be entirely contained within the cell. Another alternative is to set the alignment to "Shrink to fit cell size" (whichever the initial size of the cell would be). -- You are receiving this mail because: You are the assignee for the bug.
