home *** CD-ROM | disk | FTP | other *** search
<?xml version="1.0" encoding="UTF-8"?> <!-- # The Contents of this file are made available subject to the terms of # either of the following licenses # # - GNU Lesser General Public License Version 2.1 # - Sun Industry Standards Source License Version 1.1 # # Sun Microsystems Inc., October, 2000 # # GNU Lesser General Public License Version 2.1 # ============================================= # Copyright 2000 by Sun Microsystems, Inc. # 901 San Antonio Road, Palo Alto, CA 94303, USA # # This library is free software; you can redistribute it and/or # modify it under the terms of the GNU Lesser General Public # License version 2.1, as published by the Free Software Foundation. # # This library 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 for more details. # # You should have received a copy of the GNU Lesser General Public # License along with this library; if not, write to the Free Software # Foundation, Inc., 59 Temple Place, Suite 330, Boston, # MA 02111-1307 USA # # # Sun Industry Standards Source License Version 1.1 # ================================================= # The contents of this file are subject to the Sun Industry Standards # Source License Version 1.1 (the "License"); You may not use this file # except in compliance with the License. You may obtain a copy of the # License at http://www.openoffice.org/license.html. # # Software provided under this License is provided on an "AS IS" basis, # WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, # WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, # MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. # See the License for the specific provisions governing your rights and # obligations concerning the Software. # # The Initial Developer of the Original Code is: Sun Microsystems, Inc. # # Copyright: 2000 by Sun Microsystems, Inc. # # All Rights Reserved. # # Contributor(s): _______________________________________ # # --> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:w="http://schemas.microsoft.com/office/word/2003/wordml" xmlns:wx="http://schemas.microsoft.com/office/word/2003/auxHint" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:w10="urn:schemas-microsoft-com:office:word" xmlns:SL="http://schemas.microsoft.com/schemaLibrary/2003/core" xmlns:aml="http://schemas.microsoft.com/aml/2001/core" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:office="http://openoffice.org/2000/office" xmlns:table="http://openoffice.org/2000/table" xmlns:style="http://openoffice.org/2000/style" xmlns:text="http://openoffice.org/2000/text" xmlns:draw="http://openoffice.org/2000/drawing" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:number="http://openoffice.org/2000/datastyle" xmlns:svg="http://www.w3.org/2000/svg" xmlns:chart="http://openoffice.org/2000/chart" xmlns:dr3d="http://openoffice.org/2000/dr3d" xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:form="http://openoffice.org/2000/form" xmlns:script="http://openoffice.org/2000/script" office:class="spreadsheet" office:version="1.0" xmlns:meta="http://openoffice.org/2000/meta" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:config="http://openoffice.org/2001/config" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"> <xsl:output indent="no" version="1.0" encoding="UTF-8" method="xml"/> <xsl:template match="/"> <office:document xmlns:office="http://openoffice.org/2000/office" xmlns:style="http://openoffice.org/2000/style" xmlns:text="http://openoffice.org/2000/text" xmlns:table="http://openoffice.org/2000/table" xmlns:draw="http://openoffice.org/2000/drawing" xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:number="http://openoffice.org/2000/datastyle" xmlns:svg="http://www.w3.org/2000/svg" xmlns:chart="http://openoffice.org/2000/chart" xmlns:dr3d="http://openoffice.org/2000/dr3d" xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:form="http://openoffice.org/2000/form" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="http://openoffice.org/2000/meta" xmlns:script="http://openoffice.org/2000/script" xmlns:config="http://openoffice.org/2001/config" office:class="spreadsheet" office:version="1.0"> <xsl:apply-templates select="ss:Workbook/o:DocumentProperties"/> <xsl:apply-templates select="ss:Workbook/x:ExcelWorkbook"/> <xsl:call-template name="font-declaration"/> <xsl:apply-templates select="ss:Workbook/ss:Styles"/> <xsl:element name="office:body"> <xsl:call-template name="set-calculation"/> <xsl:apply-templates select="ss:Workbook/ss:Worksheet"/> <xsl:call-template name="Names"/> <xsl:element name="table:database-ranges"> <xsl:apply-templates select="ss:Workbook/ss:Worksheet/x:AutoFilter"/> </xsl:element> </xsl:element> </office:document> </xsl:template> <xsl:template match="o:DocumentProperties"> <office:meta> <meta:generator>Microsoft Excel 2003</meta:generator> <dc:title> <xsl:value-of select="o:Title"/> </dc:title> <dc:description> <xsl:value-of select="o:Description"/> </dc:description> <dc:subject> <xsl:value-of select="o:Subject"/> </dc:subject> <meta:initial-creator> <xsl:value-of select="o:Author"/> </meta:initial-creator> <meta:creation-date> <xsl:value-of select="substring-before( o:Created, 'Z')"/> </meta:creation-date> <dc:creator> <xsl:value-of select="o:LastAuthor"/> </dc:creator> <dc:date> <xsl:value-of select="substring-before( o:LastSaved, 'Z')"/> </dc:date> <meta:printed-by/> <meta:print-date/> <meta:keywords> <meta:keyword> <xsl:value-of select="o:Keywords"/> </meta:keyword> </meta:keywords> <dc:language/> <meta:editing-cycles> <xsl:value-of select="o:Revision"/> </meta:editing-cycles> <meta:editing-duration> <xsl:if test="o:TotalTime"> <xsl:value-of select="concat('PT', floor(o:TotalTime div 60), 'H', o:TotalTime mod 60, 'M0S')"/> </xsl:if> </meta:editing-duration> <meta:user-defined meta:name="Category"> <xsl:value-of select="o:Category"/> </meta:user-defined> <meta:user-defined meta:name="Manager"> <xsl:value-of select="o:Manager"/> </meta:user-defined> <meta:user-defined meta:name="Company"> <xsl:value-of select="o:Company"/> </meta:user-defined> <meta:user-defined meta:name="Version"> <xsl:value-of select="o:Version"/> </meta:user-defined> <meta:user-defined meta:name="HyperlinkBase"> <xsl:value-of select="o:HyperlinkBase"/> </meta:user-defined> <xsl:apply-templates select="../o:CustomDocumentProperties"/> <meta:document-statistic/> </office:meta> </xsl:template> <xsl:template match="o:CustomDocumentProperties"> <xsl:for-each select="node()[@dt:dt]"> <meta:user-defined meta:name="{name()}"> <xsl:value-of select="."/> </meta:user-defined> </xsl:for-each> </xsl:template> <xsl:template match="x:ExcelWorkbook"> <office:settings> <config:config-item-set config:name="view-settings"> <config:config-item config:name="VisibleAreaTop" config:type="int"> <xsl:value-of select="x:WindowTopY"/> </config:config-item> <config:config-item config:name="VisibleAreaLeft" config:type="int"> <xsl:value-of select="x:WindowTopX"/> </config:config-item> <config:config-item config:name="VisibleAreaWidth" config:type="int"> <xsl:value-of select="x:WindowWidth"/> </config:config-item> <config:config-item config:name="VisibleAreaHeight" config:type="int"> <xsl:value-of select="x:WindowHeight"/> </config:config-item> <xsl:variable name="ratio" select="15"/> <config:config-item-map-indexed config:name="Views"> <config:config-item-map-entry> <config:config-item config:name="ViewId" config:type="string">View1</config:config-item> <config:config-item-map-named config:name="Tables"> <!-- The panes of a table is like 3 | 1 or 3 | 1, or 3 , while 3 is the default one. glu - - - - - - - 2 | 0 2 --> <xsl:for-each select="../ss:Worksheet"> <config:config-item-map-entry config:name="{@ss:Name}"> <xsl:variable name="active-pane"> <xsl:choose> <xsl:when test="x:WorksheetOptions/x:ActivePane"> <xsl:value-of select="x:WorksheetOptions/x:ActivePane"/> </xsl:when> <xsl:otherwise/> </xsl:choose> </xsl:variable> <xsl:if test="not( $active-pane = '' ) and ( x:WorksheetOptions/x:SplitVertical or x:WorksheetOptions/x:SplitHorizontal )"> <config:config-item config:name="ActiveSplitRange" config:type="short"> <xsl:choose> <xsl:when test="x:WorksheetOptions/x:SplitVertical and not(x:WorksheetOptions/x:SplitHorizontal)"> <!-- wierd enough !! :( glu --> <xsl:value-of select="'3'"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$active-pane"/> </xsl:otherwise> </xsl:choose> </config:config-item> </xsl:if> <xsl:choose> <xsl:when test="not( $active-pane = '')"> <config:config-item config:name="CursorPositionX" config:type="int"> <xsl:value-of select="x:WorksheetOptions/x:Panes/x:Pane[x:Number = $active-pane ]/x:ActiveCol"/> </config:config-item> <config:config-item config:name="CursorPositionY" config:type="int"> <xsl:value-of select="x:WorksheetOptions/x:Panes/x:Pane[x:Number = $active-pane ]/x:ActiveRow"/> </config:config-item> </xsl:when> <xsl:otherwise> <config:config-item config:name="CursorPositionX" config:type="int"> <xsl:value-of select="x:WorksheetOptions/x:Panes/x:Pane/x:ActiveCol"/> </config:config-item> <config:config-item config:name="CursorPositionY" config:type="int"> <xsl:value-of select="x:WorksheetOptions/x:Panes/x:Pane/x:ActiveRow"/> </config:config-item> </xsl:otherwise> </xsl:choose> <xsl:variable name="position-left"> <xsl:choose> <xsl:when test="x:WorksheetOptions/x:LeftColumnVisible"> <xsl:value-of select="x:WorksheetOptions/x:LeftColumnVisible"/> </xsl:when> <xsl:otherwise>0</xsl:otherwise> </xsl:choose> </xsl:variable> <config:config-item config:name="PositionLeft" config:type="int"> <xsl:value-of select="$position-left"/> </config:config-item> <xsl:variable name="position-top"> <xsl:choose> <xsl:when test="x:WorksheetOptions/x:TopRowVisible"> <xsl:value-of select="x:WorksheetOptions/x:TopRowVisible"/> </xsl:when> <xsl:otherwise>0</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:choose> <xsl:when test="x:WorksheetOptions/x:SplitVertical and not(x:WorksheetOptions/x:SplitHorizontal)"> <!-- wierd enough !! :( glu --> <config:config-item config:name="PositionBottom" config:type="int"> <xsl:value-of select="$position-top"/> </config:config-item> </xsl:when> <xsl:otherwise> <config:config-item config:name="PositionTop" config:type="int"> <xsl:value-of select="$position-top"/> </config:config-item> </xsl:otherwise> </xsl:choose> <xsl:choose> <xsl:when test="x:WorksheetOptions/x:SplitVertical"> <config:config-item config:name="HorizontalSplitMode" config:type="short"> <xsl:choose> <xsl:when test="x:WorksheetOptions/x:FreezePanes">2</xsl:when> <xsl:otherwise>1</xsl:otherwise> </xsl:choose> </config:config-item> <config:config-item config:name="HorizontalSplitPosition" config:type="int"> <xsl:choose> <xsl:when test="x:WorksheetOptions/x:FreezePanes"> <xsl:value-of select="x:WorksheetOptions/x:SplitVertical + $position-left"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="floor( x:WorksheetOptions/x:SplitVertical div $ratio )"/> </xsl:otherwise> </xsl:choose> </config:config-item> <config:config-item config:name="PositionRight" config:type="int"> <xsl:value-of select="x:WorksheetOptions/x:LeftColumnRightPane"/> </config:config-item> </xsl:when> <xsl:otherwise> <config:config-item config:name="HorizontalSplitMode" config:type="short">0</config:config-item> </xsl:otherwise> </xsl:choose> <xsl:choose> <xsl:when test="x:WorksheetOptions/x:SplitHorizontal"> <config:config-item config:name="VerticalSplitMode" config:type="short"> <xsl:choose> <xsl:when test="x:WorksheetOptions/x:FreezePanes">2</xsl:when> <xsl:otherwise>1</xsl:otherwise> </xsl:choose> </config:config-item> <config:config-item config:name="VerticalSplitPosition" config:type="int"> <xsl:choose> <xsl:when test="x:WorksheetOptions/x:FreezePanes"> <xsl:value-of select="x:WorksheetOptions/x:SplitHorizontal + $position-top"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="floor( x:WorksheetOptions/x:SplitHorizontal div $ratio )"/> </xsl:otherwise> </xsl:choose> </config:config-item> <config:config-item config:name="PositionBottom" config:type="int"> <xsl:value-of select="x:WorksheetOptions/x:TopRowBottomPane"/> </config:config-item> </xsl:when> <xsl:otherwise> <config:config-item config:name="VerticalSplitMode" config:type="short">0</config:config-item> </xsl:otherwise> </xsl:choose> </config:config-item-map-entry> </xsl:for-each> </config:config-item-map-named> <xsl:if test="x:ActiveSheet"> <config:config-item config:name="ActiveTable" config:type="string"> <xsl:value-of select="../ss:Worksheet[/ss:Workbook/x:ExcelWorkbook/x:ActiveSheet+1]/@ss:Name"/> </config:config-item> </xsl:if> <config:config-item config:name="HorizontalScrollbarWidth" config:type="int">555</config:config-item> <!-- following are some table setting from Excel, but transformed to global setting, due to limit of Calc. glu --> <xsl:if test="../ss:Worksheet/x:WorksheetOptions/x:ShowPageBreakZoom"> <config:config-item config:name="ShowPageBreakPreview" config:type="boolean">true</config:config-item> </xsl:if> <xsl:if test="../ss:Worksheet/x:WorksheetOptions/x:PageBreakZoom"> <config:config-item config:name="PageViewZoomValue" config:type="int"> <xsl:value-of select="../ss:Worksheet/x:WorksheetOptions/x:PageBreakZoom"/> </config:config-item> </xsl:if> <xsl:if test="../ss:Worksheet/x:WorksheetOptions/x:Zoom"> <config:config-item config:name="ZoomValue" config:type="int"> <xsl:value-of select="../ss:Worksheet/x:WorksheetOptions/x:Zoom"/> </config:config-item> </xsl:if> <xsl:if test="../ss:Worksheet/x:WorksheetOptions/x:DoNotDisplayGridlines"> <config:config-item config:name="ShowGrid" config:type="boolean">false</config:config-item> </xsl:if> <xsl:if test="../ss:Worksheet/x:WorksheetOptions/x:GridlineColor"> <config:config-item config:name="GridColor" config:type="long"> <xsl:variable name="temp-code" select="substring-after(normalize-space(../ss:Worksheet/x:WorksheetOptions/x:GridlineColor), '#')"/> <xsl:variable name="temp-value"> <xsl:call-template name="hex2decimal"> <xsl:with-param name="hex-number" select="$temp-code"/> <xsl:with-param name="index" select="1"/> <xsl:with-param name="str-length" select="string-length($temp-code)"/> <xsl:with-param name="last-value" select="0"/> </xsl:call-template> </xsl:variable> <xsl:value-of select="$temp-value"/> </config:config-item> </xsl:if> <xsl:if test="../ss:Worksheet/x:WorksheetOptions/x:DoNotDisplayHeadings"> <config:config-item config:name="HasColumnRowHeaders" config:type="boolean">false</config:config-item> </xsl:if> <xsl:if test="../ss:Worksheet/x:WorksheetOptions/x:DoNotDisplayZeros"> <config:config-item config:name="ShowZeroValues" config:type="boolean">false</config:config-item> </xsl:if> <xsl:if test="../ss:Worksheet/x:WorksheetOptions/x:DoNotDisplayOutline"> <config:config-item config:name="IsOutlineSymbolsSet" config:type="boolean">false</config:config-item> </xsl:if> <xsl:if test="x:HideWorkbookTabs"> <config:config-item config:name="HasSheetTabs" config:type="boolean">false</config:config-item> </xsl:if> <!-- several properties are not saved in Calc XML but setting, whereas vice versa. :( So just to be expanded, glu. --> </config:config-item-map-entry> </config:config-item-map-indexed> </config:config-item-set> <!-- printer setting, not finished yet. glu <config:config-item-set config:name="configuration-settings"/> --> </office:settings> </xsl:template> <xsl:template name="font-declaration"> <office:font-decls> <xsl:if test="/ss:Workbook/ss:Styles/ss:Style/ss:Font"> <xsl:for-each select="/ss:Workbook/ss:Styles/ss:Style/ss:Font"> <xsl:element name="style:font-decl"> <xsl:attribute name="style:name"><xsl:value-of select="@ss:FontName"/></xsl:attribute> <xsl:attribute name="fo:font-family"><xsl:value-of select="@ss:FontName"/></xsl:attribute> <xsl:attribute name="style:font-family-generic"><xsl:call-template name="translate-font-family-generic"><xsl:with-param name="family" select="@x:Family"/></xsl:call-template></xsl:attribute> </xsl:element> </xsl:for-each> </xsl:if> <xsl:if test="/ss:Workbook/ss:Worksheet/ss:Table/ss:Row/ss:Cell/descendant::html:Font[@html:Face]"> <xsl:for-each select="/ss:Workbook/ss:Worksheet/ss:Table/ss:Row/ss:Cell/descendant::html:Font[@html:Face]"> <xsl:element name="style:font-decl"> <xsl:attribute name="style:name"><xsl:value-of select="@html:Face"/></xsl:attribute> <xsl:attribute name="fo:font-family"><xsl:value-of select="@html:Face"/></xsl:attribute> <xsl:attribute name="style:font-family-generic"><xsl:call-template name="translate-font-family-generic"><xsl:with-param name="family" select="@x:Family"/></xsl:call-template></xsl:attribute> </xsl:element> </xsl:for-each> </xsl:if> </office:font-decls> </xsl:template> <xsl:template name="translate-font-family-generic"> <xsl:param name="family"/> <xsl:choose> <xsl:when test="$family = 'Swiss'">swiss</xsl:when> <xsl:when test="$family='Modern'">modern</xsl:when> <xsl:when test="$family='Roman'">roman</xsl:when> <xsl:when test="$family='Script'">script</xsl:when> <xsl:when test="$family='Decorative'">decorative</xsl:when> <!-- change 'System' to 'Automatic' for Excel. glu --> <xsl:when test="$family='Automatic'">system</xsl:when> <xsl:otherwise>system</xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template match="ss:Styles"> <office:styles> <xsl:apply-templates select="ss:Style[@ss:Name]"/> <xsl:apply-templates select="ss:Style/ss:NumberFormat[@ss:Format]"/> <!-- if ConditionalFormatting exists,it should generate some styles for style:style.tom chen --> <xsl:if test="../ss:Worksheet/x:ConditionalFormatting"> <xsl:call-template name="CondFormat_office_style"/> </xsl:if> </office:styles> <office:automatic-styles> <xsl:apply-templates select="../ss:Worksheet/ss:Table"/> <xsl:apply-templates select="ss:Style[not(@ss:Name)]"/> <xsl:apply-templates select="ss:Style/ss:Font[@ss:VerticalAlign]"/> <xsl:apply-templates select="../ss:Worksheet/ss:Table/ss:Row/ss:Cell/ss:Data[descendant-or-self::*[namespace-uri()='http://www.w3.org/TR/REC-html40']]"/> <xsl:apply-templates select="../ss:Worksheet/x:WorksheetOptions/x:PageSetup//@x:Data"/> <!-- if ConditionalFormatting exists,transforing the styles.tom chen --> <xsl:if test="../ss:Worksheet/x:ConditionalFormatting"> <xsl:call-template name="CondFormat_automatic_style"/> </xsl:if> <xsl:call-template name="create-page-master"> <xsl:with-param name="worksheetoptions" select="../ss:Worksheet/x:WorksheetOptions"/> </xsl:call-template> </office:automatic-styles> <office:master-styles> <xsl:call-template name="create-master-styles"> <xsl:with-param name="worksheetoptions" select="../ss:Worksheet/x:WorksheetOptions"/> </xsl:call-template> </office:master-styles> </xsl:template> <xsl:template name="CondFormat_office_style"> <!-- translate the ConditionalFormatting style,including font,size,color,etc.tom chen --> <xsl:for-each select="../ss:Worksheet/x:ConditionalFormatting"> <xsl:variable name="table-pos" select="count(../preceding-sibling::ss:Worksheet)+1"/> <xsl:variable name="conditions" select="count(preceding-sibling::x:ConditionalFormatting)+1"/> <xsl:for-each select="x:Condition"> <xsl:variable name="condition-number" select="count(preceding-sibling::x:Condition)+1"/> <style:style style:name="{concat('Excel_CondFormat_',$table-pos,'_',$conditions,'_',$condition-number)}" style:family="table-cell" style:parent-style-name="Default"> <xsl:element name="style:properties"> <xsl:choose> <xsl:when test="./x:Format/@Style"> <xsl:variable name="stylevalue" select="./x:Format/@Style"/> <xsl:call-template name="recursion-condformat-style"> <xsl:with-param name="style-value-t"> <xsl:choose> <xsl:when test="substring($stylevalue,string-length($stylevalue),1) != ';'"> <xsl:value-of select="concat($stylevalue,';')"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$stylevalue"/> </xsl:otherwise> </xsl:choose> </xsl:with-param> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:attribute name="fo:font-style"><xsl:value-of select="'italic'"/></xsl:attribute> <xsl:attribute name="style:text-underline"><xsl:value-of select="'single'"/></xsl:attribute> <xsl:attribute name="style:text-underline-color"><xsl:value-of select="'font-color'"/></xsl:attribute> <xsl:attribute name="fo:font-weight"><xsl:value-of select="'bold'"/></xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:element> </style:style> </xsl:for-each> </xsl:for-each> </xsl:template> <xsl:template name="recursion-condformat-style"> <!-- generates style:style for ConditionalFormatting,tom chen --> <xsl:param name="style-value-t"/> <xsl:variable name="style-value" select="normalize-space($style-value-t)"/> <xsl:choose> <xsl:when test="starts-with($style-value,'color')"> <xsl:attribute name="fo:color"><xsl:call-template name="translate-color-style"><xsl:with-param name="source-str" select="normalize-space(substring-before(substring-after($style-value,':'),';'))"/></xsl:call-template></xsl:attribute> </xsl:when> <xsl:when test="starts-with($style-value,'font-style')"> <xsl:attribute name="fo:font-style"><xsl:value-of select="normalize-space(substring-before(substring-after($style-value,':'),';'))"/></xsl:attribute> </xsl:when> <xsl:when test="starts-with($style-value,'background')"> <xsl:choose> <xsl:when test="contains($style-value,'mso-pattern')"> <xsl:variable name="color-value"> <xsl:call-template name="translate-color-style"> <xsl:with-param name="source-str" select="normalize-space(substring-before(substring-after($style-value,':'),';'))"/> </xsl:call-template> </xsl:variable> <xsl:variable name="mso-value"> <xsl:call-template name="translate-color-style"> <xsl:with-param name="source-str" select="normalize-space(substring-after($style-value,'mso-pattern'))"/> </xsl:call-template> </xsl:variable> <xsl:variable name="mso-color" select="substring-after($mso-value,'#')"/> <xsl:variable name="pattern-color-value" select="substring($mso-color,1,6)"/> <xsl:variable name="pattern" select="concat('0.',normalize-space(substring-before(substring-after($mso-color,'gray-'),';')))"/> <xsl:variable name="pattern-color"> <xsl:call-template name="cell-pattern-color"> <xsl:with-param name="pattern" select="$pattern"/> <xsl:with-param name="color-value" select="$color-value"/> <xsl:with-param name="pattern-color-value" select="concat('#',$pattern-color-value)"/> </xsl:call-template> </xsl:variable> <xsl:attribute name="fo:background-color"><xsl:value-of select="normalize-space($pattern-color)"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="fo:background-color"><xsl:call-template name="translate-color-style"><xsl:with-param name="source-str" select="normalize-space(substring-before(substring-after($style-value,':'),';'))"/></xsl:call-template></xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:when test="starts-with($style-value,'font-weight')"> <xsl:variable name="font-weight" select="normalize-space(substring-before(substring-after($style-value,':'),';'))"/> <xsl:attribute name="fo:font-weight"><xsl:choose><xsl:when test="($font-weight > 300) and ($font-weight < 500)"><xsl:value-of select="'normal'"/></xsl:when><xsl:when test="($font-weight > 500) or ($font-weight = 500)"><xsl:value-of select="'bold'"/></xsl:when><xsl:otherwise><xsl:value-of select="'0'"/></xsl:otherwise></xsl:choose></xsl:attribute> </xsl:when> <xsl:when test="starts-with($style-value,'border')"> <xsl:attribute name="fo:border"><xsl:value-of select="'0.002cm solid #000000'"/></xsl:attribute> </xsl:when> <xsl:when test="starts-with($style-value,'text-underline-style')"> <xsl:attribute name="style:text-underline"><xsl:value-of select="normalize-space(substring-before(substring-after($style-value,':'),';'))"/></xsl:attribute> <xsl:attribute name="style:text-underline-color"><xsl:value-of select="'#000000'"/></xsl:attribute> </xsl:when> </xsl:choose> <xsl:if test="contains($style-value,':')"> <xsl:call-template name="recursion-condformat-style"> <xsl:with-param name="style-value-t" select="substring-after($style-value,';')"/> </xsl:call-template> </xsl:if> </xsl:template> <xsl:template name="translate-color-style"> <!-- translate the word of color to hex code of color.tom chen --> <xsl:param name="source-str"/> <xsl:choose> <xsl:when test="starts-with($source-str,'#')"> <xsl:value-of select="$source-str"/> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="starts-with($source-str,'black')"> <xsl:value-of select="'#000000'"/> </xsl:when> <xsl:when test="starts-with($source-str,'maroon')"> <xsl:value-of select="'#800000'"/> </xsl:when> <xsl:when test="starts-with($source-str,'red')"> <xsl:value-of select="'#FF0000'"/> </xsl:when> <xsl:when test="starts-with($source-str,'fuchsia')"> <xsl:value-of select="'#FF00FF'"/> </xsl:when> <xsl:when test="starts-with($source-str,'olive')"> <xsl:value-of select="'#808000'"/> </xsl:when> <xsl:when test="starts-with($source-str,'yellow')"> <xsl:value-of select="'#FFFF00'"/> </xsl:when> <xsl:when test="starts-with($source-str,'green')"> <xsl:value-of select="'#008000'"/> </xsl:when> <xsl:when test="starts-with($source-str,'lime')"> <xsl:value-of select="'#00FF00'"/> </xsl:when> <xsl:when test="starts-with($source-str,'teal')"> <xsl:value-of select="'#008080'"/> </xsl:when> <xsl:when test="starts-with($source-str,'aqua')"> <xsl:value-of select="'#00FFFF'"/> </xsl:when> <xsl:when test="starts-with($source-str,'navy')"> <xsl:value-of select="'#000080'"/> </xsl:when> <xsl:when test="starts-with($source-str,'blue')"> <xsl:value-of select="'#0000FF'"/> </xsl:when> <xsl:when test="starts-with($source-str,'purple')"> <xsl:value-of select="'#800080'"/> </xsl:when> <xsl:when test="starts-with($source-str,'gray')"> <xsl:value-of select="'#808080'"/> </xsl:when> <xsl:when test="starts-with($source-str,'silver')"> <xsl:value-of select="'#C0C0C0'"/> </xsl:when> <xsl:when test="starts-with($source-str,'white')"> <xsl:value-of select="'#FFFFFF'"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="'#FFFFFF'"/> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="CondFormat_automatic_style"> <!-- translate the ConditionalFormatting condition,including map,formalu,etc.tom chen --> <xsl:for-each select="../ss:Worksheet/x:ConditionalFormatting"> <xsl:variable name="table-pos" select="count(../preceding-sibling::ss:Worksheet)+1"/> <xsl:variable name="conditions" select="count(preceding-sibling::x:ConditionalFormatting)+1"/> <style:style style:name="{concat('ce',$table-pos,'-',$conditions)}" style:family="table-cell" style:parent-style-name="Default"> <xsl:for-each select="x:Condition"> <xsl:variable name="condition-number" select="count(preceding-sibling::x:Condition)+1"/> <xsl:variable name="base-address"> <xsl:choose> <xsl:when test="contains(../x:Range,',')"> <xsl:choose> <xsl:when test="contains(substring-before(../x:Range,','),':')"> <xsl:value-of select="substring-before(substring-after(../x:Range,':'),',')"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="substring-before(../x:Range,',')"/> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:value-of select="../x:Range"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="base-cell-address"> <xsl:call-template name="translate-unit"> <xsl:with-param name="column-number" select="substring-before(substring-after($base-address,'R'),'C')"/> <xsl:with-param name="row-number" select="substring-after($base-address,'C')"/> <xsl:with-param name="column-pos-style" select="absolute"/> <xsl:with-param name="row-pos-style" select="absolute"/> </xsl:call-template> </xsl:variable> <xsl:variable name="condition-value"> <xsl:call-template name="translate-condition"> </xsl:call-template> </xsl:variable> <xsl:element name="style:map"> <xsl:attribute name="style:condition"><xsl:value-of select="$condition-value"/></xsl:attribute> <xsl:attribute name="style:apply-style-name"><xsl:value-of select="concat('Excel_CondFormat_',$table-pos,'_',$conditions,'_',$condition-number)"/></xsl:attribute> <xsl:attribute name="style:base-cell-address"><xsl:value-of select="concat(../../@ss:Name,'.',$base-cell-address)"/></xsl:attribute> </xsl:element> </xsl:for-each> </style:style> </xsl:for-each> </xsl:template> <xsl:template name="translate-condition"> <!-- translates the condition to generate formula.tom chen --> <xsl:variable name="address-value"> <xsl:call-template name="translate-expression"> <xsl:with-param name="cell-row-pos" select="0"/> <xsl:with-param name="cell-column-pos" select="0"/> <xsl:with-param name="expression" select="x:Value1"/> </xsl:call-template> </xsl:variable> <xsl:choose> <xsl:when test="x:Qualifier"> <xsl:variable name="qualifier" select="x:Qualifier"/> <xsl:variable name="first-value" select="x:Value1"/> <xsl:choose> <xsl:when test="$qualifier = 'Equal'"> <xsl:choose> <xsl:when test="starts-with($first-value,'"')"> <xsl:value-of select="concat('cell-content()=',$address-value)"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="concat('cell-content()=[',$address-value,']')"/> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:when test="$qualifier = 'Less'"> <xsl:value-of select="concat('cell-content()<[',$address-value,']')"/> </xsl:when> <xsl:when test="$qualifier = 'Greater'"> <xsl:value-of select="concat('cell-content()>[',$address-value,']')"/> </xsl:when> <xsl:when test="$qualifier = 'LessOrEqual'"> <xsl:value-of select="concat('cell-content()<=[',$address-value,']')"/> </xsl:when> <xsl:when test="$qualifier = 'GreaterOrEqual'"> <xsl:value-of select="concat('cell-content()>=[',$address-value,']')"/> </xsl:when> <xsl:when test="$qualifier = 'NotEqual'"> <xsl:value-of select="concat('cell-content()!=[',$address-value,']')"/> </xsl:when> <xsl:when test="$qualifier = 'Between'"> <xsl:variable name="second-value"> <xsl:call-template name="translate-expression"> <xsl:with-param name="cell-row-pos" select="0"/> <xsl:with-param name="cell-column-pos" select="0"/> <xsl:with-param name="expression" select="x:Value2"/> </xsl:call-template> </xsl:variable> <xsl:value-of select="concat('cell-content-is-between([',$address-value,'],[',$second-value,'])')"/> </xsl:when> <xsl:when test="$qualifier = 'NotBetween'"> <xsl:variable name="second-value"> <xsl:call-template name="translate-expression"> <xsl:with-param name="cell-row-pos" select="0"/> <xsl:with-param name="cell-column-pos" select="0"/> <xsl:with-param name="expression" select="x:Value2"/> </xsl:call-template> </xsl:variable> <xsl:value-of select="concat('cell-content-is-not-between([',$address-value,'],[',$second-value,'])')"/> </xsl:when> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:value-of select="concat('is-true-formula(',$address-value,')')"/> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template match="ss:NumberFormat"> <xsl:variable name="unit-count" select="string-length(@ss:Format) - string-length(translate(@ss:Format,';','')) + 1"/> <xsl:variable name="proto-style-id" select="../@ss:ID"/> <xsl:call-template name="process-number-format-unit"> <xsl:with-param name="number-format-unit" select="@ss:Format"/> <xsl:with-param name="style-id" select="concat($proto-style-id,'F')"/> <xsl:with-param name="format-type" select="//ss:Cell[@ss:StyleID = $proto-style-id]/ss:Data/@ss:Type"/> <xsl:with-param name="total-unit" select="$unit-count"/> <xsl:with-param name="current-unit" select="0"/> </xsl:call-template> </xsl:template> <xsl:template name="process-number-format-unit"> <xsl:param name="number-format-unit"/> <xsl:param name="style-id"/> <xsl:param name="format-type"/> <xsl:param name="total-unit"/> <xsl:param name="current-unit"/> <xsl:choose> <!-- if total-unit > 1 and the last unit is just @, delete it. glu --> <xsl:when test="$current-unit = 0 and $total-unit > 1 and substring( $number-format-unit, string-length($number-format-unit) - 1) = ';@'"> <xsl:call-template name="process-number-format-unit"> <xsl:with-param name="number-format-unit" select="substring( $number-format-unit, 1, string-length($number-format-unit) - 2)"/> <xsl:with-param name="style-id" select="$style-id"/> <xsl:with-param name="format-type" select="$format-type"/> <xsl:with-param name="total-unit" select="$total-unit - 1"/> <xsl:with-param name="current-unit" select="0"/> </xsl:call-template> </xsl:when> <!-- $number-format-unit enum values: General, General Number, General Date, Long Date, Medium Date, Short Date, Long Time, Medium Time, Short Time, Currency, Euro Currency, Fixed, Standard, Percent, Scientific, Yes/No, True/False, On/Off. glu --> <xsl:when test="$number-format-unit = 'Currency'"> <number:number-style style:name="{concat( $style-id, 'P1')}" style:family="data-style" style:volatile="true"> <number:text>$</number:text> <number:number number:decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> </number:number-style> <number:number-style style:name="{$style-id}" style:family="data-style"> <style:properties fo:color="#ff0000"/> <number:text>$-</number:text> <number:number number:decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> <style:map style:condition="value()>=0" style:apply-style-name="{concat( $style-id, 'P1')}"/> </number:number-style> </xsl:when> <xsl:when test="$number-format-unit = 'Euro Currency'"> <number:currency-style style:name="{concat( $style-id, 'P1')}" style:family="data-style" style:volatile="true"> <number:text>€</number:text> <number:number number:decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> </number:currency-style> <number:currency-style style:name="{$style-id}" style:family="data-style"> <style:properties fo:color="#ff0000"/> <number:text>(€</number:text> <number:number number:decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> <number:text>)</number:text> <style:map style:condition="value()>=0" style:apply-style-name="{concat( $style-id, 'P1')}"/> </number:currency-style> </xsl:when> <xsl:when test="$number-format-unit = 'Yes/No' or $number-format-unit = 'True/False' or $number-format-unit = 'On/Off'"> <xsl:variable name="left-code" select="substring-before( $number-format-unit, '/')"/> <xsl:variable name="right-code" select="substring-after( $number-format-unit, '/')"/> <number:number-style style:name="{concat( $style-id, 'P1')}" style:family="data-style" style:volatile="true"> <number:text> <xsl:value-of select="$left-code"/> </number:text> </number:number-style> <number:number-style style:name="{concat( $style-id, 'P2')}" style:family="data-style" style:volatile="true"> <number:text> <xsl:value-of select="$left-code"/> </number:text> </number:number-style> <number:number-style style:name="{$style-id}" style:family="data-style"> <number:text> <xsl:value-of select="$right-code"/> </number:text> <style:map style:condition="value()>0" style:apply-style-name="{concat( $style-id, 'P1')}"/> <style:map style:condition="value()<0" style:apply-style-name="{concat( $style-id, 'P2')}"/> </number:number-style> </xsl:when> <xsl:otherwise> <xsl:if test="$total-unit > 1 and $current-unit = 0"> <!-- still complete number format string of multiple sub-formats, split them out. glu --> <xsl:call-template name="process-number-format-unit"> <xsl:with-param name="number-format-unit" select="substring-before($number-format-unit,';')"/> <xsl:with-param name="style-id" select="concat($style-id,'P1')"/> <xsl:with-param name="format-type" select="$format-type"/> <xsl:with-param name="total-unit" select="$total-unit"/> <xsl:with-param name="current-unit" select="1"/> </xsl:call-template> <xsl:if test="$total-unit > 2"> <xsl:call-template name="process-number-format-unit"> <xsl:with-param name="number-format-unit" select="substring-before(substring-after($number-format-unit,';'),';')"/> <xsl:with-param name="style-id" select="concat($style-id,'P2')"/> <xsl:with-param name="format-type" select="$format-type"/> <xsl:with-param name="total-unit" select="$total-unit"/> <xsl:with-param name="current-unit" select="2"/> </xsl:call-template> </xsl:if> <xsl:if test="$total-unit > 3"> <!-- four sub number format. glu --> <xsl:call-template name="process-number-format-unit"> <xsl:with-param name="number-format-unit" select="substring-before(substring-after(substring-after($number-format-unit,';'),';'),';')"/> <xsl:with-param name="style-id" select="concat($style-id,'P3')"/> <xsl:with-param name="format-type" select="$format-type"/> <xsl:with-param name="total-unit" select="$total-unit"/> <xsl:with-param name="current-unit" select="3"/> </xsl:call-template> </xsl:if> </xsl:if> <!-- symbol number format converted, below deal with ordinary number formatting. Watch out, it'll be quite complex. :( glu --> <xsl:variable name="current-number-format-unit"> <xsl:choose> <xsl:when test="$total-unit = 1 and $current-unit = 0"> <xsl:value-of select="$number-format-unit"/> </xsl:when> <xsl:when test="$total-unit = 2 and $current-unit = 0"> <xsl:value-of select="substring-after($number-format-unit,';')"/> </xsl:when> <xsl:when test="$total-unit = 3 and $current-unit = 0"> <xsl:value-of select="substring-after(substring-after($number-format-unit,';'),';')"/> </xsl:when> <xsl:when test="$current-unit = 0"> <!-- the forth sub number format. glu --> <xsl:value-of select="substring-after(substring-after(substring-after($number-format-unit,';'),';'),';')"/> </xsl:when> <xsl:otherwise> <!-- not the default sub number format, glu. --> <xsl:value-of select="$number-format-unit"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="style-type-name"> <xsl:choose> <xsl:when test="($format-type = 'Number' and contains($current-number-format-unit,'[$') and not(contains($current-number-format-unit,'[$-') ) ) or contains($current-number-format-unit,'Currency') ">number:currency-style</xsl:when> <xsl:when test="($format-type = 'Number' and (contains($current-number-format-unit,'%') or contains($current-number-format-unit, 'Percent') ) ) or contains($current-number-format-unit,'Percent') ">number:percentage-style</xsl:when> <xsl:when test="$format-type = 'DateTime' and (contains($current-number-format-unit,'y') or contains($current-number-format-unit,'g') or contains($current-number-format-unit,'d') or contains($current-number-format-unit, 'Date') )">number:date-style</xsl:when> <xsl:when test="$format-type = 'DateTime' and ( contains($current-number-format-unit,'h') or contains($current-number-format-unit,'m') or contains($current-number-format-unit,'s') or contains($current-number-format-unit, 'Time') )">number:time-style</xsl:when> <xsl:when test="contains($current-number-format-unit, 'Number') or contains($current-number-format-unit, 'Fixed') or contains($current-number-format-unit, 'Standard') or contains($current-number-format-unit, 'Scientific') or contains($current-number-format-unit, 'General') or ( contains($current-number-format-unit,'#') or contains($current-number-format-unit,'0') or contains($current-number-format-unit,'?') )">number:number-style</xsl:when> <xsl:when test="$format-type = 'Boolean'">number:boolean-style</xsl:when> <xsl:otherwise>number:text-style</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:element name="{$style-type-name}"> <xsl:attribute name="style:name"><xsl:value-of select="$style-id"/></xsl:attribute> <xsl:attribute name="style:family">data-style</xsl:attribute> <xsl:if test="$current-unit > 0"> <xsl:attribute name="style:volatile">true</xsl:attribute> </xsl:if> <xsl:if test="contains ( $current-number-format-unit, '[h]') or contains ( $current-number-format-unit, '[m]') or contains ( $current-number-format-unit, '[s]')"> <xsl:attribute name="number:truncate-on-overflow">false</xsl:attribute> </xsl:if> <xsl:if test="contains($current-number-format-unit,'[$') or contains($current-number-format-unit, '[DBNum')"> <xsl:call-template name="create-language-country-attribute"> <xsl:with-param name="attribute-code" select="substring-before(substring-after(substring-after($current-number-format-unit,'[$'),'-'),']')"/> <xsl:with-param name="number-code-style" select="substring-before( substring-after($current-number-format-unit,'[DBNum'),']')"/> </xsl:call-template> </xsl:if> <xsl:element name="style:properties"> <xsl:choose> <xsl:when test="contains( $current-number-format-unit, '[Red')"> <xsl:attribute name="fo:color">#ff0000</xsl:attribute> </xsl:when> <xsl:when test="contains( $current-number-format-unit, '[Black')"> <xsl:attribute name="fo:color">#000000</xsl:attribute> </xsl:when> <xsl:when test="contains( $current-number-format-unit, '[Blue')"> <xsl:attribute name="fo:color">#0000ff</xsl:attribute> </xsl:when> <xsl:when test="contains( $current-number-format-unit, '[Cyan')"> <xsl:attribute name="fo:color">#00ffff</xsl:attribute> </xsl:when> <xsl:when test="contains( $current-number-format-unit, '[Green')"> <xsl:attribute name="fo:color">#00ff00</xsl:attribute> </xsl:when> <xsl:when test="contains( $current-number-format-unit, '[Magenta')"> <xsl:attribute name="fo:color">#ff00ff</xsl:attribute> </xsl:when> <xsl:when test="contains( $current-number-format-unit, '[White')"> <xsl:attribute name="fo:color">#ffffff</xsl:attribute> </xsl:when> <xsl:when test="contains( $current-number-format-unit, '[Yellow')"> <xsl:attribute name="fo:color">#ffff00</xsl:attribute> </xsl:when> </xsl:choose> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$current-number-format-unit"/> <xsl:with-param name="unit-pos" select="1"/> </xsl:call-template> <!-- creat style:map for other sub number formats. glu --> <xsl:if test="$current-unit = 0 and $total-unit > 1"> <xsl:variable name="style-condition1"> <xsl:call-template name="get-number-format-condition"> <xsl:with-param name="number-format-unit" select="substring-before($number-format-unit,';')"/> </xsl:call-template> </xsl:variable> <xsl:choose> <xsl:when test="string-length($style-condition1) > 0"> <style:map style:condition="{concat('value()',$style-condition1)}" style:apply-style-name="{concat($style-id,'P1')}"/> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="$total-unit = 2"> <style:map style:condition="value()>=0" style:apply-style-name="{concat($style-id,'P1')}"/> </xsl:when> <xsl:otherwise> <style:map style:condition="value()>0" style:apply-style-name="{concat($style-id,'P1')}"/> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> <xsl:if test="$total-unit > 2"> <xsl:variable name="style-condition2"> <xsl:call-template name="get-number-format-condition"> <xsl:with-param name="number-format-unit" select="substring-before(substring-after($number-format-unit,';'),';')"/> </xsl:call-template> </xsl:variable> <xsl:choose> <xsl:when test="string-length($style-condition2) > 0"> <style:map style:condition="{concat('value()',$style-condition2)}" style:apply-style-name="{concat($style-id,'P2')}"/> </xsl:when> <xsl:otherwise> <style:map style:condition="value()<0" style:apply-style-name="{concat($style-id,'P2')}"/> </xsl:otherwise> </xsl:choose> </xsl:if> <xsl:if test="$total-unit > 3"> <!-- four sub number formats, glu. --> <xsl:variable name="style-condition3"> <xsl:call-template name="get-number-format-condition"> <xsl:with-param name="number-format-unit" select="substring-before(substring-after(substring-after($number-format-unit,';'),';'),';')"/> </xsl:call-template> </xsl:variable> <xsl:choose> <xsl:when test="string-length($style-condition3) > 0"> <style:map style:condition="{concat('value()',$style-condition3)}" style:apply-style-name="{concat($style-id,'P3')}"/> </xsl:when> <xsl:otherwise> <style:map style:condition="value()=0" style:apply-style-name="{concat($style-id,'P3')}"/> </xsl:otherwise> </xsl:choose> </xsl:if> </xsl:if> </xsl:element> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="create-language-country-attribute"> <xsl:param name="attribute-code"/> <xsl:param name="number-code-style"/> <!-- convert Microsoft List of Locale ID (LCID) to language and country codes according to ISO-639 and ISO-3166. Reference: http://www.loc.gov/standards/iso639-2/langcodes.html http://etext.lib.virginia.edu/tei/iso639.html http://nl.ijs.si/gnusl/cee/std/ISO_3166.html http://xml.coverpages.org/ripe3166.txt http://www.worldlanguage.com/ http://www.ethnologue.com/ glu --> <!-- the variables of language-country-code and number-shape-code transmit to decimal format. tom chen --> <xsl:variable name="language-country-code"> <xsl:variable name="temp-code"> <xsl:choose> <xsl:when test="string-length($attribute-code) <= 4"> <xsl:value-of select="$attribute-code"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="substring($attribute-code,string-length($attribute-code) - 3)"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:call-template name="hex2decimal"> <xsl:with-param name="hex-number" select="$temp-code"/> <xsl:with-param name="index" select="1"/> <xsl:with-param name="str-length" select="string-length($temp-code)"/> <xsl:with-param name="last-value" select="0"/> </xsl:call-template> </xsl:variable> <xsl:if test="string-length($attribute-code) > 4 or string-length($number-code-style) > 0"> <xsl:variable name="number-shape-code"> <xsl:variable name="temp-code"> <xsl:choose> <xsl:when test="string-length($attribute-code) > 4"> <xsl:value-of select="substring($attribute-code, 1, string-length($attribute-code) - 6)"/> </xsl:when> <xsl:otherwise>0</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:call-template name="hex2decimal"> <xsl:with-param name="hex-number" select="$temp-code"/> <xsl:with-param name="index" select="1"/> <xsl:with-param name="str-length" select="string-length($temp-code)"/> <xsl:with-param name="last-value" select="0"/> </xsl:call-template> </xsl:variable> <xsl:attribute name="number:transliteration-style">long</xsl:attribute> <xsl:choose> <!-- Western, #01 --> <xsl:when test="$number-shape-code = 1"/> <!-- Arabic Indic, #02 --> <xsl:when test="$number-shape-code = 2"/> <!-- Extended Arabic Indic, #03 --> <xsl:when test="$number-shape-code = 3"/> <!-- Devanagari (Sanskrit - India), #04--> <xsl:when test="$number-shape-code = 4"> <xsl:attribute name="number:transliteration-language">sa</xsl:attribute> <xsl:attribute name="number:transliteration-country">IN</xsl:attribute> </xsl:when> <!-- Bengali (India), #05 --> <xsl:when test="$number-shape-code = 5"> <xsl:attribute name="number:transliteration-language">bn</xsl:attribute> <xsl:attribute name="number:transliteration-country">IN</xsl:attribute> </xsl:when> <!-- Gurmukhi (Punjabi - India), #06 --> <xsl:when test="$number-shape-code = 6"> <xsl:attribute name="number:transliteration-language">pa</xsl:attribute> <xsl:attribute name="number:transliteration-country">IN</xsl:attribute> </xsl:when> <!-- Gujarati (India), #07 --> <xsl:when test="$number-shape-code = 7"> <xsl:attribute name="number:transliteration-language">gu</xsl:attribute> <xsl:attribute name="number:transliteration-country">IN</xsl:attribute> </xsl:when> <!-- Oriya (India), #08 --> <xsl:when test="$number-shape-code = 8"> <xsl:attribute name="number:transliteration-language">or</xsl:attribute> <xsl:attribute name="number:transliteration-country">IN</xsl:attribute> </xsl:when> <!-- Tamil (India), #09 --> <xsl:when test="$number-shape-code = 9"> <xsl:attribute name="number:transliteration-language">ta</xsl:attribute> <xsl:attribute name="number:transliteration-country">IN</xsl:attribute> </xsl:when> <!-- Telugu (India), #0a --> <xsl:when test="$number-shape-code = 10"> <xsl:attribute name="number:transliteration-language">te</xsl:attribute> <xsl:attribute name="number:transliteration-country">IN</xsl:attribute> </xsl:when> <!-- Kannada (India), #0b --> <xsl:when test="$number-shape-code = 11"> <xsl:attribute name="number:transliteration-language">kn</xsl:attribute> <xsl:attribute name="number:transliteration-country">IN</xsl:attribute> </xsl:when> <!-- Malayalam (India), #0c --> <xsl:when test="$number-shape-code = 12"> <xsl:attribute name="number:transliteration-language">ml</xsl:attribute> <xsl:attribute name="number:transliteration-country">IN</xsl:attribute> </xsl:when> <!-- Thai, #0d --> <xsl:when test="$number-shape-code = 13"> <xsl:attribute name="number:transliteration-language">th</xsl:attribute> <xsl:attribute name="number:transliteration-country">TH</xsl:attribute> </xsl:when> <!-- Lao, #0e --> <xsl:when test="$number-shape-code = 14"> <xsl:attribute name="number:transliteration-language">lo</xsl:attribute> <xsl:attribute name="number:transliteration-country">LA</xsl:attribute> </xsl:when> <!-- Tibetan (China), #0f --> <xsl:when test="$number-shape-code = 15"> <xsl:attribute name="number:transliteration-language">bo</xsl:attribute> <xsl:attribute name="number:transliteration-country">CN</xsl:attribute> </xsl:when> <!-- Myanmar (Burma), #10 --> <xsl:when test="$number-shape-code = 16"> <xsl:attribute name="number:transliteration-language">my</xsl:attribute> <xsl:attribute name="number:transliteration-country">MM</xsl:attribute> </xsl:when> <!-- Ethiopic (Geez), #11 --> <xsl:when test="$number-shape-code = 17"> <xsl:attribute name="number:transliteration-language">gez</xsl:attribute> <xsl:attribute name="number:transliteration-country">ET</xsl:attribute> </xsl:when> <!-- Khmer (Cambodian), #12--> <xsl:when test="$number-shape-code = 18"> <xsl:attribute name="number:transliteration-language">km</xsl:attribute> <xsl:attribute name="number:transliteration-country">KH</xsl:attribute> </xsl:when> <!-- Mongolian, #13 --> <xsl:when test="$number-shape-code = 19"> <xsl:attribute name="number:transliteration-language">mn</xsl:attribute> <xsl:attribute name="number:transliteration-country">CN</xsl:attribute> </xsl:when> <!-- Japanese 1 ([DBNum1]) , #1b, #0411 --> <xsl:when test="$number-shape-code = 27 or ($number-code-style = '1' and $language-country-code = 1041)"> <xsl:attribute name="number:transliteration-format">一</xsl:attribute> <xsl:attribute name="number:transliteration-language">ja</xsl:attribute> <xsl:attribute name="number:transliteration-country">JP</xsl:attribute> </xsl:when> <!-- Japanese 2 ([DBNum2]) ,#1c, #0411 --> <xsl:when test="$number-shape-code = 28 or ($number-code-style = '2' and $language-country-code = 1041 )"> <xsl:attribute name="number:transliteration-format">壹</xsl:attribute> <xsl:attribute name="number:transliteration-language">ja</xsl:attribute> <xsl:attribute name="number:transliteration-country">JP</xsl:attribute> </xsl:when> <!-- Japanese 3 ([DBNum3]), #1d, #0411 --> <xsl:when test="$number-shape-code = 29 or ($number-code-style = '3' and $language-country-code = 1041 )"> <xsl:attribute name="number:transliteration-format">１</xsl:attribute> <xsl:attribute name="number:transliteration-language">ja</xsl:attribute> <xsl:attribute name="number:transliteration-country">JP</xsl:attribute> </xsl:when> <!-- Simplified Chinese 1 ([DBNum1]), #1e, #0804 --> <xsl:when test="$number-shape-code = 30 or ($number-code-style = '1' and $language-country-code = 2052 )"> <xsl:attribute name="number:transliteration-format">一</xsl:attribute> <xsl:attribute name="number:transliteration-language">zh</xsl:attribute> <xsl:attribute name="number:transliteration-country">CN</xsl:attribute> </xsl:when> <!-- Simplified Chinese 2 ([DBNum2]),#1f,#0804 --> <xsl:when test="$number-shape-code = 31 or ($number-code-style = '2' and $language-country-code = 2052 )"> <xsl:attribute name="number:transliteration-format">壹</xsl:attribute> <xsl:attribute name="number:transliteration-language">zh</xsl:attribute> <xsl:attribute name="number:transliteration-country">CN</xsl:attribute> </xsl:when> <!-- Simplified Chinese 3 ([DBNum3]), #20,#0804 --> <xsl:when test="$number-shape-code = 32 or ($number-code-style = '3' and $language-country-code = 2052 )"> <xsl:attribute name="number:transliteration-format">１</xsl:attribute> <xsl:attribute name="number:transliteration-language">zh</xsl:attribute> <xsl:attribute name="number:transliteration-country">CN</xsl:attribute> </xsl:when> <!-- Traditional Chinese 1 ([DBNum1]), #21, #0404 --> <xsl:when test="$number-shape-code = 33 or ($number-code-style = '1' and $language-country-code = 1028 )"> <xsl:attribute name="number:transliteration-format">一</xsl:attribute> <xsl:attribute name="number:transliteration-language">zh</xsl:attribute> <xsl:attribute name="number:transliteration-country">TW</xsl:attribute> </xsl:when> <!-- Traditional Chinese 2 ([DBNum2]), #22, #0404 --> <xsl:when test="$number-shape-code = 34 or ($number-code-style = '2' and $language-country-code = 1028 )"> <xsl:attribute name="number:transliteration-format">壹</xsl:attribute> <xsl:attribute name="number:transliteration-language">zh</xsl:attribute> <xsl:attribute name="number:transliteration-country">TW</xsl:attribute> </xsl:when> <!-- Traditional Chinese 3 ([DBNum3]),#23, #0404 --> <xsl:when test="$number-shape-code = 35 or ($number-code-style = '3' and $language-country-code = 1028 )"> <xsl:attribute name="number:transliteration-format">１</xsl:attribute> <xsl:attribute name="number:transliteration-language">zh</xsl:attribute> <xsl:attribute name="number:transliteration-country">TW</xsl:attribute> </xsl:when> <!-- Korean 1 ([DBNum1]), #24, #0412 --> <xsl:when test="$number-shape-code = 36 or ($number-code-style = '1' and $language-country-code = 1042 )"> <xsl:attribute name="number:transliteration-format">一</xsl:attribute> <xsl:attribute name="number:transliteration-language">ko</xsl:attribute> <xsl:attribute name="number:transliteration-country">KR</xsl:attribute> </xsl:when> <!-- Korean 2 ([DBNum2]), #25, #0412 --> <xsl:when test="$number-shape-code = 37 or ($number-code-style = '2' and $language-country-code = 1042 )"> <xsl:attribute name="number:transliteration-format">壹</xsl:attribute> <xsl:attribute name="number:transliteration-language">ko</xsl:attribute> <xsl:attribute name="number:transliteration-country">KR</xsl:attribute> </xsl:when> <!-- Korean 3 ([DBNum3]), #26, #0412 --> <xsl:when test="$number-shape-code = 38 or ($number-code-style = '3' and $language-country-code = 1042 )"> <xsl:attribute name="number:transliteration-format">１</xsl:attribute> <xsl:attribute name="number:transliteration-language">ko</xsl:attribute> <xsl:attribute name="number:transliteration-country">KR</xsl:attribute> </xsl:when> <!-- Korean 4 ([DBNum4]), #27, #0412 --> <xsl:when test="$number-shape-code = 39 or ($number-code-style = '4' and $language-country-code = 1042 )"> <xsl:attribute name="number:transliteration-format">1</xsl:attribute> <xsl:attribute name="number:transliteration-language">ko</xsl:attribute> <xsl:attribute name="number:transliteration-country">KR</xsl:attribute> </xsl:when> </xsl:choose> </xsl:if> <!-- components of a format code: two digits for number shape codes, two for calendar types, four for LCID. glu --> <xsl:choose> <!-- totally 223 language-country LCID codes, manually created, among which MS Office 2003 supports 134, OOo supports 91. glu --> <xsl:when test="$language-country-code = 1078"> <!-- Afrikaans - South Africa, #0436 --> <xsl:attribute name="number:language">af</xsl:attribute> <xsl:attribute name="number:country">ZA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1052"> <!-- Albanian - Albania, #041c --> <xsl:attribute name="number:language">sq</xsl:attribute> <xsl:attribute name="number:country">AL</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1118"> <!-- Amharic - Ethiopia, #045e --> <xsl:attribute name="number:language">am</xsl:attribute> <xsl:attribute name="number:country">ET</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1025"> <!-- Arabic - Saudi Arabia, #0401 --> <xsl:attribute name="number:language">ar</xsl:attribute> <xsl:attribute name="number:country">SA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 5121"> <!-- Arabic - Algeria, #1401 --> <xsl:attribute name="number:language">ar</xsl:attribute> <xsl:attribute name="number:country">DZ</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 15361"> <!-- Arabic - Bahrain, #3c01 --> <xsl:attribute name="number:language">ar</xsl:attribute> <xsl:attribute name="number:country">BH</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 3073"> <!-- Arabic - Egypt, #0c01 --> <xsl:attribute name="number:language">ar</xsl:attribute> <xsl:attribute name="number:country">EG</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2049"> <!-- Arabic - Iraq, #0801 --> <xsl:attribute name="number:language">ar</xsl:attribute> <xsl:attribute name="number:country">IQ</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 11265"> <!-- Arabic - Jordan, #2c01 --> <xsl:attribute name="number:language">ar</xsl:attribute> <xsl:attribute name="number:country">JO</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 13313"> <!-- Arabic - Kuwait, #3401 --> <xsl:attribute name="number:language">ar</xsl:attribute> <xsl:attribute name="number:country">KW</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 12289"> <!-- Arabic - Lebanon, #3001 --> <xsl:attribute name="number:language">ar</xsl:attribute> <xsl:attribute name="number:country">LB</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 4097"> <!-- Arabic - Libya, #1001 --> <xsl:attribute name="number:language">ar</xsl:attribute> <xsl:attribute name="number:country">LY</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 6145"> <!-- Arabic - Morocco, #1801 --> <xsl:attribute name="number:language">ar</xsl:attribute> <xsl:attribute name="number:country">MA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 8193"> <!-- Arabic - Oman, #2001 --> <xsl:attribute name="number:language">ar</xsl:attribute> <xsl:attribute name="number:country">OM</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 16385"> <!-- Arabic - Qatar, #4001 --> <xsl:attribute name="number:language">ar</xsl:attribute> <xsl:attribute name="number:country">QA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 10241"> <!-- Arabic - Syria, #2801 --> <xsl:attribute name="number:language">ar</xsl:attribute> <xsl:attribute name="number:country">SY</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 7169"> <!-- Arabic - Tunisia, #1c01 --> <xsl:attribute name="number:language">ar</xsl:attribute> <xsl:attribute name="number:country">TN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 14337"> <!-- Arabic - U.A.E., #3801 --> <xsl:attribute name="number:language">ar</xsl:attribute> <xsl:attribute name="number:country">AE</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 9217"> <!-- Arabic - Yemen, #2401 --> <xsl:attribute name="number:language">ar</xsl:attribute> <xsl:attribute name="number:country">YE</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1067"> <!-- Armenian - Armenia, #042b --> <xsl:attribute name="number:language">hy</xsl:attribute> <xsl:attribute name="number:country">AM</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1101"> <!-- Assamese, #044d --> <xsl:attribute name="number:language">as</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2092"> <!-- Azeri - Cyrillic, #082c --> <xsl:attribute name="number:language">az</xsl:attribute> <xsl:attribute name="number:country">AZ</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1068"> <!-- Azeri - Latin, #042c --> <xsl:attribute name="number:language">az</xsl:attribute> <xsl:attribute name="number:country">AZ</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1069"> <!-- Basque - France/Spain, #042d --> <xsl:attribute name="number:language">eu</xsl:attribute> <xsl:attribute name="number:country">ES</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1059"> <!-- Belarusian - Belarus, #0423 --> <xsl:attribute name="number:language">be</xsl:attribute> <xsl:attribute name="number:country">BY</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1093"> <!-- Bengali (India), #0445 --> <xsl:attribute name="number:language">bn</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2117"> <!-- Bengali (Bangladesh), #0845 --> <xsl:attribute name="number:language">bn</xsl:attribute> <xsl:attribute name="number:country">BD</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 5146"> <!-- Bosnian (Bosnia/Herzegovina), #141a --> <xsl:attribute name="number:language">bs</xsl:attribute> <xsl:attribute name="number:country">BA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1026"> <!-- Bulgarian, #0402 --> <xsl:attribute name="number:language">bg</xsl:attribute> <xsl:attribute name="number:country">BG</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1109"> <!-- Burmese (Burma/Myanmar), #0455 --> <xsl:attribute name="number:language">my</xsl:attribute> <xsl:attribute name="number:country">MM</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1027"> <!-- Catalan - Spain, #0403 --> <xsl:attribute name="number:language">ca</xsl:attribute> <xsl:attribute name="number:country">ES</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1116"> <!-- Cherokee - United States, #045c --> <xsl:attribute name="number:language">chr</xsl:attribute> <xsl:attribute name="number:country">US</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2052"> <!-- Chinese - People's Republic of China, #0804 --> <xsl:attribute name="number:language">zh</xsl:attribute> <xsl:attribute name="number:country">CN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 4100"> <!-- Chinese - Singapore, #1004 --> <xsl:attribute name="number:language">zh</xsl:attribute> <xsl:attribute name="number:country">SG</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1028"> <!-- Chinese - Taiwan, #0404 --> <xsl:attribute name="number:language">zh</xsl:attribute> <xsl:attribute name="number:country">TW</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 3076"> <!-- Chinese - Hong Kong SAR, #0c04 --> <xsl:attribute name="number:language">zh</xsl:attribute> <xsl:attribute name="number:country">HK</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 5124"> <!-- Chinese - Macao SAR, #1404 --> <xsl:attribute name="number:language">zh</xsl:attribute> <xsl:attribute name="number:country">MO</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1050"> <!-- Croatian (Croatia), #041a --> <xsl:attribute name="number:language">hr</xsl:attribute> <xsl:attribute name="number:country">HR</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 4122"> <!-- Croatian (Bosnia/Herzegovina), #101a --> <xsl:attribute name="number:language">hr</xsl:attribute> <xsl:attribute name="number:country">BA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1029"> <!-- Czech, #0405 --> <xsl:attribute name="number:language">cs</xsl:attribute> <xsl:attribute name="number:country">CZ</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1030"> <!-- Danish, #0406 --> <xsl:attribute name="number:language">da</xsl:attribute> <xsl:attribute name="number:country">DK</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1125"> <!-- Divehi, #0465 --> <xsl:attribute name="number:language">dv</xsl:attribute> <xsl:attribute name="number:country">MV</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1043"> <!-- Dutch - Netherlands, #0413 --> <xsl:attribute name="number:language">nl</xsl:attribute> <xsl:attribute name="number:country">NL</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2067"> <!-- Dutch - Belgium, #0813 --> <xsl:attribute name="number:language">nl</xsl:attribute> <xsl:attribute name="number:country">BE</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1126"> <!-- Edo (Bini - Nigeria), #0466 --> <xsl:attribute name="number:language">bin</xsl:attribute> <xsl:attribute name="number:country">NG</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1033"> <!-- English - United States, #0409 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">US</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2057"> <!-- English - United Kingdom, #0809 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">GB</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 3081"> <!-- English - Australia, #0c09 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">AU</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 10249"> <!-- English - Belize, #2809 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">BZ</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 4105"> <!-- English - Canada, #1009 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">CA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 9225"> <!-- English - Caribbean (Cuba), #2409 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">CU</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 15369"> <!-- English - Hong Kong SAR, #3c09 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">HK</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 16393"> <!-- English - India, #4009 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 14345"> <!-- English - Indonesia, #3809 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">ID</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 6153"> <!-- English - Ireland, #1809 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">IE</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 8201"> <!-- English - Jamaica, #2009 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">JM</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 17417"> <!-- English - Malaysia, #4409 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">MY</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 5129"> <!-- English - New Zealand, #1409 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">NZ</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 13321"> <!-- English - Philippines, #3409 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">PH</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 18441"> <!-- English - Singapore, #4809 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">SG</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 7177"> <!-- English - South Africa, #1c09 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">ZA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 11273"> <!-- English - Trinidad, #2c09 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">TT</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 12297"> <!-- English - Zimbabwe, #3009 --> <xsl:attribute name="number:language">en</xsl:attribute> <xsl:attribute name="number:country">ZW</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1061"> <!-- Estonian (Estonia), #0425 --> <xsl:attribute name="number:language">et</xsl:attribute> <xsl:attribute name="number:country">EE</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1080"> <!-- Faroese (Faroe Islands), #0438 --> <xsl:attribute name="number:language">fo</xsl:attribute> <xsl:attribute name="number:country">FO</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1065"> <!-- Farsi (Persian/Iran), #0429 --> <xsl:attribute name="number:language">fa</xsl:attribute> <xsl:attribute name="number:country">IR</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1124"> <!-- Filipino (Philippine), #0464 --> <xsl:attribute name="number:language">phi</xsl:attribute> <xsl:attribute name="number:country">PH</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1035"> <!-- Finnish, #040b --> <xsl:attribute name="number:language">fi</xsl:attribute> <xsl:attribute name="number:country">FI</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1036"> <!-- French - France, #040c --> <xsl:attribute name="number:language">fr</xsl:attribute> <xsl:attribute name="number:country">FR</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2060"> <!-- French - Belgium, #080c --> <xsl:attribute name="number:language">fr</xsl:attribute> <xsl:attribute name="number:country">BE</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 11276"> <!-- French - Cameroon, #2c0c --> <xsl:attribute name="number:language">fr</xsl:attribute> <xsl:attribute name="number:country">CM</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 3084"> <!-- French - Canada, #0c0c --> <xsl:attribute name="number:language">fr</xsl:attribute> <xsl:attribute name="number:country">CA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 9228"> <!-- French - Congo, #240c --> <xsl:attribute name="number:language">fr</xsl:attribute> <xsl:attribute name="number:country">CG</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 12300"> <!-- French - Cote d'Ivoire, #300c --> <xsl:attribute name="number:language">fr</xsl:attribute> <xsl:attribute name="number:country">CI</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 15372"> <!-- French - Haiti, #3c0c --> <xsl:attribute name="number:language">fr</xsl:attribute> <xsl:attribute name="number:country">HT</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 5132"> <!-- French - Luxembourg, #140c --> <xsl:attribute name="number:language">fr</xsl:attribute> <xsl:attribute name="number:country">LU</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 13324"> <!-- French - Mali, #340c --> <xsl:attribute name="number:language">fr</xsl:attribute> <xsl:attribute name="number:country">ML</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 6156"> <!-- French - Monaco, #180c --> <xsl:attribute name="number:language">fr</xsl:attribute> <xsl:attribute name="number:country">MC</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 14348"> <!-- French - Morocco, #380c --> <xsl:attribute name="number:language">fr</xsl:attribute> <xsl:attribute name="number:country">MA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 58380"> <!-- French - North Africa (Algeria), #e40c --> <xsl:attribute name="number:language">fr</xsl:attribute> <xsl:attribute name="number:country">DZ</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 8204"> <!-- French - Reunion, #200c --> <xsl:attribute name="number:language">fr</xsl:attribute> <xsl:attribute name="number:country">RE</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 10252"> <!-- French - Senegal, #280c --> <xsl:attribute name="number:language">fr</xsl:attribute> <xsl:attribute name="number:country">SN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 4108"> <!-- French - Switzerland, #100c --> <xsl:attribute name="number:language">fr</xsl:attribute> <xsl:attribute name="number:country">CH</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1122"> <!-- Frisian - Netherlands, #0462 --> <xsl:attribute name="number:language">fy</xsl:attribute> <xsl:attribute name="number:country">NL</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1127"> <!-- Fulfude (Fulah) - Nigeria, #0467 --> <xsl:attribute name="number:language">ff</xsl:attribute> <xsl:attribute name="number:country">NG</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1071"> <!-- FYRO Macedonian, #042f --> <xsl:attribute name="number:language">mk</xsl:attribute> <xsl:attribute name="number:country">MK</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2108"> <!-- Gaelic (Ireland), #083c --> <xsl:attribute name="number:language">gd</xsl:attribute> <xsl:attribute name="number:country">IE</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1084"> <!-- Gaelic (Scotland), #043c --> <xsl:attribute name="number:language">gd</xsl:attribute> <xsl:attribute name="number:country">GB</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1110"> <!-- Galician (Gallegan) - Spain, #0456 --> <xsl:attribute name="number:language">gl</xsl:attribute> <xsl:attribute name="number:country">ES</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1079"> <!-- Georgian - Georgia, #0437 --> <xsl:attribute name="number:language">ka</xsl:attribute> <xsl:attribute name="number:country">GE</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1031"> <!-- German - Germany, #0407 --> <xsl:attribute name="number:language">de</xsl:attribute> <xsl:attribute name="number:country">DE</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 3079"> <!-- German - Austria, #0c07 --> <xsl:attribute name="number:language">de</xsl:attribute> <xsl:attribute name="number:country">AT</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 5127"> <!-- German - Liechtenstein, #1407 --> <xsl:attribute name="number:language">de</xsl:attribute> <xsl:attribute name="number:country">LI</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 4103"> <!-- German - Luxembourg, #1007 --> <xsl:attribute name="number:language">de</xsl:attribute> <xsl:attribute name="number:country">LU</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2055"> <!-- German - Switzerland, #0807 --> <xsl:attribute name="number:language">de</xsl:attribute> <xsl:attribute name="number:country">CH</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1032"> <!-- Greek, #0408 --> <xsl:attribute name="number:language">el</xsl:attribute> <xsl:attribute name="number:country">GR</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1140"> <!-- Guarani - Paraguay, #0474 --> <xsl:attribute name="number:language">gn</xsl:attribute> <xsl:attribute name="number:country">PY</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1095"> <!-- Gujarati - India, #0447 --> <xsl:attribute name="number:language">gu</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1128"> <!-- Hausa - Nigeria, #0468 --> <xsl:attribute name="number:language">ha</xsl:attribute> <xsl:attribute name="number:country">NG</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1141"> <!-- Hawaiian - US, #0475 --> <xsl:attribute name="number:language">haw</xsl:attribute> <xsl:attribute name="number:country">US</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1037"> <!-- Hebrew, #040d --> <xsl:attribute name="number:language">he</xsl:attribute> <xsl:attribute name="number:country">IL</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1081"> <!-- Hindi (India), #0439 --> <xsl:attribute name="number:language">hi</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1038"> <!-- Hungarian - Hungary, #040e --> <xsl:attribute name="number:language">hu</xsl:attribute> <xsl:attribute name="number:country">HU</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1129"> <!-- Ibibio (Niger-Kordofanian) - Nigeria, #0469 --> <xsl:attribute name="number:language">nic</xsl:attribute> <xsl:attribute name="number:country">NG</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1039"> <!-- Icelandic, #040f --> <xsl:attribute name="number:language">is</xsl:attribute> <xsl:attribute name="number:country">IS</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1136"> <!-- Igbo - Nigeria, #0470 --> <xsl:attribute name="number:language">ig</xsl:attribute> <xsl:attribute name="number:country">NG</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1057"> <!-- Indonesian, #0421 --> <xsl:attribute name="number:language">id</xsl:attribute> <xsl:attribute name="number:country">ID</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1117"> <!-- Inuktitut - US, #045d --> <xsl:attribute name="number:language">iu</xsl:attribute> <xsl:attribute name="number:country">US</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1040"> <!-- Italian - Italy, #0410 --> <xsl:attribute name="number:language">it</xsl:attribute> <xsl:attribute name="number:country">IT</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2064"> <!-- Italian - Switzerland, #0810 --> <xsl:attribute name="number:language">it</xsl:attribute> <xsl:attribute name="number:country">CH</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1041"> <!-- Japanese, #0411 --> <xsl:attribute name="number:language">ja</xsl:attribute> <xsl:attribute name="number:country">JP</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1099"> <!-- Kannada (India), #044b --> <xsl:attribute name="number:language">kn</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1137"> <!-- Kanuri - Nigeria, #0471 --> <xsl:attribute name="number:language">kr</xsl:attribute> <xsl:attribute name="number:country">NG</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2144"> <!-- Kashmiri (India), #0860 --> <xsl:attribute name="number:language">ks</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1120"> <!-- Kashmiri (Arabic), #0460 --> <xsl:attribute name="number:language">ks</xsl:attribute> <xsl:attribute name="number:country">PK</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1087"> <!-- Kazakh, #043f --> <xsl:attribute name="number:language">kk</xsl:attribute> <xsl:attribute name="number:country">KZ</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1107"> <!-- Khmer (Cambodian), #0453 --> <xsl:attribute name="number:language">km</xsl:attribute> <xsl:attribute name="number:country">KH</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1111"> <!-- Konkani (India), #0457 --> <xsl:attribute name="number:language">kok</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1042"> <!-- Korean, #0412 --> <xsl:attribute name="number:language">ko</xsl:attribute> <xsl:attribute name="number:country">KR</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1088"> <!-- Kyrgyz ( Kirgiz / Cyrillic), #0440 --> <xsl:attribute name="number:language">ky</xsl:attribute> <xsl:attribute name="number:country">KG</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1108"> <!-- Lao, #0454 --> <xsl:attribute name="number:language">lo</xsl:attribute> <xsl:attribute name="number:country">LA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1142"> <!-- Latin, #0476 --> <xsl:attribute name="number:language">la</xsl:attribute> <xsl:attribute name="number:country">IT</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1062"> <!-- Latvian, #0426 --> <xsl:attribute name="number:language">lv</xsl:attribute> <xsl:attribute name="number:country">LV</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1063"> <!-- Lithuanian, #0427 --> <xsl:attribute name="number:language">lt</xsl:attribute> <xsl:attribute name="number:country">LT</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1086"> <!-- Malay - Malaysia, #043e --> <xsl:attribute name="number:language">ms</xsl:attribute> <xsl:attribute name="number:country">MY</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2110"> <!-- Malay - Brunei Darussalam, #083e --> <xsl:attribute name="number:language">ms</xsl:attribute> <xsl:attribute name="number:country">BN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1071"> <!-- Macedonian (FYROM), #042f --> <xsl:attribute name="number:language">mk</xsl:attribute> <xsl:attribute name="number:country">MK</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1100"> <!-- Malayalam (India), #044c --> <xsl:attribute name="number:language">ml</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1082"> <!-- Maltese, #043a --> <xsl:attribute name="number:language">mt</xsl:attribute> <xsl:attribute name="number:country">MT</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1112"> <!-- Manipuri (India), #0458 --> <xsl:attribute name="number:language">mni</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1153"> <!-- Maori - New Zealand, #0481 --> <xsl:attribute name="number:language">mi</xsl:attribute> <xsl:attribute name="number:country">NZ</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1102"> <!-- Marathi (India), #044e --> <xsl:attribute name="number:language">mr</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1104"> <!-- Mongolian (Cyrillic), #0450 --> <xsl:attribute name="number:language">mn</xsl:attribute> <xsl:attribute name="number:country">MN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2128"> <!-- Mongolian (Mongolian), #0850 --> <xsl:attribute name="number:language">mn</xsl:attribute> <xsl:attribute name="number:country">CN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1121"> <!-- Nepali, #0461 --> <xsl:attribute name="number:language">ne</xsl:attribute> <xsl:attribute name="number:country">NP</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2145"> <!-- Nepali (India), #0861 --> <xsl:attribute name="number:language">ne</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1044"> <!-- Norwegian (Bokmal), #0414 --> <xsl:attribute name="number:language">nb</xsl:attribute> <xsl:attribute name="number:country">NO</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2068"> <!-- Norwegian (Nynorsk), #0814 --> <xsl:attribute name="number:language">nn</xsl:attribute> <xsl:attribute name="number:country">NO</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1096"> <!-- Oriya (India), #0448 --> <xsl:attribute name="number:language">or</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1138"> <!-- Oromo (Ethiopia), #0472 --> <xsl:attribute name="number:language">om</xsl:attribute> <xsl:attribute name="number:country">ET</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1145"> <!-- Papiamentu (Netherlands Antilles), #0479 --> <xsl:attribute name="number:language">pap</xsl:attribute> <xsl:attribute name="number:country">AN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1123"> <!-- Pashto (Afghanistan), #0463 --> <xsl:attribute name="number:language">ps</xsl:attribute> <xsl:attribute name="number:country">AF</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1045"> <!-- Polish, #0415 --> <xsl:attribute name="number:language">pl</xsl:attribute> <xsl:attribute name="number:country">PL</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1046"> <!-- Portuguese - Brazil, #0416 --> <xsl:attribute name="number:language">pt</xsl:attribute> <xsl:attribute name="number:country">BR</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2070"> <!-- Portuguese - Portugal, #0816 --> <xsl:attribute name="number:language">pt</xsl:attribute> <xsl:attribute name="number:country">PT</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1094"> <!-- Punjabi, #0446 --> <xsl:attribute name="number:language">pa</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2118"> <!-- Punjabi (Pakistan), #0846 --> <xsl:attribute name="number:language">pa</xsl:attribute> <xsl:attribute name="number:country">PK</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1131"> <!-- Quecha - Blivia, #046b --> <xsl:attribute name="number:language">qu</xsl:attribute> <xsl:attribute name="number:country">BO</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2155"> <!-- Quecha - Ecuador, #086b --> <xsl:attribute name="number:language">qu</xsl:attribute> <xsl:attribute name="number:country">EC</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 3179"> <!-- Quecha - peru, #0c6b --> <xsl:attribute name="number:language">qu</xsl:attribute> <xsl:attribute name="number:country">PE</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1047"> <!-- Rhaeto-Romanic (Italy), #0417 --> <xsl:attribute name="number:language">rm</xsl:attribute> <xsl:attribute name="number:country">IT</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1048"> <!-- Romanian, #0418 --> <xsl:attribute name="number:language">ro</xsl:attribute> <xsl:attribute name="number:country">RO</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2072"> <!-- Romanian - Moldova, #0818 --> <xsl:attribute name="number:language">ro</xsl:attribute> <xsl:attribute name="number:country">MD</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1049"> <!-- Russian, #0419 --> <xsl:attribute name="number:language">ru</xsl:attribute> <xsl:attribute name="number:country">RU</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2073"> <!-- Russian - Moldova, #0819 --> <xsl:attribute name="number:language">ru</xsl:attribute> <xsl:attribute name="number:country">MD</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1083"> <!-- Sami (Lappish), # (Northern Sami - Sweden), #043b --> <xsl:attribute name="number:language">se</xsl:attribute> <xsl:attribute name="number:country">SE</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1103"> <!-- Sanskrit (India), #044f --> <xsl:attribute name="number:language">sa</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1132"> <!-- Sepedi (Northern Sotho - South Africa), #046c --> <xsl:attribute name="number:language">nso</xsl:attribute> <xsl:attribute name="number:country">ZA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 3098"> <!-- Serbian (Cyrillic - Serbia Yugoslavia), #0c1a --> <xsl:attribute name="number:language">sr</xsl:attribute> <xsl:attribute name="number:country">YU</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2074"> <!-- Serbian (Latin - Croatia), #081a --> <xsl:attribute name="number:language">sr</xsl:attribute> <xsl:attribute name="number:country">HR</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1113"> <!-- Sindhi - India,#0459 --> <xsl:attribute name="number:language">sd</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2137"> <!-- Sindhi - Pakistan, #0859 --> <xsl:attribute name="number:language">sd</xsl:attribute> <xsl:attribute name="number:country">PK</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1115"> <!-- Sinhalese - Sri Lanka, #045b --> <xsl:attribute name="number:language">si</xsl:attribute> <xsl:attribute name="number:country">LK</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1051"> <!-- Slovak, #041b --> <xsl:attribute name="number:language">sk</xsl:attribute> <xsl:attribute name="number:country">SK</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1060"> <!-- Slovenian, #0424 --> <xsl:attribute name="number:language">sl</xsl:attribute> <xsl:attribute name="number:country">SI</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1143"> <!-- Somali, #0477 --> <xsl:attribute name="number:language">so</xsl:attribute> <xsl:attribute name="number:country">SO</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1070"> <!-- Sorbian, #042e --> <xsl:attribute name="number:language">wen</xsl:attribute> <xsl:attribute name="number:country">DE</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 3082"> <!-- Spanish - Spain (Modern/International Sort), #0c0a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">ES</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1034"> <!-- Spanish - Spain (Traditional Sort), #040a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">ES</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 11274"> <!-- Spanish - Argentina, #2c0a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">AR</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 16394"> <!-- Spanish - Bolivia, #400a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">BO</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 13322"> <!-- Spanish - Chile, #340a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">CL</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 9226"> <!-- Spanish - Colombia, #240a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">CO</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 5130"> <!-- Spanish - Costa Rica, #140a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">CR</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 7178"> <!-- Spanish - Dominican Republic, #1c0a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">DO</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 12298"> <!-- Spanish - Ecuador, #300a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">EC</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 17418"> <!-- Spanish - EL Salvador, #440a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">SV</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 4106"> <!-- Spanish - Guatemala, #100a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">GT</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 18442"> <!-- Spanish - Honduras, #480a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">HN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 58378"> <!-- Spanish - Latin America (Argentina), #e40a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">AR</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2058"> <!-- Spanish - Mexico, #080a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">MX</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 19466"> <!-- Spanish - Nicaragua, #4c0a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">NI</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 6154"> <!-- Spanish - Panama, #180a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">PA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 15370"> <!-- Spanish - Paraguay, #3c0a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">PY</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 10250"> <!-- Spanish - Peru, #280a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">PE</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 20490"> <!-- Spanish - Puerto Rico, #500a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">PR</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 21514"> <!-- Spanish - US, #540a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">US</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 14346"> <!-- Spanish - Uruguay, #380a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">UY</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 8202"> <!-- Spanish - Venezuela, #200a --> <xsl:attribute name="number:language">es</xsl:attribute> <xsl:attribute name="number:country">VE</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1072"> <!-- Sutu (Ngoni - Tanzania), #0430 --> <xsl:attribute name="number:language">bnt</xsl:attribute> <xsl:attribute name="number:country">TZ</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1089"> <!-- Swahili (Tanzania), #0441 --> <xsl:attribute name="number:language">sw</xsl:attribute> <xsl:attribute name="number:country">TZ</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1053"> <!-- Swedish (Sweden), #041d --> <xsl:attribute name="number:language">sv</xsl:attribute> <xsl:attribute name="number:country">SE</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2077"> <!-- Swedish - Finland, #081d --> <xsl:attribute name="number:language">sv</xsl:attribute> <xsl:attribute name="number:country">FI</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1114"> <!-- Syriac (Syria), #045a --> <xsl:attribute name="number:language">syr</xsl:attribute> <xsl:attribute name="number:country">SY</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1064"> <!-- Tajik, #0428 --> <xsl:attribute name="number:language">tg</xsl:attribute> <xsl:attribute name="number:country">TJ</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1119"> <!-- Tamazight (Arabic), #045f --> <xsl:attribute name="number:language">ber</xsl:attribute> <xsl:attribute name="number:country">ML</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2143"> <!-- Tamazight (Latin), #085f --> <xsl:attribute name="number:language">ber</xsl:attribute> <xsl:attribute name="number:country">MA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1097"> <!-- Tamil (India), #0449 --> <xsl:attribute name="number:language">ta</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1092"> <!-- Tatar (Russia), #0444 --> <xsl:attribute name="number:language">tt</xsl:attribute> <xsl:attribute name="number:country">RU</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1098"> <!-- Telugu (India), #044a --> <xsl:attribute name="number:language">te</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1054"> <!-- Thai, #041e --> <xsl:attribute name="number:language">th</xsl:attribute> <xsl:attribute name="number:country">TH</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2129"> <!-- Tibetan - Bhutan, #0851 --> <xsl:attribute name="number:language">bo</xsl:attribute> <xsl:attribute name="number:country">BT</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1105"> <!-- Tibetan - Peoples' Republic of China, #0451 --> <xsl:attribute name="number:language">bo</xsl:attribute> <xsl:attribute name="number:country">CN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2163"> <!-- Tigrigna (Tigrinya) - Eritrea, #0873 --> <xsl:attribute name="number:language">ti</xsl:attribute> <xsl:attribute name="number:country">ER</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1139"> <!-- Tigrigna (Tigrinya) - Ethiopia, #0473 --> <xsl:attribute name="number:language">ti</xsl:attribute> <xsl:attribute name="number:country">ET</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1073"> <!-- Tsonga (South Africa), #0431 --> <xsl:attribute name="number:language">ts</xsl:attribute> <xsl:attribute name="number:country">ZA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1074"> <!-- Tswana (South Africa), #0432 --> <xsl:attribute name="number:language">tn</xsl:attribute> <xsl:attribute name="number:country">ZA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1055"> <!-- Turkish, #041f --> <xsl:attribute name="number:language">tr</xsl:attribute> <xsl:attribute name="number:country">TR</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1090"> <!-- Turkmen, #0442 --> <xsl:attribute name="number:language">tk</xsl:attribute> <xsl:attribute name="number:country">TM</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1152"> <!-- Uighur - China, #0480 --> <xsl:attribute name="number:language">ug</xsl:attribute> <xsl:attribute name="number:country">CN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1058"> <!-- Ukrainian, #0422 --> <xsl:attribute name="number:language">uk</xsl:attribute> <xsl:attribute name="number:country">UA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1056"> <!-- Urdu (Pakistan), #0420 --> <xsl:attribute name="number:language">ur</xsl:attribute> <xsl:attribute name="number:country">PK</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2080"> <!-- Urdu - India, #0820 --> <xsl:attribute name="number:language">ur</xsl:attribute> <xsl:attribute name="number:country">IN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 2115"> <!-- Uzbek (Cyrillic), #0843 --> <xsl:attribute name="number:language">uz</xsl:attribute> <xsl:attribute name="number:country">UZ</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1091"> <!-- Uzbek (Latin), #0443 --> <xsl:attribute name="number:language">uz</xsl:attribute> <xsl:attribute name="number:country">UZ</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1075"> <!-- Venda (South Africa), #0433 --> <xsl:attribute name="number:language">ve</xsl:attribute> <xsl:attribute name="number:country">ZA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1066"> <!-- Vietnamese, #042a --> <xsl:attribute name="number:language">vi</xsl:attribute> <xsl:attribute name="number:country">VN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1106"> <!-- Welsh (UK), #0452 --> <xsl:attribute name="number:language">cy</xsl:attribute> <xsl:attribute name="number:country">UK</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1076"> <!-- Xhosa (South Africa), #0434 --> <xsl:attribute name="number:language">xh</xsl:attribute> <xsl:attribute name="number:country">ZA</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1144"> <!-- Yi (Sino-Tibetan - China), #0478 --> <xsl:attribute name="number:language">sit</xsl:attribute> <xsl:attribute name="number:country">CN</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1085"> <!-- Yiddish (Jews - Israel), #043d --> <xsl:attribute name="number:language">yi</xsl:attribute> <xsl:attribute name="number:country">IL</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1130"> <!-- Yoruba (Nigeria), #046a --> <xsl:attribute name="number:language">yo</xsl:attribute> <xsl:attribute name="number:country">NG</xsl:attribute> </xsl:when> <xsl:when test="$language-country-code = 1077"> <!-- Zulu (South Africa), #0435 --> <xsl:attribute name="number:language">zu</xsl:attribute> <xsl:attribute name="number:country">ZA</xsl:attribute> </xsl:when> </xsl:choose> </xsl:template> <xsl:template name="get-number-format-condition"> <xsl:param name="number-format-unit"/> <xsl:choose> <xsl:when test="contains($number-format-unit, '[>')"> <xsl:value-of select="concat('>', substring-before( substring-after($number-format-unit,'[>'), ']'))"/> </xsl:when> <xsl:when test="contains($number-format-unit, '[<')"> <xsl:value-of select="concat('<', substring-before( substring-after($number-format-unit,'[<'), ']'))"/> </xsl:when> <xsl:when test="contains($number-format-unit, '[=')"> <xsl:value-of select="concat('=', substring-before( substring-after($number-format-unit,'[='), ']'))"/> </xsl:when> <xsl:otherwise/> </xsl:choose> </xsl:template> <xsl:template name="create-number-format-content"> <xsl:param name="number-format-unit"/> <xsl:param name="unit-pos"/> <xsl:variable name="posed-number-format-unit" select="substring($number-format-unit,$unit-pos)"/> <xsl:variable name="calendar-type-name"> <xsl:if test="contains( $number-format-unit, '[$')"> <xsl:variable name="format-code" select="substring-before( substring-after( substring-after( $number-format-unit, '[$'), '-'), ']')"/> <xsl:if test="string-length( $format-code) > 4"> <xsl:call-template name="get-calendar-type-name"> <xsl:with-param name="calendar-type" select="substring( $format-code, string-length($format-code) -5, 2)"/> </xsl:call-template> </xsl:if> </xsl:if> </xsl:variable> <!-- process number-format-unit by character string parser. --> <xsl:choose> <xsl:when test="starts-with( $posed-number-format-unit, '[$') and (not(starts-with($posed-number-format-unit, '[$-') ) )"> <xsl:element name="number:currency-symbol"> <xsl:call-template name="create-language-country-attribute"> <xsl:with-param name="attribute-code" select="substring-before(substring-after(substring-after($posed-number-format-unit,'[$'),'-'),']')"/> </xsl:call-template> <xsl:value-of select="substring-before( substring-after( $posed-number-format-unit, '[$'), '-')"/> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + string-length( substring-before( $posed-number-format-unit, ']') ) + 1"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, '\') or starts-with( $posed-number-format-unit, '*')"> <!-- place '*' temparily here, because now StarCalc doesn't support variable filling character definition. glu --> <number:text> <xsl:value-of select="substring($posed-number-format-unit,2,1)"/> </number:text> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, '_')"> <number:text> <xsl:text> </xsl:text> </number:text> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, '"')"> <xsl:variable name="pre-character-string" select="substring-before(substring($posed-number-format-unit,2), '"')"/> <number:text> <xsl:value-of select="$pre-character-string"/> </number:text> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + string-length($pre-character-string) + 2"/> </xsl:call-template> </xsl:when> <xsl:when test="(starts-with( $posed-number-format-unit, '0') or starts-with( $posed-number-format-unit, '#') or starts-with( $posed-number-format-unit, '?') ) and (not ( contains( $posed-number-format-unit, 's.00') ) )"> <xsl:variable name="valid-number-format-string"> <xsl:call-template name="get-valid-number-format-string"> <xsl:with-param name="number-format-unit" select="$posed-number-format-unit"/> </xsl:call-template> </xsl:variable> <xsl:choose> <xsl:when test="contains( $valid-number-format-string, '/')"> <xsl:element name="number:fraction"> <xsl:attribute name="number:min-integer-digits"><xsl:value-of select="string-length( substring-before($valid-number-format-string, '/') ) - string-length(translate( substring-before($valid-number-format-string, '/'), '0', '') )"/></xsl:attribute> <xsl:if test="contains( $valid-number-format-string, ',')"> <xsl:attribute name="number:grouping">true</xsl:attribute> </xsl:if> <xsl:attribute name="number:min-numerator-digits"><xsl:value-of select="string-length( substring-before($valid-number-format-string, '/') ) - string-length(translate( substring-before($valid-number-format-string,'/'), '?', '') )"/></xsl:attribute> <xsl:attribute name="number:min-denominator-digits"><xsl:value-of select="string-length(substring-after($valid-number-format-string, '/') )"/></xsl:attribute> <!-- deal with number:embedded-text glu --> <xsl:call-template name="create-number-format-embedded-text"> <xsl:with-param name="adapted-number-format-unit" select="$posed-number-format-unit"/> <xsl:with-param name="valid-number-format-string" select="$valid-number-format-string"/> </xsl:call-template> </xsl:element> </xsl:when> <xsl:when test="contains( $valid-number-format-string, '%')"> <xsl:element name="number:number"> <xsl:choose> <xsl:when test="contains( $valid-number-format-string, '.')"> <xsl:attribute name="number:decimal-places"><xsl:value-of select="string-length( substring-before( substring-after( $valid-number-format-string, '.'), '%') ) - string-length( translate( substring-before( substring-after( $valid-number-format-string, '.'), '%'), '0', '') )"/></xsl:attribute> <xsl:attribute name="number:min-integer-digits"><xsl:value-of select="string-length( substring-before($valid-number-format-string, '.') ) - string-length(translate( substring-before($valid-number-format-string, '.'), '0', '') )"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="number:decimal-places">0</xsl:attribute> <xsl:attribute name="number:min-integer-digits"><xsl:value-of select="string-length( substring-before($valid-number-format-string, '%') ) - string-length(translate( substring-before($valid-number-format-string, '%'), '0', '') )"/></xsl:attribute> </xsl:otherwise> </xsl:choose> <xsl:choose> <xsl:when test="contains( $valid-number-format-string, ',') and (not (contains( $valid-number-format-string, ',#') ) )"> <xsl:variable name="display-factor"> <xsl:call-template name="get-display-factor"> <xsl:with-param name="start-number" select="1"/> <xsl:with-param name="thousand-count" select="string-length($valid-number-format-string) - string-length( translate($valid-number-format-string, ',', '') )"/> </xsl:call-template> </xsl:variable> <xsl:attribute name="number:display-factor"><xsl:value-of select="$display-factor"/></xsl:attribute> </xsl:when> <xsl:when test="contains( $valid-number-format-string, ',')"> <xsl:attribute name="number:grouping">true</xsl:attribute> </xsl:when> </xsl:choose> <!-- deal with number:embedded-text glu --> <xsl:call-template name="create-number-format-embedded-text"> <xsl:with-param name="adapted-number-format-unit" select="$posed-number-format-unit"/> <xsl:with-param name="valid-number-format-string" select="$valid-number-format-string"/> </xsl:call-template> </xsl:element> <number:text>%</number:text> </xsl:when> <xsl:when test="contains( $valid-number-format-string, 'E') or contains ($valid-number-format-string, 'e')"> <xsl:element name="number:scientific-number"> <xsl:choose> <xsl:when test="contains( $valid-number-format-string, '.')"> <xsl:attribute name="number:decimal-places"><xsl:value-of select="string-length( substring-before( substring-after( $valid-number-format-string, '.'), 'E') ) - string-length( translate( substring-before( substring-after( $valid-number-format-string, '.'), 'E'), '0', '') )"/></xsl:attribute> <xsl:attribute name="number:min-integer-digits"><xsl:value-of select="string-length( substring-before($valid-number-format-string, '.') ) - string-length(translate( substring-before($valid-number-format-string, '.'), '0', '') )"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="number:decimal-places">0</xsl:attribute> <xsl:attribute name="number:min-integer-digits"><xsl:value-of select="string-length( substring-before($valid-number-format-string, 'E') ) - string-length(translate( substring-before($valid-number-format-string, 'E'), '0', '') )"/></xsl:attribute> </xsl:otherwise> </xsl:choose> <xsl:attribute name="number:min-exponent-digits"><xsl:value-of select="string-length( substring-after( $valid-number-format-string, 'E') ) - string-length( translate( substring-after( $valid-number-format-string, 'E'), '0', '') )"/></xsl:attribute> <!-- deal with number:embedded-text glu --> <xsl:call-template name="create-number-format-embedded-text"> <xsl:with-param name="adapted-number-format-unit" select="$posed-number-format-unit"/> <xsl:with-param name="valid-number-format-string" select="$valid-number-format-string"/> </xsl:call-template> </xsl:element> </xsl:when> <xsl:otherwise> <!-- -normal number format, currency, and accounting, e.g. --> <xsl:element name="number:number"> <xsl:choose> <xsl:when test="contains( $valid-number-format-string, '.')"> <xsl:attribute name="number:decimal-places"><xsl:value-of select="string-length( substring-after( $valid-number-format-string, '.') ) - string-length( translate( substring-after( $valid-number-format-string, '.'), '0', '') )"/></xsl:attribute> <xsl:attribute name="number:min-integer-digits"><xsl:value-of select="string-length( substring-before($valid-number-format-string, '.') ) - string-length(translate( substring-before($valid-number-format-string, '.'), '0', '') )"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="number:decimal-places">0</xsl:attribute> <xsl:attribute name="number:min-integer-digits"><xsl:value-of select="string-length( $valid-number-format-string ) - string-length(translate( $valid-number-format-string, '0', '') )"/></xsl:attribute> </xsl:otherwise> </xsl:choose> <xsl:choose> <xsl:when test="contains( $valid-number-format-string, ',') and (not (contains( $valid-number-format-string, ',#') ) )"> <xsl:variable name="display-factor"> <xsl:call-template name="get-display-factor"> <xsl:with-param name="start-number" select="1"/> <xsl:with-param name="thousand-count" select="string-length($valid-number-format-string) - string-length( translate($valid-number-format-string, ',', '') )"/> </xsl:call-template> </xsl:variable> <xsl:attribute name="number:display-factor"><xsl:value-of select="$display-factor"/></xsl:attribute> </xsl:when> <xsl:when test="contains( $valid-number-format-string, ',')"> <xsl:attribute name="number:grouping">true</xsl:attribute> </xsl:when> </xsl:choose> <!-- deal with number:embedded-text glu --> <xsl:call-template name="create-number-format-embedded-text"> <xsl:with-param name="adapted-number-format-unit" select="$posed-number-format-unit"/> <xsl:with-param name="valid-number-format-string" select="$valid-number-format-string"/> </xsl:call-template> </xsl:element> </xsl:otherwise> </xsl:choose> <!-- deal with post number:text glu --> <xsl:variable name="post-number-format-text"> <xsl:call-template name="get-post-number-format-text"> <xsl:with-param name="adapted-number-format-unit" select="$posed-number-format-unit"/> <xsl:with-param name="valid-number-format-string" select="$valid-number-format-string"/> </xsl:call-template> </xsl:variable> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$post-number-format-text"/> <xsl:with-param name="unit-pos" select="1"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'ggg')"> <xsl:element name="number:era"> <xsl:attribute name="number:style">long</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 3"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'gg')"> <xsl:element name="number:era"> <xsl:attribute name="number:style">long</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'g')"> <xsl:element name="number:era"> <xsl:attribute name="number:style">short</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 1"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'ee')"> <xsl:element name="number:year"> <xsl:attribute name="number:style">long</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'r')"> <xsl:element name="number:year"> <xsl:attribute name="number:style">long</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 1"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'yyyy')"> <xsl:element name="number:year"> <xsl:attribute name="number:style">long</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 4"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'yy')"> <xsl:element name="number:year"> <xsl:attribute name="number:style">short</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'e') or starts-with( $posed-number-format-unit, 'y')"> <xsl:element name="number:year"> <xsl:attribute name="number:style">short</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 1"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'mmmmm')"> <xsl:element name="number:month"> <xsl:attribute name="number:style">short</xsl:attribute> <xsl:attribute name="number:textual">true</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 5"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'mmmm')"> <xsl:element name="number:month"> <xsl:attribute name="number:style">long</xsl:attribute> <xsl:attribute name="number:textual">true</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 4"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'mmm')"> <xsl:element name="number:month"> <xsl:attribute name="number:style">short</xsl:attribute> <xsl:attribute name="number:textual">true</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 3"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, '[mm]')"> <xsl:element name="number:minutes"> <xsl:attribute name="number:style">long</xsl:attribute> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 4"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, '[m]')"> <xsl:element name="number:minutes"> <xsl:attribute name="number:style">short</xsl:attribute> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 3"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'mm') and ( contains( $number-format-unit, 'h') or contains( $posed-number-format-unit, 's') )"> <xsl:element name="number:minutes"> <xsl:attribute name="number:style">long</xsl:attribute> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'mm')"> <xsl:element name="number:month"> <xsl:attribute name="number:style">long</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'm') and ( contains( $number-format-unit, 'h') or contains( $posed-number-format-unit, 's') )"> <xsl:element name="number:minutes"> <xsl:attribute name="number:style">short</xsl:attribute> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 1"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'm')"> <xsl:element name="number:month"> <xsl:attribute name="number:style">short</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 1"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'dddd') or starts-with( $posed-number-format-unit, 'aaaa')"> <xsl:element name="number:day-of-week"> <xsl:attribute name="number:style">long</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 4"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'ddd') or starts-with( $posed-number-format-unit, 'aaa')"> <xsl:element name="number:day-of-week"> <xsl:attribute name="number:style">short</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 3"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'dd')"> <xsl:element name="number:day"> <xsl:attribute name="number:style">long</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'd')"> <xsl:element name="number:day"> <xsl:attribute name="number:style">short</xsl:attribute> <xsl:if test="string-length($calendar-type-name) > 0"> <xsl:attribute name="number:calendar"><xsl:value-of select="$calendar-type-name"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 1"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'hh')"> <xsl:element name="number:hours"> <xsl:attribute name="number:style">long</xsl:attribute> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, '[hh]')"> <xsl:element name="number:hours"> <xsl:attribute name="number:style">long</xsl:attribute> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 4"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'h')"> <xsl:element name="number:hours"> <xsl:attribute name="number:style">short</xsl:attribute> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 1"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, '[h]')"> <xsl:element name="number:hours"> <xsl:attribute name="number:style">short</xsl:attribute> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 3"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'AM/PM') or starts-with( $posed-number-format-unit, 'am/pm')"> <number:am-pm/> <!-- long: am-pm doesn't support long style yet. glu --> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 5"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'a/p'or starts-with( $posed-number-format-unit, 'A/P'))"> <number:am-pm/> <!-- short: am-pm doesn't support short style yet. glu --> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 3"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 'ss')"> <xsl:variable name="decimal-places"> <xsl:choose> <xsl:when test="starts-with( $posed-number-format-unit, 'ss.0')"> <xsl:value-of select="string-length( $posed-number-format-unit) - string-length( translate( $posed-number-format-unit, '0', '') )"/> </xsl:when> <xsl:otherwise>0</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:element name="number:seconds"> <xsl:attribute name="number:style">long</xsl:attribute> <xsl:if test="$decimal-places > 0"> <xsl:attribute name="number:decimal-places"><xsl:value-of select="$decimal-places"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:variable name="second-length"> <xsl:choose> <xsl:when test="$decimal-places > 0"> <xsl:value-of select="$decimal-places + 3"/> </xsl:when> <xsl:otherwise>2</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + $second-length"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, '[ss]')"> <xsl:element name="number:seconds"> <xsl:attribute name="number:style">long</xsl:attribute> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 4"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, 's')"> <xsl:variable name="decimal-places"> <xsl:choose> <xsl:when test="starts-with( $posed-number-format-unit, 's.0')"> <xsl:value-of select="string-length( $posed-number-format-unit) - string-length( translate( $posed-number-format-unit, '0', '') )"/> </xsl:when> <xsl:otherwise>0</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:element name="number:seconds"> <xsl:attribute name="number:style">short</xsl:attribute> <xsl:if test="$decimal-places > 0"> <xsl:attribute name="number:decimal-places"><xsl:value-of select="$decimal-places"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:variable name="second-length"> <xsl:choose> <xsl:when test="$decimal-places > 0"> <xsl:value-of select="$decimal-places + 2"/> </xsl:when> <xsl:otherwise>1</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + $second-length"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, '[s]')"> <xsl:element name="number:seconds"> <xsl:attribute name="number:style">short</xsl:attribute> </xsl:element> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 3"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, '@')"> <number:text-content/> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 1"/> </xsl:call-template> </xsl:when> <!-- old numer-format-unit processing parser, to be deserted. glu --> <xsl:when test="$posed-number-format-unit = 'General' or $posed-number-format-unit = 'General Number'"> <number:number number:decimal-places="0" number:min-integer-digits="1"/> </xsl:when> <xsl:when test="$posed-number-format-unit = 'Fixed'"> <number:number number:decimal-places="2" number:min-integer-digits="1"/> <number:text/> </xsl:when> <xsl:when test="$posed-number-format-unit = 'Standard'"> <number:number number:decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> </xsl:when> <xsl:when test="$posed-number-format-unit = 'General Date'"> <number:year number:style="long"/> <number:text>-</number:text> <number:month number:style="short"/> <number:text>-</number:text> <number:day number:style="short"/> <number:text> <xsl:text> </xsl:text> </number:text> <number:hours number:style="short"/> <number:text>:</number:text> <number:minutes number:style="long"/> </xsl:when> <xsl:when test="$posed-number-format-unit = 'Long Date'"> <number:year number:style="long"/> <number:text>-</number:text> <number:month number:style="long"/> <number:text>-</number:text> <number:day number:style="long"/> </xsl:when> <xsl:when test="$posed-number-format-unit = 'Medium Date'"> <number:day number:style="short"/> <number:text>-</number:text> <number:month number:textual="true"/> <number:text>-</number:text> <number:year number:style="short"/> </xsl:when> <xsl:when test="$posed-number-format-unit = 'Short Date'"> <number:day number:style="short"/> <number:text>-</number:text> <number:month number:style="short"/> <number:text>-</number:text> <number:year number:style="short"/> </xsl:when> <xsl:when test="$posed-number-format-unit = 'Long Time'"> <number:hours number:style="long"/> <number:text>:</number:text> <number:minutes number:style="long"/> <number:text>:</number:text> <number:seconds number:style="long"/> <number:text> <xsl:text> </xsl:text> </number:text> <number:am-pm/> </xsl:when> <xsl:when test="$posed-number-format-unit = 'Medium Time'"> <number:hours number:style="short"/> <number:text>:</number:text> <number:minutes number:style="long"/> <number:text> <xsl:text> </xsl:text> </number:text> <number:am-pm/> </xsl:when> <xsl:when test="$posed-number-format-unit = 'Short Time'"> <number:hours number:style="short"/> <number:text>:</number:text> <number:minutes number:style="long"/> <number:text> <xsl:text> </xsl:text> </number:text> </xsl:when> <xsl:when test="$posed-number-format-unit = 'Percent'"> <number:number number:decimal-places="2" number:min-integer-digits="1"/> <number:text>%</number:text> </xsl:when> <xsl:when test="$posed-number-format-unit = 'Scientific'"> <number:scientific-number number:decimal-places="2" number:min-integer-digits="1" number:min-exponent-digits="2"/> </xsl:when> <xsl:when test="starts-with( $posed-number-format-unit, '[')"> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + string-length( substring-before( $posed-number-format-unit, ']') ) + 1"/> </xsl:call-template> </xsl:when> <xsl:when test="string-length( $posed-number-format-unit ) > 0"> <number:text> <xsl:value-of select="substring( $posed-number-format-unit, 1, 1)"/> </number:text> <xsl:call-template name="create-number-format-content"> <xsl:with-param name="number-format-unit" select="$number-format-unit"/> <xsl:with-param name="unit-pos" select="$unit-pos + 1"/> </xsl:call-template> </xsl:when> </xsl:choose> </xsl:template> <xsl:template name="get-calendar-type-name"> <xsl:param name="calendar-type"/> <xsl:variable name="temp-type"> <xsl:call-template name="hex2decimal"> <xsl:with-param name="hex-number" select="$calendar-type"/> <xsl:with-param name="index" select="1"/> <xsl:with-param name="str-length" select="string-length($calendar-type)"/> <xsl:with-param name="last-value" select="0"/> </xsl:call-template> </xsl:variable> <xsl:choose> <!-- Japanese (Emperor era), #03 --> <xsl:when test="$temp-type = 3">gengou</xsl:when> <!-- Taiwanese, #04 --> <xsl:when test="$temp-type = 4">ROC</xsl:when> <!-- Korean (Tangun era) hanja_yoil is ok too. #05. glu --> <xsl:when test="$temp-type = 5">hanja</xsl:when> <!-- Hijri (Arabic lunar), #06 --> <xsl:when test="$temp-type = 6">hijri</xsl:when> <!-- Thai, #07 --> <xsl:when test="$temp-type = 7">buddhist</xsl:when> <!-- 01: Gregorian (Localized), 02: Gregorian (United States), 09: Gregorian (Middle East French), 0A: Gregorian (Arabic), 0B: Gregorian (Transliterated English) --> <xsl:otherwise>gregorian</xsl:otherwise> <!-- not found jewish yet. glu --> </xsl:choose> </xsl:template> <xsl:template name="get-valid-number-format-string"> <xsl:param name="number-format-unit"/> <xsl:choose> <xsl:when test="contains( $number-format-unit, '\')"> <xsl:call-template name="get-valid-number-format-string"> <xsl:with-param name="number-format-unit" select="concat( substring-before( $number-format-unit, '\'), substring( substring-after( $number-format-unit, '\'), 2) )"/> </xsl:call-template> </xsl:when> <xsl:when test="contains( $number-format-unit, '*')"> <xsl:call-template name="get-valid-number-format-string"> <xsl:with-param name="number-format-unit" select="concat( substring-before( $number-format-unit, '*'), substring( substring-after( $number-format-unit, '*'), 2) )"/> </xsl:call-template> </xsl:when> <xsl:when test="contains( $number-format-unit, '_')"> <xsl:call-template name="get-valid-number-format-string"> <xsl:with-param name="number-format-unit" select="concat( substring-before( $number-format-unit, '_'), substring( substring-after( $number-format-unit, '_'), 2) )"/> </xsl:call-template> </xsl:when> <xsl:when test="contains( $number-format-unit, '"')"> <xsl:call-template name="get-valid-number-format-string"> <xsl:with-param name="number-format-unit" select="concat( substring-before( $number-format-unit, '"'), substring-after( substring-after( $number-format-unit, '"'), '"') )"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:value-of select="$number-format-unit"/> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="get-display-factor"> <xsl:param name="start-number"/> <xsl:param name="thousand-count"/> <xsl:choose> <xsl:when test="$thousand-count = 0"> <xsl:value-of select="$start-number"/> </xsl:when> <xsl:otherwise> <xsl:call-template name="get-display-factor"> <xsl:with-param name="start-number" select="$start-number * 1000"/> <xsl:with-param name="thousand-count" select="$thousand-count -1"/> </xsl:call-template> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="get-post-number-format-text"> <xsl:param name="adapted-number-format-unit"/> <xsl:param name="valid-number-format-string"/> <xsl:variable name="first-embedded-character-pos"> <xsl:choose> <xsl:when test="contains( $adapted-number-format-unit, '\')"> <xsl:value-of select="string-length( substring-before($adapted-number-format-unit, '\') ) + 1"/> </xsl:when> <xsl:when test="contains( $adapted-number-format-unit, '_')"> <xsl:value-of select="string-length( substring-before($adapted-number-format-unit, '_') ) + 1"/> </xsl:when> <xsl:when test="contains( $adapted-number-format-unit, '*')"> <xsl:value-of select="string-length( substring-before($adapted-number-format-unit, '*') ) + 1"/> </xsl:when> <xsl:otherwise>0</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="first-embedded-string-pos"> <xsl:choose> <xsl:when test="contains( $adapted-number-format-unit, '"')"> <xsl:value-of select="string-length( substring-before($adapted-number-format-unit, '"') ) + 1"/> </xsl:when> <xsl:otherwise>0</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="first-embedded-text-pos"> <xsl:choose> <xsl:when test="$first-embedded-character-pos < $first-embedded-string-pos and $first-embedded-character-pos > 0"> <xsl:value-of select="$first-embedded-character-pos"/> </xsl:when> <xsl:when test="$first-embedded-character-pos < $first-embedded-string-pos and $first-embedded-character-pos = 0"> <xsl:value-of select="$first-embedded-string-pos"/> </xsl:when> <xsl:when test="$first-embedded-character-pos > $first-embedded-string-pos and $first-embedded-string-pos > 0"> <xsl:value-of select="$first-embedded-string-pos"/> </xsl:when> <xsl:when test="$first-embedded-character-pos > $first-embedded-string-pos and $first-embedded-string-pos = 0"> <xsl:value-of select="$first-embedded-character-pos"/> </xsl:when> </xsl:choose> </xsl:variable> <xsl:choose> <xsl:when test="$first-embedded-text-pos > string-length( $valid-number-format-string )"> <xsl:value-of select="substring( $adapted-number-format-unit, $first-embedded-text-pos)"/> </xsl:when> <xsl:when test="$first-embedded-text-pos > 0 and $first-embedded-text-pos < string-length( $valid-number-format-string )"> <xsl:choose> <xsl:when test="starts-with( substring( $adapted-number-format-unit, $first-embedded-text-pos, 1), '\')"> <xsl:call-template name="get-post-number-format-text"> <xsl:with-param name="adapted-number-format-unit" select="concat( substring-before( $adapted-number-format-unit, '\'), substring( $adapted-number-format-unit, $first-embedded-text-pos + 2) )"/> <xsl:with-param name="valid-number-format-string" select="$valid-number-format-string"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( substring( $adapted-number-format-unit, $first-embedded-text-pos, 1), '_')"> <xsl:call-template name="get-post-number-format-text"> <xsl:with-param name="adapted-number-format-unit" select="concat( substring-before( $adapted-number-format-unit, '_'), substring( $adapted-number-format-unit, $first-embedded-text-pos + 2) )"/> <xsl:with-param name="valid-number-format-string" select="$valid-number-format-string"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( substring( $adapted-number-format-unit, $first-embedded-text-pos, 1), '*')"> <xsl:call-template name="get-post-number-format-text"> <xsl:with-param name="adapted-number-format-unit" select="concat( substring-before( $adapted-number-format-unit, '*'), substring( $adapted-number-format-unit, $first-embedded-text-pos + 2) )"/> <xsl:with-param name="valid-number-format-string" select="$valid-number-format-string"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( substring( $adapted-number-format-unit, $first-embedded-text-pos, 1), '"')"> <xsl:call-template name="get-post-number-format-text"> <xsl:with-param name="adapted-number-format-unit" select="concat( substring-before( $adapted-number-format-unit, '"'), substring-after( substring-after( $adapted-number-format-unit, '"'), '"') )"/> <xsl:with-param name="valid-number-format-string" select="$valid-number-format-string"/> </xsl:call-template> </xsl:when> </xsl:choose> </xsl:when> <xsl:otherwise/> </xsl:choose> </xsl:template> <xsl:template name="create-number-format-embedded-text"> <xsl:param name="adapted-number-format-unit"/> <xsl:param name="valid-number-format-string"/> <xsl:variable name="first-embedded-character-pos"> <xsl:choose> <xsl:when test="contains( $adapted-number-format-unit, '\')"> <xsl:value-of select="string-length( substring-before($adapted-number-format-unit, '\') ) + 1"/> </xsl:when> <xsl:when test="contains( $adapted-number-format-unit, '_')"> <xsl:value-of select="string-length( substring-before($adapted-number-format-unit, '_') ) + 1"/> </xsl:when> <xsl:when test="contains( $adapted-number-format-unit, '*')"> <xsl:value-of select="string-length( substring-before($adapted-number-format-unit, '*') ) + 1"/> </xsl:when> <xsl:otherwise>0</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="first-embedded-string-pos"> <xsl:choose> <xsl:when test="contains( $adapted-number-format-unit, '"')"> <xsl:value-of select="string-length( substring-before($adapted-number-format-unit, '"') ) + 1"/> </xsl:when> <xsl:otherwise>0</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="first-embedded-text-pos"> <xsl:choose> <xsl:when test="$first-embedded-character-pos < $first-embedded-string-pos and $first-embedded-character-pos > 0"> <xsl:value-of select="$first-embedded-character-pos"/> </xsl:when> <xsl:when test="$first-embedded-character-pos < $first-embedded-string-pos and $first-embedded-character-pos = 0"> <xsl:value-of select="$first-embedded-string-pos"/> </xsl:when> <xsl:when test="$first-embedded-character-pos > $first-embedded-string-pos and $first-embedded-string-pos > 0"> <xsl:value-of select="$first-embedded-string-pos"/> </xsl:when> <xsl:when test="$first-embedded-character-pos > $first-embedded-string-pos and $first-embedded-string-pos = 0"> <xsl:value-of select="$first-embedded-character-pos"/> </xsl:when> </xsl:choose> </xsl:variable> <xsl:if test="$first-embedded-text-pos > 0 and $first-embedded-text-pos < string-length( $valid-number-format-string )"> <xsl:variable name="text-pos"> <xsl:choose> <xsl:when test="contains( $valid-number-format-string, '.')"> <xsl:variable name="right-text-pos" select="substring( substring-before( $valid-number-format-string, '.'), $first-embedded-text-pos)"/> <xsl:value-of select="string-length($right-text-pos) - string-length( translate( $right-text-pos, '0#?', '') )"/> </xsl:when> <xsl:when test="contains( $valid-number-format-string, '/')"> <xsl:variable name="right-text-pos" select="substring( substring-before( $valid-number-format-string, '/'), $first-embedded-text-pos)"/> <xsl:value-of select="string-length($right-text-pos) - string-length( translate( $right-text-pos, '0#?', '') )"/> </xsl:when> <xsl:when test="contains( $valid-number-format-string, '%')"> <xsl:variable name="right-text-pos" select="substring( substring-before( $valid-number-format-string, '%'), $first-embedded-text-pos)"/> <xsl:value-of select="string-length($right-text-pos) - string-length( translate( $right-text-pos, '0#?', '') )"/> </xsl:when> <xsl:when test="contains( $valid-number-format-string, 'E')"> <xsl:variable name="right-text-pos" select="substring( substring-before( $valid-number-format-string, 'E'), $first-embedded-text-pos)"/> <xsl:value-of select="string-length($right-text-pos) - string-length( translate( $right-text-pos, '0#?', '') )"/> </xsl:when> <xsl:otherwise> <xsl:variable name="right-text-pos" select="substring( $valid-number-format-string, $first-embedded-text-pos)"/> <xsl:value-of select="string-length($right-text-pos) - string-length( translate( $right-text-pos, '0#?', '') )"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:choose> <xsl:when test="starts-with( substring( $adapted-number-format-unit, $first-embedded-text-pos, 1), '\')"> <number:embedded-text number:position="{$text-pos}"> <xsl:value-of select="substring( $adapted-number-format-unit, $first-embedded-text-pos + 1, 1)"/> </number:embedded-text> <xsl:call-template name="create-number-format-embedded-text"> <xsl:with-param name="adapted-number-format-unit" select="concat( substring-before( $adapted-number-format-unit, '\'), substring( $adapted-number-format-unit, $first-embedded-text-pos + 2) )"/> <xsl:with-param name="valid-number-format-string" select="$valid-number-format-string"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( substring( $adapted-number-format-unit, $first-embedded-text-pos, 1), '_')"> <number:embedded-text number:position="{$text-pos}"> <xsl:value-of select="substring( $adapted-number-format-unit, $first-embedded-text-pos + 1, 1)"/> </number:embedded-text> <xsl:call-template name="create-number-format-embedded-text"> <xsl:with-param name="adapted-number-format-unit" select="concat( substring-before( $adapted-number-format-unit, '_'), substring( $adapted-number-format-unit, $first-embedded-text-pos + 2) )"/> <xsl:with-param name="valid-number-format-string" select="$valid-number-format-string"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( substring( $adapted-number-format-unit, $first-embedded-text-pos, 1), '*')"> <number:embedded-text number:position="{$text-pos}"> <xsl:value-of select="substring( $adapted-number-format-unit, $first-embedded-text-pos + 1, 1)"/> </number:embedded-text> <xsl:call-template name="create-number-format-embedded-text"> <xsl:with-param name="adapted-number-format-unit" select="concat( substring-before( $adapted-number-format-unit, '*'), substring( $adapted-number-format-unit, $first-embedded-text-pos + 2) )"/> <xsl:with-param name="valid-number-format-string" select="$valid-number-format-string"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with( substring( $adapted-number-format-unit, $first-embedded-text-pos, 1), '"')"> <number:embedded-text number:position="{$text-pos}"> <xsl:value-of select="substring-before( substring( $adapted-number-format-unit, $first-embedded-text-pos + 1), '"')"/> </number:embedded-text> <xsl:call-template name="create-number-format-embedded-text"> <xsl:with-param name="adapted-number-format-unit" select="concat( substring-before( $adapted-number-format-unit, '"'), substring-after( substring-after( $adapted-number-format-unit, '"'), '"') )"/> <xsl:with-param name="valid-number-format-string" select="$valid-number-format-string"/> </xsl:call-template> </xsl:when> </xsl:choose> </xsl:if> </xsl:template> <xsl:template name="create-master-styles"> <xsl:param name="worksheetoptions"/> <xsl:for-each select="$worksheetoptions"> <xsl:element name="style:master-page"> <xsl:attribute name="style:name"><xsl:value-of select="concat( 'TAB_', ../@ss:Name)"/></xsl:attribute> <xsl:attribute name="style:page-master-name"><xsl:value-of select="concat( 'pm_', ../@ss:Name)"/></xsl:attribute> <xsl:choose> <xsl:when test="x:PageSetup/x:Header/@x:Data"> <style:header> <xsl:call-template name="translate-header-footer"> <xsl:with-param name="content" select="x:PageSetup/x:Header/@x:Data"/> <xsl:with-param name="style-name-header" select="concat(../@ss:Name, substring(name(x:PageSetup/x:Header),1,1))"/> </xsl:call-template> </style:header> </xsl:when> <xsl:otherwise> <style:header style:display="false"/> </xsl:otherwise> </xsl:choose> <xsl:choose> <xsl:when test="x:PageSetup/x:Footer/@x:Data"> <style:footer> <xsl:call-template name="translate-header-footer"> <xsl:with-param name="content" select="x:PageSetup/x:Footer/@x:Data"/> <xsl:with-param name="style-name-header" select="concat(../@ss:Name, substring(name(x:PageSetup/x:Footer),1,1))"/> </xsl:call-template> </style:footer> </xsl:when> <xsl:otherwise> <style:footer style:display="false"/> </xsl:otherwise> </xsl:choose> </xsl:element> </xsl:for-each> </xsl:template> <xsl:template name="translate-header-footer"> <xsl:param name="content"/> <xsl:param name="style-name-header"/> <style:region-left> <text:p> <xsl:variable name="left-content"> <xsl:call-template name="get-pos-content"> <xsl:with-param name="content" select="$content"/> <xsl:with-param name="pos" select="'left'"/> </xsl:call-template> </xsl:variable> <xsl:call-template name="locate-header-footer-data"> <xsl:with-param name="header-footer-data" select="$left-content"/> <xsl:with-param name="style-name-header" select="concat($style-name-header,'L')"/> <xsl:with-param name="index" select="0"/> <xsl:with-param name="current-pos" select="1"/> </xsl:call-template> </text:p> </style:region-left> <style:region-center> <text:p> <xsl:variable name="center-content"> <xsl:call-template name="get-pos-content"> <xsl:with-param name="content" select="$content"/> <xsl:with-param name="pos" select="'center'"/> </xsl:call-template> </xsl:variable> <xsl:call-template name="locate-header-footer-data"> <xsl:with-param name="header-footer-data" select="$center-content"/> <xsl:with-param name="style-name-header" select="concat($style-name-header,'C')"/> <xsl:with-param name="index" select="0"/> <xsl:with-param name="current-pos" select="1"/> </xsl:call-template> </text:p> </style:region-center> <style:region-right> <text:p> <xsl:variable name="right-content"> <xsl:call-template name="get-pos-content"> <xsl:with-param name="content" select="$content"/> <xsl:with-param name="pos" select="'right'"/> </xsl:call-template> </xsl:variable> <xsl:call-template name="locate-header-footer-data"> <xsl:with-param name="header-footer-data" select="$right-content"/> <xsl:with-param name="style-name-header" select="concat($style-name-header,'R')"/> <xsl:with-param name="index" select="0"/> <xsl:with-param name="current-pos" select="1"/> </xsl:call-template> </text:p> </style:region-right> </xsl:template> <xsl:template name="locate-header-footer-data"> <xsl:param name="header-footer-data"/> <xsl:param name="style-name-header"/> <xsl:param name="index"/> <xsl:param name="current-pos"/> <xsl:variable name="current-style-data"> <xsl:value-of select="substring($header-footer-data,$current-pos)"/> </xsl:variable> <xsl:choose> <xsl:when test="starts-with($current-style-data,'&X') or starts-with($current-style-data,'&Y') or starts-with($current-style-data,'&S') or starts-with($current-style-data,'&U') or starts-with($current-style-data,'&E') or starts-with($current-style-data,'&B')"> <xsl:call-template name="locate-header-footer-data"> <xsl:with-param name="header-footer-data" select="$header-footer-data"/> <xsl:with-param name="style-name-header" select="$style-name-header"/> <xsl:with-param name="index" select="$index"/> <xsl:with-param name="current-pos" select="$current-pos+2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with($current-style-data,'&0') or starts-with($current-style-data,'&1') or starts-with($current-style-data,'&2') or starts-with($current-style-data,'&3') or starts-with($current-style-data,'&4') or starts-with($current-style-data,'&5') or starts-with($current-style-data,'&6') or starts-with($current-style-data,'&7') or starts-with($current-style-data,'&8') or starts-with($current-style-data,'&9')"> <xsl:variable name="font-size-length"> <xsl:call-template name="get-digit-length"> <xsl:with-param name="complexive-string" select="substring-after($current-style-data,'&')"/> </xsl:call-template> </xsl:variable> <xsl:call-template name="locate-header-footer-data"> <xsl:with-param name="header-footer-data" select="$header-footer-data"/> <xsl:with-param name="style-name-header" select="$style-name-header"/> <xsl:with-param name="index" select="$index"/> <xsl:with-param name="current-pos" select="$current-pos+1+$font-size-length"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with($current-style-data,'&"')"> <xsl:call-template name="locate-header-footer-data"> <xsl:with-param name="header-footer-data" select="$header-footer-data"/> <xsl:with-param name="style-name-header" select="$style-name-header"/> <xsl:with-param name="index" select="$index"/> <xsl:with-param name="current-pos" select="string-length(substring-before(substring($header-footer-data,$current-pos+2),'"'))+$current-pos+3"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:variable name="current-content-last-pos"> <xsl:call-template name="get-current-content-last-pos"> <xsl:with-param name="style-data" select="$header-footer-data"/> <xsl:with-param name="current-pos" select="$current-pos"/> </xsl:call-template> </xsl:variable> <xsl:choose> <xsl:when test="$current-pos > 1"> <text:span text:style-name="{concat($style-name-header,$index)}"> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring($header-footer-data,$current-pos,$current-content-last-pos+1-$current-pos)"/> </xsl:call-template> </text:span> <xsl:if test="$current-content-last-pos < string-length($header-footer-data)"> <xsl:call-template name="locate-header-footer-data"> <xsl:with-param name="header-footer-data" select="$header-footer-data"/> <xsl:with-param name="style-name-header" select="$style-name-header"/> <xsl:with-param name="index" select="$index+1"/> <xsl:with-param name="current-pos" select="$current-content-last-pos+1"/> </xsl:call-template> </xsl:if> </xsl:when> <xsl:otherwise> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring($header-footer-data,$current-pos,$current-content-last-pos+1-$current-pos)"/> </xsl:call-template> <xsl:if test="$current-content-last-pos < string-length($header-footer-data)"> <xsl:call-template name="locate-header-footer-data"> <xsl:with-param name="header-footer-data" select="$header-footer-data"/> <xsl:with-param name="style-name-header" select="$style-name-header"/> <xsl:with-param name="index" select="$index"/> <xsl:with-param name="current-pos" select="$current-content-last-pos+1"/> </xsl:call-template> </xsl:if> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="get-current-content-last-pos"> <xsl:param name="style-data"/> <xsl:param name="current-pos"/> <xsl:variable name="current-style-data"> <xsl:value-of select="substring($style-data,$current-pos)"/> </xsl:variable> <xsl:choose> <xsl:when test="starts-with($current-style-data,'&"') or starts-with($current-style-data,'&X') or starts-with($current-style-data,'&Y') or starts-with($current-style-data,'&S') or starts-with($current-style-data,'&U') or starts-with($current-style-data,'&E') or starts-with($current-style-data,'&B')or starts-with($current-style-data,'&0') or starts-with($current-style-data,'&1') or starts-with($current-style-data,'&2') or starts-with($current-style-data,'&3') or starts-with($current-style-data,'&4') or starts-with($current-style-data,'&5') or starts-with($current-style-data,'&6') or starts-with($current-style-data,'&7') or starts-with($current-style-data,'&8') or starts-with($current-style-data,'&9')"> <xsl:value-of select="$current-pos - 1"/> </xsl:when> <xsl:when test="contains($current-style-data,'&"') or contains($current-style-data,'&X') or contains($current-style-data,'&Y') or contains($current-style-data,'&S') or contains($current-style-data,'&U') or contains($current-style-data,'&E') or contains($current-style-data,'&B')or contains($current-style-data,'&0') or contains($current-style-data,'&1') or contains($current-style-data,'&2') or contains($current-style-data,'&3') or contains($current-style-data,'&4') or contains($current-style-data,'&5') or contains($current-style-data,'&6') or contains($current-style-data,'&7') or contains($current-style-data,'&8') or contains($current-style-data,'&9')"> <xsl:variable name="temp" select="substring-before(substring($current-style-data,2),'&')"/> <xsl:variable name="next-amp-pos"> <xsl:value-of select="$current-pos+string-length($temp)+1"/> </xsl:variable> <xsl:call-template name="get-current-content-last-pos"> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="current-pos" select="$next-amp-pos"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:value-of select="string-length($style-data)"/> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="translate-header-footer-data"> <xsl:param name="header-footer-data"/> <xsl:choose> <xsl:when test="contains( $header-footer-data, '&D')"> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring-before( $header-footer-data, '&D')"/> </xsl:call-template> <text:date/> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring-after( $header-footer-data, '&D')"/> </xsl:call-template> </xsl:when> <xsl:when test="contains( $header-footer-data, '&T')"> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring-before( $header-footer-data, '&T')"/> </xsl:call-template> <text:time/> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring-after( $header-footer-data, '&T')"/> </xsl:call-template> </xsl:when> <xsl:when test="contains( $header-footer-data, '&P')"> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring-before( $header-footer-data, '&P')"/> </xsl:call-template> <text:page-number/> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring-after( $header-footer-data, '&P')"/> </xsl:call-template> </xsl:when> <xsl:when test="contains( $header-footer-data, '&N')"> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring-before( $header-footer-data, '&N')"/> </xsl:call-template> <text:page-count/> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring-after( $header-footer-data, '&N')"/> </xsl:call-template> </xsl:when> <xsl:when test="contains( $header-footer-data, '&A')"> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring-before( $header-footer-data, '&A')"/> </xsl:call-template> <text:sheet-name/> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring-after( $header-footer-data, '&A')"/> </xsl:call-template> </xsl:when> <xsl:when test="contains( $header-footer-data, '&Z&F')"> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring-before( $header-footer-data, '&Z&F')"/> </xsl:call-template> <text:file-name text:display="full"/> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring-after( $header-footer-data, '&Z&F')"/> </xsl:call-template> </xsl:when> <xsl:when test="contains( $header-footer-data, '&Z')"> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring-before( $header-footer-data, '&Z')"/> </xsl:call-template> <text:file-name text:display="path"/> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring-after( $header-footer-data, '&Z')"/> </xsl:call-template> </xsl:when> <xsl:when test="contains( $header-footer-data, '&F')"> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring-before( $header-footer-data, '&F')"/> </xsl:call-template> <text:file-name text:display="name"/> <xsl:call-template name="translate-header-footer-data"> <xsl:with-param name="header-footer-data" select="substring-after( $header-footer-data, '&F')"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:value-of select="$header-footer-data"/> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="create-page-master"> <xsl:param name="worksheetoptions"/> <xsl:for-each select="$worksheetoptions"> <xsl:element name="style:page-master"> <xsl:attribute name="style:name"><xsl:value-of select="concat( 'pm_', ../@ss:Name)"/></xsl:attribute> <xsl:element name="style:properties"> <xsl:choose> <xsl:when test="x:PageSetup/x:Layout/@x:Orientation = 'Landscape'"> <xsl:attribute name="style:print-orientation">landscape</xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="style:print-orientation">portrait</xsl:attribute> </xsl:otherwise> </xsl:choose> <xsl:choose> <xsl:when test="x:PageSetup/x:Layout/@x:StartPageNumber"> <xsl:attribute name="style:first-page-number"><xsl:value-of select="x:PageSetup/x:Layout/@x:StartPageNumber"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="style:first-page-number">continue</xsl:attribute> </xsl:otherwise> </xsl:choose> <xsl:if test="x:PageSetup/x:PageMargins"> <xsl:attribute name="fo:margin-top"><xsl:value-of select="format-number( x:PageSetup/x:PageMargins/@x:Top * 2.54, '0.###cm')"/></xsl:attribute> <xsl:attribute name="fo:margin-bottom"><xsl:value-of select="format-number( x:PageSetup/x:PageMargins/@x:Bottom * 2.54, '0.###cm')"/></xsl:attribute> <xsl:attribute name="fo:margin-left"><xsl:value-of select="format-number( x:PageSetup/x:PageMargins/@x:Left * 2.54, '0.###cm')"/></xsl:attribute> <xsl:attribute name="fo:margin-right"><xsl:value-of select="format-number( x:PageSetup/x:PageMargins/@x:Right * 2.54, '0.###cm')"/></xsl:attribute> </xsl:if> </xsl:element> <xsl:if test="x:PageSetup/x:Header"> <style:header-style> <xsl:element name="style:properties"> <xsl:attribute name="fo:min-height">0.75cm</xsl:attribute> <xsl:choose> <xsl:when test="x:PageSetup/x:Header/@x:Margin"> <xsl:attribute name="fo:margin-bottom"><xsl:value-of select="format-number( x:PageSetup/x:Header/@x:Margin * 2.54, '0.###cm')"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="fo:margin-bottom">0.25cm</xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:element> </style:header-style> </xsl:if> <xsl:if test="x:PageSetup/x:Footer"> <style:footer-style> <xsl:element name="style:properties"> <xsl:attribute name="fo:min-height">0.75cm</xsl:attribute> <xsl:choose> <xsl:when test="x:PageSetup/x:Footer/@x:Margin"> <xsl:attribute name="fo:margin-top"><xsl:value-of select="format-number( x:PageSetup/x:Footer/@x:Margin * 2.54, '0.###cm')"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="fo:margin-top">0.25cm</xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:element> </style:footer-style> </xsl:if> </xsl:element> </xsl:for-each> </xsl:template> <xsl:template match="ss:Style"> <xsl:element name="style:style"> <xsl:attribute name="style:name"><xsl:value-of select="@ss:ID"/></xsl:attribute> <!-- @ss:Name is optional, so just ust ss:ID as the default name. glu --> <xsl:attribute name="style:family">table-cell</xsl:attribute> <xsl:choose> <xsl:when test="@ss:Parent"> <xsl:attribute name="style:parent-style-name"><xsl:value-of select="@ss:Parent"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="style:parent-style-name">Default</xsl:attribute> </xsl:otherwise> </xsl:choose> <xsl:if test="ss:NumberFormat/@ss:Format"> <xsl:attribute name="style:data-style-name"><xsl:value-of select="concat( @ss:ID, 'F')"/></xsl:attribute> </xsl:if> <xsl:element name="style:properties"> <xsl:if test="ss:Alignment"> <xsl:if test="ss:Alignment/@ss:Horizontal"> <xsl:variable name="text-align"> <xsl:choose> <xsl:when test="ss:Alignment/@ss:Horizontal = 'Left'">start</xsl:when> <xsl:when test="ss:Alignment/@ss:Horizontal = 'Center'">center</xsl:when> <xsl:when test="ss:Alignment/@ss:Horizontal = 'Right'">end</xsl:when> <xsl:when test="ss:Alignment/@ss:Horizontal = 'Justify'">justify</xsl:when> <!-- many other text-align not supported yet. glu --> <xsl:otherwise>start</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:attribute name="fo:text-align"><xsl:value-of select="$text-align"/></xsl:attribute> <xsl:attribute name="style:text-align-source">fix</xsl:attribute> </xsl:if> <xsl:if test="ss:Alignment/@ss:Vertical"> <xsl:variable name="vertical-align"> <xsl:choose> <xsl:when test="ss:Alignment/@ss:Vertical = 'Top'">top</xsl:when> <xsl:when test="ss:Alignment/@ss:Vertical = 'Center'">middle</xsl:when> <xsl:when test="ss:Alignment/@ss:Vertical = 'Bottom'">bottom</xsl:when> <xsl:when test="ss:Alignment/@ss:Vertical = 'Automatic'">middle</xsl:when> <!-- actually for vertical writen characters, not supported by StarOffice/OpenOffice now yet. glu --> <xsl:otherwise>middle</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:attribute name="fo:vertical-align"><xsl:value-of select="$vertical-align"/></xsl:attribute> </xsl:if> <xsl:if test="ss:Alignment/@ss:WrapText = '1'"> <xsl:attribute name="fo:wrap-option">wrap</xsl:attribute> </xsl:if> <xsl:if test="ss:Alignment/@ss:Indent"> <xsl:attribute name="fo:margin-left"><xsl:value-of select="concat( floor( ss:Alignment/@ss:Indent div 2.834 * 1000) div 1000, 'cm')"/></xsl:attribute> </xsl:if> <xsl:if test="ss:Alignment/@ss:Rotate"> <xsl:attribute name="style:rotation-angle"><xsl:value-of select="ss:Alignment/@ss:Rotate"/></xsl:attribute> <xsl:attribute name="style:rotation-align">none</xsl:attribute> </xsl:if> <xsl:if test="ss:Alignment/@ss:VerticalText = '1'"> <xsl:attribute name="fo:direction">ttb</xsl:attribute> </xsl:if> </xsl:if> <xsl:if test="ss:Borders"> <xsl:if test="ss:Borders/ss:Border"> <xsl:apply-templates select="ss:Borders/ss:Border"/> </xsl:if> </xsl:if> <xsl:if test="ss:Font"> <xsl:choose> <xsl:when test="ss:Font/@ss:FontName"> <xsl:attribute name="style:font-name"><xsl:value-of select="ss:Font/@ss:FontName"/></xsl:attribute> <xsl:attribute name="style:font-name-asian"><xsl:value-of select="ss:Font/@ss:FontName"/></xsl:attribute> <xsl:attribute name="style:font-name-complex"><xsl:value-of select="ss:Font/@ss:FontName"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="style:font-name">Arial</xsl:attribute> </xsl:otherwise> </xsl:choose> <!-- "ss:Font/@x:Family" is useless here, so can't map to "fo:font-family" attribute. glu --> <xsl:if test="ss:Font/@ss:Bold = '1'"> <xsl:attribute name="fo:font-weight">bold</xsl:attribute> <xsl:attribute name="style:font-weight-asian">bold</xsl:attribute> <xsl:attribute name="style:font-weight-complex">bold</xsl:attribute> </xsl:if> <xsl:choose> <xsl:when test="ss:Font/@ss:Color"> <xsl:attribute name="fo:color"><xsl:value-of select="ss:Font/@ss:Color"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="style:use-window-font-color">true</xsl:attribute> </xsl:otherwise> </xsl:choose> <xsl:if test="ss:Font/@ss:Italic = '1'"> <!-- omit font-style oblique. glu --> <xsl:attribute name="fo:font-style">italic</xsl:attribute> <xsl:attribute name="style:font-style-asian">italic</xsl:attribute> <xsl:attribute name="style:font-style-complex">italic</xsl:attribute> </xsl:if> <xsl:choose> <xsl:when test="ss:Font/@ss:Size"> <xsl:attribute name="fo:font-size"><xsl:value-of select="concat( ss:Font/@ss:Size, 'pt')"/></xsl:attribute> <xsl:attribute name="style:font-size-asian"><xsl:value-of select="concat( ss:Font/@ss:Size, 'pt')"/></xsl:attribute> <xsl:attribute name="style:font-size-complex"><xsl:value-of select="concat( ss:Font/@ss:Size, 'pt')"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="fo:font-size">10pt</xsl:attribute> <xsl:attribute name="style:font-size-asian">10pt</xsl:attribute> <xsl:attribute name="style:font-size-complex">10pt</xsl:attribute> </xsl:otherwise> </xsl:choose> <xsl:if test="ss:Font/@ss:Outline = '1'"> <xsl:attribute name="style:text-outline">true</xsl:attribute> </xsl:if> <xsl:if test="ss:Font/@ss:Shadow = '1'"> <xsl:attribute name="style:text-shadow">shadow</xsl:attribute> <xsl:attribute name="fo:text-shadow">1pt 1pt</xsl:attribute> </xsl:if> <xsl:if test="ss:Font/@ss:StrikeThrough = '1'"> <xsl:attribute name="style:text-crossing-out">single-line</xsl:attribute> </xsl:if> <xsl:if test="ss:Font/@ss:Underline"> <xsl:choose> <xsl:when test="ss:Font/@ss:Underline = 'None'"> <xsl:attribute name="style:text-underline">none</xsl:attribute> </xsl:when> <xsl:when test="ss:Font/@ss:Underline = 'Single'"> <xsl:attribute name="style:text-underline">single</xsl:attribute> </xsl:when> <xsl:when test="ss:Font/@ss:Underline = 'Double'"> <xsl:attribute name="style:text-underline">double</xsl:attribute> </xsl:when> <xsl:when test="ss:Font/@ss:Underline = 'SingleAccounting'"> <xsl:attribute name="style:text-underline">single</xsl:attribute>"</xsl:when> <xsl:when test="ss:Font/@ss:Underline = 'DoubleAccounting'"> <xsl:attribute name="style:text-underline">double</xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="style:text-underline">none</xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:if> <xsl:if test="ss:Font/@x:Charset"> <!-- quite unclear till now, glu --> <xsl:attribute name="style:font-charset">x-symbol</xsl:attribute> </xsl:if> </xsl:if> <xsl:if test="ss:Interior"> <xsl:choose> <xsl:when test="ss:Interior/@ss:Pattern = 'Solid'"> <xsl:if test="ss:Interior/@ss:Color"> <xsl:attribute name="fo:background-color"><xsl:value-of select="ss:Interior/@ss:Color"/></xsl:attribute> </xsl:if> </xsl:when> <xsl:otherwise> <xsl:if test="ss:Interior/@ss:PatternColor"> <!--2003.7.15,tom chen,invoke some method in Java,the name space declare at the top. removed for other parsers. :( --> <xsl:variable name="pattern-value"> <xsl:call-template name="cell-pattern-color"> <xsl:with-param name="pattern" select="concat('0.',substring-after(./ss:Interior/@ss:Pattern,'y'))"/> <xsl:with-param name="color-value" select="./ss:Interior/@ss:Color"/> <xsl:with-param name="pattern-color-value" select="./ss:Interior/@ss:PatternColor"/> </xsl:call-template> </xsl:variable> <xsl:attribute name="fo:background-color"><xsl:value-of select="$pattern-value"/></xsl:attribute> </xsl:if> </xsl:otherwise> </xsl:choose> </xsl:if> <xsl:if test="ss:Protection"> <xsl:choose> <xsl:when test="ss:Protection/@ss:Protected = '0'"> <xsl:choose> <xsl:when test="ss:Protection/@ss:HideFormula = '1'"> <xsl:attribute name="style:cell-protect">hidden-and-protected</xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="style:cell-protect">none</xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="ss:Protection/@x:HideFormula = '1'"> <xsl:attribute name="style:cell-protect">protected formula-hidden</xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="style:cell-protect">none</xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:if> </xsl:element> </xsl:element> </xsl:template> <xsl:template name="cell-pattern-color"> <!-- generates a new color from cell-pattern-color.tom chen --> <xsl:param name="pattern"/> <xsl:param name="color-value"/> <xsl:param name="pattern-color-value"/> <xsl:variable name="rev-pattern" select="1 - $pattern"/> <xsl:variable name="color-R-value"> <xsl:call-template name="hex2decimal"> <xsl:with-param name="hex-number" select="substring($color-value,2,2)"/> <xsl:with-param name="index" select="1"/> <xsl:with-param name="str-length" select="2"/> <xsl:with-param name="last-value" select="0"/> </xsl:call-template> </xsl:variable> <xsl:variable name="color-G-value"> <xsl:call-template name="hex2decimal"> <xsl:with-param name="hex-number" select="substring($color-value,4,2)"/> <xsl:with-param name="index" select="1"/> <xsl:with-param name="str-length" select="2"/> <xsl:with-param name="last-value" select="0"/> </xsl:call-template> </xsl:variable> <xsl:variable name="color-B-value"> <xsl:call-template name="hex2decimal"> <xsl:with-param name="hex-number" select="substring($color-value,6,2)"/> <xsl:with-param name="index" select="1"/> <xsl:with-param name="str-length" select="2"/> <xsl:with-param name="last-value" select="0"/> </xsl:call-template> </xsl:variable> <xsl:variable name="pattern-R-value"> <xsl:call-template name="hex2decimal"> <xsl:with-param name="hex-number" select="substring($pattern-color-value,2,2)"/> <xsl:with-param name="index" select="1"/> <xsl:with-param name="str-length" select="2"/> <xsl:with-param name="last-value" select="0"/> </xsl:call-template> </xsl:variable> <xsl:variable name="pattern-G-value"> <xsl:call-template name="hex2decimal"> <xsl:with-param name="hex-number" select="substring($pattern-color-value,4,2)"/> <xsl:with-param name="index" select="1"/> <xsl:with-param name="str-length" select="2"/> <xsl:with-param name="last-value" select="0"/> </xsl:call-template> </xsl:variable> <xsl:variable name="pattern-B-value"> <xsl:call-template name="hex2decimal"> <xsl:with-param name="hex-number" select="substring($pattern-color-value,6,2)"/> <xsl:with-param name="index" select="1"/> <xsl:with-param name="str-length" select="2"/> <xsl:with-param name="last-value" select="0"/> </xsl:call-template> </xsl:variable> <xsl:variable name="R-value"> <xsl:variable name="combined-R-value"> <xsl:call-template name="decimal2hex"> <xsl:with-param name="dec-number" select="floor($color-R-value * $rev-pattern + $pattern-R-value * $pattern)"/> <xsl:with-param name="last-value" select="'H'"/> </xsl:call-template> </xsl:variable> <xsl:choose> <xsl:when test="string-length($combined-R-value) = 1"> <xsl:value-of select="concat('0',$combined-R-value)"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$combined-R-value"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="G-value"> <xsl:variable name="combined-G-value"> <xsl:call-template name="decimal2hex"> <xsl:with-param name="dec-number" select="floor($color-G-value * $rev-pattern + $pattern-G-value * $pattern)"/> <xsl:with-param name="last-value" select="'H'"/> </xsl:call-template> </xsl:variable> <xsl:choose> <xsl:when test="string-length($combined-G-value) = 1"> <xsl:value-of select="concat('0',$combined-G-value)"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$combined-G-value"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="B-value"> <xsl:variable name="combined-B-value"> <xsl:call-template name="decimal2hex"> <xsl:with-param name="dec-number" select="floor($color-B-value * $rev-pattern + $pattern-B-value * $pattern)"/> <xsl:with-param name="last-value" select="'H'"/> </xsl:call-template> </xsl:variable> <xsl:choose> <xsl:when test="string-length($combined-B-value) = 1"> <xsl:value-of select="concat('0',$combined-B-value)"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$combined-B-value"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:value-of select="concat('#',$R-value,$G-value,$B-value)"/> </xsl:template> <xsl:template name="hex2decimal"> <!-- transforms a hex number to a decimal number.parses the string from left to right.tom chen --> <xsl:param name="hex-number"/> <xsl:param name="index"/> <xsl:param name="str-length"/> <xsl:param name="last-value"/> <xsl:variable name="dec-char"> <xsl:call-template name="hexNumber2dec"> <xsl:with-param name="hex-value" select="substring($hex-number, $index ,1)"/> </xsl:call-template> </xsl:variable> <xsl:variable name="current-value" select="$last-value * 16 + $dec-char"/> <xsl:if test="$index < $str-length"> <xsl:call-template name="hex2decimal"> <xsl:with-param name="hex-number" select="$hex-number"/> <xsl:with-param name="index" select="$index + 1"/> <xsl:with-param name="str-length" select="$str-length"/> <xsl:with-param name="last-value" select="$current-value"/> </xsl:call-template> </xsl:if> <xsl:if test="$index = $str-length"> <xsl:value-of select="$current-value"/> </xsl:if> </xsl:template> <xsl:template name="hexNumber2dec"> <!-- return a decimal number for a hex character.tom chen --> <xsl:param name="hex-value"/> <xsl:choose> <xsl:when test="$hex-value = 'A' or ($hex-value = 'a')"> <xsl:value-of select="10"/> </xsl:when> <xsl:when test="$hex-value = 'B' or ($hex-value = 'b')"> <xsl:value-of select="11"/> </xsl:when> <xsl:when test="$hex-value = 'C' or ($hex-value = 'c')"> <xsl:value-of select="12"/> </xsl:when> <xsl:when test="$hex-value = 'D' or ($hex-value = 'd')"> <xsl:value-of select="13"/> </xsl:when> <xsl:when test="$hex-value = 'E' or ($hex-value = 'e')"> <xsl:value-of select="14"/> </xsl:when> <xsl:when test="$hex-value = 'F' or ($hex-value = 'f')"> <xsl:value-of select="15"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$hex-value"/> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="decimal2hex"> <!-- transforms a decimal number to a hex number,only for two-bit hex(less than 256 in decimal) currently.tom chen --> <xsl:param name="dec-number"/> <xsl:param name="last-value"/> <xsl:variable name="current-value"> <xsl:call-template name="decNumber2hex"> <xsl:with-param name="dec-value"> <xsl:if test="$dec-number > 15"> <xsl:value-of select="floor($dec-number div 16)"/> </xsl:if> <xsl:if test="$dec-number < 16"> <xsl:value-of select="$dec-number"/> </xsl:if> </xsl:with-param> </xsl:call-template> </xsl:variable> <xsl:if test="$dec-number > 15"> <xsl:call-template name="decimal2hex"> <xsl:with-param name="dec-number" select="$dec-number mod 16"/> <xsl:with-param name="last-value" select="concat($last-value,$current-value)"/> </xsl:call-template> </xsl:if> <xsl:if test="$dec-number < 16"> <xsl:value-of select="substring-after(concat($last-value,$current-value),'H')"/> </xsl:if> </xsl:template> <xsl:template name="decNumber2hex"> <!-- return a hex number for a decimal character.tom chen --> <xsl:param name="dec-value"/> <xsl:choose> <xsl:when test="$dec-value = 10"> <xsl:value-of select="'A'"/> </xsl:when> <xsl:when test="$dec-value = 11"> <xsl:value-of select="'B'"/> </xsl:when> <xsl:when test="$dec-value = 12"> <xsl:value-of select="'C'"/> </xsl:when> <xsl:when test="$dec-value = 13"> <xsl:value-of select="'D'"/> </xsl:when> <xsl:when test="$dec-value = 14"> <xsl:value-of select="'E'"/> </xsl:when> <xsl:when test="$dec-value = 15"> <xsl:value-of select="'F'"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$dec-value"/> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template match="ss:Border"> <xsl:variable name="position"> <xsl:choose> <xsl:when test="@ss:Position = 'Top'">fo:border-top</xsl:when> <xsl:when test="@ss:Position = 'Bottom'">fo:border-bottom</xsl:when> <xsl:when test="@ss:Position = 'Left'">fo:border-left</xsl:when> <xsl:when test="@ss:Position = 'Right'">fo:border-right</xsl:when> <!-- DiagonalLeft & DiagonalRight are not supported yet, glu --> <xsl:otherwise>fo:border-left</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="width"> <xsl:choose> <!-- 0: Hairline --> <xsl:when test="@ss:Weight = '0'">0.002cm</xsl:when> <!-- 1: Thin --> <xsl:when test="@ss:Weight = '1'">0.035cm</xsl:when> <!-- 2: Medium --> <xsl:when test="@ss:Weight = '2'">0.088cm</xsl:when> <!-- 3: Thick --> <xsl:when test="@ss:Weight = '3'"> <xsl:choose> <xsl:when test="@ss:LineStyle = 'Double'">0.105cm</xsl:when> <xsl:otherwise>0.141cm</xsl:otherwise> </xsl:choose> </xsl:when> <!-- invalid value, or parameter not exist at all. glu --> <xsl:otherwise>0.002cm</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="linestyle"> <xsl:choose> <xsl:when test="@ss:LineStyle = 'None'">none</xsl:when> <xsl:when test="@ss:LineStyle = 'Continuous'">solid</xsl:when> <xsl:when test="@ss:LineStyle = 'Double'">double</xsl:when> <!-- Dash, Dot, DashDot, DashDotDot, SlantDashDot are not supported yet. glu --> <xsl:otherwise>solid</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="color"> <xsl:choose> <xsl:when test="@ss:Color"> <xsl:value-of select="@ss:Color"/> </xsl:when> <!-- default border color is black --> <xsl:otherwise>#000000</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:attribute name="{$position}"><xsl:value-of select="concat( $width, ' ', $linestyle, ' ', $color)"/></xsl:attribute> <xsl:if test="@ss:LineStyle = 'Double'"> <xsl:variable name="widthposition"> <xsl:choose> <xsl:when test="@ss:Position = 'Top'">style:border-line-width-top</xsl:when> <xsl:when test="@ss:Position = 'Bottom'">style:border-line-width-bottom</xsl:when> <xsl:when test="@ss:Position = 'Left'">style:border-line-width-left</xsl:when> <xsl:when test="@ss:Position = 'Right'">style:border-line-width-right</xsl:when> </xsl:choose> </xsl:variable> <xsl:attribute name="{$widthposition}">0.035cm 0.035cm 0.035cm</xsl:attribute> </xsl:if> </xsl:template> <xsl:template match="ss:Font"> <xsl:choose> <xsl:when test="@ss:VerticalAlign = 'Superscript'"> <style:style style:name="{concat(../@ss:ID,'T0')}" style:family="text"> <style:properties style:text-position="33% 58%"/> </style:style> </xsl:when> <xsl:when test="@ss:VerticalAlign = 'Subscript'"> <style:style style:name="{concat(../@ss:ID,'T0')}" style:family="text"> <style:properties style:text-position="-33% 58%"/> </style:style> </xsl:when> <xsl:otherwise/> </xsl:choose> </xsl:template> <xsl:template match="ss:Table"> <xsl:variable name="table-pos"> <xsl:value-of select="count(../preceding-sibling::ss:Worksheet)+1"/> </xsl:variable> <xsl:variable name="default-column-width"> <xsl:choose> <xsl:when test="@ss:DefaultColumnWidth"> <xsl:value-of select="concat( floor(@ss:DefaultColumnWidth div 25.76 * 1000) div 1000, 'cm')"/> </xsl:when> <xsl:otherwise>2.096cm</xsl:otherwise> </xsl:choose> </xsl:variable> <style:style style:family="table-column" style:name="{concat('co', $table-pos)}"> <style:properties style:column-width="{$default-column-width}"/> </style:style> <xsl:choose> <xsl:when test="ss:Column"> <xsl:call-template name="get-column-style-name"> <xsl:with-param name="lastcolumnpos" select="0"/> <xsl:with-param name="column-count" select="count(./ss:Column)"/> <xsl:with-param name="current-count" select="1"/> <xsl:with-param name="table-pos" select="$table-pos"/> <xsl:with-param name="default-column-width" select="$default-column-width"/> </xsl:call-template> </xsl:when> </xsl:choose> <xsl:if test="../x:PageBreaks/x:ColBreaks"> <style:style style:name="{concat('cob',$table-pos)}" style:family="table-column"> <xsl:element name="style:properties"> <xsl:attribute name="style:column-width"><xsl:value-of select="$default-column-width"/></xsl:attribute> <xsl:attribute name="fo:break-before">page</xsl:attribute> </xsl:element> </style:style> </xsl:if> <xsl:variable name="default-row-width"> <xsl:choose> <xsl:when test="@ss:DefaultRowHeight"> <xsl:value-of select="concat( floor(@ss:DefaultRowHeight div 28.34 * 1000) div 1000, 'cm')"/> </xsl:when> <xsl:otherwise>0.503cm</xsl:otherwise> </xsl:choose> </xsl:variable> <style:style style:family="table-row" style:name="{concat('ro', $table-pos)}"> <style:properties style:row-height="{$default-row-width}" style:use-optimal-row-height="false"/> </style:style> <xsl:choose> <xsl:when test="ss:Row"> <xsl:call-template name="get-row-style-name"> <xsl:with-param name="lastrowpos" select="0"/> <xsl:with-param name="row-count" select="count(./ss:Row)"/> <xsl:with-param name="current-count" select="1"/> <xsl:with-param name="table-pos" select="$table-pos"/> <xsl:with-param name="default-row-width" select="$default-row-width"/> </xsl:call-template> </xsl:when> </xsl:choose> <xsl:if test="../x:PageBreaks/x:RowBreaks"> <style:style style:name="{concat('rob',$table-pos)}" style:family="table-row"> <xsl:element name="style:properties"> <xsl:attribute name="style:row-height"><xsl:value-of select="$default-row-width"/></xsl:attribute> <xsl:attribute name="style:use-optimal-row-height">false</xsl:attribute> <xsl:attribute name="fo:break-before">page</xsl:attribute> </xsl:element> </style:style> </xsl:if> <!-- create table-style. glu --> <xsl:element name="style:style"> <xsl:attribute name="style:name"><xsl:value-of select="concat( 'ta', $table-pos)"/></xsl:attribute> <xsl:attribute name="style:family">table</xsl:attribute> <xsl:attribute name="style:master-page-name"><xsl:value-of select="concat( 'TAB_', ../@ss:Name)"/></xsl:attribute> <xsl:element name="style:properties"> <xsl:choose> <xsl:when test="../x:WorksheetOptions/x:Visible = 'SheetHidden'"> <xsl:attribute name="table:display">false</xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="table:display">true</xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:element> </xsl:element> </xsl:template> <xsl:template name="get-column-style-name"> <!-- generate stylename of colbreak after matching the column number and the colbreak number.tom chen --> <xsl:param name="lastcolumnpos"/> <xsl:param name="column-count"/> <xsl:param name="current-count"/> <xsl:param name="table-pos"/> <xsl:param name="default-column-width"/> <xsl:if test="$current-count < ($column-count + 1)"> <xsl:variable name="span-value"> <xsl:choose> <xsl:when test="./ss:Column[position() = $current-count]/@ss:Span"> <xsl:value-of select="./ss:Column[position() = $current-count]/@ss:Span + 1"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="0"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="current-index"> <xsl:choose> <xsl:when test="./ss:Column[position() = $current-count]/@ss:Index"> <xsl:value-of select="./ss:Column[position() = $current-count]/@ss:Index - 1"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$lastcolumnpos"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="column-break"> <xsl:choose> <xsl:when test="$span-value = 0"> <xsl:if test="../x:PageBreaks/x:ColBreaks/x:ColBreak/x:Column = $current-index"> <xsl:value-of select="1"/> </xsl:if> </xsl:when> <xsl:otherwise> <xsl:if test="../x:PageBreaks/x:ColBreaks[(x:ColBreak/x:Column > $lastcolumnpos) and (x:ColBreak/x:Column < ($lastcolumnpos + $span-value))]"> <xsl:value-of select="1"/> </xsl:if> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:if test="$column-break = 1"> <style:style style:name="{concat('cob', $table-pos, '-',$current-count)}" style:family="table-column"> <xsl:element name="style:properties"> <xsl:choose> <xsl:when test="./ss:Column[position() = $current-count]/@ss:Width"> <xsl:attribute name="style:column-width"><xsl:value-of select="concat( floor(./ss:Column[position() = $current-count]/@ss:Width div 25.76 * 1000) div 1000, 'cm')"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="style:column-width"><xsl:value-of select="$default-column-width"/></xsl:attribute> </xsl:otherwise> </xsl:choose> <xsl:choose> <xsl:when test="./ss:Column[position() = $current-count]/@ss:AutoFitWidth = '0'"> <xsl:attribute name="style:use-optimal-column-width">false</xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="./ss:Column[position() = $current-count]/@ss:Width > 0"> <xsl:attribute name="style:use-optimal-column-width">false</xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="style:use-optimal-column-width">true</xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> <xsl:attribute name="fo:break-before">page</xsl:attribute> </xsl:element> </style:style> </xsl:if> <style:style style:name="{concat('co', $table-pos, '-',$current-count)}" style:family="table-column"> <xsl:element name="style:properties"> <xsl:choose> <xsl:when test="./ss:Column[position() = $current-count]/@ss:Width"> <xsl:attribute name="style:column-width"><xsl:value-of select="concat( floor(./ss:Column[position() = $current-count]/@ss:Width div 25.76 * 1000) div 1000, 'cm')"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="style:column-width"><xsl:value-of select="$default-column-width"/></xsl:attribute> </xsl:otherwise> </xsl:choose> <xsl:attribute name="fo:break-before">auto</xsl:attribute> </xsl:element> </style:style> <xsl:if test="$current-count < $column-count"> <xsl:call-template name="get-column-style-name"> <xsl:with-param name="lastcolumnpos"> <xsl:choose> <xsl:when test="./ss:Column[position() = $current-count]/@ss:Index"> <xsl:choose> <xsl:when test="./ss:Column[position() = $current-count]/@ss:Span"> <xsl:value-of select="./ss:Column[position() = $current-count]/@ss:Index + ./ss:Column[position() = $current-count]/@ss:Span"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="./ss:Column[position() = $current-count]/@ss:Index"/> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="./ss:Column[position() = $current-count]/@ss:Span"> <xsl:value-of select="$lastcolumnpos + ./ss:Column[position() = $current-count]/@ss:Span + 1"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$lastcolumnpos + 1"/> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:with-param> <xsl:with-param name="column-count" select="$column-count"/> <xsl:with-param name="current-count" select="$current-count + 1"/> <xsl:with-param name="table-pos" select="$table-pos"/> <xsl:with-param name="default-column-width" select="$default-column-width"/> </xsl:call-template> </xsl:if> </xsl:if> </xsl:template> <xsl:template name="get-row-style-name"> <!-- generate stylename of rowbreak after matching the row number and the rowbreak number.tom chen --> <xsl:param name="lastrowpos"/> <xsl:param name="row-count"/> <xsl:param name="current-count"/> <xsl:param name="table-pos"/> <xsl:param name="default-row-width"/> <xsl:if test="$current-count < ($row-count + 1)"> <xsl:variable name="span-value"> <xsl:choose> <xsl:when test="./ss:Row[position() = $current-count]/@ss:Index"> <xsl:choose> <xsl:when test="./ss:Row[position() = $current-count]/@ss:Span"> <xsl:value-of select="./ss:Row[position() = $current-count]/@ss:Index - $lastrowpos+ ./ss:Row[position() = $current-count]/@ss:Span"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="0"/> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="./ss:Row[position() = $current-count]/@ss:Span"> <xsl:value-of select="./ss:Row[position() = $current-count]/@ss:Span + 1"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="0"/> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="current-index"> <xsl:choose> <xsl:when test="./ss:Row[position() = $current-count]/@ss:Index"> <xsl:value-of select="./ss:Row[position() = $current-count]/@ss:Index - 1"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$lastrowpos"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="row-break"> <xsl:choose> <xsl:when test="$span-value = 0"> <xsl:if test="../x:PageBreaks/x:RowBreaks/x:RowBreak/x:Row = $current-index"> <xsl:value-of select="1"/> </xsl:if> </xsl:when> <xsl:otherwise> <xsl:if test="../x:PageBreaks/x:RowBreaks[(x:RowBreak/x:Row > $lastrowpos) and (x:RowBreak/x:Row < ($lastrowpos + $span-value))]"> <xsl:value-of select="1"/> </xsl:if> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:if test="$row-break = 1"> <style:style style:name="{concat('rob', $table-pos, '-',$current-count)}" style:family="table-row"> <xsl:element name="style:properties"> <xsl:choose> <xsl:when test="./ss:Row[position() = $current-count]/@ss:Height"> <xsl:attribute name="style:row-height"><xsl:value-of select="concat( floor(./ss:Row[position() = $current-count]/@ss:Height div 28.34 * 1000) div 1000, 'cm')"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="style:row-height"><xsl:value-of select="$default-row-width"/></xsl:attribute> </xsl:otherwise> </xsl:choose> <xsl:choose> <xsl:when test="./ss:Row[position() = $current-count]/@ss:AutoFitHeight = '0'"> <xsl:attribute name="style:use-optimal-row-height">false</xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="./ss:Row[position() = $current-count]/@ss:Height > 0"> <xsl:attribute name="style:use-optimal-row-height">false</xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="style:use-optimal-row-height">true</xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> <xsl:attribute name="fo:break-before">page</xsl:attribute> </xsl:element> </style:style> </xsl:if> <style:style style:name="{concat('ro', $table-pos, '-',$current-count)}" style:family="table-row"> <xsl:element name="style:properties"> <xsl:choose> <xsl:when test="./ss:Row[position() = $current-count]/@ss:Height"> <xsl:attribute name="style:row-height"><xsl:value-of select="concat( floor(./ss:Row[position() = $current-count]/@ss:Height div 28.34 * 1000) div 1000, 'cm')"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="style:row-height"><xsl:value-of select="$default-row-width"/></xsl:attribute> </xsl:otherwise> </xsl:choose> <xsl:choose> <xsl:when test="./ss:Row[position() = $current-count]/@ss:AutoFitHeight"> <xsl:choose> <xsl:when test="./ss:Row[position() = $current-count]/@ss:AutoFitHeight = '0'"> <xsl:attribute name="style:use-optimal-row-height">false</xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="style:use-optimal-row-height">true</xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="./ss:Row[position() = $current-count]/@ss:Height > 0"> <xsl:attribute name="style:use-optimal-row-height">false</xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="style:use-optimal-row-height">true</xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> <xsl:attribute name="fo:break-before">auto</xsl:attribute> </xsl:element> </style:style> <xsl:if test="$current-count < $row-count"> <xsl:call-template name="get-row-style-name"> <xsl:with-param name="lastrowpos"> <xsl:choose> <xsl:when test="./ss:Row[position() = $current-count]/@ss:Index"> <xsl:choose> <xsl:when test="./ss:Row[position() = $current-count]/@ss:Span"> <xsl:value-of select="./ss:Row[position() = $current-count]/@ss:Index + ./ss:Row[position() = $current-count]/@ss:Span"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="./ss:Row[position() = $current-count]/@ss:Index"/> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="./ss:Row[position() = $current-count]/@ss:Span"> <xsl:value-of select="$lastrowpos + ./ss:Row[position() = $current-count]/@ss:Span + 1"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$lastrowpos + 1"/> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:with-param> <xsl:with-param name="row-count" select="$row-count"/> <xsl:with-param name="current-count" select="$current-count + 1"/> <xsl:with-param name="table-pos" select="$table-pos"/> <xsl:with-param name="default-row-width" select="$default-row-width"/> </xsl:call-template> </xsl:if> </xsl:if> </xsl:template> <xsl:template match="ss:Worksheet"> <xsl:element name="table:table"> <xsl:attribute name="table:name"><xsl:value-of select="@ss:Name"/></xsl:attribute> <!-- other attributes aren't suitable to apply yet. glu --> <xsl:if test="ss:Table"> <xsl:attribute name="table:style-name"><xsl:value-of select="concat( 'ta', count(preceding-sibling::ss:Worksheet)+1)"/></xsl:attribute> <xsl:if test="@ss:Protected = '1'"> <xsl:attribute name="table:protected">true</xsl:attribute> </xsl:if> <xsl:if test="descendant::ss:NamedRange[@ss:Name = 'Print_Area' and contains( @ss:RefersTo, '!R')]"> <xsl:variable name="referto"> <xsl:call-template name="translate-expression"> <xsl:with-param name="cell-row-pos" select="0"/> <xsl:with-param name="cell-column-pos" select="0"/> <xsl:with-param name="expression" select="descendant::ss:NamedRange/@ss:RefersTo"/> </xsl:call-template> </xsl:variable> <xsl:attribute name="table:print-ranges"><xsl:value-of select="translate( $referto, '=', '$')"/></xsl:attribute> </xsl:if> <xsl:variable name="table-pos"> <xsl:value-of select="count(../preceding-sibling::ss:Worksheet)+1"/> </xsl:variable> <xsl:choose> <xsl:when test="./ss:Table/ss:Column"> <xsl:call-template name="Column-Data"> <xsl:with-param name="lastcolumnpos" select="0"/> <xsl:with-param name="column-count" select="count(ss:Table/ss:Column)"/> <xsl:with-param name="current-count" select="1"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:if test="./x:PageBreaks/x:ColBreaks"> <xsl:for-each select="./x:PageBreaks/x:ColBreaks/x:ColBreak"> <xsl:variable name="number-repeated"> <xsl:choose> <xsl:when test="position() = 1"> <xsl:value-of select="./x:Column"/> </xsl:when> <xsl:otherwise> <xsl:value-of select=". - preceding::x:ColBreak[position()=count(.)]/x:Column - 1"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:if test="$number-repeated > 0"> <xsl:element name="table:table-column"> <xsl:if test="ancestor::ss:Worksheet/ss:Table/@ss:StyleID"> <xsl:attribute name="table:default-cell-style-name"><xsl:value-of select="ancestor::ss:Worksheet/ss:Table/@ss:StyleID"/></xsl:attribute> </xsl:if> <xsl:if test="@ss:Hidden = '1'"> <xsl:attribute name="table:visibility">collapse</xsl:attribute> </xsl:if> <xsl:attribute name="table:style-name"><xsl:value-of select="concat('co',$table-pos)"/></xsl:attribute> <xsl:attribute name="table:number-columns-repeated"><xsl:value-of select="$number-repeated"/></xsl:attribute> </xsl:element> </xsl:if> <xsl:element name="table:table-column"> <!-- column style be made out beforehead. glu --> <xsl:if test="ancestor::ss:Worksheet/ss:Table/@ss:StyleID"> <xsl:attribute name="table:default-cell-style-name"><xsl:value-of select="ancestor::ss:Worksheet/ss:Table/@ss:StyleID"/></xsl:attribute> </xsl:if> <xsl:if test="@ss:Hidden = '1'"> <xsl:attribute name="table:visibility">collapse</xsl:attribute> </xsl:if> <xsl:attribute name="table:style-name"><xsl:value-of select="concat('cob',$table-pos)"/></xsl:attribute> </xsl:element> </xsl:for-each> </xsl:if> <!-- if exists attribute of StyleID in tag of ss:Table but no Row/Column. cp tom chen --> <xsl:if test="./ss:Table/@ss:StyleID"> <table:table-column table:style-name="co1" table:number-columns-repeated="256" table:default-cell-style-name="{./ss:Table/@ss:StyleID}"/> </xsl:if> </xsl:otherwise> </xsl:choose> <!-- generates the string of row\column position if ConditionalFormatting exists.tom chen --> <xsl:variable name="condition-pos-str"> <xsl:if test="./x:ConditionalFormatting"> <xsl:call-template name="condition-row-column-string"> <xsl:with-param name="last" select="''"/> <xsl:with-param name="total" select="count(./x:ConditionalFormatting)"/> <xsl:with-param name="index" select="1"/> </xsl:call-template> </xsl:if> </xsl:variable> <xsl:choose> <xsl:when test="./ss:Table/ss:Row"> <xsl:call-template name="Row-Data"> <xsl:with-param name="lastrowpos" select="0"/> <xsl:with-param name="row-count" select="count(ss:Table/ss:Row)"/> <xsl:with-param name="current-count" select="1"/> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:variable name="table-style-value"> <xsl:choose> <xsl:when test="./ss:Table[@ss:StyleID]"> <xsl:value-of select="1"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="0"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:if test="./x:PageBreaks/x:RowBreaks"> <xsl:for-each select="./x:PageBreaks/x:RowBreaks/x:RowBreak"> <xsl:variable name="number-repeated"> <xsl:choose> <xsl:when test="position() = 1"> <xsl:value-of select="./x:Row"/> </xsl:when> <xsl:otherwise> <xsl:value-of select=". - preceding::x:RowBreak[position()=count(.)]/x:Row - 1"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:if test="$number-repeated > 0"> <xsl:element name="table:table-row"> <xsl:if test="ancestor::ss:Worksheet/ss:Table/@ss:StyleID"> <xsl:attribute name="table:default-cell-style-name"><xsl:value-of select="ancestor::ss:Worksheet/ss:Table/@ss:StyleID"/></xsl:attribute> </xsl:if> <xsl:if test="@ss:Hidden = '1'"> <xsl:attribute name="table:visibility">collapse</xsl:attribute> </xsl:if> <xsl:attribute name="table:style-name"><xsl:value-of select="concat('ro',$table-pos)"/></xsl:attribute> <xsl:attribute name="table:number-rows-repeated"><xsl:value-of select="$number-repeated"/></xsl:attribute> <xsl:if test="$table-style-value = 1"> <table:table-cell table:number-columns-repeated="256"/> </xsl:if> </xsl:element> </xsl:if> <xsl:element name="table:table-row"> <xsl:if test="ancestor::ss:Worksheet/ss:Table/@ss:StyleID"> <xsl:attribute name="table:default-cell-style-name"><xsl:value-of select="ancestor::ss:Worksheet/ss:Table/@ss:StyleID"/></xsl:attribute> </xsl:if> <xsl:if test="@ss:Hidden = '1'"> <xsl:attribute name="table:visibility">collapse</xsl:attribute> </xsl:if> <xsl:attribute name="table:style-name"><xsl:value-of select="concat('rob',$table-pos)"/></xsl:attribute> <xsl:if test="$table-style-value = 1"> <table:table-cell table:number-columns-repeated="256"/> </xsl:if> </xsl:element> </xsl:for-each> </xsl:if> <xsl:if test="./x:ConditionalFormatting"> <xsl:variable name="condition-row-max"> <xsl:call-template name="condition-row-col-pos-max"> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> <xsl:with-param name="last-value" select="0"/> <xsl:with-param name="div-value" select="'R'"/> </xsl:call-template> </xsl:variable> <xsl:variable name="condition-col-max"> <xsl:call-template name="condition-row-col-pos-max"> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> <xsl:with-param name="last-value" select="0"/> <xsl:with-param name="div-value" select="'C'"/> </xsl:call-template> </xsl:variable> <xsl:variable name="break-row-max"> <xsl:call-template name="break-row-beyond-max"> <xsl:with-param name="pos" select="1"/> <xsl:with-param name="last-value" select="0"/> <xsl:with-param name="count-value" select="count(./x:PageBreaks/x:RowBreaks/x:RowBreak)"/> </xsl:call-template> </xsl:variable> <xsl:variable name="end-value"> <xsl:choose> <xsl:when test="$condition-row-max < $break-row-max"> <xsl:value-of select="$break-row-max"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$condition-row-max"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:call-template name="get-row-beyond-last"> <xsl:with-param name="index-value" select="1"/> <xsl:with-param name="pre-worksheet" select="count(preceding-sibling::ss:Worksheet)+1"/> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> <xsl:with-param name="end-pos" select="$end-value"/> <xsl:with-param name="total-col" select="$condition-col-max"/> </xsl:call-template> </xsl:if> <!-- if exists attribute of StyleID in tag of ss:Table but no Row/Column. cp tom chen --> <xsl:if test="./ss:Table/@ss:StyleID"> <table:table-row table:style-name="ro1" table:number-rows-repeated="32000" table:default-cell-style-name="{./ss:Table/@ss:StyleID}"> <table:table-cell table:number-columns-repeated="256"/> </table:table-row> </xsl:if> </xsl:otherwise> </xsl:choose> </xsl:if> </xsl:element> </xsl:template> <xsl:template name="Column-Data"> <xsl:param name="lastcolumnpos"/> <xsl:param name="column-count"/> <xsl:param name="current-count"/> <xsl:if test="$current-count < ($column-count + 1)"> <xsl:variable name="span-value"> <xsl:choose> <xsl:when test="./ss:Table/ss:Column[position() = $current-count]/@ss:Index"> <xsl:choose> <xsl:when test="./ss:Table/ss:Column[position() = $current-count]/@ss:Span"> <xsl:value-of select="./ss:Table/ss:Column[position() = $current-count]/@ss:Index - $lastcolumnpos + ./ss:Table/ss:Column[position() = $current-count]/@ss:Span"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="./ss:Table/ss:Column[position() = $current-count]/@ss:Index - $lastcolumnpos"/> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="./ss:Table/ss:Column[position() = $current-count]/@ss:Span"> <xsl:value-of select="./ss:Table/ss:Column[position() = $current-count]/@ss:Span + 1"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="1"/> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="current-index"> <xsl:choose> <xsl:when test="./ss:Table/ss:Column[position() = $current-count]/@ss:Index"> <xsl:value-of select="./ss:Table/ss:Column[position() = $current-count]/@ss:Index"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$lastcolumnpos + 1"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:call-template name="get-column-span-in"> <xsl:with-param name="index-value" select="$lastcolumnpos"/> <xsl:with-param name="span-value" select="$span-value"/> <xsl:with-param name="pre-worksheet" select="count(preceding-sibling::ss:Worksheet)+1"/> <xsl:with-param name="row-value" select="$current-count"/> <xsl:with-param name="times" select="1"/> <xsl:with-param name="current-index" select="$current-index"/> </xsl:call-template> <xsl:if test="$current-count < $column-count"> <xsl:call-template name="Column-Data"> <xsl:with-param name="lastcolumnpos"> <xsl:choose> <xsl:when test="./ss:Table/ss:Column[position() = $current-count]/@ss:Index"> <xsl:choose> <xsl:when test="./ss:Table/ss:Column[position() = $current-count]/@ss:Span"> <xsl:value-of select="./ss:Table/ss:Column[position() = $current-count]/@ss:Index + ./ss:Table/ss:Column[position() = $current-count]/@ss:Span"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="./ss:Table/ss:Column[position() = $current-count]/@ss:Index"/> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="./ss:Table/ss:Column[position() = $current-count]/@ss:Span"> <xsl:value-of select="$lastcolumnpos + ./ss:Table/ss:Column[position() = $current-count]/@ss:Span + 1"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$lastcolumnpos + 1"/> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:with-param> <xsl:with-param name="column-count" select="$column-count"/> <xsl:with-param name="current-count" select="$current-count + 1"/> </xsl:call-template> </xsl:if> </xsl:if> <xsl:if test="$current-count = $column-count"> <xsl:variable name="last-pos"> <xsl:choose> <xsl:when test="./ss:Table/ss:Column[position() = $current-count]/@ss:Index"> <xsl:choose> <xsl:when test="./ss:Table/ss:Column[position() = $current-count]/@ss:Span"> <xsl:value-of select="./ss:Table/ss:Column[position() = $current-count]/@ss:Index + ./ss:Table/ss:Column[position() = $current-count]/@ss:Span"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="./ss:Table/ss:Column[position() = $current-count]/@ss:Index"/> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="./ss:Table/ss:Column[position() = $current-count]/@ss:Span"> <xsl:value-of select="$lastcolumnpos + ./ss:Table/ss:Column[position() = $current-count]/@ss:Span + 1"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$lastcolumnpos + 1"/> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:if test="./x:PageBreaks/x:ColBreaks/x:ColBreak/x:Column > ($last-pos - 1)"> <xsl:call-template name="get-column-beyond-last"> <xsl:with-param name="index-value" select="$last-pos + 1"/> <xsl:with-param name="pre-worksheet" select="count(preceding-sibling::ss:Worksheet)+1"/> </xsl:call-template> </xsl:if> <!-- generates some special tags for whole row style. tom chen --> <xsl:if test="(./ss:Table[@ss:StyleID] or ./ss:Table/ss:Row[@ss:StyleID]) and (256 - $last-pos > 0)"> <xsl:element name="table:table-column"> <xsl:attribute name="table:default-cell-style-name"><xsl:choose><xsl:when test="./ss:Table[@ss:StyleID]"><xsl:value-of select="./ss:Table/@ss:StyleID"/></xsl:when><xsl:otherwise><xsl:value-of select="'Default'"/></xsl:otherwise></xsl:choose></xsl:attribute> <xsl:attribute name="table:style-name"><xsl:value-of select="'co1'"/></xsl:attribute> <xsl:attribute name="table:number-columns-repeated"><xsl:value-of select="256 - $last-pos"/></xsl:attribute> </xsl:element> </xsl:if> </xsl:if> </xsl:template> <xsl:template name="current-column-row-pos"> <xsl:param name="current-column-row-list"/> <xsl:choose> <xsl:when test="$current-column-row-list"> <!-- Xalan-J returns preceding-sibling in forward document sequence, not reverse as XPath 1.0 defined. glu --> <xsl:variable name="current-column-row" select="$current-column-row-list[position()=last()]"/> <xsl:choose> <xsl:when test="$current-column-row/@ss:Index"> <xsl:choose> <xsl:when test="$current-column-row/@ss:Span"> <xsl:value-of select="$current-column-row/@ss:Span + $current-column-row/@ss:Index"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$current-column-row/@ss:Index"/> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:variable name="preceding-column-row"> <xsl:call-template name="current-column-row-pos"> <xsl:with-param name="current-column-row-list" select="$current-column-row-list[position()!=last()]"/> </xsl:call-template> </xsl:variable> <xsl:choose> <xsl:when test="$current-column-row/@ss:Span"> <xsl:value-of select="1 + $current-column-row/@ss:Span + $preceding-column-row"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="1 + $preceding-column-row"/> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise>0</xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="Row-Data"> <xsl:param name="lastrowpos"/> <xsl:param name="row-count"/> <xsl:param name="current-count"/> <xsl:param name="condition-pos-str"/> <xsl:if test="$current-count < ($row-count + 1)"> <xsl:variable name="span-value"> <xsl:choose> <xsl:when test="./ss:Table/ss:Row[position() = $current-count]/@ss:Index"> <xsl:choose> <xsl:when test="./ss:Table/ss:Row[position() = $current-count]/@ss:Span"> <xsl:value-of select="./ss:Table/ss:Row[position() = $current-count]/@ss:Index - $lastrowpos + ./ss:Table/ss:Row[position() = $current-count]/@ss:Span"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="./ss:Table/ss:Row[position() = $current-count]/@ss:Index - $lastrowpos"/> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="./ss:Table/ss:Row[position() = $current-count]/@ss:Span"> <xsl:value-of select="./ss:Table/ss:Row[position() = $current-count]/@ss:Span + 1"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="1"/> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="current-index"> <xsl:choose> <xsl:when test="./ss:Table/ss:Row[position() = $current-count]/@ss:Index"> <xsl:value-of select="./ss:Table/ss:Row[position() = $current-count]/@ss:Index"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$lastrowpos + 1"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:call-template name="get-row-span-in"> <xsl:with-param name="index-value" select="$lastrowpos"/> <xsl:with-param name="span-value" select="$span-value"/> <xsl:with-param name="pre-worksheet" select="count(preceding-sibling::ss:Worksheet)+1"/> <xsl:with-param name="row-value" select="$current-count"/> <xsl:with-param name="times" select="1"/> <xsl:with-param name="current-index" select="$current-index"/> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> </xsl:call-template> <xsl:if test="$current-count < $row-count"> <xsl:call-template name="Row-Data"> <xsl:with-param name="lastrowpos"> <xsl:choose> <xsl:when test="./ss:Table/ss:Row[position() = $current-count]/@ss:Index"> <xsl:choose> <xsl:when test="./ss:Table/ss:Row[position() = $current-count]/@ss:Span"> <xsl:value-of select="./ss:Table/ss:Row[position() = $current-count]/@ss:Index + ./ss:Table/ss:Row[position() = $current-count]/@ss:Span"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="./ss:Table/ss:Row[position() = $current-count]/@ss:Index"/> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="./ss:Table/ss:Row[position() = $current-count]/@ss:Span"> <xsl:value-of select="$lastrowpos + ./ss:Table/ss:Row[position() = $current-count]/@ss:Span + 1"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$lastrowpos + 1"/> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:with-param> <xsl:with-param name="row-count" select="$row-count"/> <xsl:with-param name="current-count" select="$current-count + 1"/> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> </xsl:call-template> </xsl:if> </xsl:if> <xsl:if test="$current-count = $row-count"> <xsl:variable name="last-pos"> <xsl:choose> <xsl:when test="./ss:Table/ss:Row[position() = $current-count]/@ss:Index"> <xsl:choose> <xsl:when test="./ss:Table/ss:Row[position() = $current-count]/@ss:Span"> <xsl:value-of select="./ss:Table/ss:Row[position() = $current-count]/@ss:Index + ./ss:Table/ss:Row[position() = $current-count]/@ss:Span"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="./ss:Table/ss:Row[position() = $current-count]/@ss:Index"/> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="./ss:Table/ss:Row[position() = $current-count]/@ss:Span"> <xsl:value-of select="$lastrowpos + ./ss:Table/ss:Row[position() = $current-count]/@ss:Span + 1"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$lastrowpos + 1"/> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:if test="./x:PageBreaks/x:RowBreaks/x:RowBreak/x:Row > ($last-pos - 1) or ./x:ConditionalFormatting"> <xsl:variable name="condition-row-max"> <xsl:call-template name="condition-row-col-pos-max"> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> <xsl:with-param name="last-value" select="0"/> <xsl:with-param name="div-value" select="'R'"/> </xsl:call-template> </xsl:variable> <xsl:variable name="condition-col-max"> <xsl:call-template name="condition-row-col-pos-max"> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> <xsl:with-param name="last-value" select="0"/> <xsl:with-param name="div-value" select="'C'"/> </xsl:call-template> </xsl:variable> <xsl:variable name="break-row-max"> <xsl:call-template name="break-row-beyond-max"> <xsl:with-param name="pos" select="1"/> <xsl:with-param name="last-value" select="0"/> <xsl:with-param name="count-value" select="count(./x:PageBreaks/x:RowBreaks/x:RowBreak)"/> </xsl:call-template> </xsl:variable> <xsl:variable name="end-value"> <xsl:choose> <xsl:when test="$condition-row-max < $break-row-max"> <xsl:value-of select="$break-row-max"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$condition-row-max"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:call-template name="get-row-beyond-last"> <xsl:with-param name="index-value" select="$last-pos + 1"/> <xsl:with-param name="pre-worksheet" select="count(preceding-sibling::ss:Worksheet)+1"/> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> <xsl:with-param name="end-pos" select="$end-value"/> <xsl:with-param name="total-col" select="$condition-col-max"/> </xsl:call-template> </xsl:if> <!-- generates some special tags for whole column style. tom chen --> <xsl:if test="./ss:Table/ss:Column[@ss:StyleID] or ./ss:Table[@ss:StyleID]"> <table:table-row table:style-name="ro1" table:number-rows-repeated="31990"> <table:table-cell table:number-columns-repeated="256"/> </table:table-row> <table:table-row table:style-name="ro1"> <table:table-cell table:number-columns-repeated="256"/> </table:table-row> </xsl:if> </xsl:if> </xsl:template> <xsl:template name="get-row-span-in"> <!-- dealing the every row from lastrowpos to Index or ss:Span(if exists) one by one.tom chen --> <xsl:param name="index-value"/> <xsl:param name="span-value"/> <xsl:param name="pre-worksheet"/> <xsl:param name="row-value"/> <xsl:param name="times"/> <xsl:param name="current-index"/> <xsl:param name="condition-pos-str"/> <xsl:element name="table:table-row"> <!-- generates default-cell-style-name tag if appearance of StyleID in tag of Table. --> <xsl:if test="./ss:Table[@ss:StyleID]"> <xsl:attribute name="table:default-cell-style-name"><xsl:value-of select="./ss:Table/@ss:StyleID"/></xsl:attribute> </xsl:if> <xsl:choose> <xsl:when test="./x:PageBreaks/x:RowBreaks/x:RowBreak/x:Row = ($index-value + $times - 1)"> <xsl:choose> <xsl:when test="($index-value + $times < $current-index) and ($current-index != 0)"> <xsl:attribute name="table:style-name"><xsl:value-of select="concat('rob',$pre-worksheet)"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="table:style-name"><xsl:value-of select="concat('rob', $pre-worksheet, '-', $row-value)"/></xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="($index-value + $times < $current-index) and ($current-index != 0)"> <xsl:attribute name="table:style-name"><xsl:value-of select="concat('ro',$pre-worksheet)"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="table:style-name"><xsl:value-of select="concat('ro', $pre-worksheet, '-', $row-value)"/></xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> <xsl:if test="./ss:Table/ss:Row[position() = $row-value]/@ss:Hidden = '1'"> <xsl:choose> <xsl:when test="./ss:Table/ss:Row[position() = $row-value]/@ss:Span"> <xsl:if test="$index-value + $times > ($current-index - 1)"> <xsl:attribute name="table:visibility">collapse</xsl:attribute> </xsl:if> </xsl:when> <xsl:otherwise> <xsl:if test="$index-value + $times = $current-index"> <xsl:attribute name="table:visibility">collapse</xsl:attribute> </xsl:if> </xsl:otherwise> </xsl:choose> </xsl:if> <xsl:if test="$index-value + $times < $current-index"> <xsl:variable name="current" select="concat('R',($index-value + $times),'C')"/> <xsl:variable name="col-pos-max"> <xsl:call-template name="condition-row-col-pos-max"> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> <xsl:with-param name="last-value" select="0"/> <xsl:with-param name="div-value" select="'C'"/> </xsl:call-template> </xsl:variable> <xsl:if test="contains($condition-pos-str,$current)"> <xsl:call-template name="get-cell-span-in"> <xsl:with-param name="row-pos" select="$index-value + $times"/> <xsl:with-param name="c-start" select="1"/> <xsl:with-param name="c-end" select="$col-pos-max"/> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> </xsl:call-template> </xsl:if> </xsl:if> <xsl:if test="$index-value + $times = $current-index"> <xsl:call-template name="Cell-Data"> <xsl:with-param name="row-node" select="descendant-or-self::ss:Table/ss:Row[position() = $row-value]"/> <xsl:with-param name="row-pos" select="$index-value + $times"/> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> </xsl:call-template> </xsl:if> <!-- generates code for whole row style. the filter will don't work the style of first row correctly if total cells more than 256. to be modified. tom chen --> <xsl:if test="./ss:Table[@ss:StyleID] or ./ss:Table/ss:Row[position() = $row-value]/@ss:StyleID or ./ss:Table/ss:Column[@ss:StyleID]"> <xsl:element name="table:table-cell"> <xsl:attribute name="table:number-columns-repeated"><xsl:value-of select="256"/></xsl:attribute> <xsl:if test="$index-value + $times = $current-index and (./ss:Table/ss:Row[position() = $row-value]/@ss:StyleID)"> <xsl:attribute name="table:style-name"><xsl:value-of select="./ss:Table/ss:Row[position() = $row-value]/@ss:StyleID"/></xsl:attribute> </xsl:if> <xsl:if test="./ss:Table[@ss:StyleID]"> <xsl:attribute name="table:default-cell-style-name"><xsl:value-of select="./ss:Table/@ss:StyleID"/></xsl:attribute> </xsl:if> </xsl:element> </xsl:if> </xsl:element> <xsl:if test="$times < $span-value"> <xsl:call-template name="get-row-span-in"> <xsl:with-param name="index-value" select="$index-value"/> <xsl:with-param name="span-value" select="$span-value"/> <xsl:with-param name="pre-worksheet" select="$pre-worksheet"/> <xsl:with-param name="row-value" select="$row-value"/> <xsl:with-param name="times" select="$times + 1"/> <xsl:with-param name="current-index" select="$current-index"/> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> </xsl:call-template> </xsl:if> </xsl:template> <xsl:template name="get-column-span-in"> <!-- dealing the every column from lastcolumnpos to Index or ss:Span(if exists) one by one.tom chen --> <xsl:param name="index-value"/> <xsl:param name="span-value"/> <xsl:param name="pre-worksheet"/> <xsl:param name="row-value"/> <xsl:param name="times"/> <xsl:param name="current-index"/> <xsl:if test="$times - 1 < $span-value"> <xsl:element name="table:table-column"> <xsl:attribute name="table:default-cell-style-name"><xsl:choose><xsl:when test="($times + $index-value = $current-index) and ./ss:Table/ss:Column[position() = $row-value]/@ss:StyleID"><xsl:value-of select="./ss:Table/ss:Column[position() = $row-value]/@ss:StyleID"/></xsl:when><xsl:otherwise><xsl:choose><xsl:when test="./ss:Table[@ss:StyleID]"><xsl:value-of select="./ss:Table/@ss:StyleID"/></xsl:when><xsl:otherwise><xsl:value-of select="'Default'"/></xsl:otherwise></xsl:choose></xsl:otherwise></xsl:choose></xsl:attribute> <xsl:choose> <xsl:when test="./x:PageBreaks/x:ColBreaks/x:ColBreak/x:Column = ($index-value + $times - 1)"> <xsl:choose> <xsl:when test="($index-value + $times < $current-index) and ($current-index != 0)"> <xsl:attribute name="table:style-name"><xsl:value-of select="concat('cob',$pre-worksheet)"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="table:style-name"><xsl:value-of select="concat('cob', $pre-worksheet, '-', $row-value)"/></xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="($index-value + $times < $current-index) and ($current-index != 0)"> <xsl:attribute name="table:style-name"><xsl:value-of select="concat('co',$pre-worksheet)"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="table:style-name"><xsl:value-of select="concat('co', $pre-worksheet, '-', $row-value)"/></xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> <xsl:if test="./ss:Table/ss:Column[position() = $row-value]/@ss:Hidden = '1'"> <xsl:choose> <xsl:when test="./ss:Table/ss:Column[position() = $row-value]/@ss:Span"> <xsl:if test="$index-value + $times > ($current-index - 1)"> <xsl:attribute name="table:visibility">collapse</xsl:attribute> </xsl:if> </xsl:when> <xsl:otherwise> <xsl:if test="$index-value + $times = $current-index"> <xsl:attribute name="table:visibility">collapse</xsl:attribute> </xsl:if> </xsl:otherwise> </xsl:choose> </xsl:if> </xsl:element> </xsl:if> <xsl:if test="$times - 1 < $span-value"> <xsl:call-template name="get-column-span-in"> <xsl:with-param name="index-value" select="$index-value"/> <xsl:with-param name="span-value" select="$span-value"/> <xsl:with-param name="pre-worksheet" select="$pre-worksheet"/> <xsl:with-param name="row-value" select="$row-value"/> <xsl:with-param name="times" select="$times + 1"/> <xsl:with-param name="current-index" select="$current-index"/> </xsl:call-template> </xsl:if> </xsl:template> <xsl:template name="get-row-beyond-last"> <!-- dealing the RowBreak after last row by recursion.tom chen --> <xsl:param name="index-value"/> <xsl:param name="pre-worksheet"/> <xsl:param name="condition-pos-str"/> <xsl:param name="end-pos"/> <xsl:param name="total-col"/> <xsl:variable name="current" select="concat('R',$index-value)"/> <xsl:element name="table:table-row"> <xsl:choose> <xsl:when test="./x:PageBreaks/x:RowBreaks/x:RowBreak/x:Row = ($index-value - 1)"> <xsl:attribute name="table:style-name"><xsl:value-of select="concat('rob',$pre-worksheet)"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="table:style-name"><xsl:value-of select="concat('ro',$pre-worksheet)"/></xsl:attribute> </xsl:otherwise> </xsl:choose> <xsl:if test="./ss:Table/ss:Column[@ss:StyleID] or ./ss:Table[@ss:StyleID]"> <xsl:if test="256 - count(./ss:Table/ss:Column) > 0"> <table:table-cell table:number-columns-repeated="{256 - count(./ss:Table/ss:Column)}"/> </xsl:if> </xsl:if> <xsl:if test="contains($condition-pos-str,$current)"> <xsl:call-template name="get-cell-span-in"> <xsl:with-param name="row-pos" select="$index-value"/> <xsl:with-param name="c-start" select="1"/> <xsl:with-param name="c-end" select="$total-col"/> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> </xsl:call-template> </xsl:if> </xsl:element> <xsl:if test="$index-value < ($end-pos + 1)"> <xsl:call-template name="get-row-beyond-last"> <xsl:with-param name="index-value" select="$index-value + 1"/> <xsl:with-param name="pre-worksheet" select="$pre-worksheet"/> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> <xsl:with-param name="end-pos" select="$end-pos"/> <xsl:with-param name="total-col" select="$total-col"/> </xsl:call-template> </xsl:if> </xsl:template> <xsl:template name="break-row-beyond-max"> <!-- returns the max position of the row from condition-pos-str.tom chen --> <xsl:param name="pos"/> <xsl:param name="last-value"/> <xsl:param name="count-value"/> <xsl:variable name="pre-value" select="./x:PageBreaks/x:RowBreaks/x:RowBreak[position() = $pos]/x:Row"/> <xsl:variable name="end-value"> <xsl:choose> <xsl:when test="$last-value < $pre-value"> <xsl:value-of select="$pre-value"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$last-value"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:choose> <xsl:when test="$pos < $count-value"> <xsl:call-template name="break-row-beyond-max"> <xsl:with-param name="pos" select="$pos + 1"/> <xsl:with-param name="last-value" select="$end-value"/> <xsl:with-param name="count-value" select="$count-value"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:value-of select="$end-value"/> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="get-column-beyond-last"> <!-- dealing the ColBreak after last column by recursion.tom chen --> <xsl:param name="index-value"/> <xsl:param name="pre-worksheet"/> <xsl:for-each select="./x:PageBreaks/x:ColBreaks/x:ColBreak"> <xsl:variable name="each-column-value" select="./x:Column"/> <xsl:choose> <xsl:when test="$each-column-value + 1 > $index-value"> <xsl:variable name="number-repeated"> <xsl:choose> <xsl:when test="preceding-sibling::x:ColBreak[position()=count(.)]/x:Column + 1 = $index-value"> <xsl:value-of select="$each-column-value - preceding-sibling::x:ColBreak[position()=count(.)]/x:Column - 1"/> </xsl:when> <xsl:when test="preceding-sibling::x:ColBreak[position()=count(.)]/x:Column + 1 > $index-value"> <xsl:value-of select="$each-column-value - preceding-sibling::x:ColBreak[position()=count(.)]/x:Column - 1"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$each-column-value - $index-value + 1"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:if test="$number-repeated > 0"> <xsl:element name="table:table-column"> <xsl:attribute name="table:style-name"><xsl:value-of select="'co1'"/></xsl:attribute> <xsl:attribute name="table:number-columns-repeated"><xsl:value-of select="$number-repeated"/></xsl:attribute> </xsl:element> </xsl:if> <xsl:element name="table:table-column"> <xsl:if test="./../../../ss:Table[@ss:StyleID]"> <xsl:attribute name="table:default-cell-style-name"><xsl:value-of select="./ss:Table/@ss:StyleID"/></xsl:attribute> </xsl:if> <xsl:attribute name="table:style-name"><xsl:value-of select="concat('cob',$pre-worksheet)"/></xsl:attribute> </xsl:element> </xsl:when> <xsl:when test="$each-column-value + 1 = $index-value"> <xsl:element name="table:table-column"> <xsl:if test="./../../../ss:Table[@ss:StyleID]"> <xsl:attribute name="table:default-cell-style-name"><xsl:value-of select="./../../../ss:Table/@ss:StyleID"/></xsl:attribute> </xsl:if> <xsl:attribute name="table:style-name"><xsl:value-of select="concat('cob',$pre-worksheet)"/></xsl:attribute> </xsl:element> </xsl:when> </xsl:choose> </xsl:for-each> </xsl:template> <xsl:template name="get-cell-span-in"> <!-- judge the position of the Cell in the condition-pos-str.tom chen --> <xsl:param name="row-pos"/> <xsl:param name="c-start"/> <xsl:param name="c-end"/> <xsl:param name="condition-pos-str"/> <xsl:variable name="current" select="concat('R',$row-pos,'C',$c-start,',')"/> <xsl:variable name="style-name"> <xsl:choose> <xsl:when test="contains($condition-pos-str,$current)"> <xsl:variable name="temp-str"> <xsl:call-template name="condition-str"> <xsl:with-param name="param-str" select="substring-before($condition-pos-str,$current)"/> </xsl:call-template> </xsl:variable> <xsl:value-of select="concat('ce',$temp-str)"/> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="../ss:Cell[position() = position() - 1]/@ss:StyleID"> <xsl:value-of select="../ss:Cell[position() = position() - 1]/@ss:StyleID "/> </xsl:when> <xsl:when test="../@ss:StyleID"> <xsl:value-of select="../@ss:StyleID"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="'Default'"/> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:if test="$c-start < $c-end"> <xsl:call-template name="get-cell-condition-in"> <xsl:with-param name="style-name" select="$style-name"/> </xsl:call-template> <xsl:call-template name="get-cell-span-in"> <xsl:with-param name="row-pos" select="$row-pos"/> <xsl:with-param name="c-start" select="$c-start + 1"/> <xsl:with-param name="c-end" select="$c-end"/> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> </xsl:call-template> </xsl:if> <xsl:if test="$c-start = $c-end"> <xsl:call-template name="get-cell-condition-in"> <xsl:with-param name="style-name" select="$style-name"/> </xsl:call-template> </xsl:if> </xsl:template> <xsl:template name="get-cell-condition-in"> <!-- generates the style code for current tag of Cell one by one.tom chen --> <xsl:param name="style-name"/> <xsl:element name="table:table-cell"> <xsl:if test="not( contains($style-name, 'Default'))"> <xsl:attribute name="table:style-name"><xsl:value-of select="$style-name"/></xsl:attribute> </xsl:if> </xsl:element> </xsl:template> <xsl:template name="condition-row-col-pos-max"> <!-- returns the max position of the column or row from condition-pos-str.tom chen --> <xsl:param name="condition-pos-str"/> <xsl:param name="last-value"/> <xsl:param name="div-value"/> <xsl:variable name="pre-value"> <xsl:choose> <xsl:when test="$div-value = 'R'"> <xsl:value-of select="substring-before(substring-after($condition-pos-str,$div-value),'C')"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="substring-before(substring-after($condition-pos-str,$div-value),',')"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="end-value"> <xsl:choose> <xsl:when test="$last-value < $pre-value"> <xsl:value-of select="$pre-value"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$last-value"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:choose> <xsl:when test="contains($condition-pos-str,$div-value)"> <xsl:call-template name="condition-row-col-pos-max"> <xsl:with-param name="condition-pos-str" select="substring-after($condition-pos-str,$div-value)"/> <xsl:with-param name="last-value" select="$end-value"/> <xsl:with-param name="div-value" select="$div-value"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:value-of select="$end-value"/> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="condition-str"> <!-- returns the string of style name of condition-pos-str.tom chen --> <xsl:param name="param-str"/> <xsl:choose> <xsl:when test="contains($param-str,'(')"> <xsl:call-template name="condition-str"> <xsl:with-param name="param-str" select="substring-after($param-str,'(')"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:value-of select="substring-before($param-str,':')"/> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="Cell-Data"> <xsl:param name="row-node"/> <xsl:param name="row-pos"/> <xsl:param name="condition-pos-str"/> <xsl:variable name="col-pos-max"> <xsl:call-template name="condition-row-col-pos-max"> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> <xsl:with-param name="last-value" select="0"/> <xsl:with-param name="div-value" select="'C'"/> </xsl:call-template> </xsl:variable> <xsl:choose> <xsl:when test="$row-node/ss:Cell"> <xsl:for-each select="$row-node/ss:Cell"> <xsl:variable name="column-pos"> <xsl:choose> <xsl:when test="@ss:Index"> <xsl:value-of select="@ss:Index"/> </xsl:when> <xsl:otherwise> <xsl:variable name="preceding-cell-pos"> <xsl:call-template name="current-cell-pos"> <xsl:with-param name="current-cell-list" select="preceding-sibling::ss:Cell"/> </xsl:call-template> </xsl:variable> <xsl:value-of select="$preceding-cell-pos + 1"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:if test="@ss:Index"> <xsl:variable name="lastcellpos"> <xsl:call-template name="current-cell-pos"> <xsl:with-param name="current-cell-list" select="preceding-sibling::ss:Cell"/> </xsl:call-template> </xsl:variable> <xsl:variable name="last-repeated-pos"> <xsl:value-of select="@ss:Index - $lastcellpos - 1"/> </xsl:variable> <xsl:if test="$last-repeated-pos > 0"> <xsl:call-template name="get-cell-span-in"> <xsl:with-param name="row-pos" select="$row-pos"/> <xsl:with-param name="c-start" select="$lastcellpos + 1"/> <xsl:with-param name="c-end" select="@ss:Index - 1"/> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> </xsl:call-template> </xsl:if> </xsl:if> <xsl:element name="table:table-cell"> <xsl:variable name="current-str" select="concat('R',$row-pos,'C',$column-pos,',')"/> <xsl:variable name="style-name"> <xsl:choose> <xsl:when test="contains($condition-pos-str,$current-str)"> <xsl:variable name="temp-str"> <xsl:call-template name="condition-str"> <xsl:with-param name="param-str" select="substring-before($condition-pos-str,$current-str)"/> </xsl:call-template> </xsl:variable> <xsl:value-of select="concat('ce',$temp-str)"/> </xsl:when> <xsl:otherwise> <xsl:choose> <xsl:when test="@ss:StyleID"> <xsl:value-of select="@ss:StyleID"/> </xsl:when> <xsl:when test="../@ss:StyleID"> <xsl:value-of select="../@ss:StyleID"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="'Default'"/> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:if test="not( contains($style-name, 'Default'))"> <xsl:attribute name="table:style-name"><xsl:value-of select="$style-name"/></xsl:attribute> </xsl:if> <xsl:if test="@ss:MergeAcross or @ss:MergeDown"> <xsl:choose> <xsl:when test="@ss:MergeAcross"> <xsl:attribute name="table:number-columns-spanned"><xsl:value-of select="@ss:MergeAcross + 1"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="table:number-columns-spanned">1</xsl:attribute> </xsl:otherwise> </xsl:choose> <xsl:choose> <xsl:when test="@ss:MergeDown"> <xsl:attribute name="table:number-rows-spanned"><xsl:value-of select="@ss:MergeDown+1"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="table:number-rows-spanned">1</xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:if> <xsl:if test="@ss:Formula"> <!-- formula translation from Excel to Clac, quite complexive. :( glu --> <xsl:variable name="calc-formula"> <xsl:call-template name="translate-expression"> <xsl:with-param name="cell-row-pos" select="$row-pos"/> <xsl:with-param name="cell-column-pos" select="$column-pos"/> <xsl:with-param name="expression" select="@ss:Formula"/> </xsl:call-template> </xsl:variable> <xsl:attribute name="table:formula"><xsl:value-of select="$calc-formula"/></xsl:attribute> </xsl:if> <xsl:variable name="style-id"> <xsl:value-of select="@ss:StyleID"/> </xsl:variable> <xsl:if test="ss:Data"> <xsl:variable name="data-format"> <xsl:value-of select="/ss:Workbook/ss:Styles/ss:Style[@ss:ID=$style-id]/ss:NumberFormat/@ss:Format"/> </xsl:variable> <xsl:choose> <xsl:when test="ss:Data/@ss:Type = 'Number'"> <xsl:choose> <xsl:when test="$data-format = 'Percent' or contains( $data-format, '%')"> <xsl:attribute name="table:value-type">percentage</xsl:attribute> </xsl:when> <xsl:when test="contains( $data-format, 'currency') or ( contains( $data-format, '[$') and (not( contains( $data-format, '[$-') )) )"> <xsl:attribute name="table:value-type">currency</xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="table:value-type">float</xsl:attribute> </xsl:otherwise> </xsl:choose> <xsl:attribute name="table:value"><xsl:value-of select="ss:Data"/></xsl:attribute> </xsl:when> <xsl:when test="ss:Data/@ss:Type = 'DateTime'"> <xsl:choose> <xsl:when test="(contains( $data-format, 'Date') or contains($data-format,'y') or contains($data-format,'g') or contains($data-format,'d') or contains($data-format,'e') or starts-with( substring( ss:Data, 11), 'T00:00:00.000' ) ) and (not (contains( $data-format, 'Time') ) )"> <xsl:attribute name="table:value-type">date</xsl:attribute> <xsl:attribute name="table:date-value"><xsl:value-of select="substring(ss:Data, 1, 19)"/></xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="table:value-type">time</xsl:attribute> <xsl:attribute name="table:time-value"><xsl:value-of select="concat('P',substring(ss:Data, 11, 3), 'H', substring(ss:Data, 15, 2), 'M', substring(ss:Data, 18,2), ',', substring-after( ss:Data, '.'), '000S')"/></xsl:attribute> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:when test="ss:Data/@ss:Type = 'Boolean'"> <xsl:attribute name="table:value-type">boolean</xsl:attribute> </xsl:when> <xsl:when test="ss:Data/@ss:Type = 'String'"> <xsl:attribute name="table:value-type">string</xsl:attribute> </xsl:when> <xsl:otherwise/> </xsl:choose> </xsl:if> <xsl:apply-templates select="ss:Comment"/> <xsl:if test="ss:Data"> <text:p> <xsl:choose> <xsl:when test="ss:Data/descendant-or-self::*[(namespace-uri()='http://www.w3.org/TR/REC-html40' or child::html:*) and text() and string-length(.) > 0]"> <xsl:for-each select="descendant-or-self::*[(namespace-uri()='http://www.w3.org/TR/REC-html40' or child::html:*) and text() and string-length(.) > 0]"> <text:span text:style-name="{concat( $style-id, 'T', count(preceding::ss:Data[child::html:*]), '_', position())}"> <xsl:value-of select="text()"/> </text:span> </xsl:for-each> </xsl:when> <xsl:when test="contains( /ss:Workbook/ss:Styles/ss:Style[@ss:ID=$style-id]/ss:Font/@ss:VerticalAlign, 'script')"> <text:span text:style-name="{concat( $style-id, 'T0')}"> <xsl:choose> <xsl:when test="@ss:HRef"> <text:a xlink:href="{@ss:HRef}"> <xsl:value-of select="ss:Data"/> </text:a> </xsl:when> <xsl:otherwise> <xsl:value-of select="ss:Data"/> </xsl:otherwise> </xsl:choose> </text:span> </xsl:when> <xsl:when test="@ss:HRef"> <text:a xlink:href="{@ss:HRef}"> <xsl:value-of select="ss:Data"/> </text:a> </xsl:when> <xsl:otherwise> <xsl:value-of select="ss:Data"/> </xsl:otherwise> </xsl:choose> </text:p> </xsl:if> </xsl:element> <xsl:if test="@ss:MergeAcross"> <xsl:element name="table:covered-table-cell"> <xsl:if test="@ss:MergeAcross > 1"> <xsl:attribute name="table:number-columns-repeated"><xsl:value-of select="@ss:MergeAcross"/></xsl:attribute> </xsl:if> </xsl:element> </xsl:if> <xsl:if test="position() = count(../ss:Cell) and ../../../x:ConditionalFormatting"> <!-- at the last position of the Cell tag,inspecting the following cell before condition-row-col-pos-max.tom chen --> <xsl:call-template name="get-cell-span-in"> <xsl:with-param name="row-pos" select="$row-pos"/> <xsl:with-param name="c-start" select="$column-pos + 1"/> <xsl:with-param name="c-end" select="$col-pos-max"/> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> </xsl:call-template> </xsl:if> </xsl:for-each> </xsl:when> <xsl:otherwise> <xsl:variable name="current" select="concat('R',$row-pos,'C')"/> <xsl:if test="contains($condition-pos-str,$current)"> <xsl:call-template name="get-cell-span-in"> <xsl:with-param name="row-pos" select="$row-pos"/> <xsl:with-param name="c-start" select="1"/> <xsl:with-param name="c-end" select="$col-pos-max"/> <xsl:with-param name="condition-pos-str" select="$condition-pos-str"/> </xsl:call-template> </xsl:if> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="condition-row-column-string"> <!-- returns a string with structer,including row\column position by extraction from x:ConditionalFormatting.tom chen --> <xsl:param name="last"/> <xsl:param name="total"/> <xsl:param name="index"/> <xsl:variable name="table-pos" select="count(preceding-sibling::ss:Worksheet)+1"/> <xsl:variable name="current"> <xsl:call-template name="parse-range"> <xsl:with-param name="range-value" select="./x:ConditionalFormatting[position() = $index]/x:Range"/> </xsl:call-template> </xsl:variable> <xsl:variable name="current-value" select="concat('(',$table-pos,'-',$index,':', $current,');')"/> <xsl:if test="$index < $total"> <xsl:call-template name="condition-row-column-string"> <xsl:with-param name="last" select="concat($last, $current-value)"/> <xsl:with-param name="total" select="$total"/> <xsl:with-param name="index" select="$index + 1"/> </xsl:call-template> </xsl:if> <xsl:if test="$index = $total"> <xsl:value-of select="concat($last, $current-value)"/> </xsl:if> </xsl:template> <xsl:template name="parse-range"> <!-- returns a string,input param:the value of x:Range.tom chen --> <xsl:param name="range-value"/> <xsl:param name="last"/> <xsl:variable name="first-pit"> <xsl:choose> <xsl:when test="contains($range-value,',')"> <xsl:value-of select="substring-before($range-value,',')"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$range-value"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="current"> <xsl:choose> <xsl:when test="contains($first-pit,':')"> <xsl:variable name="R-start" select="substring-before(substring-after($first-pit,'R'),'C')"/> <xsl:variable name="C-start" select="substring-before(substring-after($first-pit,'C'),':')"/> <xsl:variable name="second-pit" select="substring-after($first-pit,':')"/> <xsl:variable name="R-end" select="substring-before(substring-after($second-pit,'R'),'C')"/> <xsl:variable name="C-end" select="substring-after($second-pit,'C')"/> <xsl:variable name="the-str"> <xsl:call-template name="condition-rc-str"> <xsl:with-param name="r-start" select="$R-start"/> <xsl:with-param name="r-end" select="$R-end"/> <xsl:with-param name="c-start" select="$C-start"/> <xsl:with-param name="c-end" select="$C-end"/> <xsl:with-param name="last" select="''"/> </xsl:call-template> </xsl:variable> <xsl:value-of select="$the-str"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="concat($first-pit,',')"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:choose> <xsl:when test="contains($range-value,',')"> <xsl:call-template name="parse-range"> <xsl:with-param name="range-value" select="substring-after($range-value,',')"/> <xsl:with-param name="last" select="concat($last,$current)"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:value-of select="concat($last,$current)"/> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="condition-rc-str"> <!-- dealing the range of row\column.tom chen --> <xsl:param name="r-start"/> <xsl:param name="r-end"/> <xsl:param name="c-start"/> <xsl:param name="c-end"/> <xsl:param name="last"/> <xsl:variable name="current"> <xsl:call-template name="condition-c-str"> <xsl:with-param name="rc-str" select="concat('R',$r-start)"/> <xsl:with-param name="start" select="$c-start"/> <xsl:with-param name="end" select="$c-end"/> <xsl:with-param name="last" select="''"/> </xsl:call-template> </xsl:variable> <xsl:if test="$r-start < $r-end"> <xsl:call-template name="condition-rc-str"> <xsl:with-param name="r-start" select="$r-start + 1"/> <xsl:with-param name="r-end" select="$r-end"/> <xsl:with-param name="c-start" select="$c-start"/> <xsl:with-param name="c-end" select="$c-end"/> <xsl:with-param name="last" select="concat($last,$current)"/> </xsl:call-template> </xsl:if> <xsl:if test="$r-start = $r-end"> <xsl:value-of select="concat($last,$current)"/> </xsl:if> </xsl:template> <xsl:template name="condition-c-str"> <xsl:param name="rc-str"/> <xsl:param name="start"/> <xsl:param name="end"/> <xsl:param name="last"/> <xsl:variable name="current" select="concat($rc-str,'C',$start,',')"/> <xsl:if test="$start < $end"> <xsl:call-template name="condition-c-str"> <xsl:with-param name="rc-str" select="$rc-str"/> <xsl:with-param name="start" select="$start + 1"/> <xsl:with-param name="end" select="$end"/> <xsl:with-param name="last" select="concat($last,$current)"/> </xsl:call-template> </xsl:if> <xsl:if test="$start = $end"> <xsl:value-of select="concat($last,$current)"/> </xsl:if> </xsl:template> <xsl:template match="ss:Data"> <xsl:for-each select="descendant-or-self::*[(namespace-uri()='http://www.w3.org/TR/REC-html40' or child::html:*) and text() and string-length(.)>0]"> <style:style style:name="{concat(ancestor::ss:Cell/@ss:StyleID,'T',count(preceding::ss:Data[child::html:*]), '_', position())}" style:family="text"> <xsl:element name="style:properties"> <xsl:if test="ancestor-or-self::html:Font/@html:Face"> <xsl:attribute name="style:font-name"><xsl:value-of select="ancestor-or-self::html:Font/@html:Face"/></xsl:attribute> </xsl:if> <xsl:if test="ancestor-or-self::html:Font/@html:Size"> <xsl:attribute name="fo:font-size"><xsl:value-of select="concat(ancestor-or-self::html:Font/@html:Size,'pt')"/></xsl:attribute> <xsl:attribute name="style:font-size-asian"><xsl:value-of select="concat(ancestor-or-self::html:Font/@html:Size,'pt')"/></xsl:attribute> <xsl:attribute name="style:font-size-complex"><xsl:value-of select="concat(ancestor-or-self::html:Font/@html:Size,'pt')"/></xsl:attribute> </xsl:if> <xsl:if test="ancestor-or-self::html:Font/@html:Color"> <xsl:attribute name="fo:color"><xsl:value-of select="ancestor-or-self::html:Font/@html:Color"/></xsl:attribute> </xsl:if> <xsl:if test="ancestor-or-self::html:B"> <xsl:attribute name="fo:font-weight">bold</xsl:attribute> <xsl:attribute name="style:font-weight-asian">bold</xsl:attribute> <xsl:attribute name="style:font-weight-complex">bold</xsl:attribute> </xsl:if> <xsl:if test="ancestor-or-self::html:I"> <xsl:attribute name="fo:font-style">italic</xsl:attribute> <xsl:attribute name="style:font-style-asian">italic</xsl:attribute> <xsl:attribute name="style:font-style-complex">italic</xsl:attribute> </xsl:if> <xsl:if test="ancestor-or-self::html:U"> <xsl:attribute name="style:text-underline">single</xsl:attribute> </xsl:if> <xsl:if test="ancestor-or-self::html:S"> <xsl:attribute name="style:text-crossing-out">single-line</xsl:attribute> </xsl:if> <xsl:if test="ancestor-or-self::html:Sup"> <xsl:attribute name="style:text-position">33% 58%</xsl:attribute> </xsl:if> <xsl:if test="ancestor-or-self::html:Sub"> <xsl:attribute name="style:text-position">-33% 58%</xsl:attribute> </xsl:if> </xsl:element> </style:style> </xsl:for-each> </xsl:template> <xsl:template name="get-pos-content"> <xsl:param name="content"/> <xsl:param name="pos"/> <xsl:choose> <xsl:when test="$pos = 'left'"> <xsl:choose> <xsl:when test="contains($content,'&C')"> <xsl:value-of select="substring-before( substring-after( $content, '&L'), '&C')"/> </xsl:when> <xsl:when test="contains($content,'&R')"> <xsl:value-of select="substring-before( substring-after( $content, '&L'), '&R')"/> </xsl:when> <xsl:when test="contains($content,'&L')"> <xsl:value-of select="substring-after( $content, '&L')"/> </xsl:when> <xsl:otherwise/> </xsl:choose> </xsl:when> <xsl:when test="$pos = 'center'"> <xsl:choose> <xsl:when test="contains($content,'&R')"> <xsl:value-of select="substring-before( substring-after( $content, '&C'), '&R')"/> </xsl:when> <xsl:when test="contains($content,'&C')"> <xsl:value-of select="substring-after( $content, '&C')"/> </xsl:when> <xsl:when test="contains($content,'&L')"/> <xsl:otherwise> <xsl:value-of select="$content"/> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:when test="$pos = 'right'"> <xsl:value-of select="substring-after( $content, '&R')"/> </xsl:when> </xsl:choose> </xsl:template> <xsl:template match="@x:Data"> <xsl:variable name="style-name-header"> <xsl:value-of select="concat(ancestor::ss:Worksheet/@ss:Name, substring(name(..),1,1))"/> </xsl:variable> <xsl:variable name="left-style-data"> <xsl:call-template name="get-pos-content"> <xsl:with-param name="content" select="."/> <xsl:with-param name="pos" select="'left'"/> </xsl:call-template> </xsl:variable> <xsl:if test="string-length($left-style-data)>0 and contains($left-style-data,'&')"> <xsl:call-template name="create-header-footer-style"> <xsl:with-param name="style-name-header" select="concat($style-name-header,'L')"/> <xsl:with-param name="style-data" select="$left-style-data"/> <xsl:with-param name="index" select="0"/> <xsl:with-param name="current-pos" select="1"/> </xsl:call-template> </xsl:if> <xsl:variable name="center-style-data"> <xsl:call-template name="get-pos-content"> <xsl:with-param name="content" select="."/> <xsl:with-param name="pos" select="'center'"/> </xsl:call-template> </xsl:variable> <xsl:if test="string-length($center-style-data)>0 and contains($center-style-data,'&')"> <xsl:call-template name="create-header-footer-style"> <xsl:with-param name="style-name-header" select="concat($style-name-header,'C')"/> <xsl:with-param name="style-data" select="$center-style-data"/> <xsl:with-param name="index" select="0"/> <xsl:with-param name="current-pos" select="1"/> </xsl:call-template> </xsl:if> <xsl:variable name="right-style-data"> <xsl:call-template name="get-pos-content"> <xsl:with-param name="content" select="."/> <xsl:with-param name="pos" select="'right'"/> </xsl:call-template> </xsl:variable> <xsl:if test="string-length($right-style-data)>0 and contains($right-style-data,'&')"> <xsl:call-template name="create-header-footer-style"> <xsl:with-param name="style-name-header" select="concat($style-name-header,'R')"/> <xsl:with-param name="style-data" select="$right-style-data"/> <xsl:with-param name="index" select="0"/> <xsl:with-param name="current-pos" select="1"/> </xsl:call-template> </xsl:if> </xsl:template> <xsl:template name="create-header-footer-style"> <xsl:param name="style-name-header"/> <xsl:param name="style-data"/> <xsl:param name="index"/> <xsl:param name="current-pos"/> <xsl:variable name="current-style-data"> <xsl:value-of select="substring($style-data,$current-pos)"/> </xsl:variable> <xsl:choose> <xsl:when test="starts-with($current-style-data,'&D') or starts-with($current-style-data,'&T') or starts-with($current-style-data,'&P') or starts-with($current-style-data,'&N') or starts-with($current-style-data,'&A') or starts-with($current-style-data,'&F') or starts-with($current-style-data,'&Z')"> <xsl:call-template name="create-header-footer-style"> <xsl:with-param name="style-name-header" select="$style-name-header"/> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="index" select="$index"/> <xsl:with-param name="current-pos" select="$current-pos +2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with($current-style-data,'&')"> <xsl:element name="style:style"> <xsl:attribute name="style:name"><xsl:value-of select="concat($style-name-header,$index)"/></xsl:attribute> <xsl:attribute name="style:family">text</xsl:attribute> <xsl:element name="style:properties"> <xsl:call-template name="process-header-footer-style-properties"> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="current-pos" select="$current-pos"/> </xsl:call-template> </xsl:element> </xsl:element> <xsl:variable name="next-style-header-pos"> <xsl:call-template name="get-current-content-pos"> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="current-pos" select="$current-pos"/> </xsl:call-template> </xsl:variable> <xsl:call-template name="create-header-footer-style"> <xsl:with-param name="style-name-header" select="$style-name-header"/> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="index" select="$index+1"/> <xsl:with-param name="current-pos" select="$next-style-header-pos"/> </xsl:call-template> </xsl:when> <xsl:when test="contains($current-style-data,'&')"> <xsl:variable name="temp" select="substring-before($current-style-data,'&')"/> <xsl:call-template name="create-header-footer-style"> <xsl:with-param name="style-name-header" select="$style-name-header"/> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="index" select="$index"/> <xsl:with-param name="current-pos" select="string-length($temp)+$current-pos"/> </xsl:call-template> </xsl:when> <xsl:otherwise/> </xsl:choose> </xsl:template> <xsl:template name="process-header-footer-style-properties"> <xsl:param name="style-data"/> <xsl:param name="current-pos"/> <xsl:variable name="current-style-data"> <xsl:value-of select="substring($style-data,$current-pos)"/> </xsl:variable> <xsl:choose> <!-- stack operations necessary. glu --> <xsl:when test="starts-with($current-style-data,'&"')"> <xsl:attribute name="style:font-name"><xsl:value-of select="substring-before(substring-after($current-style-data,'&"'),',')"/></xsl:attribute> <xsl:if test="contains(substring-before(substring-after($current-style-data,','),'"'),'Bold')"> <xsl:attribute name="fo:font-weight">bold</xsl:attribute> <xsl:attribute name="style:font-weight-asian">bold</xsl:attribute> <xsl:attribute name="style:font-weight-complex">bold</xsl:attribute> </xsl:if> <xsl:if test="contains(substring-before(substring-after($current-style-data,','),'"'),'Italic')"> <xsl:attribute name="fo:font-style">italic</xsl:attribute> <xsl:attribute name="style:font-style-asian">italic</xsl:attribute> <xsl:attribute name="style:font-style-complex">italic</xsl:attribute> </xsl:if> <xsl:variable name="temp" select="substring-before(substring($style-data,$current-pos+2),'"')"/> <xsl:call-template name="process-header-footer-style-properties"> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="current-pos" select="string-length($temp)+$current-pos+3"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with($current-style-data,'&0') or starts-with($current-style-data,'&1') or starts-with($current-style-data,'&2') or starts-with($current-style-data,'&3') or starts-with($current-style-data,'&4') or starts-with($current-style-data,'&5') or starts-with($current-style-data,'&6') or starts-with($current-style-data,'&7') or starts-with($current-style-data,'&8') or starts-with($current-style-data,'&9')"> <xsl:variable name="font-size-length"> <xsl:call-template name="get-digit-length"> <xsl:with-param name="complexive-string" select="substring-after($current-style-data,'&')"/> </xsl:call-template> </xsl:variable> <xsl:attribute name="fo:font-size"><xsl:value-of select="concat(substring($current-style-data,2,$font-size-length),'pt')"/></xsl:attribute> <xsl:call-template name="process-header-footer-style-properties"> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="current-pos" select="$current-pos + 1 + $font-size-length"/> </xsl:call-template> </xsl:when> <!-- dont' consider tangled or adjoined '&X' and '&Y', '&U' & '&E', processing-check is necessary, too complex. :( glu --> <xsl:when test="starts-with($current-style-data,'&X')"> <xsl:variable name="superscript-count-before"> <xsl:call-template name="get-substyle-count-in-data"> <xsl:with-param name="style-data" select="substring($style-data,1,$current-pos)"/> <xsl:with-param name="substyle" select="'&X'"/> <xsl:with-param name="count" select="0"/> </xsl:call-template> </xsl:variable> <xsl:if test="$superscript-count-before mod 2 = 0"> <xsl:attribute name="style:text-position">33% 58%</xsl:attribute> </xsl:if> <xsl:call-template name="process-header-footer-style-properties"> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="current-pos" select="$current-pos + 2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with($current-style-data,'&B')"> <xsl:variable name="subscript-count-before"> <xsl:call-template name="get-substyle-count-in-data"> <xsl:with-param name="style-data" select="substring($style-data,1,$current-pos)"/> <xsl:with-param name="substyle" select="'&B'"/> <xsl:with-param name="count" select="0"/> </xsl:call-template> </xsl:variable> <xsl:if test="$subscript-count-before mod 2 = 0"> <xsl:attribute name="fo:font-weight">bold</xsl:attribute> <xsl:attribute name="style:font-weight-asian">bold</xsl:attribute> <xsl:attribute name="style:font-weight-complex">bold</xsl:attribute> </xsl:if> <xsl:call-template name="process-header-footer-style-properties"> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="current-pos" select="$current-pos + 2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with($current-style-data,'&Y')"> <xsl:variable name="subscript-count-before"> <xsl:call-template name="get-substyle-count-in-data"> <xsl:with-param name="style-data" select="substring($style-data,1,$current-pos)"/> <xsl:with-param name="substyle" select="'&Y'"/> <xsl:with-param name="count" select="0"/> </xsl:call-template> </xsl:variable> <xsl:if test="$subscript-count-before mod 2 = 0"> <xsl:attribute name="style:text-position">-33% 58%</xsl:attribute> </xsl:if> <xsl:call-template name="process-header-footer-style-properties"> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="current-pos" select="$current-pos + 2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with($current-style-data,'&S')"> <xsl:variable name="strikethrough-count-before"> <xsl:call-template name="get-substyle-count-in-data"> <xsl:with-param name="style-data" select="substring($style-data,1,$current-pos)"/> <xsl:with-param name="substyle" select="'&S'"/> <xsl:with-param name="count" select="0"/> </xsl:call-template> </xsl:variable> <xsl:if test="$strikethrough-count-before mod 2 = 0"> <xsl:attribute name="style:text-crossing-out">single-line</xsl:attribute> </xsl:if> <xsl:call-template name="process-header-footer-style-properties"> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="current-pos" select="$current-pos + 2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with($current-style-data,'&U')"> <xsl:variable name="single-underline-count-before"> <xsl:call-template name="get-substyle-count-in-data"> <xsl:with-param name="style-data" select="substring($style-data,1,$current-pos)"/> <xsl:with-param name="substyle" select="'&U'"/> <xsl:with-param name="count" select="0"/> </xsl:call-template> </xsl:variable> <xsl:if test="$single-underline-count-before mod 2 = 0"> <xsl:attribute name="style:text-underline">single</xsl:attribute> </xsl:if> <xsl:call-template name="process-header-footer-style-properties"> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="current-pos" select="$current-pos + 2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with($current-style-data,'&E')"> <xsl:variable name="double-underline-count-before"> <xsl:call-template name="get-substyle-count-in-data"> <xsl:with-param name="style-data" select="substring($style-data,1,$current-pos)"/> <xsl:with-param name="substyle" select="'&E'"/> <xsl:with-param name="count" select="0"/> </xsl:call-template> </xsl:variable> <xsl:if test="$double-underline-count-before mod 2 = 0"> <xsl:attribute name="style:text-underline">double</xsl:attribute> </xsl:if> <xsl:call-template name="process-header-footer-style-properties"> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="current-pos" select="$current-pos + 2"/> </xsl:call-template> </xsl:when> <xsl:otherwise/> </xsl:choose> </xsl:template> <xsl:template name="get-substyle-count-in-data"> <xsl:param name="style-data"/> <xsl:param name="substyle"/> <xsl:param name="count"/> <xsl:choose> <xsl:when test="contains($style-data,$substyle)"> <xsl:call-template name="get-substyle-count-in-data"> <xsl:with-param name="style-data" select="substring-after($style-data,$substyle)"/> <xsl:with-param name="substyle" select="$substyle"/> <xsl:with-param name="count" select="$count+1"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:value-of select="$count"/> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="get-current-content-pos"> <xsl:param name="style-data"/> <xsl:param name="current-pos"/> <xsl:variable name="current-style-data"> <xsl:value-of select="substring($style-data,$current-pos)"/> </xsl:variable> <xsl:choose> <xsl:when test="starts-with($current-style-data,'&X') or starts-with($current-style-data,'&Y') or starts-with($current-style-data,'&S') or starts-with($current-style-data,'&U') or starts-with($current-style-data,'&E') or starts-with($current-style-data,'&B')"> <xsl:call-template name="get-current-content-pos"> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="current-pos" select="$current-pos+2"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with($current-style-data,'&0') or starts-with($current-style-data,'&1') or starts-with($current-style-data,'&2') or starts-with($current-style-data,'&3') or starts-with($current-style-data,'&4') or starts-with($current-style-data,'&5') or starts-with($current-style-data,'&6') or starts-with($current-style-data,'&7') or starts-with($current-style-data,'&8') or starts-with($current-style-data,'&9')"> <xsl:variable name="font-size-length"> <xsl:call-template name="get-digit-length"> <xsl:with-param name="complexive-string" select="substring-after($current-style-data,'&')"/> </xsl:call-template> </xsl:variable> <xsl:call-template name="get-current-content-pos"> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="current-pos" select="$current-pos+1+$font-size-length"/> </xsl:call-template> </xsl:when> <xsl:when test="starts-with($current-style-data,'&"')"> <xsl:variable name="temp" select="substring-before(substring($style-data,$current-pos+2),'"')"/> <xsl:call-template name="get-current-content-pos"> <xsl:with-param name="style-data" select="$style-data"/> <xsl:with-param name="current-pos" select="string-length($temp)+$current-pos+3"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:value-of select="$current-pos"/> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="translate-expression"> <xsl:param name="cell-row-pos"/> <xsl:param name="cell-column-pos"/> <xsl:param name="expression"/> <xsl:choose> <xsl:when test="contains($expression,'R') and contains(substring-after($expression,'R'),'C')"> <!-- process the row part. glu --> <xsl:variable name="after-R"> <xsl:value-of select="substring(substring-after($expression,'R'),1,1)"/> </xsl:variable> <xsl:choose> <!-- found one cell unit. glu --> <xsl:when test="$after-R='C' or $after-R='[' or $after-R='0' or $after-R='1' or $after-R='2' or $after-R='3' or $after-R='4' or $after-R='5' or $after-R='6' or $after-R='7' or $after-R='8' or $after-R='9'"> <xsl:value-of select="translate( substring-before($expression,'R'),',!', ';.')"/> <xsl:variable name="row-pos"> <xsl:choose> <xsl:when test="$after-R='['"> <xsl:value-of select="$cell-row-pos+substring-before( substring-after($expression,'R['),']')"/> </xsl:when> <xsl:when test="$after-R='C'"> <xsl:value-of select="$cell-row-pos"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="substring-before(substring-after($expression,'R'),'C')"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="row-pos-style"> <xsl:choose> <xsl:when test="$after-R='[' or $after-R='C'">relative</xsl:when> <xsl:otherwise>absolute</xsl:otherwise> </xsl:choose> </xsl:variable> <!-- process the column part. glu --> <xsl:variable name="after-C"> <xsl:value-of select="substring(substring-after(substring-after($expression,'R'),'C'),1,1)"/> </xsl:variable> <xsl:variable name="column-digit-length"> <xsl:choose> <xsl:when test="$after-C='0' or $after-C='1' or $after-C='2' or $after-C='3' or $after-C='4' or $after-C='5' or $after-C='6' or $after-C='7' or $after-C='8' or $after-C='9'"> <xsl:call-template name="get-digit-length"> <xsl:with-param name="complexive-string" select="substring-after(substring-after($expression,'R'),'C')"/> </xsl:call-template> </xsl:when> </xsl:choose> </xsl:variable> <xsl:variable name="column-pos"> <xsl:choose> <xsl:when test="$after-C='['"> <xsl:value-of select="$cell-column-pos + substring-before(substring-after(substring-after($expression,'R'),'C['),']')"/> </xsl:when> <xsl:when test="$after-C='0' or $after-C='1' or $after-C='2' or $after-C='3' or $after-C='4' or $after-C='5' or $after-C='6' or $after-C='7' or $after-C='8' or $after-C='9'"> <xsl:value-of select="substring(substring-after(substring-after($expression,'R'),'C'),1,$column-digit-length)"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$cell-column-pos"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="column-pos-style"> <xsl:choose> <xsl:when test="$after-C='0' or $after-C='1' or $after-C='2' or $after-C='3' or $after-C='4' or $after-C='5' or $after-C='6' or $after-C='7' or $after-C='8' or $after-C='9'">absolute</xsl:when> <xsl:otherwise>relative</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:call-template name="translate-unit"> <xsl:with-param name="column-number" select="$column-pos"/> <xsl:with-param name="row-number" select="$row-pos"/> <xsl:with-param name="column-pos-style" select="$column-pos-style"/> <xsl:with-param name="row-pos-style" select="$row-pos-style"/> </xsl:call-template> <xsl:variable name="post-unit"> <xsl:choose> <xsl:when test="$column-pos-style='absolute'"> <xsl:value-of select="substring(substring-after(substring-after($expression,'R'),'C'),$column-digit-length+1)"/> </xsl:when> <xsl:when test="$after-C='['"> <xsl:value-of select="substring-after(substring-after(substring-after($expression,'R'),'C['),']')"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="substring-after(substring-after($expression,'R'),'C')"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:call-template name="translate-expression"> <xsl:with-param name="cell-row-pos" select="$cell-row-pos"/> <xsl:with-param name="cell-column-pos" select="$cell-column-pos"/> <xsl:with-param name="expression" select="$post-unit"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:value-of select="concat(translate( substring-before($expression,'R'),',!', ';.'),'R')"/> <xsl:call-template name="translate-expression"> <xsl:with-param name="cell-row-pos" select="$cell-row-pos"/> <xsl:with-param name="cell-column-pos" select="$cell-column-pos"/> <xsl:with-param name="expression" select="substring-after($expression,'R')"/> </xsl:call-template> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:value-of select="translate( $expression,',!', ';.')"/> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="translate-unit"> <xsl:param name="column-number"/> <xsl:param name="row-number"/> <xsl:param name="column-pos-style"/> <xsl:param name="row-pos-style"/> <xsl:variable name="column-number1"> <xsl:value-of select="floor( $column-number div 26 )"/> </xsl:variable> <xsl:variable name="column-number2"> <xsl:value-of select="$column-number mod 26"/> </xsl:variable> <xsl:variable name="column-character1"> <xsl:call-template name="number-to-character"> <xsl:with-param name="number" select="$column-number1"/> </xsl:call-template> </xsl:variable> <xsl:variable name="column-character2"> <xsl:call-template name="number-to-character"> <xsl:with-param name="number" select="$column-number2"/> </xsl:call-template> </xsl:variable> <!-- position styles are 'absolute' or 'relative', glu --> <xsl:choose> <xsl:when test="$column-pos-style = 'absolute'"> <xsl:value-of select="concat( '$', $column-character1, $column-character2)"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="concat( $column-character1, $column-character2)"/> </xsl:otherwise> </xsl:choose> <xsl:choose> <xsl:when test="$row-pos-style ='absolute'"> <xsl:value-of select="concat( '$', $row-number)"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$row-number"/> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="number-to-character"> <xsl:param name="number"/> <xsl:choose> <xsl:when test="$number = 0"/> <xsl:when test="$number = 1">A</xsl:when> <xsl:when test="$number = 2">B</xsl:when> <xsl:when test="$number = 3">C</xsl:when> <xsl:when test="$number = 4">D</xsl:when> <xsl:when test="$number = 5">E</xsl:when> <xsl:when test="$number = 6">F</xsl:when> <xsl:when test="$number = 7">G</xsl:when> <xsl:when test="$number = 8">H</xsl:when> <xsl:when test="$number = 9">I</xsl:when> <xsl:when test="$number = 10">J</xsl:when> <xsl:when test="$number = 11">K</xsl:when> <xsl:when test="$number = 12">L</xsl:when> <xsl:when test="$number = 13">M</xsl:when> <xsl:when test="$number = 14">N</xsl:when> <xsl:when test="$number = 15">O</xsl:when> <xsl:when test="$number = 16">P</xsl:when> <xsl:when test="$number = 17">Q</xsl:when> <xsl:when test="$number = 18">R</xsl:when> <xsl:when test="$number = 19">S</xsl:when> <xsl:when test="$number = 20">T</xsl:when> <xsl:when test="$number = 21">U</xsl:when> <xsl:when test="$number = 22">V</xsl:when> <xsl:when test="$number = 23">W</xsl:when> <xsl:when test="$number = 24">X</xsl:when> <xsl:when test="$number = 25">Y</xsl:when> <xsl:when test="$number = 26">Z</xsl:when> <xsl:otherwise/> </xsl:choose> </xsl:template> <xsl:template name="get-digit-length"> <xsl:param name="complexive-string"/> <xsl:variable name="first-char"> <xsl:value-of select="substring( $complexive-string, 1, 1)"/> </xsl:variable> <xsl:choose> <xsl:when test="$first-char = '1' or $first-char = '2' or $first-char = '3' or $first-char = '4' or $first-char = '5' or $first-char = '6' or $first-char = '7' or $first-char = '8' or $first-char = '9' or $first-char = '0' "> <xsl:variable name="temp"> <xsl:call-template name="get-digit-length"> <xsl:with-param name="complexive-string" select="substring( $complexive-string, 2)"/> </xsl:call-template> </xsl:variable> <xsl:value-of select="$temp+1"/> </xsl:when> <xsl:otherwise>0</xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="current-cell-pos"> <xsl:param name="current-cell-list"/> <xsl:choose> <xsl:when test="$current-cell-list"> <xsl:variable name="current-cell" select="$current-cell-list[position()=last()]"/> <xsl:choose> <xsl:when test="$current-cell/@ss:Index"> <xsl:choose> <xsl:when test="$current-cell/@ss:MergeAcross"> <xsl:value-of select="$current-cell/@ss:MergeAcross + $current-cell/@ss:Index"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$current-cell/@ss:Index"/> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:variable name="preceding-cell"> <xsl:call-template name="current-cell-pos"> <xsl:with-param name="current-cell-list" select="$current-cell-list[position()!=last()]"/> </xsl:call-template> </xsl:variable> <xsl:choose> <xsl:when test="$current-cell/@ss:MergeAcross"> <xsl:value-of select="1 + $current-cell/@ss:MergeAcross + $preceding-cell"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="1 + $preceding-cell"/> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise>0</xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template match="ss:Comment"> <xsl:element name="office:annotation"> <xsl:if test="@ss:Author"> <xsl:attribute name="office:author"><xsl:value-of select="@ss:Author"/></xsl:attribute> </xsl:if> <xsl:if test="@ss:ShowAlways = '1'"> <xsl:attribute name="office:display">true</xsl:attribute> </xsl:if> <xsl:if test="ss:Data"> <text:p> <xsl:value-of select="ss:Data"/> </text:p> </xsl:if> </xsl:element> </xsl:template> <xsl:template name="Names"> <xsl:if test="//ss:NamedRange"> <table:named-expressions> <xsl:for-each select="//ss:NamedRange"> <xsl:choose> <xsl:when test="contains( @ss:RefersTo, '!R')"> <xsl:variable name="referto"> <xsl:call-template name="translate-expression"> <xsl:with-param name="cell-row-pos" select="0"/> <xsl:with-param name="cell-column-pos" select="0"/> <xsl:with-param name="expression" select="@ss:RefersTo"/> </xsl:call-template> </xsl:variable> <xsl:element name="table:named-range"> <xsl:attribute name="table:name"><xsl:value-of select="@ss:Name"/></xsl:attribute> <xsl:attribute name="table:base-cell-address"><xsl:value-of select="translate( $referto, '=', '$')"/></xsl:attribute> <xsl:attribute name="table:cell-range-address"><xsl:value-of select="translate( $referto, '=', '$')"/></xsl:attribute> <xsl:if test="@ss:Name = 'Print_Area'"> <xsl:attribute name="table:range-usable-as">print-range</xsl:attribute> </xsl:if> </xsl:element> </xsl:when> <xsl:otherwise> <xsl:variable name="expression-name"> <xsl:value-of select="@ss:Name"/> </xsl:variable> <xsl:element name="table:named-expression"> <xsl:attribute name="table:name"><xsl:value-of select="@ss:Name"/></xsl:attribute> <!-- just set '$Sheet1.$A$1' as named-expressions virtual base-cell-address. glu --> <xsl:attribute name="table:base-cell-address">$Sheet1.$A$1</xsl:attribute> <xsl:attribute name="table:expression"><xsl:value-of select="substring( @ss:RefersTo, 2)"/></xsl:attribute> </xsl:element> </xsl:otherwise> </xsl:choose> </xsl:for-each> </table:named-expressions> </xsl:if> </xsl:template> <xsl:template match="x:AutoFilter"> <xsl:element name="table:database-range"> <xsl:attribute name="table:name"><xsl:value-of select="concat(../@ss:Name,'_',@x:Range)"/></xsl:attribute> <xsl:variable name="range"> <xsl:call-template name="translate-expression"> <xsl:with-param name="cell-row-pos" select="0"/> <xsl:with-param name="cell-column-pos" select="0"/> <xsl:with-param name="expression" select="@x:Range"/> </xsl:call-template> </xsl:variable> <xsl:attribute name="table:target-range-address"><xsl:value-of select="concat('$',../@ss:Name,'.',$range)"/></xsl:attribute> <xsl:attribute name="table:display-filter-buttons">true</xsl:attribute> </xsl:element> </xsl:template> <xsl:template name="set-calculation"> <xsl:element name="table:calculation-settings"> <xsl:if test="/ss:Workbook/x:ExcelWorkbook/x:PrecisionAsDisplayed"> <xsl:attribute name="table:precision-as-shown">true</xsl:attribute> </xsl:if> <xsl:if test="/ss:Workbook/x:ExcelWorkbook/x:Date1904"> <table:null-date table:date-value="1904-01-01"/> </xsl:if> <xsl:element name="table:iteration"> <xsl:if test="/ss:Workbook/x:ExcelWorkbook/x:Iteration"> <xsl:attribute name="table:status">enable</xsl:attribute> </xsl:if> <xsl:if test="/ss:Workbook/x:ExcelWorkbook/x:MaxIterations"> <xsl:attribute name="table:steps"><xsl:value-of select="/ss:Workbook/x:ExcelWorkbook/x:MaxIterations"/></xsl:attribute> </xsl:if> <xsl:if test="/ss:Workbook/x:ExcelWorkbook/x:MaxChange"> <xsl:attribute name="table:maximum-difference"><xsl:value-of select="/ss:Workbook/x:ExcelWorkbook/x:MaxChange"/></xsl:attribute> </xsl:if> </xsl:element> </xsl:element> </xsl:template> </xsl:stylesheet> 
