Helllo,
Was following below guide to create xml file from calc.
was working fine till i was creteing username password for examination software.
now would like to create question paper for the same but i don’t understand it create xml file but “table:table-cell” oder change it self.
In ods file “inline_answers” is set to cell 8 but its fetch value from “description” cell 10, and then other row restuls mess.
All order changes.
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" exclude-result-prefixes="office table text">
<xsl:template match="/">
<root>
<xsl:apply-templates select="/*/office:body" />
</root>
</xsl:template>
<xsl:template match="office:body">
<xsl:apply-templates />
</xsl:template>
<xsl:template match="office:spreadsheet">
<xsl:apply-templates />
</xsl:template>
<xsl:template match="office:spreadsheet/table:table">
<xsl:for-each select="table:table-row[position() > 1]">
<question>
<enabled><xsl:value-of select="table:table-cell[2]/text:p" /></enabled>
<type><xsl:value-of select="table:table-cell[3]/text:p" /></type>
<difficulty><xsl:value-of select="table:table-cell[4]/text:p" /></difficulty>
<position><xsl:value-of select="table:table-cell[5]/text:p" /></position>
<timer><xsl:value-of select="table:table-cell[6]/text:p" /></timer>
<fullscreen><xsl:value-of select="table:table-cell[7]/text:p" /></fullscreen>
<inline_answers><xsl:value-of select="table:table-cell[8]/text:p" /></inline_answers>
<auto_next><xsl:value-of select="table:table-cell[9]/text:p" /></auto_next>
<description><xsl:value-of select="table:table-cell[10]/text:p" /></description>
<explanation><xsl:value-of select="table:table-cell[11]/text:p" /></explanation>
<answer>
<enabled><xsl:value-of select="table:table-cell[13]/text:p" /></enabled>
<isright><xsl:value-of select="table:table-cell[14]/text:p" /></isright>
<position><xsl:value-of select="table:table-cell[15]/text:p" /></position>
<keyboard_key><xsl:value-of select="table:table-cell[16]/text:p" /></keyboard_key>
<description><xsl:value-of select="table:table-cell[17]/text:p" /></description>
<explanation><xsl:value-of select="table:table-cell[18]/text:p" /></explanation>
</answer>
<answer>
<enabled><xsl:value-of select="table:table-cell[20]/text:p" /></enabled>
<isright><xsl:value-of select="table:table-cell[21]/text:p" /></isright>
<position><xsl:value-of select="table:table-cell[22]/text:p" /></position>
<keyboard_key><xsl:value-of select="table:table-cell[23]/text:p" /></keyboard_key>
<description><xsl:value-of select="table:table-cell[24]/text:p" /></description>
<explanation><xsl:value-of select="table:table-cell[25]/text:p" /></explanation>
</answer>
<answer>
<enabled><xsl:value-of select="table:table-cell[27]/text:p" /></enabled>
<isright><xsl:value-of select="table:table-cell[28]/text:p" /></isright>
<position><xsl:value-of select="table:table-cell[29]/text:p" /></position>
<keyboard_key><xsl:value-of select="table:table-cell[30]/text:p" /></keyboard_key>
<description><xsl:value-of select="table:table-cell[31]/text:p" /></description>
<explanation><xsl:value-of select="table:table-cell[32]/text:p" /></explanation>
</answer>
<answer>
<enabled><xsl:value-of select="table:table-cell[34]/text:p" /></enabled>
<isright><xsl:value-of select="table:table-cell[35]/text:p" /></isright>
<position><xsl:value-of select="table:table-cell[36]/text:p" /></position>
<keyboard_key><xsl:value-of select="table:table-cell[37]/text:p" /></keyboard_key>
<description><xsl:value-of select="table:table-cell[38]/text:p" /></description>
<explanation><xsl:value-of select="table:table-cell[39]/text:p" /></explanation>
</answer>
</question>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>[Untitled 1.ods|attachment](upload://ekstFat3cUFFJsioqokkKPD0KlC.ods)
Out put below
<?xml version="1.0"?>
-<root>
-<question>
<enabled>true</enabled>
<type>single</type>
<difficulty>1</difficulty>
<position/>
<timer>0</timer>
<fullscreen>false</fullscreen>
<inline_answers>अर्थ का उचित अनेकार्थी शब्द चुनिए - </inline_answers>
<auto_next/>
<description>true</description>
<explanation/>
-<answer>
<enabled/>
<isright>true</isright>
<position>false</position>
<keyboard_key/>
<description>स) एक व्यायाम </description>
<explanation/>
</answer>
-<answer>
<enabled>false</enabled>
<isright/>
<position>ब) किनारा </position>
<keyboard_key/>
<description>true</description>
<explanation>false</explanation>
</answer>
-<answer>
<enabled>अ ) अमर </enabled>
<isright/>
<position/>
<keyboard_key/>
<description/>
<explanation/>
</answer>
-<answer>
<enabled/>
<isright/>
<position/>
<keyboard_key/>
<description/>
<explanation/>
</answer>
</question>
-<question>
<enabled>true</enabled>
<type>single</type>
<difficulty>1</difficulty>
<position/>
<timer>0</timer>
<fullscreen>false</fullscreen>
<inline_answers>test1</inline_answers>
<auto_next/>
<description>true</description>
<explanation/>
-<answer>
<enabled/>
<isright>true</isright>
<position>false</position>
<keyboard_key/>
<description>B</description>
<explanation/>
</answer>
-<answer>
<enabled>false</enabled>
<isright/>
<position>C</position>
<keyboard_key/>
<description>true</description>
<explanation>false</explanation>
</answer>
-<answer>
<enabled>D</enabled>
<isright/>
<position/>
<keyboard_key/>
<description/>
<explanation/>
</answer>
-<answer>
<enabled/>
<isright/>
<position/>
<keyboard_key/>
<description/>
<explanation/>
</answer>
</question>
-<question>
<enabled>true</enabled>
<type>single</type>
<difficulty>1</difficulty>
<position/>
<timer>0</timer>
<fullscreen>false</fullscreen>
<inline_answers>test2</inline_answers>
<auto_next/>
<description>true</description>
<explanation/>
-<answer>
<enabled/>
<isright>true</isright>
<position>false</position>
<keyboard_key/>
<description>B</description>
<explanation/>
</answer>
-<answer>
<enabled>false</enabled>
<isright/>
<position>C</position>
<keyboard_key/>
<description>true</description>
<explanation>false</explanation>
</answer>
-<answer>
<enabled>D</enabled>
<isright/>
<position/>
<keyboard_key/>
<description/>
<explanation/>
</answer>
-<answer>
<enabled/>
<isright/>
<position/>
<keyboard_key/>
<description/>
<explanation/>
</answer>
</question>
-<question>
<enabled>true</enabled>
<type>single</type>
<difficulty>1</difficulty>
<position/>
<timer>0</timer>
<fullscreen>false</fullscreen>
<inline_answers>ઉનાળો આવતા લોકો કેવાં કપડાં પહેરવાં લાગ્યા ? </inline_answers>
<auto_next/>
<description>true</description>
<explanation/>
-<answer>
<enabled/>
<isright>true</isright>
<position>false</position>
<keyboard_key/>
<description>રંગબેરંગી </description>
<explanation/>
</answer>
-<answer>
<enabled>false</enabled>
<isright/>
<position>રેશમી </position>
<keyboard_key/>
<description>true</description>
<explanation>false</explanation>
</answer>
-<answer>
<enabled>test96</enabled>
<isright/>
<position/>
<keyboard_key/>
<description/>
<explanation/>
</answer>
-<answer>
<enabled/>
<isright/>
<position/>
<keyboard_key/>
<description/>
<explanation/>
</answer>
</question>
-<question>
<enabled>2</enabled>
<type>3</type>
<difficulty>4</difficulty>
<position>5</position>
<timer>6</timer>
<fullscreen>7</fullscreen>
<inline_answers>8</inline_answers>
<auto_next>9</auto_next>
<description>10</description>
<explanation/>
-<answer>
<enabled/>
<isright/>
<position/>
<keyboard_key/>
<description/>
<explanation/>
</answer>
-<answer>
<enabled/>
<isright/>
<position/>
<keyboard_key/>
<description/>
<explanation/>
</answer>
-<answer>
<enabled/>
<isright/>
<position/>
<keyboard_key/>
<description/>
<explanation/>
</answer>
-<answer>
<enabled/>
<isright/>
<position/>
<keyboard_key/>
<description/>
<explanation/>
</answer>
</question>
</root>