Optimal row height, in linked cell

asked 2015-01-19 03:01:03 +0100

dejayajay
1 ●4 ●8 ●7

Is it possible to get a destination cell's Row Height to automatically adjust, when the text in a source cell increases (causing the source cell's row height to automatically increase). Both source and destination are merged to equal sizes, but are on different sheets.

I can get the source cell to increase as I increase the text, but I cannot (yet) get the destination cell to do likewise, without having to manually re-select Optimal Row Height for the destination cell.

Is there a solution to this? Perhaps with a Macro if necessary?

answered 2019-02-02 20:25:04 +0100

libreofficeUser30872
156 ●2 ●8 ●16

How are you increasing the text size - direct formatting or style format?

Get rid of the direct formatting and use the same style for both cells. Works even if on different sheets.

Tip: An easy way to create a style from a direct formatted cell is to use the Style Manager (Styles > Manage Styles or F11). There is a button on the top right of the Style Manager. Hover over the cells to see the tool text and look for, "Create a new style based on the formatting of a selected object". When you click the button, a window will be displayed to allow you to enter your new style name. Remove direct formatting. Apply new style to all needed cells.

Conditional Styles can be used if the cells style changes with content.

LO: V6.1.4.2

edit flag offensive delete link

add a comment

Optimal row height, in linked cell

1 Answer

Question Tools

Stats

Related questions

Optimal row height, in linked cell edit

1 Answer

Question Tools

Stats

Related questions

Optimal row height, in linked cell