diff options
-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> |