Re: [libreoffice-users] copy cell format

On 2015/09/18 20:17, Jim Quinn wrote:
> 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
> it ALWAYS comes out with equal column width (+ the default height of the
> new document).
>
> 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.
> Thomas
No, it is just the other way around.
I want to copy a formatted row with column headers into a blank document.
AND I want the copied row look in the new document exactly as it was in 
the original document.
THAT is something Calc does not seem to be able to do.
I just tried that trick with Excel (which I usually do not use any 
longer) - and it works there almost as easy as in Lotus123.

I believe this operation cannot be so tremendously difficult, that it is 
sheer impossible to accomplish (in Calc) ...
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