Issue 124359

Summary: Consider "table:null-date" parameter when import sheet from other document
Product: Calc Reporter: Rainer Bielefeld <rainerbielefeld_ooo_qa>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: awf.aoo, bogdan, elish, issues, rainerbielefeld_ooo_qa
Version: 3.3.0 or older (OOo)   
Target Milestone: ---   
Hardware: All   
OS: Windows 7   
See Also: https://issues.apache.org/ooo/show_bug.cgi?id=95710
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Test Kit none

Description Rainer Bielefeld 2014-03-05 06:13:01 UTC
Created attachment 82799 [details]
Test Kit

Currently all date (and time) data in a sheet imported from an other document will show wrong values if source and target document have different date base settings in menu 'Tools -> Options -> Calc -> Calculate - Date'.

Steps how to reproduce Reproducible with server installation of "AOO 4.1.0-Dev – English UI / German locale - [AOO410m1(Build:9750) - Rev. 1565724 - 2014-02-09]" on German WIN7 Home Premium (64bit)", own separate user profile:

1. Download and unzip attached test kit
2. From AOO Start Center open "TargetTest_DateBase is 31.12.1899.ods"
3. Menu 'Insert -> Sheet from File -> Source__Date Base is 1.1.1904.ods
  [Insert] - Tabelle1 [ok]' 
4. In new sheet check value shown in A1.. Should be 1.1.2014, is 31.12.09

The root of the problem is that differences in  "table:null-date" parameter (ODF 1.2 Part 1: OpenDocument Schema 9.4.2 <table:null-date>) of both documents are not considered during sheet import.  

The enhancement request is that contents in all cells with a date or time format containing a number value (not formula) should be corrected by adding difference:
(source-document table:null-date) - (target-document table:null-date)

Additional info:
----------------
(a) A problem would be standard number values what will be used as date
    in other cells with a reference:
    A2 contains Number "40178"
    A3 Contains formula "=A2" and is in date format
    this can not be recognized with acceptable costs and so there is no
    way to correct that.
(b) There might be other snares like (a)
(c) in a second step a similar adaption should be done for import from 
    not-ODF-documents
(d) This one is a spin off from "Bug 95710 - Date object pasted from another 
    workbook sheet with different date base changes value"
(e) Also a solution for copy / paste between documents with different 
    date base needs enhancement
(f) DDE-reference-link works fine
(g) "='file:// .................." reference also needs a solution 
    as requested here
Comment 1 Rainer Bielefeld 2014-03-05 06:18:29 UTC
(h) Related ...
    I added all users involved in Bug 95710 to CC
(i) WONTFIX "Bug 28223 - Excel XML export transformation - Calculation", but
    rating might have changed in between.