You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@openoffice.apache.org by bu...@apache.org on 2020/03/13 19:30:24 UTC

[Issue 128336] Golf handicap differential calculation errors

https://bz.apache.org/ooo/show_bug.cgi?id=128336

Czesław Wolański <cz...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |czeslaw.wolanski@gmail.com

--- Comment #1 from Czesław Wolański <cz...@gmail.com> ---
Hi,


It seems AOO Calc treats a number as text in a cell formatted as number.

For example: if you edit cell E1, you will see in the input line of formula
bar: "'103" instead of "103".

Look at the following link:
https://www.ryananddebi.com/2009/11/29/remove-apostrophes-before-numbers-in-openoffice-calc/

where you will find a detailed procedure under "The Solution" section:

"There is a solution for this.  It involves a “find and replace” function.
[...]"


If you follow it precisely, as I did, you should regain your calculation: cell
Z9 = 19.288

However if you are looking for explanation, you shall ask someone wiser than
me.

-- 
You are receiving this mail because:
You are the assignee for the issue.