[Libreoffice-ux-advise] [Bug 142515] Optimal width/height of merged cells

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Apr 21 20:30:00 UTC 2023


https://bugs.documentfoundation.org/show_bug.cgi?id=142515

--- Comment #11 from Eike Rathke <erack at redhat.com> ---
I don't see a straight forward solution for this. As the content of the merged
cell has 6 lines, the only good solution would be to merge it over 6 rows
instead of 5, i.e. B2:B7. Not doing so and not manually adjusting height calls
for trouble. Any other would have to ask the user what they want, as Heiko
lined out in comment 9. And then imagine multiple merged cells with different
content height merged over different rows..

Mentioning the dirty word, what does Excel do for this?

(In reply to Heiko Tietze from comment #10)
> Potential duplicate:
> * bug 57150: Calc FORMATTING: "Optimal column width" works incorrectly when
> column includes a merged cell
Not a duplicate, because that optimal column width behaviour is a result of a
combination of merged cell with wrap-text cells interspersed with a not-wrapped
cell, see https://bugs.documentfoundation.org/show_bug.cgi?id=57150#c6 about
A20.

-- 
You are receiving this mail because:
You are on the CC list for the bug.


More information about the Libreoffice-ux-advise mailing list