Re: [libreoffice-users] Re: formatting lost in referenced calc fields

2012-09-27 Thread jef.peeraer


ok, but it would be nice if you could indicate to copy the formatting as 
wellI thought I saw this somewhere in a dialog


jef


On Thu, 27 Sep 2012, Andreas Säger wrote:


Am 27.09.2012 09:31, jef.peeraer wrote:

So the thousands separator is lost.
Shouldn't the formatting of the calculator fields be copied into the
writer doc? Or do I have to format the fields again in the writer doc ?
LO is version 3.6.0.4 on 32 bit linux.


No, it shouldn't. You pull some raw data from somewhere (could be plain
text, html, some type of database as well) and apply your individual
formatting according to the capabilities of the reporting application (a
spreadsheet in this case).
Separation of data and formatting is an important feature even if
spreadsheets suggest the opposite.



--
For unsubscribe instructions e-mail to: users+h...@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


--
For unsubscribe instructions e-mail to: users+h...@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



Re: [libreoffice-users] Re: formatting lost in referenced calc fields

2012-09-27 Thread Tom Davies
Hi :)
Surely just either
Edit - Paste Special
or 
Ctrl Shift and v 
(both get same dialogue box).  Then choose Paste formatted text (Rtf), it's 
the 2nd option.  We usually use that route to paste unformatted so i've not 
tried the formatted option.  

I'm a huge fan of Rtf but it's just a description that might mean something to 
more people.  The Rtf is not quite proprietary and not quite OpenSource and is 
'maintained' by MS (who don't maintain it or develop it anymore because they 
lost the court-case about it and developed .DocX to be able to give the same 
promises legally.  Oddly .DocX seems to be falling short of the same promises  
in much the same way that Rtf did [shrugs])
Regards from
Tom :)  







 From: jef.peeraer jef.peer...@telenet.be
To: Andreas Säger ville...@t-online.de 
Cc: users@global.libreoffice.org 
Sent: Thursday, 27 September 2012, 12:56
Subject: Re: [libreoffice-users] Re: formatting lost in referenced calc fields
 

ok, but it would be nice if you could indicate to copy the formatting as 
wellI thought I saw this somewhere in a dialog

jef


On Thu, 27 Sep 2012, Andreas Säger wrote:

 Am 27.09.2012 09:31, jef.peeraer wrote:
 So the thousands separator is lost.
 Shouldn't the formatting of the calculator fields be copied into the
 writer doc? Or do I have to format the fields again in the writer doc ?
 LO is version 3.6.0.4 on 32 bit linux.

 No, it shouldn't. You pull some raw data from somewhere (could be plain
 text, html, some type of database as well) and apply your individual
 formatting according to the capabilities of the reporting application (a
 spreadsheet in this case).
 Separation of data and formatting is an important feature even if
 spreadsheets suggest the opposite.



 -- 
 For unsubscribe instructions e-mail to: users+h...@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

-- 
For unsubscribe instructions e-mail to: users+h...@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




-- 
For unsubscribe instructions e-mail to: users+h...@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