Re: [libreoffice-users] Formulas in Calc not showing results
OK, having now rebooted, LO seems to be displaying the results of the formulas again. That's a relief, and no doubt it's the reboot that solved the issue. Wish I understood why such things happen, but in any case, thanks for pushing me in that direction. As for: Also with Mac i think updates and even installing stuff seldom demands a reboot? Correct. In some cases with OS updates, reboot is required, but not usually. Mac may also have a way to re-open all the last work after a shutdown, but I haven't looked into it yet (Safari browser does this, so maybe Apple thought about it for the entire OS). I do hope to look into Linux and the like one day... Cheers, Carl With Ubuntu there is some setting that allows you to make the start-up procedure open up everything that you had open when you shut-down. There might be something similar on Mac but i don't know of good places to find out. There must be forums or soemthing worth asking. Apols and regards from Tom :) From: Carl Paulsen carlpaul...@comcast.net To: users@global.libreoffice.org Sent: Thursday, 13 December 2012, 12:25 Subject: Re: [libreoffice-users] Formulas in Calc not showing results It's not the downtime but rather all the work that's open that I have to keep track of, decide how to save and then close. It's hard to explain but given I work 3-4 different jobs at once and am working on new tools that I don't know very well yet, I'm always reluctant to reboot. Obviously I'll have to change that. And I too can shut down processes individually on my Mac, but I don't always know what ones apply to what programs. Sounds easier than it is... I'm still wondering why it's happening, and why LO is now opening the CSV files (no re-start or re-boot yet). In the latter case, obviously re-starting or re-booting didn't matter. This is all a lot more complicated that just re-booting. Cheers, Carl On 12/13/12 1:39 AM, Tom Davies wrote: Hi :) Lol, +1 Even on GnuLinux distros (mainly Ubuntu ime tbh) it's a good plan to do a reboot to ensure that services that are normally on haven't been stopped temporarily without you really being aware of it. Of course in GnuLinux you could restart individual processes in order to avoid any down-time at all but on a desktop or mobile machine a couple of minutes of downtime is unlikely to matter much. Regards from Tom :) From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Sent: Wednesday, 12 December 2012, 22:21 Subject: Re: [libreoffice-users] Formulas in Calc not showing results At 16:35 12/12/2012 -0500, Carl Paulsen wrote: Restart the software or reboot the computer sometimes helps these odd glitches. You mean that you didn't try this before asking your question?! Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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 -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@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 -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@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] Formulas in Calc not showing results
Hi :) Mac is based on Bsd which is unix-based and practically a brother or sister to GnuLinux anyway. Sticking with Mac makes sense. It gets you nearly all the way without having some of the painful bits. Regards from Tom :) From: Carl Paulsen carlpaul...@comcast.net To: Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Friday, 14 December 2012, 14:05 Subject: Re: [libreoffice-users] Formulas in Calc not showing results OK, having now rebooted, LO seems to be displaying the results of the formulas again. That's a relief, and no doubt it's the reboot that solved the issue. Wish I understood why such things happen, but in any case, thanks for pushing me in that direction. As for: Also with Mac i think updates and even installing stuff seldom demands a reboot? Correct. In some cases with OS updates, reboot is required, but not usually. Mac may also have a way to re-open all the last work after a shutdown, but I haven't looked into it yet (Safari browser does this, so maybe Apple thought about it for the entire OS). I do hope to look into Linux and the like one day... Cheers, Carl With Ubuntu there is some setting that allows you to make the start-up procedure open up everything that you had open when you shut-down. There might be something similar on Mac but i don't know of good places to find out. There must be forums or soemthing worth asking. Apols and regards from Tom :) From: Carl Paulsen carlpaul...@comcast.net To: users@global.libreoffice.org Sent: Thursday, 13 December 2012, 12:25 Subject: Re: [libreoffice-users] Formulas in Calc not showing results It's not the downtime but rather all the work that's open that I have to keep track of, decide how to save and then close. It's hard to explain but given I work 3-4 different jobs at once and am working on new tools that I don't know very well yet, I'm always reluctant to reboot. Obviously I'll have to change that. And I too can shut down processes individually on my Mac, but I don't always know what ones apply to what programs. Sounds easier than it is... I'm still wondering why it's happening, and why LO is now opening the CSV files (no re-start or re-boot yet). In the latter case, obviously re-starting or re-booting didn't matter. This is all a lot more complicated that just re-booting. Cheers, Carl On 12/13/12 1:39 AM, Tom Davies wrote: Hi :) Lol, +1 Even on GnuLinux distros (mainly Ubuntu ime tbh) it's a good plan to do a reboot to ensure that services that are normally on haven't been stopped temporarily without you really being aware of it. Of course in GnuLinux you could restart individual processes in order to avoid any down-time at all but on a desktop or mobile machine a couple of minutes of downtime is unlikely to matter much. Regards from Tom :) From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Sent: Wednesday, 12 December 2012, 22:21 Subject: Re: [libreoffice-users] Formulas in Calc not showing results At 16:35 12/12/2012 -0500, Carl Paulsen wrote: Restart the software or reboot the computer sometimes helps these odd glitches. You mean that you didn't try this before asking your question?! Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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 -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@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 -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Formulas in Calc not showing results
It's not the downtime but rather all the work that's open that I have to keep track of, decide how to save and then close. It's hard to explain but given I work 3-4 different jobs at once and am working on new tools that I don't know very well yet, I'm always reluctant to reboot. Obviously I'll have to change that. And I too can shut down processes individually on my Mac, but I don't always know what ones apply to what programs. Sounds easier than it is... I'm still wondering why it's happening, and why LO is now opening the CSV files (no re-start or re-boot yet). In the latter case, obviously re-starting or re-booting didn't matter. This is all a lot more complicated that just re-booting. Cheers, Carl On 12/13/12 1:39 AM, Tom Davies wrote: Hi :) Lol, +1 Even on GnuLinux distros (mainly Ubuntu ime tbh) it's a good plan to do a reboot to ensure that services that are normally on haven't been stopped temporarily without you really being aware of it. Of course in GnuLinux you could restart individual processes in order to avoid any down-time at all but on a desktop or mobile machine a couple of minutes of downtime is unlikely to matter much. Regards from Tom :) From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Sent: Wednesday, 12 December 2012, 22:21 Subject: Re: [libreoffice-users] Formulas in Calc not showing results At 16:35 12/12/2012 -0500, Carl Paulsen wrote: Restart the software or reboot the computer sometimes helps these odd glitches. You mean that you didn't try this before asking your question?! Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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 -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@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] Formulas in Calc not showing results
Hi :) Ahh, yes. I don't know why i assumed you were using Windows. It's a lot easier to reboot Windows because you can't open so many programs at the same time so there is lot less to keep track of. Also with Mac i think updates and even installing stuff seldom demands a reboot? With Ubuntu there is some setting that allows you to make the start-up procedure open up everything that you had open when you shut-down. There might be something similar on Mac but i don't know of good places to find out. There must be forums or soemthing worth asking. Apols and regards from Tom :) From: Carl Paulsen carlpaul...@comcast.net To: users@global.libreoffice.org Sent: Thursday, 13 December 2012, 12:25 Subject: Re: [libreoffice-users] Formulas in Calc not showing results It's not the downtime but rather all the work that's open that I have to keep track of, decide how to save and then close. It's hard to explain but given I work 3-4 different jobs at once and am working on new tools that I don't know very well yet, I'm always reluctant to reboot. Obviously I'll have to change that. And I too can shut down processes individually on my Mac, but I don't always know what ones apply to what programs. Sounds easier than it is... I'm still wondering why it's happening, and why LO is now opening the CSV files (no re-start or re-boot yet). In the latter case, obviously re-starting or re-booting didn't matter. This is all a lot more complicated that just re-booting. Cheers, Carl On 12/13/12 1:39 AM, Tom Davies wrote: Hi :) Lol, +1 Even on GnuLinux distros (mainly Ubuntu ime tbh) it's a good plan to do a reboot to ensure that services that are normally on haven't been stopped temporarily without you really being aware of it. Of course in GnuLinux you could restart individual processes in order to avoid any down-time at all but on a desktop or mobile machine a couple of minutes of downtime is unlikely to matter much. Regards from Tom :) From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Sent: Wednesday, 12 December 2012, 22:21 Subject: Re: [libreoffice-users] Formulas in Calc not showing results At 16:35 12/12/2012 -0500, Carl Paulsen wrote: Restart the software or reboot the computer sometimes helps these odd glitches. You mean that you didn't try this before asking your question?! Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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 -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Formulas in Calc not showing results
LO = 3.5.6.2 for Mac OS 10.6 AutoCalculate is on I'm trying to build a simple text concatenation (forumula is =CONCATENATE(Dear ,Q2), though I also tried it as =Dear Q2). The formula only shows as the text of the formula, not the result of the formula. Using the formula builder, it shows the correct result (in this case, Dear Kate and Marc. It's just that the result doesn't show in the cell. My Tools menu doesn't contain Options as a choice (not even grayed out), so can't adjust that. Finally, when I export to csv, where I should be able to see the formula results if they are being created, I can't even open the resulting csv file with LO (or anything else I have on hand). Any suggestions? Thanks! -- For unsubscribe instructions e-mail to: users+h...@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] Formulas in Calc not showing results
At 12:10 12/12/2012 -0500, Carl Paulsen wrote: LO = 3.5.6.2 for Mac OS 10.6 AutoCalculate is on I'm trying to build a simple text concatenation (formula is =CONCATENATE(Dear ,Q2), though I also tried it as =Dear Q2). The formula only shows as the text of the formula, not the result of the formula. Using the formula builder, it shows the correct result (in this case, Dear Kate and Marc. It's just that the result doesn't show in the cell. Remove the tick at Tools | Options...| LibreOffice Calc | View | Display | Formulas. My Tools menu doesn't contain Options as a choice (not even grayed out), so can't adjust that. Under Mac OS, this setting is at LibreOffice | Preferences | LibreOffice Calc | View | Display | Formulas instead. Finally, when I export to csv, where I should be able to see the formula results if they are being created, I can't even open the resulting csv file with LO (or anything else I have on hand). A CSV file is plain text, so you can certainly open it as a spreadsheet with LibreOffice Calc or as text with LibreOffice Writer. Remember that when you save as CSV, only the active sheet is saved. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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] Formulas in Calc not showing results
Hi :) I think saving a spreadsheet as a Csv strips out the formulae and replaces them with whatever the answer happened to be at the moment of saving. It's better to save an original version as Ods and then if you want other people to be able to edit and work with the sheet use File - Save As ... to save in Xls format (that's Microsoft Excel (97/2000/Xp) (or soemthing like that). Avoid using the XlsX (MS 2007 or 2010 or 365, as all 3 of those are slightly different from each other). Regards from Tom :) From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Sent: Wednesday, 12 December 2012, 19:54 Subject: Re: [libreoffice-users] Formulas in Calc not showing results At 12:10 12/12/2012 -0500, Carl Paulsen wrote: LO = 3.5.6.2 for Mac OS 10.6 AutoCalculate is on I'm trying to build a simple text concatenation (formula is =CONCATENATE(Dear ,Q2), though I also tried it as =Dear Q2). The formula only shows as the text of the formula, not the result of the formula. Using the formula builder, it shows the correct result (in this case, Dear Kate and Marc. It's just that the result doesn't show in the cell. Remove the tick at Tools | Options...| LibreOffice Calc | View | Display | Formulas. My Tools menu doesn't contain Options as a choice (not even grayed out), so can't adjust that. Under Mac OS, this setting is at LibreOffice | Preferences | LibreOffice Calc | View | Display | Formulas instead. Finally, when I export to csv, where I should be able to see the formula results if they are being created, I can't even open the resulting csv file with LO (or anything else I have on hand). A CSV file is plain text, so you can certainly open it as a spreadsheet with LibreOffice Calc or as text with LibreOffice Writer. Remember that when you save as CSV, only the active sheet is saved. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Formulas in Calc not showing results
At 12:10 12/12/2012 -0500, Carl Paulsen wrote: I'm trying to build a simple text concatenation (formula is =CONCATENATE(Dear ,Q2), though I also tried it as =Dear Q2). The formula only shows as the text of the formula, not the result of the formula. Another possible cause of this is formatting the cell as Text before you enter the formula. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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] Formulas in Calc not showing results
Thanks, Brian, So I finally was able to open the CSV file after re-saving it a few times. Not sure what that's about... The CSV file has the proper values saved instead of the formulas, so it appears it's just a display issue. I'll try to dig further to see what might be going on. Restart the software or reboot the computer sometimes helps these odd glitches. Carl On 12/12/12 3:45 PM, Brian Barker wrote: At 12:10 12/12/2012 -0500, Carl Paulsen wrote: I'm trying to build a simple text concatenation (formula is =CONCATENATE(Dear ,Q2), though I also tried it as =Dear Q2). The formula only shows as the text of the formula, not the result of the formula. Another possible cause of this is formatting the cell as Text before you enter the formula. I trust this helps. Brian Barker -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@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] Formulas in Calc not showing results
At 16:35 12/12/2012 -0500, Carl Paulsen wrote: Restart the software or reboot the computer sometimes helps these odd glitches. You mean that you didn't try this before asking your question?! Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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] Formulas in Calc not showing results
Hi :) Lol, +1 Even on GnuLinux distros (mainly Ubuntu ime tbh) it's a good plan to do a reboot to ensure that services that are normally on haven't been stopped temporarily without you really being aware of it. Of course in GnuLinux you could restart individual processes in order to avoid any down-time at all but on a desktop or mobile machine a couple of minutes of downtime is unlikely to matter much. Regards from Tom :) From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Sent: Wednesday, 12 December 2012, 22:21 Subject: Re: [libreoffice-users] Formulas in Calc not showing results At 16:35 12/12/2012 -0500, Carl Paulsen wrote: Restart the software or reboot the computer sometimes helps these odd glitches. You mean that you didn't try this before asking your question?! Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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