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
result.xls
Description: MS-Excel spreadsheet
<?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>
