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

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 <dasaibene@icloud.com> wrote:
>
> > On Feb 19, 2015, at 5:27 PM, Brian Barker <b.m.barker@btinternet.com 
> > <mailto: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 
> <mailto:users+unsubscribe@global.libreoffice.org>
> 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: 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