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

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.

> ... 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.

> ... 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.

> ... 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.

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