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 2013/11/06 04:46:32 UTC
[Bug 55745] New: XSSFSheet's method getTables() fails when the sheet
contains more than 6 tables
https://issues.apache.org/bugzilla/show_bug.cgi?id=55745
Bug ID: 55745
Summary: XSSFSheet's method getTables() fails when the sheet
contains more than 6 tables
Product: POI
Version: 3.9
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: liubao2014@gmail.com
I'm using excel 2007 and POI-3.9.
When the number of tables in a sheet is greater than 6, the
XSSFSheet.getTables() method fails to get all the tables, the result of
expression getTables().size() equals zero.
I've tried with POI-3.10beta2, It failed, too.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55745] XSSFSheet's method getTables() fails when the sheet
contains more than 6 tables
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55745
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
OS| |All
--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
Can you provide a sample file and test code which shows the problem? Preferably
as unit test?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55745] XSSFSheet's method getTables() fails when the sheet
contains more than 6 tables and some table cells are commented.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55745
Walker <li...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|XSSFSheet's method |XSSFSheet's method
|getTables() fails when the |getTables() fails when the
|sheet contains more than 6 |sheet contains more than 6
|tables |tables and some table cells
| |are commented.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55745] XSSFSheet's method getTables() fails when the sheet
contains more than 6 tables and some table cells are commented.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55745
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED
--- Comment #4 from Dominik Stadler <do...@gmx.at> ---
This is fixed as part of r1546385, it was a simple coding error when handling
comments and tables in XSSF, a loop was left upon the first comment table,
disregarding all subsequent normal tables, thus leading to this problem. In
fact it was kind of unpredictable, as I saw 1 table before putting the fix in
place.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55745] XSSFSheet's method getTables() fails when the sheet
contains more than 6 tables
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55745
--- Comment #2 from Walker <li...@gmail.com> ---
Created attachment 31016
--> https://issues.apache.org/bugzilla/attachment.cgi?id=31016&action=edit
workbook with sheet on which getTables() doesn't work
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55745] XSSFSheet's method getTables() fails when the sheet
contains more than 6 tables
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55745
--- Comment #3 from Walker <li...@gmail.com> ---
(In reply to Dominik Stadler from comment #1)
> Can you provide a sample file and test code which shows the problem?
> Preferably as unit test?
I tried it again, and found that:
1). getTables() works when no table cells are commented;
2). getTables() works when some table cell is commented and the number of
tables is less than 7, it fails when the number of tables is no less than 7.
The test class:
public class TablesTest {
public static void main(String[] args) throws InvalidFormatException,
IOException {
String workbook = "workbook.xlsx";
OPCPackage pkg = OPCPackage.open(new File(workbook));
XSSFWorkbook wb = new XSSFWorkbook(pkg);
XSSFSheet sheet = wb.getSheetAt(0);
System.out.println(sheet.getTables().size());
}
}
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55745] XSSFSheet's method getTables() fails when the sheet
contains more than 6 tables and some table cells are commented.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55745
Walker <li...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org