What I hate is when people then go and print out 500 page report so that can review 2 pages of the thing.
-- Glen ----- Original Message ----- From: "Andrew C. Oliver" <[EMAIL PROTECTED]> To: "poi users" <[EMAIL PROTECTED]> Sent: Sunday, March 31, 2002 6:06 PM Subject: Re: AW: Is XML a solution for creating large excel-files? What always baffles me... is who the heck reads these long spreadsheets!? -Andy On Sun, 2002-03-31 at 02:22, J�rn Heid wrote: > 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 > -- 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
