Issue 28841 - formated formulas are not recognized as number in expresions
Summary: formated formulas are not recognized as number in expresions
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-05-06 23:44 UTC by mrsoto
Modified: 2013-02-07 22:40 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description mrsoto 2004-05-06 23:44:16 UTC
OO does not recognize as number a cell in a table that is a formula w/ currency

| formula[999] ; format "currency" |
| formula[sum(<a1>)]; result = 0   |

It works if cells w/numbers (not formula) has format
Comment 1 michael.ruess 2004-05-07 10:45:00 UTC
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?
Comment 2 mrsoto 2004-05-07 14:14:19 UTC
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.
Comment 3 bettina.haberer 2010-05-21 14:52:46 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".