Calc: Duplicate reference formatting automatically?

asked 2016-01-17 22:20:42 +0100

Chris UK gravatar image

updated 2016-01-18 14:51:08 +0100

Hello, I have a reference to a range of cells on a seperate sheet, these are in the same document.

Is there a way to copy the formatting of the referenced sheets automatically? I'm currently getting frustrated as when i add a new line to the area being referenced it breaks my layout in the first sheet.

What i want to be able to copy is the data which works but also the borders, font styles and merged cells.

Is this at all possible? or would i need a macro to do it?

edit retag flag offensive close merge delete