[Solved] Extension that can do Fill Right for format?

[swampwiz]

Here's what I want to do. I have a column such that the cells are all different formats - forecolor, typeface, etc., and I want the whole row to have that same format. Fill Right would do it, but it would fill the data, and I want the data to remain the same. I don't think I can do this with the standard Calc. I thought that the color2rows extension would do that for colors (which is what I really need in terms of functionality), but I don't even see how to access that extensions!

[FJCC]

This should do what you want. Select all of the required cells of the formatted column and go to the menu Edit -> Copy. Select the entire block to which you want to transfer the formatting. Choose the menu Edit -> Paste Special and select to paste only the formatting.

[Zizi64]

...or use the Cell styles feature. Create some cell styles with the desired properties and apply them for your cellranges. Use the CTRL-M (Format - Clear Direct Formatting) to reset the manual formatting properties to the default properties of the Style.

[FJCC]

Tibor's answer is better than mine, styles are the way to go. You can even select a cell and click the New Style From Select button in the Styles and Formatting window (menu Format -> Styles and Formatting, second icon from the right near the top of the window) to create a style directly from your existing work.

[swampwiz]

This should do what you want. Select all of the required cells of the formatted column and go to the menu Edit -> Copy. Select the entire block to which you want to transfer the formatting. Choose the menu Edit -> Paste Special and select to paste only the formatting.

We have a winner!

[Villeroy]

If you want to expand an area to the right, insert new cells adjacent to the existing area.
If you want to expant A1:C10 --> A1:D10, select D1:D10 and insert cells or insert a whole column.
This will take over the format from the left and adjust all references to your cell range [*]
For instance, =SUM(A1:C1) becomes =SUM(A1:D1), same with charts, named ranges and any other feature that works with references.

[*] In rare cases this can be annoying, so this is a configurable option: Tools>Options>Calc>General> "Expand references ..." When this option is unset, only insertion within the recerenced area (and not adjacent to the right or below) will expand all references.