Issue 8592

Summary:	if-clause for table-calculating
Product:	Writer	Reporter:	martho <martin>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Normal
Priority:	P3	CC:	elish, issues
Version:	OOo 1.0.1
Target Milestone:	---
Hardware:	PC
OS:	Windows, all
Issue Type:	ENHANCEMENT	Latest Confirmation in:	4.1.0-beta
Developer Difficulty:	---

Description martho 2002-10-22 15:07:56 UTC

Hello!

When calcing in a writers document table, you can make something like:
=<A1> > 10, which results 
- in -1, if <A1> is bigger then 10
- in 0, if <A1> is lower or equal then 10

But it seems not to be possible to do something like an if-cluse like it's 
possible in calc:
=if (<A1> > 10; "Yes"; "No");

or

=if (<A1> > 10; 2; 5);

This would be a good enhancement I think.

Comment 1 martho 2002-10-22 15:11:52 UTC

*** Issue 8591 has been marked as a duplicate of this issue. ***

Comment 2 stefan.baltzer 2003-06-04 14:16:52 UTC

Reassigned to Bettina.

Comment 3 martho 2005-09-01 16:14:54 UTC

Anthing new about this?

Comment 4 bettina.haberer 2010-05-21 14:46:06 UTC

To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".

Comment 5 Edwin Sharp 2014-03-25 11:15:04 UTC

Confirmed (zero if false, one if true) with
AOO410m14(Build:9760)  -  Rev. 1573601
2014-03-03 17:47:48 (Mo, 03 Mrz 2014)
Win 7