Re: [libreoffice-users] ### signs in Calc

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