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