Best fit column height = ceil(best fit column width / current column width) * (height of a character + line spacing between each line of text) + margin top + margin bottom
This assumes all characters in the cell are the same font. On Apr 18, 2016 9:20 AM, "Roberto Marchioni" <[email protected]> wrote: > Hi everyone, > I'm merging two cell (for example A2:B2) and I'm writing in the new region > with the 'wrap' option enabled. > I'm not able to automatically adjust the height of the row, so if the > string wraps it's not correctly viewed. > Is there a code to make it adjust it? > > Thanks everyone, > Roberto > > _________________________ > > Roberto Marchioni > Technical Dept. > > Tattile S.r.l. > Via Gaetano Donizetti, 1 - 25030 Mairano (BS) - Italy > ph.: +39 030 9700269 > [email protected] - www.tattile.com >
