To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108059 Issue #|108059 Summary|SUMPRODUCT/SUMMENPRODUKT - problem with environement s |uiss-german Component|Spreadsheet Version|1.0.0 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|configuration Assigned to|spreadsheet Reported by|sanne2010
------- Additional comments from sanne2...@openoffice.org Mon Jan 4 13:03:10 +0000 2010 ------- Hi When I use a date in a SUMPRODUCT formula in an installation with region "suiss-german" I've a problem with using a date. Example: When I type this formula: =SUMMENPRODUKT($C$1:$C$10;$A$1:$A$10="Offen";$D$1:$D$10>=01.01.09;$D$1:$D$10<=31.01.09) and have a german(germany) environement, the program changes the date to a number, which does not cause any problem: =SUMMENPRODUKT($C$1:$C$10;$A$1:$A$10="Offen";$D$1:$D$10>=39814;$D$1:$D$10<=39844) But when I do the same with the environement german (switzerland), I get: =SUMMENPRODUKT($C$1:$C$10;$A$1:$A$10="Offen";$D$1:$D$10>=01.010.09;$D$1:$D$10<=31.010.09) As you may see, the date 01.01.09 is changed to 01.010.09 which results as an error. It's not the "document language" but the environement Greetings, Sanne --------------------------------------------------------------------- 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