You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2016/12/29 09:09:26 UTC

[Bug 60528] New: Duplicate PageSettingsBlock Record

https://bz.apache.org/bugzilla/show_bug.cgi?id=60528

            Bug ID: 60528
           Summary: Duplicate PageSettingsBlock Record
           Product: POI
           Version: unspecified
          Hardware: PC
            Status: NEW
          Severity: blocker
          Priority: P2
         Component: HSSF
          Assignee: dev@poi.apache.org
          Reporter: priy2501@gmail.com
  Target Milestone: ---

Created attachment 34565
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=34565&action=edit
The file giving the error.

The attached file opens in MS-Excel but does not open using Apache POI API.

It gives a Duplicate PageSettingsBlock Record error. I investigated it and the
record that is duplicate is : HorizontalPageBreakRecord 

I guess there was a similar error for multiple header/footer records (id =
42086 ) which was fixed.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 60528] Duplicate PageSettingsBlock Record

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60528

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |WORKSFORME
             Status|NEW                         |RESOLVED

--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
I just tried it with the current turnk-version of POI and could not reproduce
this, the document opens fine for me and I can read the data from it. 

Please try with a current nightly build () and if you still manage to reproduce
this then please provide the full exception output and a self-sufficient piece
of code that reproduces the problem.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 60528] Duplicate PageSettingsBlock Record

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60528

Priyanshu Srivastava <pr...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All
                 CC|                            |priy2501@gmail.com

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 60528] Duplicate PageSettingsBlock Record

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60528

--- Comment #8 from Dominik Stadler <do...@gmx.at> ---
We need sample code to reproduce it, I cannot say much based on the information
provided...

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 60528] Duplicate PageSettingsBlock Record

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60528

--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
A recent nightly build can be found at
https://builds.apache.org/view/POI/job/POI-DSL-1.6/lastSuccessfulBuild/artifact/build/dist/

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 60528] Duplicate PageSettingsBlock Record

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60528

--- Comment #6 from Priyanshu Srivastava <pr...@gmail.com> ---
Can you please tell if the current version of POI supports multiple
HorizontalPageBreakRecord records, similar to multiple Header/Footer Records.
If yes, can you please guide me to the cl/ which incorporated this change.

Its not possible for me to migrate to the new version of POI. So can you please
help me with this ?

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 60528] Duplicate PageSettingsBlock Record

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60528

Javen O'Neal <on...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |WORKSFORME
             Status|NEEDINFO                    |RESOLVED

--- Comment #9 from Javen O'Neal <on...@apache.org> ---
Closing as WORKSFORME. Please reopen with supporting code if you are still
facing this issue with the latest code (trunk).

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 60528] Duplicate PageSettingsBlock Record

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60528

--- Comment #7 from Priyanshu Srivastava <pr...@gmail.com> ---
This is happening while reading PageSettingsBlock Records from the file.
Multiple HorizontalPageBreakRecord records are present leading to the
exception.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 60528] Duplicate PageSettingsBlock Record

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60528

Priyanshu Srivastava <pr...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|WORKSFORME                  |---

--- Comment #3 from Priyanshu Srivastava <pr...@gmail.com> ---
Please find the stack trace here:

org.apache.poi.hssf.record.RecordFormatException: Duplicate PageSettingsBlock
record (sid=0x1b)
        at
org.apache.poi.hssf.record.aggregates.PageSettingsBlock.checkNotPresent(PageSettingsBlock.java:337)
        at
org.apache.poi.hssf.record.aggregates.PageSettingsBlock.readARecord(PageSettingsBlock.java:256)
        at
org.apache.poi.hssf.record.aggregates.PageSettingsBlock.addLateRecords(PageSettingsBlock.java:858)
        at
com.quickoffice.ole.adapter.spreadsheet.elements.POISheet.<init>(POISheet.java:658)

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 60528] Duplicate PageSettingsBlock Record

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60528

Javen O'Neal <on...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|blocker                     |normal

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 60528] Duplicate PageSettingsBlock Record

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60528

--- Comment #5 from Dominik Stadler <do...@gmx.at> ---
And please try with a more recent version of POI as it seems you still use a
quite dated version where many fixes have been done over time.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 60528] Duplicate PageSettingsBlock Record

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60528

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |NEEDINFO

--- Comment #4 from Dominik Stadler <do...@gmx.at> ---
What about the "self sufficient piece of code". i.e. what exactly do you do in 
POISheet.<init>(POISheet.java:658), please share the relevant parts of your
code as it seems you are not just opening the spreadsheet, but rather do some
more specialized processing here...

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org