Fixed! Thanks The Formula check box was ticked as Brian indicated. It was a little difficult getting back to this since clicking Preferences did not give me the option to look at the Calc setting Preferences which was indicated via the Help menus. however getting back to the basic sheet, then Preferences showed me the check box. Hope this makes sense. Anyway what I would think is a bug and others may disagree, is that if I do a reinstall of an app that all my settings should be set back to defaults. If not I think the App should ask me if I want to go back to the defaults or keep the settings I have. The reason I am saying this is because if everything is OK and I am upgrading the App then I want all my settings as they were. If I am having a new issue as I have encountered, I have no way of knowing with out the help of this forum if I am at fault or it is the App. Anyway thanks for your help.
> On Feb 19, 2015, at 6:01 PM, Dave Asaibene <[email protected]> wrote: > >> >> On Feb 19, 2015, at 5:27 PM, Brian Barker <[email protected] >> <mailto:[email protected]>> wrote: >> >> At 22:51 19/02/2015 +0200, Pertti Rönnberg wrote: >>> From mr Asaibene's message I think it is obvious -- at least we can assume >>> -- that he is rather familiar with using spreadsheets (e.g. LO/Calc) and >>> knows the basics, ... >> >> I don't want to be overcritical of the original questioner, but I suspect >> that this is not entirely true. Not recognising "###" and its meaning is >> perfectly understandable for a beginner. >> Agreed I am a beginner and I feel that I have used most of my resources to >> try and fix my issue. The ### is not necessarily the the issue, not getting >> the expected result is. OS is Mac OS 10.4.11. All updates installed. >>> ... he described a simple calculation that is all correct but showed the >>> result that is in no way normal whatever his (operating)system is. >> >> It is normal if the Formulae display option is ticked. >> I will find this option take a look however I think a reinstall of the app >> would not have ticked this option. >>> ... if a spreadsheet program (e.g. LO/Calc) does not behave or do the >>> calculations correctly you may not be aware of the failures and draw wrong >>> conclutions ... >> >> This is entirely true! And it's a good lesson to learn: spreadsheets are by >> their nature fragile and can be relied on only if their construction has >> been very carefully executed. > Yes of course. When I was not getting a result in a Calc I was developing, I > stopped and tried to get back to basics. >> >>> ... a spreadsheet program is worse than worthless if you cannot trust it >>> "150%". A couple of years ago I experienced some that sort of problems with >>> LO/Calc why I still try to check the results in every project of importance. >> >> Again, that is excellent advice. >> >>> Mr Asaibene's message is alarming: if a spreadsheet behaves odd in small >>> then there can be more serious issues. I think mr Asaibene should post a >>> bug report. > Not sure how to do this, but unless others are seeing this issue or can > reproduce it, I think it is my issue. I am going back to 4.3.6.2 to see if it > provides any different results. >> >> I'm still working with the theory that Calc is operating as advertised. >> >> Brian Barker >> >> -- >> 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 >> > > > -- > To unsubscribe e-mail to: [email protected] > <mailto:[email protected]> > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > <http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > <http://wiki.documentfoundation.org/Netiquette> > List archive: http://listarchives.libreoffice.org/global/users/ > <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: [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
