Hello all together,
perhaps this is just an oversight on my end, but I haven’t found a solution so far. Perhaps someone can enlighten me.
Creating a form for a user, I want to use a text box, which automatically adjusts height to text- together with the row height.
Trying so with various methods, there is always some problem.
-
Method I tried:
Using the Text Box from “Drawing”, this is a rather easy task- selecting “Fit Height to Text” this works nicely, it does what it is supposed to.
However, it does not adjust the row height together with it, so if I write enough text, the rows below simply are hidden behind the textbox.
Is there a way to auto adjust the row height with it? -
Method:
Using the Text Box from “Form Controls”, gives me a nice Text Box which I even would prefer, setting it Multiline it’s nicer to handle than the drawing one imho.
But it seems it doesn’t adjust the height of the Box to Text at all, the option “Fit Height to Text” (in Position and Size) is plain greyed out for this one.
Is there a way to auto adjust the height with the entered text? (and corresponding the row height of course). -
Method
Ok, thinking: Then no Text Box, just merging the area in which the user is supposed to write in and tell him to “Ctrl+Enter”. Not the best handling, but alright, after all we are in calc here.
Yet again, no dice, once merged the cells to an area, the row height ain’t adjusted anymore.
Any way to enable row height adjusting again if using “Merge Cells”?
Of course just could put a border around it and call it a day, but… 
Is there a way to solve this in a nice and user friendly way?
Alternative ways which I maybe missed are also welcome.
Thanks 
