To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108059
User er changed the following:
What |Old value |New value
================================================================================
Assigned to|spreadsheet |er
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Priority|P3 |P4
--------------------------------------------------------------------------------
Platform|Unknown |All
--------------------------------------------------------------------------------
Summary|SUMPRODUCT/SUMMENPRODUKT -|Unquoted date in formula w
| problem with environement|ith decimal separator used
| suiss-german | as date separators (case
| |of error) leads to wrong d
| |isplay of date in formula
--------------------------------------------------------------------------------
Subcomponent|configuration |editing
--------------------------------------------------------------------------------
Target milestone|--- |OOo 3.x
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Fri Jan 8 11:04:17 +0000
2010 -------
Not related to SUMPRODUCT, reproducible with =01.01.09 as well, which becomes
=01.010.09 and that =01.0100.09 and so on, 0s appended to decimals. Also in an
en_US locale.
What happens is that since in a German_Switzerland locale the decimal separator
is a '.' dot it takes precedence over any date recognition in this case, with
01.01.09 not being a valid decimal number and thus an error is returned. That a
0 is inserted is a bug.
Using dates in formulas this way isn't good style anyway, as you can see a valid
date is converted to its date serial number and can't be retrieved as date when
editing the formula. Instead, use a date input in a cell and a reference to that
cell in the formula. You may also use a quoted ISO 8601 date representation in
the formula, here "2009-01-01", but in your case it has to be forced to numeric
for comparison and the part would read
$D$1:$D$10>="2009-01-01"+0
where the +0 forces the date into numeric context for the comparison. A date in
a cell is always a cleaner solution.
---------------------------------------------------------------------
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]
