You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2007/07/31 23:01:05 UTC

DO NOT REPLY [Bug 43005] New: - Problems in Large Sheet - Action Read

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=43005>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=43005

           Summary: Problems in Large Sheet - Action Read
           Product: POI
           Version: 3.0
          Platform: PC
        OS/Version: Windows 2000
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: ramilani@gmail.com
                CC: ramilani@gmail.com


I�m try reading a simple Sheet in Excel 2003, for specify sheet it contains 683
rows I passed problems 
I�m using object HSSFSheet for Read but not it reaches the last row which is 683
 the read stop in row 628 

somebody help me?

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


DO NOT REPLY [Bug 43005] - Problems in Large Sheet - Action Read

Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=43005>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=43005


poi-support@buni.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |INVALID




------- Additional Comments From poi-support@buni.org  2007-07-31 14:14 -------
Inappropriate place to ask a question.  You found your way here...now find the
mail list as well.

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


DO NOT REPLY [Bug 43005] - Problems in Large Sheet - Action Read

Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=43005>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=43005


ramilani@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED




------- Additional Comments From ramilani@gmail.com  2007-08-04 09:27 -------
(In reply to comment #3)
> (In reply to comment #2)
> /**
>   * Returns the number of phsyically defined rows (NOT the number of rows in 
> the sheet)
> */
> public int getPhysicalNumberOfRows()
> 
> Try to use HSSFSheet.getLastRowNum() to solve your problem because
> getPhysicalNumberOfRows() has another nature as you can see - this method don't 
> considered empty rows.

Hello Bina thanks for you help but I fixed my problem before , reading all
javadoc I discovered this method getLastRowNum().
First moment I thought was bug but did not.


-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


DO NOT REPLY [Bug 43005] - Problems in Large Sheet - Action Read

Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=43005>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=43005





------- Additional Comments From ramilani@gmail.com  2007-08-01 05:46 -------
(In reply to comment #1)
> Inappropriate place to ask a question.  You found your way here...now find the
> mail list as well.

Yes I know this inappropriate place to ask question , I�m sorry  but I searched
many sites and not found solution for my Problem

My Sheet has this	
structure:

XXXXX YYYY	1200401		10	11	12	13	14
A	55	104		 1      76      27       0       0
B							
C							
D							
E							
F							
G							
H							
I							
J							
------------------------- row blank
This structure repeat many times in sheet 
but when call  HSSFSheet.getPhysicalNumberOfRows() not it reaches the last row 






-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


DO NOT REPLY [Bug 43005] - Problems in Large Sheet - Action Read

Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=43005>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=43005





------- Additional Comments From Bina@math.spbu.ru  2007-08-03 08:09 -------
(In reply to comment #2)
/**
  * Returns the number of phsyically defined rows (NOT the number of rows in 
the sheet)
*/
public int getPhysicalNumberOfRows()

Try to use HSSFSheet.getLastRowNum() to solve your problem because
getPhysicalNumberOfRows() has another nature as you can see - this method don't 
considered empty rows.



> (In reply to comment #1)
> > Inappropriate place to ask a question.  You found your way here...now find 
the
> > mail list as well.
> 
> Yes I know this inappropriate place to ask question , I�m sorry  but I 
searched
> many sites and not found solution for my Problem
> 
> My Sheet has this	
> structure:
> 
> XXXXX YYYY	1200401		10	11	12	13	14
> A	55	104		 1      76      27       0       0
> B							
> C							
> D							
> E							
> F							
> G							
> H							
> I							
> J							
> ------------------------- row blank
> This structure repeat many times in sheet 
> but when call  HSSFSheet.getPhysicalNumberOfRows() not it reaches the last 
row 
> 
> 
> 
> 
> 



-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org