Eclipse Community Forums: BIRT » Excel and OpenOfficeSpreadSheet is Crashing when There are 1,50,000 Rows

Help

Home

Home » Archived » BIRT » Excel and OpenOfficeSpreadSheet is Crashing when There are 1,50,000 Rows

Show: Today's Messages :: Show Polls :: Message Navigator

Excel and OpenOfficeSpreadSheet is Crashing when There are 1,50,000 Rows [message #1702116]

Mon, 20 July 2015 03:50

Suvarnni M V

Messages: 12
Registered: July 2015

Junior Member

I want to know the behaviour of Excel and OpenOfficeCalc when the Report having more than 1,50,000 row. Whether it will split into two sheets? or Is it possible to get it a single sheet.

Kindly Reply as soon as possible.

Awaiting for the positive response

Report message to a moderator

Re: Excel and OpenOfficeSpreadSheet is Crashing when There are 1,50,000 Rows [message #1704046 is a reply to message #1702116]

Thu, 06 August 2015 20:59

Jesse Freeman

Messages: 184
Registered: January 2015

Senior Member

It is not possible to have in a single sheet due to the limitation of maximum rows on a single XLSX sheet at 1,048,576.
This is a limitation of the Microsoft XLSX Excel format.

However, there are ways using the Spudsoft emitter for XLSX to set page breaks for a specific number of rows.

Report message to a moderator