Re: [libreoffice-users] Re: Subject: Digest of users -AT- global.libreoffice.org issue 2704 (52154-52162)

Greetings,

I am not sure how or why this is affecting your formulas, but the period 
"." character is a meaningful character to Calc. It is used in sheet 
references, as in:

=Projects.D2
         ^

Where "Projects" is the sheet name and "D2" is the cell reference in 
that sheet.

Something may be confusing Calc, although I agree, it shouldn't be doing 
that and I do not know the remedy to prevent it from evaluating 1.5 as 
sheet 1, cell 5, which also sounds strange. Maybe that is why you are 
getting the errors. Calc expects a column letter before the 5 and it 
isn't there. There must be some way to force Calc to assume the 
formula's cell is numeric and not a cell reference. Maybe someone else 
has the solution.  Good luck.

HTH.

Girvin Herr



On 07/29/2017 12:57 PM, bunk3m wrote:
> Hello Regina and Jorge,
>
> Thank you for your help and suggestions.  I apologize for the delay as 
> I didn't get the emails until I received the daily digest this 
> afternoon. I have quoted both your posts in order to keep them 
> together but this post is getting rather long.
>
> I have tried your suggestions and I'm still unable to get a basic 
> decimal calculation to work.
>
> But now I am getting "#NAME?" for the cell containing "=1+1.5".
>
> Interestingly enough, if I put "=1+20" it does give me "21" as an answer.
>
> What it doesn't like about the decimal place I don't understand. This 
> is very strange.
>
> I tried using a comma "," instead as a decimal separator but that 
> didn't work either.
>
> Perhaps I should delete all the preferences and all the extensions in 
> the Application Support folder??  Then I would have a "new" install?
>
> Thanks again and regards,
> B.
>
> On 29.07.2017 06:00, rb.henschel@t-online.de wrote:
> > Hi,
> >
> > bunk3m schrieb:
> > > Thank you Jorge.
> > >
> > > I have checked this.  The Mac settings are OK.  It works with Excel 
> > > fine
> > > and Apple Numbers.  Mac settings are to show decimal as "."
> > >
> > > I have some LO Calc sheets that were created a few years ago that are
> > > OK.  It seems to be some change in the last few versions??
> > >
> > > Would you know if there are any override settings in the LO 
> > > Preferences?
> > >  I can't find it if it exists.
> >
> > There exists the setting in Tools > Options > Language Settings > 
> > Languages, where you can determine the decimal separator key.
> >
> > In addition there is a setting "Ignore system input language", but I 
> > don't know, what effect it has.
> >
> > Another setting is in the cell properties in Format > Cells. On the 
> > tab "Numbers" you find top right a "Language" drop-down list. You can 
> > determine the language for numbers independent from UI. Do not use 
> > the "Default - xyz" but select the correct language explicitly.
> >
> > That the places I know, which might influence it.
> >
> > Kind regards
> > Regina
>
>
> On 29.07.2017 06:00, jrodriguez1717@gmail.com wrote:
> > Hi again:
> >
> >         I suggest to do this in the Language-Language settings:
> >
> >         *User Interface: Select English US
> >
> >         *Locale Settings: English (Canada)
> >
> >         *Decimal Separator Key: uncheck
> >
> >         *Default Currency: Default CAD (English or French)
> >
> >         *Default Language for Documents: A English Canada or French
> >
> >         *Ignore system input language: check
> >
> >         I did this in my LO, and restart LO, and then LO accept " . " 
> > as decimal separator key
> >
> > I hope this help,
> >
> > Jorge Rodríguez
> >
> >
> > El 28/07/2017 a las 18:14, jorge Rodríguez escribió:
> > > Hi:
> > >
> > >     In LO Preference (Menu-Tools-Options-Language settings), you can 
> > > find some ways to customize your settings.
> > >
> > >     I hope this help,
> > >
> > > Jorge Rodríguez
> > >
> > >
> > > El 28/07/2017 a las 16:11, bunk3m escribió:
> > > > Thank you Jorge.
> > > >
> > > > I have checked this.  The Mac settings are OK.  It works with Excel 
> > > > fine and Apple Numbers.  Mac settings are to show decimal as "."
> > > >
> > > > I have some LO Calc sheets that were created a few years ago that 
> > > > are OK.  It seems to be some change in the last few versions??
> > > >
> > > > Would you know if there are any override settings in the LO 
> > > > Preferences?  I can't find it if it exists.
> > > >
> > > > Thanks again.
> > > > B.
> > > >
> > > > On 28.07.2017 17:46, jorge Rodríguez wrote:
> > > > > Hi :
> > > > >
> > > > >      I don't have a Mac, I use GNU / Linux Ubuntu...but usually 
> > > > > that kind of issues are define with the Operative System. Try to 
> > > > > find how is it define it in you Mac. Probably is as " , " and you 
> > > > > have to change to " . " as you use it in Canada.
> > > > >
> > > > > Regards,
> > > > >
> > > > >
> > > > > Jorge Rodríguez
> > > > >
> > > > >
> > > > >
> > > > > El 28/07/2017 a las 14:50, bunk3m escribió:
> > > > > > I'm having a struggle with Calc. I trying to migrate over from 
> > > > > > Excel but have a problem.
> > > > > >
> > > > > > When I type [=1+1.5] into a cell, I get "Invalid Name" error. If 
> > > > > > I save the file as an xlsx and open in Excel it calculates OK and 
> > > > > > give 2.5.  If I then open the xlsx in LO, it still says "Invalid 
> > > > > > Name".
> > > > > >
> > > > > > If I put [=1+1,5], I get ERR: 509. This makes sense since I'm in 
> > > > > > Canada and we use "." to separate decimals.
> > > > > >
> > > > > > If I put [=1+1] LO correctly calculates "2" with no error.
> > > > > >
> > > > > > I have older LO spreadsheets that calculate OK.  Every new CALC 
> > > > > > spreadsheet has this problem.
> > > > > >
> > > > > > I'm not sure how to figure out why I get this error and why LO 
> > > > > > won't calculate such a basic equation.
> > > > > >
> > > > > > What should I be looking at?
> > > > > >
> > > > > > Mac OSX 10.10.5
> > > > > > LO 5.3.4 & 5.4
> > > > > >
> > > > > > I'm on daily digest mode so please cc me when you reply to the list.
> > > > > >
> > > > > > Thank you in advance.
> > > > > > B.


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