Copy format

[TAB]

How to copy the format (Column widths, row heights, cell number and date formats,..) from one sheet to another?
TY

[kingfisher]

Use Paste special and select only "formats".

[keme]

Use Paste special and select only "formats".

... or use the paintbrush tool: Select the entire sheet. Click the paintbrush icon, then select the target sheet tab and click in cell A1.

[Villeroy]

Row heights and column widths do not belong to cell formats. Copy the entire sheet, select all cells (Ctrl+A) and clear contents (Backspace).

[huw]

Row heights and column widths do not belong to cell formats.

But they can be copied & pasted with "Paste special - formats only" when selecting rows or columns by their header, or when selecting a whole sheet by the wee square at the top left (does it have a name?).

I keep a formatted empty sheet as a "template" and select it by the wee square, hit Ctrl+C, then go to the new sheet I want to set up. Again I select it by the wee square, and Ctrl+Shift+V formats only.

[TAB]

the wee square at the top left (does it have a name?).

What about 'the origin'?
Thank you for the information.

[huw]

OpenOffice Application Help calls it by the catchy names of the empty gray box in the upper left of the spreadsheet, or the field in the upper left corner.

Microsoft have added a triangle to it, and call it the Select All button.

[Villeroy]

huw,
Thank you fo rcorrecting me. I did not know that rows and columns can be copied as separate objects.

[quio]

What if you want to copy a number of cells and paste them in the same sheet, keeping both height and width of cells? The select all button doesn't work and by only selecting either columns or rows you only conserve either width or height respectively.
One would think this should be an easy everyday task, but apparently, it is not...

[Lupp]

As already relevant for previous posts:

Height and width aren't cell attributes but attributes of rows an columns respectively. They cannot be copied therefor together with cell ranges except if these ranges consist of complete rows (for height) or columns (for width).

To force the heights and widths exemplified by the copied cells upon the rows and columns where the cells are pasted in, regardless of all the other cells afflicted by that, you would need a specialised copy-paste-process implemented by user code.

Conflicts and unwanted side-effects to be expected!

Edit1:

...you would need a specialised copy-paste-process implemented by user code.

Came back to attach a demo I made last week and equiped today with a caller:

aoo3440copyWithForcedHeightWidth_1.ods

(16.82 KiB) Downloaded 170 times