Ask Your Question

Optimal row height, in linked cell

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

dejayajay gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

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

libreofficeUser30872 gravatar image

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 more
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 79 times

Last updated: Feb 02