Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.