DO NOT REPLY [Bug 49872] XSSFFormulaEvaluator.evaluateInCell() with shared formula's

2010-09-12 Thread bugzilla 
https://issues.apache.org/bugzilla/show_bug.cgi?id=49872

Yegor Kozlov ye...@dinom.ru changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution||FIXED

--- Comment #3 from Yegor Kozlov ye...@dinom.ru 2010-09-12 05:15:31 EDT ---
It was a bug. The same workbook saved as .xls evaluates OK in HSSF.  

When a group of cells shares a formula then only the first cell in the group
contains the actual formula expression. This is considered the 'master' formula
cell. Subsequent cells refer to the master by id and adjust the expression
based on the cell's relative location to the master formula.

FormulaEvaluator.evaluateInCell changes cell type. This method evaluates the
formula, and puts the result back into the cell, in place of the old formula. 
In your case, the first call of evaluateInCell changed the master shared
formula and subsequent calls on dependent cells resulted in NPE. 

I committed the fix in r996265. Now you can call evaluateInCell on a group of
shared formulas cells in any order - first master then dependent or first
dependent cells and then master. 

Yegor

-- 
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

[GUMP@vmgump]: Project poi (in module poi) failed

2010-09-12 Thread Gump [HEAD] :-( 
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 2 projects.
The current state of this project is 'Failed', with reason 'Build Failed'.
For reference only, the following projects are affected by this:
- org.apache.poi :  POI
- 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:
 -INFO- Failed with reason build failed
 -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: 4 mins 12 secs
Command Line: /usr/lib/jvm/java-6-openjdk/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/xalan-unbundled.jar:/srv/gump/public/workspace/xml-xalan/build/serializer.jar
 org.apache.tools.ant.Main -Dgump.merge=/srv/gump/public/gump/work/merge.xml 
-Dbuild.sysclasspath=only -Dversion.id=gump -DDSTAMP=13092010 -f build.xml gump 
[Working Directory: /srv/gump/public/workspace/poi]
CLASSPATH: 
/usr/lib/jvm/java-6-openjdk/lib/tools.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.jar:/srv/gump/public/workspace/ant/dist/lib/ant-launcher.jar:/srv/gump/public/workspace/ant/dist/lib/ant-jmf.jar:/srv/gump/public/workspace/ant/dist/lib/ant-junit.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/logging-log4j-12/dist/lib/log4j-13092010.jar:/srv/gump/public/workspace/apache-comm
 
ons/logging/target/commons-logging-13092010.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-api-13092010.jar:/srv/gump/public/workspace/apache-commons/beanutils/dist/commons-beanutils-13092010.jar:/srv/gump/public/workspace/commons-collections-3.x/target/commons-collections-3.3-SNAPSHOT.jar:/srv/gump/public/workspace/commons-lang-2.x/target/commons-lang-2.6-SNAPSHOT.jar:/srv/gump/public/workspace/junit/dist/junit-13092010.jar:/srv/gump/public/workspace/junit/dist/junit-dep-13092010.jar:/srv/gump/public/workspace/xml-commons/java/external/build/xml-apis-ext.jar:/srv/gump/public/workspace/dom4j/build/dom4j.jar:/srv/gump/public/workspace/poi/ooxml-lib/geronimo-stax-api_1.0_spec-1.0.jar:/srv/gump/public/workspace/poi/ooxml-lib/xmlbeans-2.3.0.jar:/srv/gump/public/workspace/poi/ooxml-lib/ooxml-schemas-1.1.jar
-
[junit] Running org.apache.poi.xssf.extractor.TestXSSFExcelExtractor
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 2.145 sec
[junit] Running org.apache.poi.xssf.extractor.TestXSSFExportToXML
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.732 sec
[junit] Running org.apache.poi.xssf.extractor.TestXSSFImportFromXML
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.42 sec
[junit] Running org.apache.poi.xssf.io.TestLoadSaveXSSF
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.144 sec
[junit] Running org.apache.poi.xssf.model.TestCalculationChain
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 2.473 sec
[junit] Running org.apache.poi.xssf.model.TestCommentsTable
[junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 0.296 sec
[junit] Running org.apache.poi.xssf.model.TestMapInfo
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.032 sec
[junit] Running org.apache.poi.xssf.model.TestSharedStringsTable
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.209 sec
[junit] Running org.apache.poi.xssf.model.TestStylesTable
[junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 0.247 sec
[junit] Running org.apache.poi.xssf.usermodel.TestFormulaEvaluatorOnXSSF
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.923 sec
[junit] Running org.apache.poi.xssf.usermodel.TestSheetHiding
[junit] Tests run: 5, Failures: 0,