Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


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

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.