Re: SV: SV: [xml-dev] XML=WAP? And DOA?

[John Cowan <jcowan@reutershealth.com>]

Mike Champion wrote:

> How about a simple CSV vs XML export of a realistic, non-
> trivial document/spreadsheet/etc. from a real program?  I'd 
> guess that Excel XP can do that (but I don't have it 
> installed). Can someone provide such an example?

Gnumeric's native format is gzipped XML, and it can
handle both Excel 95 and CSV formats.  I am not a spreadsheet
user, so don't have any "realistic" ones lying around;
however, here is a spreadsheet wherein A1 = 3, A2 = 4,
and A3 is the formula "A1 + A2".  Content and presentation
information are rather intermingled, but I find it fairly
readable, as XML goes.

<?xml version="1.0"?>
<gmr:Workbook xmlns:gmr="http://www.gnome.org/gnumeric/v5";>
   <gmr:Attributes>
     <gmr:Attribute>
       <gmr:name>WorkbookView::show_horizontal_scrollbar</gmr:name>
       <gmr:type>4</gmr:type>
       <gmr:value>TRUE</gmr:value>
     </gmr:Attribute>
     <gmr:Attribute>
       <gmr:name>WorkbookView::show_vertical_scrollbar</gmr:name>
       <gmr:type>4</gmr:type>
       <gmr:value>TRUE</gmr:value>
     </gmr:Attribute>
     <gmr:Attribute>
       <gmr:name>WorkbookView::show_notebook_tabs</gmr:name>
       <gmr:type>4</gmr:type>
       <gmr:value>TRUE</gmr:value>
     </gmr:Attribute>
   </gmr:Attributes>
   <gmr:Summary>
     <gmr:Item>
       <gmr:name>application</gmr:name>
       <gmr:val-string>gnumeric</gmr:val-string>
     </gmr:Item>
     <gmr:Item>
       <gmr:name>author</gmr:name>
       <gmr:val-string>John Cowan</gmr:val-string>
     </gmr:Item>
   </gmr:Summary>
   <gmr:Names/>
   <gmr:Geometry Width="0" Height="0"/>
   <gmr:Sheets>
     <gmr:Sheet>
       <gmr:Name>Sheet1</gmr:Name>
       <gmr:MaxCol>2</gmr:MaxCol>
       <gmr:MaxRow>0</gmr:MaxRow>
       <gmr:Zoom>1.000000</gmr:Zoom>
       <gmr:Names/>
       <gmr:PrintInformation>
         <gmr:PrintUnit Points="28.34645669291" 
PrefUnit="cm">top</gmr:PrintUnit>
         <gmr:PrintUnit Points="28.34645669291" 
PrefUnit="cm">bottom</gmr:PrintUn
it>
         <gmr:PrintUnit Points="28.34645669291" 
PrefUnit="cm">left</gmr:PrintUnit
 >
         <gmr:PrintUnit Points="28.34645669291" 
PrefUnit="cm">right</gmr:PrintUni
t>
         <gmr:PrintUnit Points="14.17322834646" 
PrefUnit="cm">header</gmr:PrintUn
it>
         <gmr:PrintUnit Points="14.17322834646" 
PrefUnit="cm">footer</gmr:PrintUn
it>
         <gmr:vcenter value="0"/>
         <gmr:hcenter value="0"/>
         <gmr:grid value="0"/>
         <gmr:monochrome value="0"/>
         <gmr:draft value="0"/>
         <gmr:titles value="0"/>
         <gmr:repeat_top value=""/>
         <gmr:repeat_left value=""/>
         <gmr:order>r_then_d</gmr:order>
         <gmr:orientation>landscape</gmr:orientation>
         <gmr:Header Left="" Middle="&amp;[TAB]" Right=""/>
         <gmr:Footer Left="" Middle="Page &amp;[PAGE]" Right=""/>
         <gmr:paper>A4</gmr:paper>
       </gmr:PrintInformation>
       <gmr:Cols DefaultSizePts="48">
         <gmr:ColInfo No="0" Unit="48" MarginA="2" MarginB="2" 
HardSize="0" Hidde
n="0" Count="3"/>
       </gmr:Cols>
       <gmr:Rows DefaultSizePts="12.75">
         <gmr:RowInfo No="0" Unit="12.75" MarginA="1" MarginB="0" 
HardSize="0" Hi
dden="0"/>
       </gmr:Rows>
       <gmr:Selections CursorCol="2" CursorRow="1">
         <gmr:Selection startCol="2" startRow="1" endCol="2" endRow="1"/>
       </gmr:Selections>
       <gmr:Cells>
         <gmr:Cell Col="0" Row="0" ValueType="30">
           <gmr:Content>3</gmr:Content>
         </gmr:Cell>
         <gmr:Cell Col="1" Row="0" ValueType="30">
           <gmr:Content>4</gmr:Content>
         </gmr:Cell>
         <gmr:Cell Col="2" Row="0">
           <gmr:Content>=A1+B1</gmr:Content>
         </gmr:Cell>
       </gmr:Cells>
       <gmr:Solver TargetCol="-1" TargetRow="-1" ProblemType="1" Inputs=""/>
     </gmr:Sheet>
   </gmr:Sheets>
   <gmr:UIData SelectedTab="0"/>
</gmr:Workbook>

-- 
Not to perambulate             || John Cowan <jcowan@reutershealth.com>
    the corridors               || http://www.reutershealth.com
during the hours of repose     || http://www.ccil.org/~cowan
    in the boots of ascension.  \\ Sign in Austrian ski-resort hotel