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

Thank you, Mark. I also don't have a MAC so on that score I was speaking theoretically. 

-- 
Jim

-----Original Message-----
From: libreoffice-ml.mbourne@spamgourmet.com
To: users@global.libreoffice.org
Sent: Fri, 10 Apr 2015 12:56
Subject: Re: [libreoffice-users] Calc: How to concat CTRL+ENTER to a string?

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

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