Hi Javen, thank you for the answer. How can I retrieve the best fit column width and the line spacing between each line of text? Which is the current column width, is it the sum of A and B?
Thanks, 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 -----Messaggio originale----- Da: Javen O'Neal [mailto:[email protected]] Inviato: lunedì 18 aprile 2016 19.23 A: POI Users List <[email protected]> Oggetto: Re: Setting automatic height for merged cells 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 > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
