To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108136
Issue #|108136
Summary|conditional formating with unexpected result
Component|Spreadsheet
Version|OOO310m19
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|programming
Assigned to|spreadsheet
Reported by|mgw2010
------- Additional comments from mgw2...@openoffice.org Thu Jan 7 15:35:57
+0000 2010 -------
conditional formating in German version with
=WENN(UND($B$2>=B11;$B$2<=C11);A11;"")&VORLAGE(WENN(AKTUELL()<>"";"blau";"Standard"))
WENN = IF
UND = AND
AKTUELL = CURRENT
VORLAGE = STYLE
"blau" is a cell style with blue background
"Standard" is the standard cell style
results in correct formatting (blue background) but the char string in cell A11
is amended with a zero ("0") i.e. if A11 contains the string "Text" the result
of the above is "Text0" in the respective cell whereas the expected result
should be "Text" (without the added "0").
---------------------------------------------------------------------
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
