To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=110360
User er changed the following:
What |Old value |New value
================================================================================
Assigned to|spreadsheet |er
--------------------------------------------------------------------------------
Keywords| |ms_interoperability
--------------------------------------------------------------------------------
Summary|Autofiler on date column d|Autofiler on date column d
|isplays wrong info |isplays wrong info with YY
| |YY-MM-DD;@ format (importe
| |d from Excel)
--------------------------------------------------------------------------------
Target milestone|--- |OOo Later
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Wed Mar 24 19:37:08 +0000
2010 -------
I just love Excel..
Apparently for filter entries even the actual subformat applied to the actual
value is considered by Excel, so categorizing such a format as date would only
solve this halfway in case someone used YYYY-MM-DD;-0 or a similar mix and
really had negative values. Still, ignoring subformats in categorization might
be a step into the right direction.
However, we should not have the "suppress negative values" behavior with code;@
that is wrong anyway and a trailing ;@ (respectively trailing section containing
@) always denotes the text subformat instead, regardless of its position. In
this case might be especially nasty because as opposed to Excel OOo does handle
negative date serials as values before 1899-12-30 and a user probably would not
like to have them displayed empty..
---------------------------------------------------------------------
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]
