To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=47757
User wsp changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |UNCONFIRMED
--------------------------------------------------------------------------------
Resolution|INVALID |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Sun Jun 19 03:23:08 -0700
2005 -------
Hi Frank,
>if you paste a value into a cell, numberrecognition jumps in and converts (in
>this case the string) into a date based on the locale. That means it formats
>the cell to show as a date of a serial number.
Fine, thanks. With my words: Any string, that is formatted like a known date
format (standard & user defined) will be converted to a number representing a
date. The cell shows the date in the current (user selected) date format. The
cell content can be used for date calculations.
A string represents a date, if it looks like a date.
Look at the following table:
cp spec cp spec Copied =5+D2 isDate(D2)
Standard isoDate From
formatted formatted
05.06.15 05-06-15 Console 05-06-20 #NAME?
(05.06.2005 15.06.2005 editWin)
05-06-16 05-06-16 Kate 05-06-21 #NAME?
(16.06.2005 15.06.2005 editWin)
05-06-17 05-06-17 writer 05-06-22 #NAME?
(17.06.2005 15.06.2005 editWin)
Only 2 of WINNER of Calc ok unknown in
3 hits beauty Function
Wizard
'Paste Special' __AND__ a IsoDate preformatted field shows the date correct,
but the edit window (toolbar) shows a wrong item (numbers exchanged, wrong
delimiter, hard to edit (does not follow the rules of a GUI/Wysiwyg)).
-Cant find anything about the above solution in help 'pasting clipboard'. What
to do?
-Repair the edit window?
BTW: Missing 'isDate()' in 'Function wizard' and in help, but the function is
listed in books (e.g. Andrew Pitonyak)?
Wolfgang
---------------------------------------------------------------------
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]
