To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=80371
User fs changed the following:
What |Old value |New value
================================================================================
OtherIssuesDependingOnTh| |20748
is| |
--------------------------------------------------------------------------------
Assigned to|dbaneedsconfirm |oj
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Priority|P3 |P4
--------------------------------------------------------------------------------
Summary|dates offset by 2 days on |copy table wizard: allow t
|import from Calc to Base |o specify a null date for
| |columns where non-date val
| |ues are imported as date v
| |alues
--------------------------------------------------------------------------------
Target milestone|not determined |OOo Later
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Aug 21 10:22:14 +0000
2007 -------
There is absolutely no way to *reliably* translate a mere integer value into a
date. In fact, to do so yo need a so-called "null date", which the integers are
an offset to. This date is not available in the clipboard (there are only the
integers), so Base assumes the standard SQL null date. Since this differs from
Calc's default null date by two days, and since you "stripped" the information
about this null date on the Calc side with removing the date formatting, Base
has no chance to properly import the dates.
What one could do is that the import wizard allows to user to specify a null
date, which it should assume when none is (implicitly) specified in the pasted
data.
This would be a enhancement to the mentioned wizard, which sounds reasonable,
though I'd say it wouldn't have a high priority.
---------------------------------------------------------------------
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]
