Re: Infinite loop in SectionIDMap.get() and .put()

2017-11-22 Thread Andreas Beeker
On 11/22/17 9:01 PM, pj.fanning wrote: > Hi Arjohn, > Could you log a bugzilla issue? Would it be possible to provide a Java test > case? > Reproducing this is easy ... and it's a shame this hasn't bubbled up earlier. I've fixed and junit-tested it - will commit with bugzilla entry probably tomorr

Re: Infinite loop in SectionIDMap.get() and .put()

2017-11-22 Thread pj.fanning
Hi Arjohn, Could you log a bugzilla issue? Would it be possible to provide a Java test case? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org

Re: Apache POI: Content Issue while processing huge excel file with SXSSF

2017-11-22 Thread Greg Woolsey
Perhaps there are some other less obvious limits POI isn't checking. There is quite a list at https://support.office.com/en-us/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 On Wed, Nov 22, 2017 at 11:51 AM Andreas Reichel < andr...@manticore-projects.com> wrote: >

Re: Apache POI: Content Issue while processing huge excel file with SXSSF

2017-11-22 Thread Andreas Reichel
On Wed, 2017-11-22 at 19:39 +, Greg Woolsey wrote: > POI streaming may not catch it (it should, but maybe that's the bug), > but > > OOXML compliant apps (Excel, OpenOffice/LibreOffice, etc.) will > consider it > > corrupt. We have hit that limit and POI throws an exception (both in XSSF an

Re: Apache POI: Content Issue while processing huge excel file with SXSSF

2017-11-22 Thread Greg Woolsey
The OOXML/Excel 2007+ limit is 2^20 (1,048,576) rows per sheet. If you are trying to put 5 million rows on a single sheet, Excel will never open it. POI streaming may not catch it (it should, but maybe that's the bug), but OOXML compliant apps (Excel, OpenOffice/LibreOffice, etc.) will consider i

Infinite loop in SectionIDMap.get() and .put()

2017-11-22 Thread Arjohn Kampman
Hi all, After upgrading my code to POI 3.17 it runs into an infinite loop and a subsequent stack overflow when SectionIDMap.getPIDString(ClassID) is called. This method invokes itself on the instance returned by SectionIDMap.getInstance(). My guess is that getInstance() should rather have ret

Re: Apache POI: Content Issue while processing huge excel file with SXSSF

2017-11-22 Thread Andreas Reichel
Thamodharam, we use Apache POI 3.18 development snapshot and have no problem to create SXSSF workbooks of 300 MByte, with up to 1 Mill. Rows and around 40 columns. On the server, that took up to 20 GB of RAM. However, we were never able to open such files with Libre Office, Gnumeric or Excel (whil

Apache POI: Content Issue while processing huge excel file with SXSSF

2017-11-22 Thread Thamodharan Balraj
Hi Everyone, I am trying to generate a excel with SXSSF workbook. The size of excel may shoot to 200-300MB, whose row count will be 5,00,000 and column count will be around 150 approximately..! I get content issue while opening such large excel file. The version which I am using is APACHE POI 3.9

Re: How to create oleObject1.bin for Word (.docx)

2017-11-22 Thread kiwiwings
Hi Nilez, coincidentally I've provided a similar topic (XSSF ole object inside XSLF) yesterday evening [1]. It will take some time to try it myself, but based on my experience from [1] I can answer you the following: @1) embedded objects aren't always stored in the same way, as you've already not

How to create oleObject1.bin for Word (.docx)

2017-11-22 Thread nilez
Hi all, I am new for poi. I would like to insert objects in Microsoft word (.docx) using java. In the editor, I can insert object (from several file types) by going to menu : *Insert > Object...* Following are structure of each objec