https://issues.apache.org/bugzilla/show_bug.cgi?id=55248

            Bug ID: 55248
           Summary: public interface Sheet - showInPane - parameter in
                    short data type limiting the toprow at 32767
           Product: POI
           Version: 3.8
          Hardware: PC
                OS: Mac OS X 10.4
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: [email protected]
          Reporter: [email protected]

I am making an excel file using Apache POI library. After creating an excel
file with more than 32767 rows, I can't set showInPane because of toprow
parameter in short data type. When I pass more than 32767 row as a variable, it
gives me an error.

java.lang.IllegalArgumentException: row index may not be negative
    at org.apache.poi.ss.util.CellReference.<init>(CellReference.java:133)
    at org.apache.poi.ss.util.CellReference.<init>(CellReference.java:127)
    at org.apache.poi.ss.util.CellReference.<init>(CellReference.java:119)
    at org.apache.poi.xssf.usermodel.XSSFSheet.showInPane(XSSFSheet.java:2380)
Is there any way I can set the toprow overriding short data type maximum value?

showInPane from Apache Javadoc

void showInPane(short toprow, short leftcol)
    Sets desktop window pane display area, when the file is first opened in a
viewer.
Parameters:
    toprow - the top row to show in desktop window pane
    leftcol - the left column to show in desktop window pane

http://stackoverflow.com/questions/17586245/apache-poi-showinpane-parameter-in-short-data-type

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to