[PATCH] updating the gnumeric schema

["Andrew C. Oliver" <acoliver nc rr com>]

Hi All,

This is directed mostly at the POI people but I'll cc the gnumeric list
since they may prefer to do this themselves (and faster than I for
sure).

I've tried and tried to update and validate the gnumeric schema and
followed these http://xml.apache.org/xerces-j/faq-general.html and
Marc's directions to the best of my abillity, but I'm unable to find
some way of sanity checking or validating my schema. (even with full
schema support and validation on it said even the most egregiously wrong
things were correct -- go figure).  What is worse for some reason the
gnome CVS repostiory thinks I'm doggy doo and now won't let me connect
to generate a new patch for mergedregions.  

Anyhow, I've spent way too much time on what should have been a short
and simple task and I'm now going to go into heads down mode basically. 
I'm way behind where I want to be on updating the POI::HSSFSerializer to
support all POI::HSSF 1.0 features.  (And possibly merged cells if it
"feels" right).  

So if someone else wants to give it a try, attached is my patch (I
stopped with one element cause I wanted to sanity check first).  If
you're able to run this against the gnumeric schema and validate it then
great.

Basically I'm trying to add SheetLayout and MergedRegions stuff which is
currently NOT in the schema.

If someone can give me a babytalk step by step on how to do this
(Validate a schema via command line) then I'll be happy to do it myself,
but I'd be happy to have someone else contribute.

BTW this isn't a criticism against anything or one, just frustration at
my own incompetence in this particular issue.  Back to working the
POI::HSSFSerializer... 

Thanks,

Andy "Misguided Java Developer" 
(hehehe:
http://cvs.gnome.org/lxr/source/gnumeric/plugins/excel/README - guess
what Michael....we did it)

PS.

If someone can write me a simple program that I can use with 0 effort
that takes an infile and schemafile as input disregards any pedantic
issues with location and just validates the sucker what a pain in the
butt I'll be SOOoo greatful ).  I tried but no luck there either.

------------------------------------------------------------------


example MERGED REGIONS (didn't get to this yet):

      <gmr:MergedRegions>
        <gmr:Merge>B1:C1</gmr:Merge>
      </gmr:MergedRegions>


PATCH (SheetLayout):

Index: gnumeric.xsd
===================================================================
RCS file: /cvs/gnome/gnumeric/gnumeric.xsd,v
retrieving revision 1.5
diff -u -r1.5 gnumeric.xsd
--- gnumeric.xsd        2001/10/25 19:25:27     1.5
+++ gnumeric.xsd        2002/01/07 15:46:16
@@ -166,6 +166,7 @@
                         <xsd:element name="Selections"     
type="gmr:Selections"/>
                         <xsd:element name="Objects"        
type="gmr:Objects" minOccurs="0" maxOccurs="1"/>
                         <xsd:element name="Cells"          
type="gmr:Cells"/>
+                        <xsd:element name="SheetLayout"    
type="gmr:SheetLayout"/>
                         <xsd:element name="Solver"         
type="gmr:Solver"/>                     </xsd:sequence>
                         <!-- note: xsd:boolean values can be true,
false, 1, 0;@@ -719,6 +720,10 @@
             <xsd:enumeration value="80"/> <!-- array     -->
         </xsd:restriction>
     </xsd:simpleType>
+
+    <xsd:complexType name="SheetLayout">
+       <xsd:attribute name="TopLeft" type="xsd:integer"
use="required"/>
+    </xsd:complexType>

     <xsd:complexType name="Solver">
         <xsd:sequence>



-- 
www.superlinksoftware.com
www.sourceforge.net/projects/poi - serialize XML as XLS via Cocoon 2
http://developer.java.sun.com/developer/bugParade/bugs/4487555.html 
                        - fix java generics!


The avalanche has already started. It is too late for the pebbles to
vote.
-Ambassador Kosh