Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.