poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Avik Sengupta <a...@apache.org>
Subject Re: Formula / Graph Support
Date Fri, 21 Feb 2003 15:52:22 GMT
On Fri, 2003-02-21 at 21:09, Reto Badertscher wrote:
> 
> We are producing spreadsheets by taking a template with Formulas and Graphs 
> and generate data cells at runtime. It works good, but one has to be careful 
> how to enter the formulas. 
> Using the 1.9.0-dev-200030129 version we found the following issues:
> - cells which are copied (copy/paste) do not work, we must manually change 
> each formula
Thats a known limitation. Excel uses certain optimisations for
copy/pasted formulas that we dont read at the moment. 

> - when the formula contains a  'DSUM' ('DBSUMME' in the german excel version) 
> copied formulas do work
> - when such a formula does end with a division (e.g. '=DSUM(xx!A:AC)/100') 
> the template could not be read. See the stacktrace below.
Maybe you could add this to bugzilla with a minimal file that exhibits
this behaviour. 

> 
> If it helps i can provide a sample template
> 
> Reto
> 
> Stacktrace when reading template 
> java.lang.reflect.InvocationTargetException
> 	at sun.reflect.GeneratedConstructorAccessor23.newInstance(Unknown Source)
> 	at 
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> 	at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
> 	at 
> org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:254)
> 	at 
> org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:192)
> 	at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:187)
> 	at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:154)
> 	at sims.model.report.XL_COUGraph.write(XL_COUGraph.java:121)
> 	at sims.model.report.ReportRunner.run(ReportRunner.java:46)
> 	at java.lang.Thread.run(Thread.java:536)
> Caused by: java.lang.ArrayIndexOutOfBoundsException: 55
> 	at org.apache.poi.util.LittleEndian.getNumber(LittleEndian.java:557)
> 	at org.apache.poi.util.LittleEndian.getShort(LittleEndian.java:90)
> 	at 
> org.apache.poi.hssf.record.formula.ReferencePtg.<init>(ReferencePtg.java:107)
> 	at org.apache.poi.hssf.record.formula.Ptg.createPtg(Ptg.java:210)
> 	at 
> org.apache.poi.hssf.record.FormulaRecord.getParsedExpressionTokens(FormulaRecord.java:171)
> 	at 
> org.apache.poi.hssf.record.FormulaRecord.fillFields(FormulaRecord.java:147)
> 	at org.apache.poi.hssf.record.Record.fillFields(Record.java:143)
> 	at org.apache.poi.hssf.record.Record.<init>(Record.java:105)
> 	at org.apache.poi.hssf.record.FormulaRecord.<init>(FormulaRecord.java:118)
> 	... 10 more
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 




Mime
View raw message