Issue 28841

Summary:	formated formulas are not recognized as number in expresions
Product:	Writer	Reporter:	mrsoto <mrsoto>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P4	CC:	issues
Version:	OOo 1.1
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

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
format

+----------------------------------+
| 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".