https://bugs.documentfoundation.org/show_bug.cgi?id=142515
--- Comment #11 from Eike Rathke <er...@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.