To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97864 Issue #|97864 Summary|Save -Export with XSLT selected cal value Component|Spreadsheet Version|OOO300m9 Platform|PC URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|hasler
------- Additional comments from [email protected] Thu Jan 8 12:50:20 +0000 2009 ------- Hello, i find a bug in save-Export. when you imported the data and than save export data. you can see in the export file that the last cols of the first secounds rows dont export data in export file. Data xml file <?xml version="1.0" encoding="UTF-8"?> <TravelLine> <Taetigkeiten> <InsertUpdateTaetigkeit firmenId="1" taetigkeitsId="--" gesperrt="0" vorschlagswert="0"> </InsertUpdateTaetigkeit> <InsertUpdateTaetigkeit firmenId="1" taetigkeitsId="0815" gesperrt="0" vorschlagswert="0"> </InsertUpdateTaetigkeit> <InsertUpdateTaetigkeit firmenId="1" taetigkeitsId="A" gesperrt="-1" vorschlagswert="0"> </InsertUpdateTaetigkeit> <InsertUpdateTaetigkeit firmenId="1" taetigkeitsId="I" gesperrt="-1" vorschlagswert="0"> </InsertUpdateTaetigkeit> <InsertUpdateTaetigkeit firmenId="1" taetigkeitsId="P" gesperrt="-1" vorschlagswert="0"> </InsertUpdateTaetigkeit> <InsertUpdateTaetigkeit firmenId="1" taetigkeitsId="R" gesperrt="-1" vorschlagswert="0"> </InsertUpdateTaetigkeit> <InsertUpdateTaetigkeit firmenId="1" taetigkeitsId="S" gesperrt="-1" vorschlagswert="0"> </InsertUpdateTaetigkeit> </Taetigkeiten> </TravelLine> Import XSLT <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform";> <xsl:template match="/"> <office:document-content xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink"; xmlns:dc="http://purl.org/dc/elements/1.1/"; xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:math="http://www.w3.org/1998/Math/MathML"; xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:ooo="http://openoffice.org/2004/office"; xmlns:ooow="http://openoffice.org/2004/writer"; xmlns:oooc="http://openoffice.org/2004/calc"; xmlns:dom="http://www.w3.org/2001/xml-events"; xmlns:xforms="http://www.w3.org/2002/xforms"; xmlns:xsd="http://www.w3.org/2001/XMLSchema"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; office:version="1.0"> <office:body> <office:spreadsheet> <table:table> <table:table-row> <table:table-cell> <text:p>FirmenId</text:p> </table:table-cell> <table:table-cell office:value-type="string"> <text:p>TaetigkeitsId</text:p> </table:table-cell> <table:table-cell office:value-type="string"> <text:p>Gesperrt</text:p> </table:table-cell> <table:table-cell office:value-type="string"> <text:p>Vorschlagswert</text:p> </table:table-cell> <table:table-cell office:value-type="string"> <text:p>SprachenId</text:p> </table:table-cell> <table:table-cell office:value-type="string"> <text:p>Beschreibung</text:p> </table:table-cell> </table:table-row> <xsl:for-each select="TravelLine/Taetigkeiten/InsertUpdateTaetigkeit"> <table:table-row> <!-- Insert string InsertUpdateTaetigkeit firmenId--> <table:table-cell> <text:p> <xsl:value-of select="@firmenId" /> </text:p> </table:table-cell> <!-- Insert string InsertUpdateKostenart taetigkeitsId--> <table:table-cell> <text:p> <xsl:value-of select="@taetigkeitsId" /> </text:p> </table:table-cell> <!-- Insert string InsertUpdateKostenart vorschlagswert--> <table:table-cell> <text:p> <xsl:value-of select="@vorschlagswert" /> </text:p> </table:table-cell> <!-- Insert string InsertUpdateKostenart gesperrt--> <table:table-cell> <text:p> <xsl:value-of select="@gesperrt" /> </text:p> </table:table-cell> </table:table-row> </xsl:for-each> </table:table> </office:spreadsheet> </office:body> </office:document-content> </xsl:template> </xsl:stylesheet> Export XSLT File <?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:output method = "xml" indent = "yes" encoding = "UTF-8" omit-xml-declaration = "no"/> <!-- Process the document model --> <xsl:template match="/"> <TravelLine> <Taetigkeiten> <!-- Process all tables --> <xsl:apply-templates select="//table:table"/> </Taetigkeiten> </TravelLine> </xsl:template> <xsl:template match="table:table"> <xsl:for-each select="table:table-row"> <xsl:if test="position()>1"> <InsertUpdateTaetigkeit> <xsl:for-each select="table:table-cell"> <xsl:choose> <xsl:when test="position()=1"> <xsl:attribute name="firmenId"><xsl:value-of select="text:p"/></xsl:attribute> </xsl:when> <xsl:when test="position()=2"> <xsl:attribute name="taetigkeitsId"><xsl:value-of select="text:p"/></xsl:attribute> </xsl:when> <xsl:when test="position()=3"> <xsl:attribute name="gesperrt"><xsl:value-of select="text:p"/></xsl:attribute> </xsl:when> <xsl:when test="position()=4"> <xsl:attribute name="vorschlagswert"><xsl:value-of select="text:p"/></xsl:attribute> </xsl:when> </xsl:choose> </xsl:for-each> </InsertUpdateTaetigkeit> </xsl:if> </xsl:for-each> </xsl:template> </xsl:stylesheet> thx and regards Frank --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
