To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102924 Issue #|102924 Summary|Formula that works in Excel dont work in OOo Component|Spreadsheet Version|OOO310m9 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|fredrik1
------- Additional comments from [email protected] Thu Jun 18 20:49:13 +0000 2009 ------- Im from germany and only have german expressions, so I try to explain. I have a formula that format every number in a colour if it is double, the formula is: ZÄHLENWENN(a:a;A2)>1 if you insert this formula in Excel under Conditional Formatting it works, but not in Open Office. In Openoffice 3.1 you have to write: ZÄHLENWENN(Tabelle1.A$1:Tabelle1.A $65536;Tabelle1.A1)>1 In my oppinion this takes to long to write, could you bring the excel formula in openoffice to work? --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
