Hi All,
Excel sheet is getting devided after 64999 rows! :-\ I am getting 4 sheets, but I need whole output in a single sheet.
should i set some kind of property? do excel support only 65000 rows per sheet?
is there any workaround for this?
My report configuration:
List No of rows per page: (Default, nothing specified)
List Pagination: Allow content to break across pages (Unchecked)
Allow Horizontal Pagination (Unchecked)
Report Properties: Group repeating cells when exporting to excel (Unchecked)
Any help will be appreciated.
Thanks in advance
I think that's a fixed number for the export.
On a more general note, what is the user expecting to do with roughly a quarter of a million rows of data?!?
Quote from: Mfg on 11 Apr 2017 08:32:07 AM
Hi All,
Excel sheet is getting devided after 64999 rows! :-\ I am getting 4 sheets, but I need whole output in a single sheet.
should i set some kind of property? do excel support only 65000 rows per sheet?
is there any workaround for this?
My report configuration:
List No of rows per page: (Default, nothing specified)
List Pagination: Allow content to break across pages (Unchecked)
Allow Horizontal Pagination (Unchecked)
Report Properties: Group repeating cells when exporting to excel (Unchecked)
Any help will be appreciated.
Thanks in advance
It is a limit set by default, but may be overridden with a change to a setting.
http://www-01.ibm.com/support/docview.wss?uid=swg21419957
Although I have to agree with BigChris about the volume of data being extracted.
Hi BigChris & Lynn,
Thanks for your replies.