Re: [libreoffice-users] Calc - Invalid name error - help request

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