Thanks for your answer. The problem is that my program is running on normal desktop systems (with about 128 mb RAM). I can increase the heap size but because of swapping the system will nearly freeze when the vm reaches about 80 mb.
Well, I have to insert a warning message about that (I've already got one for that stupid 65,000 row limit). Thanks again for your answer. JOERN -----Urspr�ngliche Nachricht----- Von: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] Gesendet: Samstag, 30. M�rz 2002 23:34 An: poi users Betreff: Re: Is XML a solution for creating large excel-files? Why can't you just pass -Xmx100m or something to your JVM and allocate more memory? The serializer is no work around for this problem. Large files require a lot of memory. The structure of an XLS file requires us to keep the whole thing in memory before writing it out (sorry to say). The reason being that there are upstream pointers in the file to downstream portions. So we have to have the whole thing constructed before we know where the latter item is going to be. If you're not working in an applet then supplying a batch file that relies on JAVA_HOME and shell script is standard practice. -Andy On Fri, 2002-03-29 at 06:09, J�rn Heid wrote: > > I have to create some excel files with up to 65,000 rows (excel limit) and > about 20 cols. > Using the HSSF API will result in a out of memory exception (well, it should > work on clients so I can't set up the heap size as swapping will freeze my > program). > > So perhaps it would be possible to use the HSSF serializer. I just have to > generate SAX events - and if it's possible - the result can be continously > written to disc. > > > So, here's question No. 1: Will this work (will the memory consumption keep > low)? > > > To make a first test I took an xml example from Cocoon 2.0.2 (attached) and > the following, simple source code: > > // I used 1.2dev from Sourceforge and Cocoon 2.0.2-libs and Xerces 2.0.1 > import net.sourceforge.poi.serialization.HSSFSerializer; > import java.io.*; > import javax.xml.parsers.*; > import org.xml.sax.*; > > public class SerializerTest { > > public static void main (String[] argv) throws Exception { > HSSFSerializer hssf = new HSSFSerializer(); > hssf.setOutputStream (new FileOutputStream ("result.xls")); > > XMLReader reader = SAXParserFactory.newInstance ().newSAXParser > ().getXMLReader (); > reader.setContentHandler (hssf); > reader.parse (new InputSource (new FileInputStream ("test.xml"))); > } > } > > When running everything works fine (no exception). When opening the > result.xls Excel says that the file is corrupted (attached). > > > So I tried the lib drom Cocoon 2 (jakarta-poi-1.5-dev-20020315.jar). > > After changing the source code (just altered the first import statement) I > receive the following error: > > Exception in thread "main" java.lang.NullPointerException > at > org.apache.cocoon.serialization.ElementProcessorSerializer.startEleme > nt(ElementProcessorSerializer.java:490) > at > org.apache.xerces.parsers.AbstractSAXParser.startElement(AbstractSAXP > arser.java:434) > at > org.apache.xerces.impl.XMLNamespaceBinder.startElement(XMLNamespaceBi > nder.java:571) > at > org.apache.xerces.impl.dtd.XMLDTDValidator.startElement(XMLDTDValidat > or.java:796) > at > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElemen > t(XMLDocumentFragmentScannerImpl.java:752) > at > org.apache.xerces.impl.XMLDocumentScannerImpl$ContentDispatcher.scanR > ootElementHook(XMLDocumentScannerImpl.java:927) > at > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContent > Dispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1519) > at > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(XM > LDocumentFragmentScannerImpl.java:333) > at > org.apache.xerces.parsers.StandardParserConfiguration.parse(StandardP > arserConfiguration.java:529) > at > org.apache.xerces.parsers.StandardParserConfiguration.parse(StandardP > [...] > > > Please help. > > Regards, > JOERN > > ---- > > <?xml version="1.0"?> > <gmr:Workbook xmlns:gmr="http://www.gnome.org/gnumeric/v7";> > <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>Jody Goldberg</gmr:val-string> > </gmr:Item> > </gmr:Summary> > <gmr:SheetNameIndex> > <gmr:SheetName>Sheet 0</gmr:SheetName> > </gmr:SheetNameIndex> > <gmr:Names/> > <gmr:Geometry Width="1166" Height="752"/> > <gmr:Sheets> > <gmr:Sheet DisplayFormulas="false" HideZero="false" HideGrid="false" HideColHeader="false" HideRowHeader="false" DisplayOutlines="true" OutlineSymbolsBelow="true" OutlineSymbolsRight="true"> > <gmr:Name>Sheet 0</gmr:Name> > <gmr:MaxCol>6</gmr:MaxCol> > <gmr:MaxRow>20</gmr:MaxRow> > <gmr:Zoom>1.000000</gmr:Zoom> > <gmr:Names/> > <gmr:PrintInformation> > <gmr:Margins> > <gmr:top Points="72" PrefUnit="in"/> > <gmr:bottom Points="72" PrefUnit="in"/> > <gmr:left Points="54" PrefUnit="in"/> > <gmr:right Points="54" PrefUnit="in"/> > <gmr:header Points="36" PrefUnit="in"/> > <gmr:footer Points="36" PrefUnit="in"/> > </gmr:Margins> > <gmr:vcenter value="0"/> > <gmr:hcenter value="0"/> > <gmr:grid value="0"/> > <gmr:even_if_only_styles value="1"/> > <gmr:monochrome value="0"/> > <gmr:draft value="0"/> > <gmr:titles value="0"/> > <gmr:repeat_top value=""/> > <gmr:repeat_left value=""/> > <gmr:order>d_then_r</gmr:order> > <gmr:orientation>landscape</gmr:orientation> > <gmr:Header Left="" Middle="&[TAB]" Right=""/> > <gmr:Footer Left="" Middle="Page &[PAGE]" Right=""/> > <gmr:paper>US-Letter</gmr:paper> > </gmr:PrintInformation> > <gmr:Styles> > <gmr:StyleRegion startCol="1" startRow="13" endCol="1" endRow="13"> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="6" Color="0:0:0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="2" startRow="14" endCol="3" endRow="14"> > <gmr:Style HAlign="1" VAlign="4" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="#,##0_);[red](#,##0)"> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="1" startRow="1" endCol="1" endRow="1"> > <gmr:Style HAlign="1" VAlign="1" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="#,##0_);[red](#,##0)"> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="6" Color="0:0:0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="6" Color="0:0:0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="0" startRow="13" endCol="0" endRow="13"> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="1" startRow="14" endCol="1" endRow="14"> > <gmr:Style HAlign="1" VAlign="4" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="#,##0_);[red](#,##0)"> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="6" Color="0:0:0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="0" startRow="15" endCol="3" endRow="15"> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="0" startRow="14" endCol="0" endRow="14"> > <gmr:Style HAlign="4" VAlign="4" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="8" startRow="0" endCol="15" endRow="255"> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="16" startRow="0" endCol="63" endRow="4095"> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="7" startRow="0" endCol="7" endRow="31"> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="6" startRow="21" endCol="6" endRow="31"> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="6" startRow="0" endCol="6" endRow="19"> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="4" startRow="0" endCol="5" endRow="31"> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="6" startRow="20" endCol="6" endRow="20"> > <gmr:Style HAlign="1" VAlign="4" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="4" startRow="32" endCol="7" endRow="255"> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="0" startRow="16" endCol="3" endRow="255"> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="0" startRow="256" endCol="15" endRow="4095"> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="64" startRow="0" endCol="255" endRow="65535"> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="2" startRow="2" endCol="3" endRow="12"> > <gmr:Style HAlign="1" VAlign="1" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="#,##0_);[red](#,##0)"> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="1" startRow="0" endCol="3" endRow="0"> > <gmr:Style HAlign="8" VAlign="4" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="0" startRow="4096" endCol="63" endRow="65535"> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="1" startRow="2" endCol="1" endRow="12"> > <gmr:Style HAlign="1" VAlign="1" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="#,##0_);[red](#,##0)"> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="6" Color="0:0:0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="0" startRow="1" endCol="0" endRow="12"> > <gmr:Style HAlign="4" VAlign="4" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="2" startRow="13" endCol="3" endRow="13"> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="0" startRow="0" endCol="0" endRow="0"> > <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General"> > <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > <gmr:StyleRegion startCol="2" startRow="1" endCol="3" endRow="1"> > <gmr:Style HAlign="1" VAlign="1" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="#,##0_);[red](#,##0)"> > <gmr:Font Unit="14" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font> > <gmr:StyleBorder> > <gmr:Top Style="6" Color="0:0:0"/> > <gmr:Bottom Style="0"/> > <gmr:Left Style="0"/> > <gmr:Right Style="0"/> > <gmr:Diagonal Style="0"/> > <gmr:Rev-Diagonal Style="0"/> > </gmr:StyleBorder> > </gmr:Style> > </gmr:StyleRegion> > </gmr:Styles> > <gmr:Cols DefaultSizePts="48"> > <gmr:ColInfo No="0" Unit="97" MarginA="1" MarginB="2"/> > <gmr:ColInfo No="1" Unit="80" MarginA="1" MarginB="2" Count="4"/> > <gmr:ColInfo No="6" Unit="48" MarginA="2" MarginB="2"/> > </gmr:Cols> > <gmr:Rows DefaultSizePts="12.8"> > <gmr:RowInfo No="0" Unit="20" MarginA="1" MarginB="0" Count="15"/> > <gmr:RowInfo No="20" Unit="18" MarginA="0" MarginB="0"/> > </gmr:Rows> > <gmr:Selections CursorCol="2" CursorRow="28"> > <gmr:Selection startCol="2" startRow="28" endCol="2" endRow="28"/> > </gmr:Selections> > <gmr:Objects> > <gmr:SheetObjectFilled Type="102" Width="1" ObjectBound="D15:E16" ObjectOffset="0.00934579409658909 0.0370370373129845 0.359375 0.0588235296308994" ObjectAnchorType="0 0 0 0" Direction="255"/> > </gmr:Objects> > <gmr:Cells> > <gmr:Cell Col="1" Row="0" ValueType="60"> > <gmr:Content>DOS</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="2" Row="0" ValueType="60"> > <gmr:Content>Linux</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="3" Row="0" ValueType="60"> > <gmr:Content>SCO</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="0" Row="1" ValueType="60"> > <gmr:Content>Jannuary</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="1" Row="1" ValueType="30"> > <gmr:Content>1000</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="2" Row="1" ValueType="30"> > <gmr:Content>900</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="3" Row="1" ValueType="30"> > <gmr:Content>500</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="0" Row="2" ValueType="60"> > <gmr:Content>February</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="1" Row="2" ValueType="30"> > <gmr:Content>900</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="2" Row="2" ValueType="30"> > <gmr:Content>2500</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="3" Row="2" ValueType="30"> > <gmr:Content>300</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="0" Row="3" ValueType="60"> > <gmr:Content>March</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="1" Row="3" ValueType="30"> > <gmr:Content>800</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="2" Row="3" ValueType="30"> > <gmr:Content>4100</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="3" Row="3" ValueType="30"> > <gmr:Content>100</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="0" Row="4" ValueType="60"> > <gmr:Content>April</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="1" Row="4" ValueType="30"> > <gmr:Content>700</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="2" Row="4" ValueType="30"> > <gmr:Content>5700</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="3" Row="4" ValueType="30"> > <gmr:Content>-100</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="0" Row="5" ValueType="60"> > <gmr:Content>May</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="1" Row="5" ValueType="30"> > <gmr:Content>600</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="2" Row="5" ValueType="30"> > <gmr:Content>7300</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="3" Row="5" ValueType="30"> > <gmr:Content>-300</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="0" Row="6" ValueType="60"> > <gmr:Content>June</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="1" Row="6" ValueType="30"> > <gmr:Content>500</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="2" Row="6" ValueType="30"> > <gmr:Content>8900</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="3" Row="6" ValueType="30"> > <gmr:Content>-500</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="0" Row="7" ValueType="60"> > <gmr:Content>July</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="1" Row="7" ValueType="30"> > <gmr:Content>400</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="2" Row="7" ValueType="30"> > <gmr:Content>10500</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="3" Row="7" ValueType="30"> > <gmr:Content>-700</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="0" Row="8" ValueType="60"> > <gmr:Content>August</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="1" Row="8" ValueType="30"> > <gmr:Content>300</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="2" Row="8" ValueType="30"> > <gmr:Content>12100</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="3" Row="8" ValueType="30"> > <gmr:Content>-900</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="0" Row="9" ValueType="60"> > <gmr:Content>September</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="1" Row="9" ValueType="30"> > <gmr:Content>200</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="2" Row="9" ValueType="30"> > <gmr:Content>13700</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="3" Row="9" ValueType="30"> > <gmr:Content>-1100</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="0" Row="10" ValueType="60"> > <gmr:Content>October</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="1" Row="10" ValueType="30"> > <gmr:Content>100</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="2" Row="10" ValueType="30"> > <gmr:Content>15300</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="3" Row="10" ValueType="30"> > <gmr:Content>-1300</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="0" Row="11" ValueType="60"> > <gmr:Content>November</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="1" Row="11" ValueType="30"> > <gmr:Content>0</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="2" Row="11" ValueType="30"> > <gmr:Content>16900</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="3" Row="11" ValueType="30"> > <gmr:Content>-1500</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="0" Row="12" ValueType="60"> > <gmr:Content>December</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="1" Row="12" ValueType="30"> > <gmr:Content>-100</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="2" Row="12" ValueType="30"> > <gmr:Content>18500</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="3" Row="12" ValueType="30"> > <gmr:Content>-1700</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="0" Row="14" ValueType="60"> > <gmr:Content>Totals:</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="1" Row="14"> > <gmr:Content>=sum(B2:B13)</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="2" Row="14"> > <gmr:Content>=sum(C1:C13)</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="3" Row="14"> > <gmr:Content>=sum(D2:D13)</gmr:Content> > </gmr:Cell> > <gmr:Cell Col="6" Row="20" ValueType="60"> > <gmr:Content>Bad year</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> -- http://www.superlinksoftware.com http://jakarta.apache.org/poi - port of Excel/Word/OLE 2 Compound Document format to java 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
