MidNiteRaver
New Member
- Joined
- Jul 18, 2005
- Messages
- 34
I have a vlookup formula that returns variable text to a cell, some one line others up to 10 lines. I want to know how I can get the row height to automatically / dynamically adjust to accommodate the amount of text returned by the formula. The sheet is a protected sheet.
I know I can put autofit on the cell however when only one line of text is returned it leaves 9 lines of white space which is undesirable.
The above question was asked before in 2021 and responded to but for an Excel user. No sure if the answer is the same for LibreOffice Calc. Can it be done with using Macros?
Thank you
I know I can put autofit on the cell however when only one line of text is returned it leaves 9 lines of white space which is undesirable.
The above question was asked before in 2021 and responded to but for an Excel user. No sure if the answer is the same for LibreOffice Calc. Can it be done with using Macros?
Thank you