https://bz.apache.org/ooo/show_bug.cgi?id=128336
Czesław Wolański <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Czesław Wolański <[email protected]> --- 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.
