Issue 25626 - When pasting/importing date data into a spreadsheet a warning should appear if the base/null date is different between the source document and the target document.
Summary: When pasting/importing date data into a spreadsheet a warning should appear i...
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.1.1
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: rfe_eval_ok, usability
Depends on:
Reported: 2004-02-17 22:28 UTC by bobbv
Modified: 2013-02-07 22:38 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description bobbv 2004-02-17 22:28:12 UTC
I recently reported (in issue 25576) that there was a copy-paste problem, which
turned out to be a different null date in the document I was pasting from.  That
document was originally generated by StarOffice, which is how I assume that the
null date got set to 1/1/1904, instead of (I assume 1/1/1900).  My enhancement
request is for a warning when dates are copied between documents with different
null dates or when files are imported that have different null dates than the
default date, with the option of setting the null date to the standard default
and updating all date fields appropriately.

The warning could read "The [cells you are copying|document you are importing]
has a nonstandard null date--the date from when OpenOffice begins calculating
dates--which could change the value of the dates displayed.  Select OK to
[paste|open] the dates using the default null date, which may make them look
different, or [Import|Paste Special] to adjust the dates so that they look the
same, but are calculated using the default null date."  Or something.

I understand the reason for the existence of the null date, but it's very
confusing behavior to just change the date as it displays without warning the user.
Comment 1 frank 2004-02-18 08:32:25 UTC
Hi Bettina,

IMHO this is not possible on Pasting maybe on import.

Comment 2 erwin.tenhumberg 2004-11-04 14:33:52 UTC
enhanced summary, set keywords and reassigned issue according to RFE process

This feature is probably difficult to implement since the pure date data does
not include information about the base date. However, when copying data between
two spreadsheets this potentially could be handled by an internal
date format. 

The priority of this enhancement is probably low since not too many people will
face this problem.
Comment 3 ace_dent 2008-05-16 00:39:28 UTC Issue Tracker - Feedback Request.

The Issue you raised is currently assigned to 'Requirements' pending review, but
has not been updated within the last 3 years. Please consider re-testing with
one of the latest versions of OOo, as the problem(s) may have already been
addressed. Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~