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 21:07:20 +0200
commit8d10be803ce0598489aa102953473fb9ea95db6e (patch)
tree016a00326af2633b04745d0f39ab2315f5101a45 /filter
parentffd8e6b44e7dacb28047661fd6b73061790761cf (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>
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>