dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

Oops.  I guess you've exceeded the 65,536 rows hard limit of xls
files.  The only way to increase the number of rows is to use the
.xlsx format and I don't think jxl supports this.  POI?

On the other hand, do you really want a spreadsheet that big?

On 17 September 2012 13:15, Olav P <1051925@xxxxxxxxxxxxxxxxxx> wrote:
> Public bug reported:
>
> Trying to aggregate for a large number of org units and/or periods, DHIS2 show a blank page and the log shows:
> * ERROR 2012-09-17 12:07:11,071 Error while executing action (ExceptionInterceptor.java [TP-Processor2])
> jxl.write.biff.RowsExceededException: The maximum number of rows permitted on a worksheet been exceeded
>         at jxl.write.biff.WritableSheetImpl.getRowRecord(WritableSheetImpl.java:1214)
>         at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:1151)
>         at org.hisp.dhis.system.grid.GridUtils.toXlsInternal(GridUtils.java:280)
>         at org.hisp.dhis.system.grid.GridUtils.toXls(GridUtils.java:228)
>         at org.hisp.dhis.result.GridXlsResult.execute(GridXlsResult.java:119)
>         at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:374)
> …..
>
> ** Affects: dhis2
>      Importance: Undecided
>          Status: New
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1051925
>
> Title:
>   Person aggregation: blank page when too many org units/period
>
> Status in DHIS 2 - District Health Information Software:
>   New
>
> Bug description:
>   Trying to aggregate for a large number of org units and/or periods, DHIS2 show a blank page and the log shows:
>   * ERROR 2012-09-17 12:07:11,071 Error while executing action (ExceptionInterceptor.java [TP-Processor2])
>   jxl.write.biff.RowsExceededException: The maximum number of rows permitted on a worksheet been exceeded
>         at jxl.write.biff.WritableSheetImpl.getRowRecord(WritableSheetImpl.java:1214)
>         at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:1151)
>         at org.hisp.dhis.system.grid.GridUtils.toXlsInternal(GridUtils.java:280)
>         at org.hisp.dhis.system.grid.GridUtils.toXls(GridUtils.java:228)
>         at org.hisp.dhis.result.GridXlsResult.execute(GridXlsResult.java:119)
>         at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:374)
>   …..
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1051925/+subscriptions
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp