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.