Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|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.|
|Component:||open-import||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Version:||OOo 1.1.1||Keywords:||rfe_eval_ok, usability|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
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