Allowing exporting ODF < 1.2 formulas to Excel 2003 XML too.
Patch by: me
diff --git a/main/filter/source/xslt/export/spreadsheetml/formular.xsl b/main/filter/source/xslt/export/spreadsheetml/formular.xsl
index b33afba..de271a1 100644
--- a/main/filter/source/xslt/export/spreadsheetml/formular.xsl
+++ b/main/filter/source/xslt/export/spreadsheetml/formular.xsl
@@ -87,7 +87,7 @@
<xsl:choose>
<!-- OASIS Open Document XML formular expressions -->
<xsl:when test="starts-with($expression,'of:')">
- <!-- giving out the '=', which will be removed with 'of:=' to enable recursive string parsing -->
+ <!-- ODF >= 1.2: giving out the '=', which will be removed with 'of:=' to enable recursive string parsing -->
<xsl:text>=</xsl:text>
<xsl:call-template name="function-parameter-mapping">
<xsl:with-param name="rowPos" select="$rowPos" />
@@ -96,6 +96,16 @@
<xsl:with-param name="expression" select="translate(substring($expression,5),';',',')"/>
</xsl:call-template>
</xsl:when>
+ <xsl:when test="starts-with($expression,'oooc:')">
+ <!-- ODF < 1.2: giving out the '=', which will be removed with 'oooc:=' to enable recursive string parsing -->
+ <xsl:text>=</xsl:text>
+ <xsl:call-template name="function-parameter-mapping">
+ <xsl:with-param name="rowPos" select="$rowPos" />
+ <xsl:with-param name="columnPos" select="$columnPos" />
+ <!-- 1) remove 'oooc:=' prefix and exchange ';' with ',' -->
+ <xsl:with-param name="expression" select="translate(substring($expression,7),';',',')"/>
+ </xsl:call-template>
+ </xsl:when>
<xsl:otherwise>
<xsl:value-of select="$expression" />
</xsl:otherwise>
