Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 19 Sep 2018 16:19:28 +0200Getting #NAME? as a result when dividing decimals in calchttps://ask.libreoffice.org/en/question/166117/getting-name-as-a-result-when-dividing-decimals-in-calc/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.orgWed, 19 Sep 2018 15:21:36 +0200https://ask.libreoffice.org/en/question/166117/getting-name-as-a-result-when-dividing-decimals-in-calc/Comment by BigRAl for <p>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 <a href="https://bugs.documentfoundation.org">https://bugs.documentfoundation.org</a></p>
https://ask.libreoffice.org/en/question/166117/getting-name-as-a-result-when-dividing-decimals-in-calc/?comment=166120#post-id-166120You say your locale is not US English.
Is your locale's decimal separator a period (dot)?Wed, 19 Sep 2018 15:36:01 +0200https://ask.libreoffice.org/en/question/166117/getting-name-as-a-result-when-dividing-decimals-in-calc/?comment=166120#post-id-166120Answer by Mike Kaganski for <p>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 <a href="https://bugs.documentfoundation.org">https://bugs.documentfoundation.org</a></p>
https://ask.libreoffice.org/en/question/166117/getting-name-as-a-result-when-dividing-decimals-in-calc/?answer=166128#post-id-166128*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.Wed, 19 Sep 2018 16:19:28 +0200https://ask.libreoffice.org/en/question/166117/getting-name-as-a-result-when-dividing-decimals-in-calc/?answer=166128#post-id-166128