Re: [libreoffice-users] copy cell format

I think the problem being experienced is that the column widths are not copied or adjusted to fit 
the contents. The best I can think of is to paste the data, then select it and use 
Format>Column>optimal width. This may not be quite what is required, but it may at least help a 
bit. /Gary
      From: Jim Quinn <quinnje.1@gmail.com>
 To: users@global.libreoffice.org; Thomas <nyuwa@hb.tp1.jp> 
 Sent: Friday, 18 September 2015, 12:17
 Subject: Re: [libreoffice-users] copy cell format
   
Sorry for just replying to email vs getting into LO and answering.  Just too 
busy with huge biking event this weekend and am new using LO forums.

That said, if I understand that you want to copy the data from 1 spread 
sheet file (1 or more rows/columns) and paste just the data into a file with 
different column/row formatting, then use the "Paste Special" option and 
only check the items in the "Paste Special" pop-up menu that you want.  Do 
not check "Format" and the column/row format will remain unchanged.

Of course, the number of rows/columns you paste into should equal what you 
copied.

-----Original Message----- 
From: Thomas
Sent: Friday, September 18, 2015 4:02 AM
To: users@global.libreoffice.org
Subject: [libreoffice-users] copy cell format

Good evening
I have been trying to find hints in the documentation, but had no
success so far.

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).
That means, I have to reformat the whole thing EVERY time I do this.
(not frequently, but also not a rare operation)

In an ancient but VERY useful software = Lotus123 that requires only
checking one box.

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 what Lotus could do 20 years ago.
Is that right? Or am I missing something?
I am also under the impression, that the "paint brush" works ONLY within
one file, but not across different files.

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.

Is there a trick?
Is so, I would really like to know.

Thank you.
Thomas



-- 
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 




-- 
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


  
-- 
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