> On Feb 19, 2015, at 5:27 PM, Brian Barker <b.m.bar...@btinternet.com> 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: 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