Re: [libreoffice-users] copy cell format

At 17:02 18/09/2015 +0900, Thomas Blasejewicz wrote:
> I have (naturally) a number of sheets / files. Sometimes I want to 
> copy let's say the first row, which contains all the names of the 
> columns etc., to create a new document. (not ALL documents use the 
> same format) Imagine there are 20-25 columns, most of which have 
> different widths. But when I copy row No.1 from file A to a new 
> file, no matter HOW I paste it there, it ALWAYS comes out with equal 
> column width (+ the default height of the new document).

I think you are right.

> In an ancient but VERY useful software = Lotus123 ...

I can't speak for Lotus 1-2-3 (which anyway has been discontinued).

> If I understand the page:
> https://help.libreoffice.org/Common/Copying_Attributes_With_the_Format_Paintbrush 
> correctly, "Form control is selected Not supported" means that Calc 
> is not able to do ...

I think the relevant entry here is for "Calc table or cells are 
selected", which says "Copies the formatting that is specified in the 
Format - Cells dialog as well as the formatting of the cell 
contents". That confirms that column width is not included.

> I am also under the impression, that the "paint brush" works ONLY 
> within one file, but not across different files.

I agree.

> Styles do not help either (as far as I can tell), since I could not 
> find any tab there, where I can specify column width + height.

That's right.

I think this all boils down to the fact that column width is a 
property of entire columns, of course, whereas the other formatting 
aspects that Calc is happy to copy may apply only to some cells in a column.

> Is there a trick?

There are some workarounds:

o Select the entire sheet in the source spreadsheet: go to Edit | 
Select All or press Ctrl+A or click the cell at top left where the 
column and row headers meet.
o Copy.
o Paste into the target spreadsheet. Create a new sheet in which to 
paste if necessary.
o Delete unwanted material.

Alternatively:
o Go to Insert | Sheet From File... .
o Browse to the source document and click Insert.
o Select the appropriate sheet to insert and the required position in 
the target document.
o OK.
o Delete unwanted material as above.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted