List Info

Thread: entering 10-2 in a field results in 39,357?




entering 10-2 in a field results in 39,357?
user name
2007-11-05 03:09:48
To comment on the following update, log in, then open the
issue:
http://www.openoffice.org/issues/show_bug.cgi?id=83306



User fst changed the following:

                What    ld value 
               |New value
============================================================
====================
                  Status|UNCONFIRMED              
|RESOLVED
------------------------------------------------------------
--------------------
              Resolution|                          |INVALID
------------------------------------------------------------
--------------------




------- Additional comments from fstopenoffice.org Mon Nov  5
09:09:47 +0000 2007 -------
Hi,

this is not a bug. You've formatted the cell to display
entered values as
numbers with thousands separator, 10-2 is recognized as a
date actually as
October 2nd 2007. This date formatted as number gives
39357.

So Calc works correctly in this case and this Issue is
closed invalid.

Frank

------------------------------------------------------------
---------
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-unsubscribesc.openoffice.org
For additional commands, e-mail: issues-helpsc.openoffice.org


[1]

about | contact  Other archives ( Real Estate discussion Medical topics )