Ask Your Question
0

Getting #NAME? as a result when dividing decimals in calc

asked 2018-09-19 15:21:36 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I'm not sure if this is a bug. In a column, I have formatted it for USD with no decimals, only whole dollars. I input the following "=35/12" and as expected after entering this, I get $3 (since 35/12 is 2.91666). In another cell in the same column, I have "=15.50/12" but it returns "#NAME?" If I put "=15/12", it returns normal $1 This decimal issue also occurs in other cells of the same column. It seems to happen only with decimal division. My locale is not US English. What am I doing wrong, or is this a bug? I can't find this online here https://bugs.documentfoundation.org

edit retag flag offensive close merge delete

Comments

You say your locale is not US English. Is your locale's decimal separator a period (dot)?

BigRAl gravatar imageBigRAl ( 2018-09-19 15:36:01 +0100 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2018-09-19 16:19:28 +0100

Formatting a cell is how to show its contents. When you are writing to a cell, Calc needs to understand what you wrote. It uses the cell's formatting to see if what you entered matches the format; but if it does not (like in this case: =15.50/12 does not fit to a US number mask, which does not include any = or /), it starts interpreting the string using normal (locale-dependent) means. So - only your locale separators in formulas.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-19 15:21:36 +0100

Seen: 37 times

Last updated: Sep 19 '18