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, [email protected]
wrote:
James E Lang - [email protected] 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: [email protected]
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
