Apache OpenOffice (AOO) Bugzilla – Issue 28841
formated formulas are not recognized as number in expresions
Last modified: 2013-02-07 22:40:12 UTC
OO does not recognize as number a cell in a table that is a formula w/ currency format +----------------------------------+ | formula[999] ; format "currency" | +----------------------------------+ | formula[sum(<a1>)]; result = 0 | +----------------------------------+ It works if cells w/numbers (not formula) has format
An additional implementation in Writer's tables will be needed for recognizing the format of the cells used in a cell's formula/calculation. Also has to be cleared then: which format should be taken, when a formula contains different number formats?
If the format in the formula is _standard_ and the cell has _number recognition_ activated, it does not allow to set the _format_ at cell level which in this case it should works like a typed number. This may be an option.
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".