diff options
| author | Mike Kaganski <mike.kaganski@collabora.com> | 2017-05-05 21:08:32 +0300 |
|---|---|---|
| committer | Mike Kaganski <mike.kaganski@collabora.com> | 2017-05-05 21:07:20 +0200 |
| commit | 8d10be803ce0598489aa102953473fb9ea95db6e (patch) | |
| tree | 016a00326af2633b04745d0f39ab2315f5101a45 | |
| parent | ffd8e6b44e7dacb28047661fd6b73061790761cf (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>
| -rw-r--r-- | filter/source/xslt/import/spreadsheetml/adorowset2ods.xsl | 3 |
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> |