summaryrefslogtreecommitdiff
path: root/filter
diff options
context:
space:
mode:
authorMike Kaganski <mike.kaganski@collabora.com>2017-05-05 21:08:32 +0300
committerMike Kaganski <mike.kaganski@collabora.com>2017-05-05 23:10:05 +0200
commit87cc61449023e0675ea8ef456c567fb357a340f3 (patch)
treebf646eb234184fbe92f34e7b0bdb2b35f6e098bd /filter
parent0d045c85fb8dbdb7fa2e116ef9983e0a60bd2b99 (diff)
tdf#106525: fix date import
Change-Id: I81c1cc58b0201412f650854fa9ebf920b4df68bd Reviewed-on: https://gerrit.libreoffice.org/37302 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com> (cherry picked from commit 8d10be803ce0598489aa102953473fb9ea95db6e) Reviewed-on: https://gerrit.libreoffice.org/37304 Tested-by: Mike Kaganski <mike.kaganski@collabora.com>
Diffstat (limited to 'filter')
-rw-r--r--filter/source/xslt/import/spreadsheetml/adorowset2ods.xsl3
1 files changed, 2 insertions, 1 deletions
diff --git a/filter/source/xslt/import/spreadsheetml/adorowset2ods.xsl b/filter/source/xslt/import/spreadsheetml/adorowset2ods.xsl
index d8e77f39a047..727dd1df150a 100644
--- a/filter/source/xslt/import/spreadsheetml/adorowset2ods.xsl
+++ b/filter/source/xslt/import/spreadsheetml/adorowset2ods.xsl
@@ -88,7 +88,8 @@
<xsl:attribute name="office:value"><xsl:value-of select="$thisCellValue"/></xsl:attribute>
</xsl:when>
<xsl:when test="$thisColType='date'">
- <xsl:attribute name="office:date-value"><xsl:value-of select="$thisCellValue"/></xsl:attribute>
+ <!-- We need to convert '2017-04-06 00:40:40' to '2017-04-06T00:40:40', so replace space with 'T' -->
+ <xsl:attribute name="office:date-value"><xsl:value-of select="translate($thisCellValue,' ','T')"/></xsl:attribute>
</xsl:when>
<xsl:when test="$thisColType='time'">
<xsl:attribute name="office:time-value"><xsl:value-of select="$thisCellValue"/></xsl:attribute>