Issue 83023

Summary: DateTime fields lose date information when imported from MS-XML via XSLT
Product: Calc Reporter: slowfox71 <openoffice>
Component: open-importAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P2 CC: issues
Version: OOo 2.3   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description slowfox71 2007-10-26 20:10:31 UTC
When importing a MS-XML spreadsheet containing DateTime fields, only the time
portion is imported, date information is lost irrecoverably. A small sample file is:

------------------------------------------------------------------
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
   xmlns:x="urn:schemas-microsoft-com:office:excel"
      xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
         xmlns:html="http://www.w3.org/TR/REC-html40">

<ss:Styles>
        <ss:Style ss:ID="prefaceDate">
                <ss:NumberFormat ss:Format="DD.MM.YYYY, hh:mm" />
        </ss:Style>
</ss:Styles>
<Worksheet>
<ss:Table>
<ss:Row>
        <ss:Cell ss:StyleID="prefaceDate">
                <ss:Data ss:Type="DateTime">2007-10-26T15:42:42</ss:Data>
        </ss:Cell>
</ss:Row>
</ss:Table>
</Worksheet>
</Workbook>
---------------------------------------------------------------------

The problem seems to be located in
share/xslt/import/spreadsheet/spreadsheetml2000.xsl around line 6665,
where either the date or the time from the original file is used, but
not both parts.
Comment 1 frank 2007-10-29 13:26:48 UTC
double to Issue 82849

*** This issue has been marked as a duplicate of 82849 ***
Comment 2 frank 2007-10-29 13:27:10 UTC
closed double