Issue 25626

Summary:	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.
Product:	Calc	Reporter:	bobbv <mikek>
Component:	open-import	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1.1	Keywords:	rfe_eval_ok, usability
Target Milestone:	---
Hardware:	PC
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

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.

Frank

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 OpenOffice.org 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

OpenOffice.org 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:
http://download.openoffice.org/index.html
or consider trying the new OOo 3 BETA (still in testing):
http://download.openoffice.org/3.0beta/
 
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:
http://www.openoffice.org/issues/query.cgi
 
Many thanks,
Andrew
 
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html