DO NOT REPLY [Bug 46953] Incorrect HSSFWorkbook.getNumberOfSheets() and corrupt Excel file
https://issues.apache.org/bugzilla/show_bug.cgi?id=46953 --- Comment #1 from Matthew 2009-04-01 22:46:50 PST --- Created an attachment (id=23436) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23436) problem.output.xls -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 46953] New: Incorrect HSSFWorkbook.getNumberOfSheets() and corrupt Excel file
https://issues.apache.org/bugzilla/show_bug.cgi?id=46953
Summary: Incorrect HSSFWorkbook.getNumberOfSheets() and corrupt
Excel file
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: major
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: matthew@gmail.com
Created an attachment (id=23435)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23435)
problem.xls
I use following codes to read attached "problem.xls" Excel file, the Excel file
contains 5 worksheets but HSSFWorkbook.getNumberOfSheets() output 1 only. And
write the workbook out, it cannot be opened by MS Excel.
--
FileInputStream fis = new FileInputStream("problem.xls");
POIFSFileSystem poifs = new POIFSFileSystem(fis);
HSSFWorkbook wb = new HSSFWorkbook(poifs);
System.out.println("wb.getNumberOfSheets() = " + wb.getNumberOfSheets());
FileOutputStream os = new FileOutputStream("problem.output.xls");
wb.write(os);
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
[g...@vmgump]: Project poi (in module poi) failed
To whom it may engage... This is an automated request, but not an unsolicited one. For more information please visit http://gump.apache.org/nagged.html, and/or contact the folk at gene...@gump.apache.org. Project poi has an issue affecting its community integration. This issue affects 1 projects. The current state of this project is 'Failed', with reason 'Build Timed Out'. For reference only, the following projects are affected by this: - poi : POI Full details are available at: http://vmgump.apache.org/gump/public/poi/poi/index.html That said, some information snippets are provided here. The following annotations (debug/informational/warning/error messages) were provided: -DEBUG- Output [poi-ooxml-gump-01042009.jar] identifier set to output basename: [poi-ooxml-gump] -DEBUG- Output [poi-contrib-gump-01042009.jar] identifier set to output basename: [poi-contrib-gump] -DEBUG- Output [poi-scratchpad-gump-01042009.jar] identifier set to output basename: [poi-scratchpad-gump] -DEBUG- Output [poi-gump-01042009.jar] identifier set to output basename: [poi-gump] -INFO- Failed with reason build timed out -DEBUG- Extracted fallback artifacts from Gump Repository The following work was performed: http://vmgump.apache.org/gump/public/poi/poi/gump_work/build_poi_poi.html Work Name: build_poi_poi (Type: Build) Work ended in a state of : Failed Elapsed: 60 mins Command Line: /usr/lib/jvm/java-6-sun/bin/java -Djava.awt.headless=true -Xbootclasspath/p:/srv/gump/public/workspace/xml-commons/java/external/build/xml-apis.jar:/srv/gump/public/workspace/xml-xerces2/build/xercesImpl.jar:/srv/gump/public/workspace/xml-xalan/build/serializer.jar:/srv/gump/public/workspace/xml-xalan/build/xalan-unbundled.jar org.apache.tools.ant.Main -Dgump.merge=/srv/gump/public/gump/work/merge.xml -Dbuild.sysclasspath=only -Dversion.id=gump -DDSTAMP=01042009 -f build.xml gump [Working Directory: /srv/gump/public/workspace/poi] CLASSPATH: /usr/lib/jvm/java-6-sun/lib/tools.jar:/srv/gump/public/workspace/poi/ooxml-lib/xmlbeans-2.3.0.jar:/srv/gump/public/workspace/poi/ooxml-lib/jsr173_1.0_api.jar:/srv/gump/public/workspace/poi/ooxml-lib/ooxml-schemas-1.0.jar:/srv/gump/public/workspace/poi/ooxml-lib/openxml4j-1.0-beta.jar:/srv/gump/public/workspace/poi/build/classes:/srv/gump/public/workspace/poi/build/contrib-classes:/srv/gump/public/workspace/poi/build/scratchpad-classes:/srv/gump/public/workspace/poi/build/ooxml-classes:/srv/gump/public/workspace/poi/build/test-classes:/srv/gump/public/workspace/poi/build/scratchpad-test-classes:/srv/gump/public/workspace/poi/build/ooxml-test-classes:/srv/gump/public/workspace/ant/dist/lib/ant-jmf.jar:/srv/gump/public/workspace/ant/dist/lib/ant-swing.jar:/srv/gump/public/workspace/ant/dist/lib/ant-apache-resolver.jar:/srv/gump/public/workspace/ant/dist/lib/ant-apache-xalan2.jar:/srv/gump/public/workspace/ant/dist/lib/ant-trax.jar:/srv/gump/public/workspace/ant/dist/l ib/ant-junit.jar:/srv/gump/public/workspace/ant/dist/lib/ant-launcher.jar:/srv/gump/public/workspace/ant/dist/lib/ant-nodeps.jar:/srv/gump/public/workspace/ant/dist/lib/ant.jar:/srv/gump/public/workspace/logging-log4j-12/dist/lib/log4j-01042009.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-01042009.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-api-01042009.jar:/srv/gump/public/workspace/apache-commons/beanutils/dist/commons-beanutils-01042009.jar:/srv/gump/public/workspace/apache-commons/collections/build/commons-collections-01042009.jar:/srv/gump/public/workspace/apache-commons/lang/target/commons-lang-3.0-SNAPSHOT.jar:/srv/gump/public/workspace/junit/dist/junit-01042009.jar:/srv/gump/public/workspace/xml-commons/java/external/build/xml-apis-ext.jar:/srv/gump/public/workspace/dom4j/build/dom4j.jar - check-jars: fetch-jars: testexist: downloadfile: [get] Getting: http://www.ibiblio.org/maven/commons-logging/jars/commons-logging-1.1.jar [get] To: /srv/gump/public/workspace/poi/lib/commons-logging-1.1.jar testexist: downloadfile: [get] Getting: http://www.ibiblio.org/maven/log4j/jars/log4j-1.2.13.jar [get] To: /srv/gump/public/workspace/poi/lib/log4j-1.2.13.jar testexist: downloadfile: [get] Getting: http://www.ibiblio.org/maven/junit/jars/junit-3.8.1.jar [get] To: /srv/gump/public/workspace/poi/lib/junit-3.8.1.jar check-ooxml-jars: fetch-ooxml-jars: testexist: downloadfile: [get] Getting: http://www.ibiblio.org/maven/dom4j/jars/dom4j-1.6.1.jar [get] To: /srv/gump/public/workspace/poi/ooxml-lib/dom4j-1.6.1.jar testexist: downloadfile: [get] Getting: http://www.ibiblio.org/maven/org.apache.xmlbeans/jars/xmlbeans-2.3.0.jar [get] To: /srv/gump/public/workspace/poi/ooxml-lib/xmlbeans-2.3.0.jar testexist: downloadfile: [get] Getting: http://repo1.maven.org/maven2/org/apache/geronimo/specs/geronimo-stax-api_1.0_spec/1.0/geroni
DO NOT REPLY [Bug 46806] Unable to Create XSSF Workbook with formula that references column > 255
https://issues.apache.org/bugzilla/show_bug.cgi?id=46806 --- Comment #2 from Josh Micich 2009-04-01 17:49:05 PST --- (In reply to comment #0) > Creating an XSSF Workbook with a cell formula that references a cell in a > column that is greater than 255 causes an exception. > > In org.apache.poi.ss.util.CellReference there is the constant: > > private static final String BIFF8_LAST_COLUMN = "IV"; > > Should be some kind of switch depending on if the workbook is HSSF or XSSF to > allow for references in columns > 255. You're absolutely correct, but this change is is not a trivial one to make (there is an extensive tree of method calls to pass that parameter through). This is something we intend to get done before 3.5-final release. AS far as I know there is no practical work-around. -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 46806] Unable to Create XSSF Workbook with formula that references column > 255
https://issues.apache.org/bugzilla/show_bug.cgi?id=46806 --- Comment #1 from Tim 2009-04-01 16:19:45 PST --- Does anyone have a workaround for this? I am trying to generate a calendar year of hours worked for all employees in our organization. I need 365 columns for the days in the year and a SUM at the end. -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 46944] Error Value can only be 0,7,15,23,29,36 or 42. It cannot be -30
https://issues.apache.org/bugzilla/show_bug.cgi?id=46944 Josh Micich changed: What|Removed |Added Status|NEW |RESOLVED Resolution||LATER --- Comment #3 from Josh Micich 2009-04-01 13:37:41 PST --- The -30 code is caused by POI attempting to evaluate a function which has not been implemented. Part of the problem is that the -30 error value can silently propagate around, masquerading as a genuine Excel error code. So using FormulaEvaluator.evaluateInCell() has probably not avoided the real problem. Since bug 46580 , POI has been improved to throw an exception explaining which function needs to be implemented. In the file you have uploaded, there are actually two functions that POI does not support yet: ADDRESS() and INDIRECT(). The implementation of ADDRESS() should be relatively straightforward. INDIRECT() might be more complex because it involves invoking a formula parser on an arbitrary string value, during evaluation (something that hasn't been done in POI yet). Since you are using a combination of INDIRECT(ADDRESS(...)) it might be possible to replace this with OFFSET() (which POI *can* evaluate). I am marking this bug as 'LATER' in the hope that OFFSET() might do what you need. Please change the status if you can't find an acceptable work around. As always, we are happy to receive patches from new contributors. -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[g...@vmgump]: Project poi (in module poi) failed
To whom it may engage... This is an automated request, but not an unsolicited one. For more information please visit http://gump.apache.org/nagged.html, and/or contact the folk at gene...@gump.apache.org. Project poi has an issue affecting its community integration. This issue affects 1 projects. The current state of this project is 'Failed', with reason 'Build Timed Out'. For reference only, the following projects are affected by this: - poi : POI Full details are available at: http://vmgump.apache.org/gump/public/poi/poi/index.html That said, some information snippets are provided here. The following annotations (debug/informational/warning/error messages) were provided: -DEBUG- Output [poi-ooxml-gump-01042009.jar] identifier set to output basename: [poi-ooxml-gump] -DEBUG- Output [poi-contrib-gump-01042009.jar] identifier set to output basename: [poi-contrib-gump] -DEBUG- Output [poi-scratchpad-gump-01042009.jar] identifier set to output basename: [poi-scratchpad-gump] -DEBUG- Output [poi-gump-01042009.jar] identifier set to output basename: [poi-gump] -INFO- Failed with reason build timed out -DEBUG- Extracted fallback artifacts from Gump Repository The following work was performed: http://vmgump.apache.org/gump/public/poi/poi/gump_work/build_poi_poi.html Work Name: build_poi_poi (Type: Build) Work ended in a state of : Failed Elapsed: 60 mins Command Line: /usr/lib/jvm/java-6-sun/bin/java -Djava.awt.headless=true -Xbootclasspath/p:/srv/gump/public/workspace/xml-commons/java/external/build/xml-apis.jar:/srv/gump/public/workspace/xml-xerces2/build/xercesImpl.jar:/srv/gump/public/workspace/xml-xalan/build/serializer.jar:/srv/gump/public/workspace/xml-xalan/build/xalan-unbundled.jar org.apache.tools.ant.Main -Dgump.merge=/srv/gump/public/gump/work/merge.xml -Dbuild.sysclasspath=only -Dversion.id=gump -DDSTAMP=01042009 -f build.xml gump [Working Directory: /srv/gump/public/workspace/poi] CLASSPATH: /usr/lib/jvm/java-6-sun/lib/tools.jar:/srv/gump/public/workspace/poi/ooxml-lib/xmlbeans-2.3.0.jar:/srv/gump/public/workspace/poi/ooxml-lib/jsr173_1.0_api.jar:/srv/gump/public/workspace/poi/ooxml-lib/ooxml-schemas-1.0.jar:/srv/gump/public/workspace/poi/ooxml-lib/openxml4j-1.0-beta.jar:/srv/gump/public/workspace/poi/build/classes:/srv/gump/public/workspace/poi/build/contrib-classes:/srv/gump/public/workspace/poi/build/scratchpad-classes:/srv/gump/public/workspace/poi/build/ooxml-classes:/srv/gump/public/workspace/poi/build/test-classes:/srv/gump/public/workspace/poi/build/scratchpad-test-classes:/srv/gump/public/workspace/poi/build/ooxml-test-classes:/srv/gump/public/workspace/ant/dist/lib/ant-jmf.jar:/srv/gump/public/workspace/ant/dist/lib/ant-swing.jar:/srv/gump/public/workspace/ant/dist/lib/ant-apache-resolver.jar:/srv/gump/public/workspace/ant/dist/lib/ant-apache-xalan2.jar:/srv/gump/public/workspace/ant/dist/lib/ant-trax.jar:/srv/gump/public/workspace/ant/dist/l ib/ant-junit.jar:/srv/gump/public/workspace/ant/dist/lib/ant-launcher.jar:/srv/gump/public/workspace/ant/dist/lib/ant-nodeps.jar:/srv/gump/public/workspace/ant/dist/lib/ant.jar:/srv/gump/public/workspace/logging-log4j-12/dist/lib/log4j-01042009.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-01042009.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-api-01042009.jar:/srv/gump/public/workspace/apache-commons/beanutils/dist/commons-beanutils-01042009.jar:/srv/gump/public/workspace/apache-commons/collections/build/commons-collections-01042009.jar:/srv/gump/public/workspace/apache-commons/lang/target/commons-lang-3.0-SNAPSHOT.jar:/srv/gump/public/workspace/junit/dist/junit-01042009.jar:/srv/gump/public/workspace/xml-commons/java/external/build/xml-apis-ext.jar:/srv/gump/public/workspace/dom4j/build/dom4j.jar - check-jars: fetch-jars: testexist: downloadfile: [get] Getting: http://www.ibiblio.org/maven/commons-logging/jars/commons-logging-1.1.jar [get] To: /srv/gump/public/workspace/poi/lib/commons-logging-1.1.jar testexist: downloadfile: [get] Getting: http://www.ibiblio.org/maven/log4j/jars/log4j-1.2.13.jar [get] To: /srv/gump/public/workspace/poi/lib/log4j-1.2.13.jar testexist: downloadfile: [get] Getting: http://www.ibiblio.org/maven/junit/jars/junit-3.8.1.jar [get] To: /srv/gump/public/workspace/poi/lib/junit-3.8.1.jar check-ooxml-jars: fetch-ooxml-jars: testexist: downloadfile: [get] Getting: http://www.ibiblio.org/maven/dom4j/jars/dom4j-1.6.1.jar [get] To: /srv/gump/public/workspace/poi/ooxml-lib/dom4j-1.6.1.jar testexist: downloadfile: [get] Getting: http://www.ibiblio.org/maven/org.apache.xmlbeans/jars/xmlbeans-2.3.0.jar [get] To: /srv/gump/public/workspace/poi/ooxml-lib/xmlbeans-2.3.0.jar testexist: downloadfile: [get] Getting: http://repo1.maven.org/maven2/org/apache/geronimo/specs/geronimo-stax-api_1.0_spec/1.0/geroni
DO NOT REPLY [Bug 46948] java.lang.IllegalArgumentException: Unexpected ref arg class (org.apache.poi.ss.formula.LazyAreaEval)
https://issues.apache.org/bugzilla/show_bug.cgi?id=46948
Josh Micich changed:
What|Removed |Added
Status|NEW |RESOLVED
Resolution||FIXED
--- Comment #1 from Josh Micich 2009-04-01 12:50:43 PST
---
Fixed in svn r761023 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=761023 )
junit added
POI can now *evaluate* formulas which apply the range operator to area refs.
(e.g. "SUM((C1:D2):(D2:E3))"). So the example code should run OK now.
However, POI still cannot *parse* these formulas. For example, these calls will
fail:
cell.setCellFormula("AVERAGE(J6:OFFSET(I6,0,DAY(TODAY())-1))");
cell.setCellFormula("SUM((C1:D2):(D2:E3))");
Bug 46951 has been opened to track this as a separate bug.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 46951] New: Cannot parse range expressions with non-cell ref operands
https://issues.apache.org/bugzilla/show_bug.cgi?id=46951
Summary: Cannot parse range expressions with non-cell ref
operands
Product: POI
Version: 3.5-dev
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: P5
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: j...@gildedtree.com
The following code:
cell.setCellFormula("SUM(C1:OFFSET(C1,0,B1))");
fails with this exception:
org.apache.poi.ss.formula.FormulaParser$FormulaParseException: Specified named
range 'OFFSET' does not exist in the current workbook.
This bug was noticed while fixing bug 46948 , which is concerned about
evaluation of the corresponding Ptg array (pre-parsed by Excel).
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 39526] ArrayIndexOutOfBoundsException opening Word document
https://issues.apache.org/bugzilla/show_bug.cgi?id=39526 Piotr Gawron changed: What|Removed |Added CC|piotr.gaw...@cs.put.poznan. | |pl | -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 39526] ArrayIndexOutOfBoundsException opening Word document
https://issues.apache.org/bugzilla/show_bug.cgi?id=39526 Piotr Gawron changed: What|Removed |Added CC||piotr.gaw...@cs.put.poznan. ||pl -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 45269] but at replaceText function - String index out of range: -5
https://issues.apache.org/bugzilla/show_bug.cgi?id=45269 Piotr Gawron changed: What|Removed |Added CC||piotr.gaw...@cs.put.poznan. ||pl -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
DO NOT REPLY [Bug 45269] but at replaceText function - String index out of range: -5
https://issues.apache.org/bugzilla/show_bug.cgi?id=45269 --- Comment #1 from Piotr Gawron 2009-04-01 06:16:20 PST --- Created an attachment (id=23433) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23433) Patch to this bug Changes: scratchpad/src/org/apache/poi/hwpf/usermodel/Range.java now the modification of size of Range during text replacement is changed recursively to upper levels scratchpad/testcases/org/apache/poi/hwpf/usermodel/TestProblems.java test case to this bug was added scratchpad/testcases/org/apache/poi/hwpf/usermodel/TestRangeReplacement.java there was one error in this test case - after replacing text with new, longer text number of paragraphs in section changed (5->4), but it shouldn't This patch need also the *.doc file which was attached before as scratchpad\testcases\org\apache\poi\hwpf\data\Bug45269.doc -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
