Re: [libreoffice-users] Calc: How to concat CTRL+ENTER to a string?

Thanks to all who replied. <y problem is solved. This is 
what I'm using:

="Target Balance" & CHAR(10) & "Assuming " & $E$2*100 & "% 
Growth"

No need for the CHAR(13).

-Bill

On 4/10/2015 3:54 PM, libreoffice-ml.mbourne@spamgourmet.com 
wrote:
> James E Lang - jim+lou@lang.hm wrote:
> > On a Windows platform I use &CHAR(13)&CHAR(10) [CR+LF] 
> > instead of just &CHAR(10) [LF] which I use on a Linux 
> > platform or just &CHAR(13) [CR] which I would expect to 
> > use on a MAC platform
>
> Those are the conventions for plain text files on those 
> systems. Although I believe Mac OSX uses LF, same as Unix, 
> while Mac OS up to version 9 used CR.
>
> Even in the case of plain text, now that files are so 
> readily transferred between systems, most decent text 
> editors cope fine with all 3 formats regardless of which 
> system they're running on.
>
> > Do I over complicate the process?
>
> For LibreOffice documents, I think you do. What do you do 
> in a document which might be transferred between different 
> systems?
>
> Does CHAR(13) in a LibreOffice formula on Mac even have 
> the intended effect of splitting lines? Come to that, does 
> LibreOffice even run on Mac OS 9 or before? I suspect 
> LibreOffice only uses CHAR(10) regardless of OS, although 
> I don't have a Mac (let along one before OSX) to try.
>
> On Windows LibreOffice, all that's needed is CHAR(10). 
> CHAR(13) has no apparent effect, other than cluttering the 
> formula.
>
> Mark.


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