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.mbou...@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+...@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+unsubscr...@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+unsubscr...@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] Calc: How to concat CTRL+ENTER to a string?
James E Lang - jim+...@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+unsubscr...@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
[libreoffice-users] Calc: How to concat CTRL+ENTER to a string?
All, To place two lines of text in a cell I type the first line then press CTRL+ENTER and type the second line. I am trying to do this in an equation and don't know how. Here's what I have: =CONCATENATE(Target Balance Assuming , E2*100, % Growth) I want everything after Target Balance to appear in the second line of the cell so that the cell looks like this: Target Balance Assuming xx% Growth How do I modify the above equation to achieve this? Thanks, -Bill -- To unsubscribe e-mail to: users+unsubscr...@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] Calc: How to concat CTRL+ENTER to a string?
Hi,try: =CONCATENATE(Target Balance CHAR(10) Assuming E2*100 % Growth) /Gary From: William Drago wdr...@suffolk.lib.ny.us To: LibreOffice List users@global.libreoffice.org Sent: Thursday, 9 April 2015, 12:17 Subject: [libreoffice-users] Calc: How to concat CTRL+ENTER to a string? All, To place two lines of text in a cell I type the first line then press CTRL+ENTER and type the second line. I am trying to do this in an equation and don't know how. Here's what I have: =CONCATENATE(Target Balance Assuming , E2*100, % Growth) I want everything after Target Balance to appear in the second line of the cell so that the cell looks like this: Target Balance Assuming xx% Growth How do I modify the above equation to achieve this? Thanks, -Bill -- To unsubscribe e-mail to: users+unsubscr...@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+unsubscr...@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] Calc: How to concat CTRL+ENTER to a string?
Hi William, Am 09.04.2015 um 13:17 schrieb William Drago: =CONCATENATE(Target Balance Assuming , E2*100, % Growth) I want everything after Target Balance to appear in the second line of the cell so that the cell looks like this: Target Balance Assuming xx% Growth First, you do not need to use CONCATENATE. You can just use the -operator for concatenating strings. However, you can use the CONCATENATE function, as well, if you want. ;-) For a line break, take the ASCII character no. 10. e.g. =Target Balance Assuming CHAR(10) E2*100 % Growth Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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