Re: [libreoffice-users] Two formulas in one cell?
That is an impressive solution from Michael but, not knowing the layout of your spreadsheet, I wonder why you cannot simply insert a new column adjacent to the cell in question so that each formula can be in a separate cell. Regards MalJaros - Original Message - From: "Michael D. Setzer II" To: "Brian Barker" , users@global.libreoffice.org, "Carl Winerich" Sent: Sunday, 3 June, 2018 03:44:39 Subject: Re: [libreoffice-users] Two formulas in one cell? =3DTEXT(A3+3, D, )60;TEXT(A4,#) A3 was1/15/18 in my case and A4 was 27 result in cell is: Thursday, January 18, 201827 Would be nice if you could put actually wanting with examples. You can get the formating you need using the text command, and you can see the diffiernt format option using the cell format, and it shows examples of the format code. Just picked a longer one for the date format. Then just a regular number format used for the second. On 2 Jun 2018 at 20:54, Carl Winerich wrote: To:;Brian barkerb.m.bar...@btinternet.com, users@global.libreoffice.org From:60;Carl winerichl...@ipadring.net Subject:;Re: [libreoffice-users] Two formulas in one cell?Date sent:60;Sat, 2 Jun 2018 20:54:49 -0400 Concatenate works...to a point. Another problem is that first formula must provide a result formatted as a date, let's say June 2.The second formula must provide a result as a day-number-of-the-year (which I haven't figured out how to do yet). Using concatenate the result is a 5 digit number returned for the first formula even though the cell is formatted as a D. How can these format requirements be maintained? Thanks, Carl On 06/02/2018 06:10 PM, Brian Barker wrote: At 17:20 02/06/2018 -0400, Dotty Carl Noname wrote: In cell A2 the following formula is placed =F30-2 In the same cell (A2) I want to place a second formula which is =A10+4 How can I add this second formula into A2 and obtain the results of both formulas in the same cell (A2) but each separated by several spaces so the results are distinct? Thank you, Carl The answer to this question is very similar to that for the almost identical question that you asked (and had answered) last November 21st: http://document-foundation-mail-archive.969070.n3.nabble.com/Formula-and-text-in-same-cell-td4227487.html . If a cell contains a formula, the result of that formula is what appears in the cell, so having two formulae would be simply contradicting yourself. As you already know, if you wanted F30-2 you would not expect to use =F30 and then =-2 separately but instead =F30-2. In the same way, you must construct a single formula that creates the combination of values that you ask for. You can combine results using the CONCATENATE() function or, more simply, the operator.Try: =F30-260;A10+4 Incidentally, do please put your name in the real name field of your mail messages: it's an elementary courtesy to those offering to help you. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Two formulas in one cell?
Not sure why this list corrupts anything pasted directly from a spread sheet. Looked fine when I sent it, but the result on list was WRONG?? Thursday, January 18, 2018 27 =TEXT(A3+3," d, ")&" "(A4,"#") How it got =3DTEXT(A3+3, D, )60;TEXT(A4,#) So copied it to a text editor, and then pasted it. On 3 Jun 2018 at 11:44, Michael D. Setzer II wrote: From: "Michael D. Setzer II" To: Brian Barker , users@global.libreoffice.org, Carl Winerich Date sent: Sun, 03 Jun 2018 11:44:39 +1000 Subject:Re: [libreoffice-users] Two formulas in one cell? Priority: normal > =3DTEXT(A3+3, D, )60;TEXT(A4,#) > > > A3 was1/15/18 in my case and A4 was 27 result in cell is: > > > Thursday, January 18, 201827 > > > > > Would be nice if you could put actually wanting with examples. > > > You can get the formating you need using the text command, and you can > see the diffiernt format option using the cell format, and it shows examples > of > the format code. Just picked a longer one for the date format. Then just a > > regular number format used for the second. > > > > > On 2 Jun 2018 at 20:54, Carl Winerich wrote: > > > To:;Brian barkerb.m.bar...@btinternet.com, > users@global.libreoffice.org > From:60;Carl winerichl...@ipadring.net > Subject:;Re: [libreoffice-users] Two formulas in one cell?Date sent:60;Sat, 2 > Jun 2018 20:54:49 -0400 > > > Concatenate works...to a point. > > > Another problem is that first formula must provide a result formatted as > a date, let's say June 2.The second formula must provide a result as a > day-number-of-the-year (which I haven't figured out how to do yet). > Using concatenate the result is a 5 digit number returned for the first > formula even though the cell is formatted as a D. > > > How can these format requirements be maintained? > > > Thanks, > > > Carl > > > > > On 06/02/2018 06:10 PM, Brian Barker wrote: > At 17:20 02/06/2018 -0400, Dotty Carl Noname wrote: > In cell A2 the following formula is placed =F30-2 In the same cell > (A2) I want to place a second formula which is =A10+4 How can I add > this second formula into A2 and obtain the results of both formulas > in the same cell (A2) but each separated by several spaces so the > results are distinct? Thank you, Carl > > > The answer to this question is very similar to that for the almost > identical question that you asked (and had answered) last November 21st: > http://document-foundation-mail-archive.969070.n3.nabble.com/Formula-and-text-in-same-cell-td4227487.html > . > > > If a cell contains a formula, the result of that formula is what > appears in the cell, so having two formulae would be simply > contradicting yourself. As you already know, if you wanted F30-2 you > would not expect to use =F30 and then =-2 separately but instead > =F30-2. In the same way, you must construct a single formula that > creates the combination of values that you ask for. You can combine > results using the CONCATENATE() function or, more simply, the > operator.Try: > =F30-260;A10+4 > > > Incidentally, do please put your name in the real name field of your > mail messages: it's an elementary courtesy to those offering to help you. > > > I trust this helps. > > > Brian Barker > > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ ++ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS ROSETTA 65563610.075728 | ABC 16613838.513356 SETI109375858.605587 | EINSTEIN141133906.999240 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?
Re: [libreoffice-users] Two formulas in one cell?
=3DTEXT(A3+3, D, )60;TEXT(A4,#) A3 was1/15/18 in my case and A4 was 27 result in cell is: Thursday, January 18, 201827 Would be nice if you could put actually wanting with examples. You can get the formating you need using the text command, and you can see the diffiernt format option using the cell format, and it shows examples of the format code. Just picked a longer one for the date format. Then just a regular number format used for the second. On 2 Jun 2018 at 20:54, Carl Winerich wrote: To:;Brian barkerb.m.bar...@btinternet.com, users@global.libreoffice.org From:60;Carl winerichl...@ipadring.net Subject:;Re: [libreoffice-users] Two formulas in one cell?Date sent:60;Sat, 2 Jun 2018 20:54:49 -0400 Concatenate works...to a point. Another problem is that first formula must provide a result formatted as a date, let's say June 2.The second formula must provide a result as a day-number-of-the-year (which I haven't figured out how to do yet). Using concatenate the result is a 5 digit number returned for the first formula even though the cell is formatted as a D. How can these format requirements be maintained? Thanks, Carl On 06/02/2018 06:10 PM, Brian Barker wrote: At 17:20 02/06/2018 -0400, Dotty Carl Noname wrote: In cell A2 the following formula is placed =F30-2 In the same cell (A2) I want to place a second formula which is =A10+4 How can I add this second formula into A2 and obtain the results of both formulas in the same cell (A2) but each separated by several spaces so the results are distinct? Thank you, Carl The answer to this question is very similar to that for the almost identical question that you asked (and had answered) last November 21st: http://document-foundation-mail-archive.969070.n3.nabble.com/Formula-and-text-in-same-cell-td4227487.html . If a cell contains a formula, the result of that formula is what appears in the cell, so having two formulae would be simply contradicting yourself. As you already know, if you wanted F30-2 you would not expect to use =F30 and then =-2 separately but instead =F30-2. In the same way, you must construct a single formula that creates the combination of values that you ask for. You can combine results using the CONCATENATE() function or, more simply, the operator.Try: =F30-260;A10+4 Incidentally, do please put your name in the real name field of your mail messages: it's an elementary courtesy to those offering to help you. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Two formulas in one cell?
Concatenate works...to a point. Another problem is that first formula must provide a result formatted as a date, let's say June 2. The second formula must provide a result as a day-number-of-the-year (which I haven't figured out how to do yet). Using concatenate the result is a 5 digit number returned for the first formula even though the cell is formatted as a D. How can these format requirements be maintained? Thanks, Carl On 06/02/2018 06:10 PM, Brian Barker wrote: > At 17:20 02/06/2018 -0400, Dotty Carl Noname wrote: >> In cell A2 the following formula is placed =F30-2 In the same cell >> (A2) I want to place a second formula which is =A10+4 How can I add >> this second formula into A2 and obtain the results of both formulas >> in the same cell (A2) but each separated by several spaces so the >> results are distinct? Thank you, Carl > > The answer to this question is very similar to that for the almost > identical question that you asked (and had answered) last November 21st: > http://document-foundation-mail-archive.969070.n3.nabble.com/Formula-and-text-in-same-cell-td4227487.html > . > > If a cell contains a formula, the result of that formula is what > appears in the cell, so having two formulae would be simply > contradicting yourself. As you already know, if you wanted F30-2 you > would not expect to use =F30 and then =-2 separately but instead > =F30-2. In the same way, you must construct a single formula that > creates the combination of values that you ask for. You can combine > results using the CONCATENATE() function or, more simply, the "&" > operator. Try: > =F30-2&" "+4 > > Incidentally, do please put your name in the real name field of your > mail messages: it's an elementary courtesy to those offering to help you. > > I trust this helps. > > Brian Barker > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Two formulas in one cell?
Thank you...I'll give it a try. On 06/02/2018 05:49 PM, T. R. Valentine wrote: > =CONCATENATE(<1st formula>,"",<2nd formula>) > > On 2 June 2018 at 16:20, . wrote: >> In cell A2 the following formula >> is placed-=F30-2In the same cell (A2) I want to place a second >> formula which is >> =A10+4How can I add this second formula into A2 and obtain the >> results >> of both formulas in the same cell (A2) but each separated by >> several spaces so the results are distinct?Thank you,Carl >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? >> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/users/ >> Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Two formulas in one cell?
At 17:20 02/06/2018 -0400, Dotty Carl Noname wrote: In cell A2 the following formula is placed =F30-2 In the same cell (A2) I want to place a second formula which is =A10+4 How can I add this second formula into A2 and obtain the results of both formulas in the same cell (A2) but each separated by several spaces so the results are distinct? Thank you, Carl The answer to this question is very similar to that for the almost identical question that you asked (and had answered) last November 21st: http://document-foundation-mail-archive.969070.n3.nabble.com/Formula-and-text-in-same-cell-td4227487.html . If a cell contains a formula, the result of that formula is what appears in the cell, so having two formulae would be simply contradicting yourself. As you already know, if you wanted F30-2 you would not expect to use =F30 and then =-2 separately but instead =F30-2. In the same way, you must construct a single formula that creates the combination of values that you ask for. You can combine results using the CONCATENATE() function or, more simply, the "&" operator. Try: =F30-2&" "+4 Incidentally, do please put your name in the real name field of your mail messages: it's an elementary courtesy to those offering to help you. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Two formulas in one cell?
=CONCATENATE(<1st formula>,"",<2nd formula>) On 2 June 2018 at 16:20, . wrote: > In cell A2 the following formula > is placed-=F30-2In the same cell (A2) I want to place a second > formula which is > =A10+4How can I add this second formula into A2 and obtain the results > of both formulas in the same cell (A2) but each separated by > several spaces so the results are distinct?Thank you,Carl > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy -- T. R. Valentine A rich heart may be under a poor coat. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Two formulas in one cell?
In cell A2 the following formula is placed-=F30-2In the same cell (A2) I want to place a second formula which is =A10+4How can I add this second formula into A2 and obtain the results of both formulas in the same cell (A2) but each separated by several spaces so the results are distinct?Thank you,Carl -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Language not "picked" correctly
I am currently using Ubuntu 18.04 - - Language - en_US.UTF-8(en_US) When I go to the download page for the newest LO version 6.0.4 x86_64 (deb) I keep getting the English (GB) version files. It has shown up with both Ubuntu 16.04 and 18.04 installs. --- https://www.libreoffice.org/download/download/ Supplementary Downloads: Translated User Interface: English (GB) (Torrent, Info) Help for offline use: English (GB) (Torrent, Info) -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Long comments in calc?
Ahoy: I am still using Version: 4.4.7.2, so this note may be of no help. (I am not aware of any “improvements” in later versions that would help me, and I read here of so many regressions, that I have not been tempted to “upgrade”.) Anyway, in Version: 4.4.7.2, when you select “Insert-Text Box”, you do not immediately get a box, but only an indicator that something has changed, which might appear to you as “nothing”. The “regular” calc arrow cursor changes to a cross, with an apparent subscript looking something like a curvey-flanged I-beam. You can use this cursor to draw the outline of the text box, which need not conform to cell boundaries. Anything you type within those boundaries goes not into the underlying cells, but rather into the text box. Executing a CR exits the “text-box mode”, leaving the text floating. You cannot make any entry into the underlying cells when the text box boundary is displayed, but you can after exiting, even entering right under “box” text. Clicking within the now-invisible boundary does not select any cell; instead it brings back the box boundary, handles, The box can be manipulated in the usual ways when its boundary is displayed, including re-sizing and being dragged over pre-existing cell entries. There is, of course, much more detail to be gleaned, but best by experimentation, not additional tortured prose. Any help? mxk -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Long comments in calc?
Hi Rakidzija : There is an option that you can use for input a comment into a cell. If you right click mouse over a specific cell, you get a menu with differents options. One of them is "Insert a comment" (The last in my LO Versión: 6.0.3.2). Select that option an appear a little yellow rectangule where you can write your comment about some issue of the content of it cell. This rectangule grow when you input your sentence but when you ending your wrotten the comment. When you did it you, the comment closed an appear a red super little point in the right top corner of the cell where you input the comment. Then, always over the cell that content the comment, you can righ click mouse again and appear 3 more options in the context menu: Edit, Delete and Show the comment. With each of them you can modify your comment of the cell. By the way, only with Show Comment option you can modify the form of the yellow rectangule making more wide (wider ?), for example, to structure the comment to your needs and your sheet. For do this, you have to select the border of the yellow rectangule when it is showed. Then if you click right again you can see again in the menu context but only : Edit,hide (instead show) and delete option menu. With hide option you can do it and show only the red point in the cell. I hope this help, Regards, Jorge Rodríguez El sáb, 02-06-2018 a las 11:34 +0200, David Rakidzija escribió: > Hi, > > what's the best way to insert long comments into calc? A floating > window that > does not interfere with the spreadsheet itself would be best. > 1. the built in commentary for cells seems to be buggy, sometimes > wound't > display corretly, cannot be resized... unusable for me if it's more > than a > couple of words > 2. merging cells is not what I want. Cannot really edit the box as if > it were > a text box and resizing seems difficult > 3. Supposedly there is a text box function, but whenever I click it > nothing > happens (insert -> text box) > > I'm using LO 6.0.4. > > Thanks for your help. > > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Long comments in calc?
Le samedi 02 juin 2018 à 11:34 +0200, David Rakidzija a écrit : > Hi, > > what's the best way to insert long comments into calc? A floating window that > does not interfere with the spreadsheet itself would be best. > 1. the built in commentary for cells seems to be buggy, sometimes wound't > display corretly, cannot be resized... unusable for me if it's more than a > couple of words > 2. merging cells is not what I want. Cannot really edit the box as if it were > a text box and resizing seems difficult > 3. Supposedly there is a text box function, but whenever I click it nothing > happens (insert -> text box) > > I'm using LO 6.0.4. > > Thanks for your help. > Hi, 1. Built-in comments can be re-sized by selecting "Edit comment", and then clicking inside the comment: this will make handles appear that you can use to make the comment any size you want. 2. As far as text boxes go, once you have selected Insert -> text box, your cursor should become a plus sign (+): at that point, click and drag to set the location/size of the box. I hope this helps. Rémy Gauthier. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Long comments in calc?
Hi, what's the best way to insert long comments into calc? A floating window that does not interfere with the spreadsheet itself would be best. 1. the built in commentary for cells seems to be buggy, sometimes wound't display corretly, cannot be resized... unusable for me if it's more than a couple of words 2. merging cells is not what I want. Cannot really edit the box as if it were a text box and resizing seems difficult 3. Supposedly there is a text box function, but whenever I click it nothing happens (insert -> text box) I'm using LO 6.0.4. Thanks for your help. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy