diff options
Diffstat (limited to 'test/user-template/user/xslt/export/spreadsheetml/style_mapping.xsl')
| -rw-r--r-- | test/user-template/user/xslt/export/spreadsheetml/style_mapping.xsl | 390 |
1 files changed, 0 insertions, 390 deletions
diff --git a/test/user-template/user/xslt/export/spreadsheetml/style_mapping.xsl b/test/user-template/user/xslt/export/spreadsheetml/style_mapping.xsl deleted file mode 100644 index a3396f1f9ac3..000000000000 --- a/test/user-template/user/xslt/export/spreadsheetml/style_mapping.xsl +++ /dev/null @@ -1,390 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<!-- - - DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - - Copyright 2000, 2010 Oracle and/or its affiliates. - - OpenOffice.org - a multi-platform office productivity suite - - This file is part of OpenOffice.org. - - OpenOffice.org is free software: you can redistribute it and/or modify - it under the terms of the GNU Lesser General Public License version 3 - only, as published by the Free Software Foundation. - - OpenOffice.org is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - GNU Lesser General Public License version 3 for more details - (a copy is included in the LICENSE file that accompanied this code). - - You should have received a copy of the GNU Lesser General Public License - version 3 along with OpenOffice.org. If not, see - <http://www.openoffice.org/license.html> - for a copy of the LGPLv3 License. - ---> -<xsl:stylesheet version="1.0" - xmlns:xsl="http://www.w3.org/1999/XSL/Transform" - xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" - xmlns:config="urn:oasis:names:tc:opendocument:xmlns:config:1.0" - xmlns:dc="http://purl.org/dc/elements/1.1/" - xmlns:dom="http://www.w3.org/2001/xml-events" - xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" - xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" - xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" - xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" - xmlns:math="http://www.w3.org/1998/Math/MathML" - xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" - xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" - xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" - xmlns:ooo="http://openoffice.org/2004/office" - xmlns:oooc="http://openoffice.org/2004/calc" - xmlns:ooow="http://openoffice.org/2004/writer" - xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" - xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" - xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" - xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" - xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" - xmlns:xlink="http://www.w3.org/1999/xlink" - xmlns:xt="http://www.jclark.com/xt" - xmlns:common="http://exslt.org/common" - xmlns:xalan="http://xml.apache.org/xalan" - xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" - exclude-result-prefixes="chart config dc dom dr3d draw fo form math meta number office ooo oooc ooow script style svg table text xlink xt common xalan"> - - <xsl:variable name="namespace-html" select="'http://www.w3.org/TR/REC-html40'" /> - - <xsl:template match="@table:style-name | @table:default-cell-style-name"> - <xsl:if test="not(name() = 'Default')"> - <xsl:attribute name="ss:StyleID"> - <xsl:value-of select="." /> - </xsl:attribute> - </xsl:if> - </xsl:template> - - <xsl:key match="table:table-cell" name="getCellByStyle" use="@table:style-name"/> - <xsl:template match="@table:style-name" mode="table-row"> - <!-- only row styles used by cells are exported, - as usual row style properties are already written as row attributes --> - <xsl:if test="key('getCellByStyle', '.')"> - <xsl:attribute name="ss:StyleID"> - <xsl:value-of select="." /> - </xsl:attribute> - </xsl:if> - </xsl:template> - - <xsl:template name="style-and-contents"> - <xsl:param name="cellStyleName" /> - - <!-- WorkAround of Excel2003 issue: - Styles from the CellStyle will not be inherited to HTML content (e.g. Colour style). - --> - <xsl:choose> - <xsl:when test="@text:style-name"> - <xsl:variable name="styles"> - <xsl:copy-of select="key('styles', @text:style-name)/*" /> - <xsl:copy-of select="key('styles', $cellStyleName)/*" /> - </xsl:variable> - <xsl:choose> - <xsl:when test="function-available('xalan:nodeset')"> - <xsl:call-template name="create-nested-format-tags"> - <xsl:with-param name="styles" select="xalan:nodeset($styles)" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:when> - <xsl:when test="function-available('xt:node-set')"> - <xsl:call-template name="create-nested-format-tags"> - <xsl:with-param name="styles" select="xt:node-set($styles)" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:when> - <xsl:when test="function-available('common:node-set')"> - <xsl:call-template name="create-nested-format-tags"> - <xsl:with-param name="styles" select="common:node-set($styles)" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:when> - <xsl:otherwise> - <xsl:message terminate="yes">The required node-set function was not found!</xsl:message> - </xsl:otherwise> - </xsl:choose> - </xsl:when> - <xsl:when test="@table:style-name"> - <xsl:variable name="styles"> - <xsl:copy-of select="key('styles', @text:style-name)/*" /> - <xsl:copy-of select="key('styles', $cellStyleName)/*" /> - </xsl:variable> - - <xsl:choose> - <xsl:when test="function-available('xalan:nodeset')"> - <xsl:call-template name="create-nested-format-tags"> - <xsl:with-param name="styles" select="xalan:nodeset($styles)" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:when> - <xsl:when test="function-available('xt:node-set')"> - <xsl:call-template name="create-nested-format-tags"> - <xsl:with-param name="styles" select="xt:node-set($styles)" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:when> - <xsl:when test="function-available('common:node-set')"> - <xsl:call-template name="create-nested-format-tags"> - <xsl:with-param name="styles" select="common:node-set($styles)" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:when> - <xsl:otherwise> - <xsl:message terminate="yes">The required node-set function was not found!</xsl:message> - </xsl:otherwise> - </xsl:choose> - </xsl:when> - <xsl:otherwise> - <xsl:apply-templates> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:apply-templates> - </xsl:otherwise> - </xsl:choose> - </xsl:template> - - - <!-- *********************************** --> - <!-- *** creating nested format tags *** --> - <!-- *********************************** --> - - <!-- Bold --> - <xsl:template name="create-nested-format-tags"> - <xsl:param name="styles" /> - <xsl:param name="cellStyleName" /> - - <xsl:choose> - <xsl:when test="$styles/*/@fo:font-weight = 'bold' or $styles/*/@fo:font-weight = 'bolder'"> - <xsl:element namespace="{$namespace-html}" name="B"> - <xsl:call-template name="italic"> - <xsl:with-param name="styles" select="$styles" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:element> - </xsl:when> - <xsl:otherwise> - <xsl:call-template name="italic"> - <xsl:with-param name="styles" select="$styles" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:otherwise> - </xsl:choose> - </xsl:template> - - - <!-- Italic --> - <xsl:template name="italic"> - <xsl:param name="styles" /> - <xsl:param name="cellStyleName" /> - - <xsl:choose> - <xsl:when test="$styles/*/@fo:font-style = 'italic' or $styles/*/@fo:font-style = 'oblique'"> - <xsl:element namespace="{$namespace-html}" name="I"> - <xsl:call-template name="underline"> - <xsl:with-param name="styles" select="$styles" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:element> - </xsl:when> - <xsl:otherwise> - <xsl:call-template name="underline"> - <xsl:with-param name="styles" select="$styles" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:otherwise> - </xsl:choose> - </xsl:template> - - - <!-- Underline --> - <xsl:template name="underline"> - <xsl:param name="styles" /> - <xsl:param name="cellStyleName" /> - - <xsl:choose> - <xsl:when test="$styles/*/@style:text-underline-type and not($styles/*/@style:text-underline-type = 'none')"> - <xsl:element namespace="{$namespace-html}" name="U"> - <xsl:call-template name="strikethrough"> - <xsl:with-param name="styles" select="$styles" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:element> - </xsl:when> - <xsl:otherwise> - <xsl:call-template name="strikethrough"> - <xsl:with-param name="styles" select="$styles" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:otherwise> - </xsl:choose> - - </xsl:template> - - - <!-- strikethrough --> - <xsl:template name="strikethrough"> - <xsl:param name="styles" /> - <xsl:param name="cellStyleName" /> - - <xsl:choose> - <xsl:when test="$styles/*/@style:text-line-through-style and not($styles/*/@style:text-line-through-style = 'none')"> - <xsl:element namespace="{$namespace-html}" name="S"> - <xsl:call-template name="super-subscript"> - <xsl:with-param name="styles" select="$styles" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:element> - </xsl:when> - <xsl:otherwise> - <xsl:call-template name="super-subscript"> - <xsl:with-param name="styles" select="$styles" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:otherwise> - </xsl:choose> - </xsl:template> - - - - <!-- superscript & subscript --> - <xsl:template name="super-subscript"> - <xsl:param name="styles" /> - <xsl:param name="cellStyleName" /> - - <xsl:choose> - <xsl:when test="$styles/*/@style:text-position"> - <xsl:variable name="textPosition" select="number(substring-before($styles/*/@style:text-position, '% '))" /> - <xsl:choose> - <xsl:when test="$textPosition > 0"> - <xsl:element namespace="{$namespace-html}" name="Sup"> - <xsl:call-template name="align"> - <xsl:with-param name="styles" select="$styles" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:element> - </xsl:when> - <xsl:when test="$textPosition < 0"> - <xsl:element namespace="{$namespace-html}" name="Sub"> - <xsl:call-template name="align"> - <xsl:with-param name="styles" select="$styles" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:element> - </xsl:when> - <xsl:otherwise> - <xsl:call-template name="align"> - <xsl:with-param name="styles" select="$styles" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:otherwise> - </xsl:choose> - </xsl:when> - <xsl:otherwise> - <xsl:call-template name="align"> - <xsl:with-param name="styles" select="$styles" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:otherwise> - </xsl:choose> - </xsl:template> - - - <!-- Alignment - normally called by strikethrough, but no DIV elements in HTML --> - <xsl:template name="align"> - <xsl:param name="styles" /> - <xsl:param name="cellStyleName" /> - - <xsl:choose> - <xsl:when test="$styles/*/@fo:font-align"> - <xsl:element namespace="{$namespace-html}" name="DIV"> - <xsl:attribute name="html:style"> - <xsl:choose> - <xsl:when test="$styles/*/@fo:font-align = 'start'"> - <xsl:text>text-align:left;</xsl:text> - </xsl:when> - <xsl:when test="$styles/*/@fo:font-align = 'end'"> - <xsl:text>text-align:right;</xsl:text> - </xsl:when> - <xsl:otherwise> - <xsl:text>text-align:center;</xsl:text> - </xsl:otherwise> - </xsl:choose> - </xsl:attribute> - <xsl:call-template name="font"> - <xsl:with-param name="styles" select="$styles" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:element> - </xsl:when> - <xsl:otherwise> - <xsl:call-template name="font"> - <xsl:with-param name="styles" select="$styles" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:otherwise> - </xsl:choose> - </xsl:template> - - - <!-- Font (size and color) --> - <xsl:template name="font"> - <xsl:param name="styles" /> - <xsl:param name="cellStyleName" /> - - <xsl:choose> - <xsl:when test="$styles/*/@style:font-name or - $styles/*/@fo:font-size or - $styles/*/@fo:color"> - <xsl:element namespace="{$namespace-html}" name="Font"> - <xsl:if test="$styles/*/@style:font-name"> - <xsl:attribute name="html:Face"> - <xsl:value-of select="$styles/*/@style:font-name" /> - </xsl:attribute> - </xsl:if> - <xsl:if test="$styles/*/@fo:color"> - <xsl:attribute name="html:Color"> - <xsl:value-of select="$styles/*/@fo:color" /> - </xsl:attribute> - </xsl:if> - <xsl:if test="$styles/*/@fo:font-size"> - <!-- WORKAROUND TO EXCEL2003 issue where nested FONT elements with size attributes result in unloadable documents --> - <!-- Only create size attribute if parent do not have already one --> - - <!--<xsl:choose> - <xsl:when test="not(key('styles', parent::*/@text:style-name)/*/@fo:font-size)"> --> - <xsl:if test="not(key('styles', parent::*/@text:style-name)/*/@fo:font-size)"> - <xsl:attribute name="html:Size"> - <xsl:call-template name="convert2pt"> - <xsl:with-param name="value" select="$styles/*/@fo:font-size" /> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:call-template> - </xsl:attribute> - </xsl:if> - <!--</xsl:when> - <xsl:otherwise> - <xsl:message>Due Excel issue we have to neglect size from @text:style-name '<xsl:value-of select="@text:style-name"/>'!</xsl:message> - </xsl:otherwise> - </xsl:choose>--> - </xsl:if> - <!-- get the embedded content --> - <xsl:apply-templates> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:apply-templates> - </xsl:element> - </xsl:when> - <xsl:otherwise> - <!-- get the embedded content --> - <xsl:apply-templates> - <xsl:with-param name="cellStyleName" select="$cellStyleName" /> - </xsl:apply-templates> - </xsl:otherwise> - </xsl:choose> - </xsl:template> - -</xsl:stylesheet> |