Established that the "automatic wrapping" function needs the involved row beeing setted "Optimal Height" I suggest to add a warning in the help (all languages) in order to instruct that the function needs as prerequisite the "Optimal Height" setted for the involved rows (for references see bugs 95098, 32950, 95131). Note: not always that setting is the default, such as migrating from Excel.
Seems like documentation issue, not Calc issue - setting to Documentation.
(In reply to Joel Madero from comment #1) > Seems like documentation issue, not Calc issue - setting to Documentation. Yes, documentation, but related to Calc
Let's set to NEW.
Made changes to 1) source/text/scalc/guide/text_wrap.xhp <note id="note_xls_optimal_height">For automatic wrapping, row should be set to Optimal Height. </note> 2) source/text/shared/guide/breaking_lines.xhp <embed href="text/scalc/guide/text_wrap.xhp#note_xls_optimal_height"/>
gar Soul committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/a097662d6678263bb91b6a1dc1f5494fbf47bf38 tdf#95147 Add note to use Optimal Height with wrapping in XLS files
gar Soul committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/help/commit/b9a3bdeb9ede49b13e65c0f2c403ef5fbed6e0ee tdf#95147 Add note to use Optimal Height with wrapping in XLS files
Verified as fixed in: https://help.libreoffice.org/7.2/en-GB/text/scalc/guide/text_wrap.html?&DbPAR=WRITER&System=UNIX and: https://help.libreoffice.org/7.2/en-GB/text/shared/guide/breaking_lines.html?&DbPAR=WRITER&System=UNIX