Attachment 46091 Details for Bug 36610 – filer to import xml data into LO spreadsheet

filer to import xml data into LO spreadsheet

xml2calc.xsl (text/xml), 10.83 KB, created by Fernand on 2011-04-26 09:13:38 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Fernand

Created: 2011-04-26 09:13:38 UTC

Size: 10.83 KB

patch

obsolete

><?xml version="1.0" encoding="UTF-8" ?>
>
>
>
>
> 
><xsl:stylesheet 
>	xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
>	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:script="http://openoffice.org/2000/script" 
>	xmlns:meta="http://openoffice.org/2000/meta" 
>	version="1.0" 
>	office:class="spreadsheet">
>	
><xsl:output method="xml" indent="yes" omit-xml-declaration="no"/>
>
>
><xsl:strip-space elements="*" />
>
>
>
><xsl:template match="/"> 
>
>
><office:document-content office:version="1.0">
>
>	<office:automatic-styles>
>		<xsl:call-template name="array_styles"/>
>	</office:automatic-styles>
>
>	<office:body>
>		<xsl:call-template name="feuille_import"/>
>	</office:body>
>
></office:document-content>
>
></xsl:template>
>
>
>
><xsl:template name="array_styles">
>
>	<style:style
>		style:name="co1"
>		style:family="table-column">
>
>		<style:properties fo:break-before="auto"
>			style:column-width="2.267cm"/>
>	</style:style>
>
>	<style:style style:name="ro1" style:family="table-row">
>
>		<style:properties style:row-height="0.427cm"
>			fo:break-before="auto"
>			style:use-optimal-row-height="true"/>
>	</style:style>
>
>	<style:style style:name="ta1" style:family="table"
>		style:master-page-name="Default">
>		<style:properties
>			table:display="true"/>
>	</style:style>
>	
></xsl:template>
>
>
>
><xsl:template name="feuille_import">
>
>
>	
>	
>	<table:table table:name="{normalize-space(name(/*))}" table:style-name="ta1">
>
>		
>		
>		<xsl:call-template name="xml_depth"/>
>		
>    
>    <xsl:call-template name="headerRow"/>
>
>    <xsl:for-each select="/*/child::*"> 
>      <xsl:call-template name="myrow"/>
>    </xsl:for-each> 
>
>	</table:table>
>
></xsl:template>
>
>
>
>
>
>
>
>
>
>
><xsl:template name="xml_depth">
>
>	
>	<table:table-column table:style-name="co1" 
>		table:default-cell-style-name="Default" >
>	</table:table-column>
>
>	
>	<table:table-column-group>
>		<xsl:for-each select="/*/child::*[1]">
>			<xsl:call-template name="plan"/>
>		</xsl:for-each> 
>	</table:table-column-group>
>
></xsl:template>
>
>
>
><xsl:template name="plan">
>
>	<xsl:for-each select="./child::*">
>		
>		<xsl:variable name="has_child" select="count(./child::*) &gt; 0"/>
>
>		
>		
>		<xsl:variable name="position_last_elmt_with_child" select="count(
>			preceding-sibling::* [count(./child::*)&gt;0] [position()=1]
>			/child::*/../preceding-sibling::node() ) + 1"/>
>
>		<xsl:choose>
>
>			
>			<xsl:when test="$has_child">
>
>				<xsl:choose>
>					
>					
>					<xsl:when test= "count(
>						preceding-sibling::*[count(./child::*)&gt;0] ) &gt; 0">
>						<table:table-column table:style-name="co1"
>							table:number-columns-repeated=
>							"{position() - $position_last_elmt_with_child}"
>							table:default-cell-style-name="Default" >
>						</table:table-column>
>					</xsl:when>
>
>					
>					<xsl:otherwise>
>						<table:table-column table:style-name="co1"
>							table:number-columns-repeated=
>							"{position()}"
>							table:default-cell-style-name="Default" >
>						</table:table-column>
>					</xsl:otherwise>
>					
>				</xsl:choose>
>				
>				
>				<table:table-column-group>
>					<xsl:call-template name="plan"/>
>				</table:table-column-group>
>
>			</xsl:when>
>
>			
>			<xsl:when test="(position() = last()) and ( not( $has_child ) )">
>
>				<xsl:choose>
>					
>					<xsl:when test= "count(
>						preceding-sibling::*[count(./child::*)&gt;0] ) &gt; 0">
>
>						<table:table-column table:style-name="co1"
>							table:number-columns-repeated=
>							"{position() - $position_last_elmt_with_child}"
>							table:default-cell-style-name="Default" >
>						</table:table-column>
>					</xsl:when>
>
>					
>					<xsl:otherwise>
>						<table:table-column table:style-name="co1"
>							table:number-columns-repeated= "{position()}"
>							table:default-cell-style-name="Default" >
>						</table:table-column>
>
>					</xsl:otherwise>
>
>				</xsl:choose>
>			</xsl:when>
>
>		</xsl:choose>
>	</xsl:for-each> 
>
></xsl:template>
>
>
>
>
>
>
>
>
>
>
>
><xsl:template name="headerRow">
>
>	<table:table-row table:style-name="ro1">
>
>				<xsl:for-each select="./*/*[1]/descendant-or-self::*"> 
>					<xsl:call-template name="headercell"/>		
>				</xsl:for-each> 
>			</table:table-row>
>
>		</xsl:template>
>
>
>		<xsl:template name="headercell">
>			<table:table-cell>
>				<text:p>
>					<xsl:value-of select="normalize-space(name())"/>
>				</text:p>
>			</table:table-cell>
>		</xsl:template>
>
>
>		
>		<xsl:template name="myrow">
>
>			<table:table-row table:style-name="ro1">
>				<xsl:for-each select="./descendant-or-self::*"> 
>					<xsl:call-template name="mycell"/>		
>				</xsl:for-each> 
>			</table:table-row>
>
>		</xsl:template>
>
>		
>		<xsl:template name="mycell">
>			<table:table-cell>
>
>				<text:p>
>					<xsl:value-of select="normalize-space(text())"/>
>					
>				</text:p>
>			</table:table-cell>
>		</xsl:template>
>
>	</xsl:stylesheet>

Actions: View

Attachments on bug 36610: 46091

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.