Ahh... Thats the first time I've ever had a good answer to that question! :-)
POI's main target is serverside. Which generally means you have a few megs to spare. (Not to say we discourage client side use, its just not optimized for client side use). A great project for someone who wanted to do so, would be to create a file-mapped feature to POI (without breaking the server version). By depending on read/write file access, you could achieve a smaller memory footprint. POI currently relies on one way streams (in and out). So it has to deal with the limitations of handling upstream pointers to downstream things by alloting enough memory to construct the entire file. I never have been particularly interested in doing this for JDK 1.22+ so it never made it into the requirements. (It would have to work in JDK 1.22+). JDK 1.4 contains structures that make this easier and more elegant. That being said, if someone took it up I'm sure we'd accept the donation. -Andy On Sun, 2002-03-31 at 15:56, J�rn Heid wrote: > If you want to know it.... > Those data are measurements from a nuclear power plant for a visualisation > (no critical data of course ;). > If you want to see for example a curve of temperatures throughout one month > you will receive a lot of data :) > Most queries result in about 300 lines but some won't... > > > -----Urspr�ngliche Nachricht----- > Von: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] > Gesendet: Sonntag, 31. M�rz 2002 10:07 > An: poi users > Betreff: 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 > -- 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
