Re: Duplicate PageSettingsBlock record

[Yegor Kozlov <ye...@dinom.ru>]

This is a known issue and we are working on it. Can you attach the problem file to  Bug 48026:
https://issues.apache.org/bugzilla/show_bug.cgi?id=48026
It would be helpful to include it in our test cases.

Do you have any insight on the origin of this file? Was it created in Excel? Which version?

Yegor

> Dear POI Team,
> 
>  
> 
> I have a web application which uses poi api to write to an Excel file. I am
> processing a file created in Excel with 97-2003 compatibility. However, the
> new version of this file creates the error trace given below. 
> 
>  
> 
> I am using the POI-3.5 which I downloaded today and titled to be the
> 20090928 version. 
> 
>  
> 
> I have seen that there is a previous thread on this. As suggested, I checked
> for the application server (this is not my development environment) and no
> other poi api jars can be found on the server. Therefore I am assuming that
> this is not the problem. 
> 
>  
> 
> Do you have any other suggestions? Is there a straightforward way to make
> the file available to you?
> 
>  
> 
> Thank you. 
> 
>  
> 
> Irem 
> 
>  
> 
> org.apache.poi.hssf.record.RecordFormatException: Duplicate
> PageSettingsBlock record (sid=0x89c)
> 
>       at
> org.apache.poi.hssf.record.aggregates.PageSettingsBlock.checkNotPresent(Page
> SettingsBlock.java:227)
> 
>       at
> org.apache.poi.hssf.record.aggregates.PageSettingsBlock.readARecord(PageSett
> ingsBlock.java:215)
> 
>       at
> org.apache.poi.hssf.record.aggregates.PageSettingsBlock.addLateRecords(PageS
> ettingsBlock.java:639)
> 
>       at org.apache.poi.hssf.model.Sheet.<init>(Sheet.java:222)
> 
>       at org.apache.poi.hssf.model.Sheet.createSheet(Sheet.java:158)
> 
>       at
> org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:286)
> 
>       at
> org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:200)
> 
>       at
> org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:182)
> 
>       at list.CreateNew.writeQuotation(CreateNew.java:210)
> 
>       at list.CreateNew.CreateQuotationDR(CreateNew.java:176)
> 
>       at list.CreateNew.processRequest(CreateNew.java:84)
> 
>       at list.CreateNew.doPost(CreateNew.java:139)
> 
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
> 
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
> 
>       at
> org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFi
> lterChain.java:427)
> 
>       at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
> va:315)
> 
>       at
> org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContext
> Valve.java:287)
> 
>       at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
> va:218)
> 
>       at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648
> )
> 
>       at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593
> )
> 
>       at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
> 
>       at
> com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLock
> ingStandardPipeline.java:98)
> 
>       at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:222
> )
> 
>       at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648
> )
> 
>       at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593
> )
> 
>       at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587)
> 
>       at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1096)
> 
>       at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
> :166)
> 
>       at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648
> )
> 
>       at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593
> )
> 
>       at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587)
> 
>       at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1096)
> 
>       at
> org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:288)
> 
>       at
> com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(
> DefaultProcessorTask.java:647)
> 
>       at
> com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(Defa
> ultProcessorTask.java:579)
> 
>       at
> com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(Defaul
> tProcessorTask.java:831)
> 
>       at
> com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTas
> k(DefaultReadTask.java:341)
> 
>       at
> com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadT
> ask.java:263)
> 
>       at
> com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadT
> ask.java:214)
> 
>       at
> com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
> 
>       at
> com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerTh
> read.java:106)
> 
>  
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org