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

2009-03-31 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 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-31032009.jar] identifier set to output 
basename: [poi-ooxml-gump]
 -DEBUG- Output [poi-contrib-gump-31032009.jar] identifier set to output 
basename: [poi-contrib-gump]
 -DEBUG- Output [poi-scratchpad-gump-31032009.jar] identifier set to output 
basename: [poi-scratchpad-gump]
 -DEBUG- Output [poi-gump-31032009.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=31032009 -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-31032009.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-31032009.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-api-31032009.jar:/srv/gump/public/workspace/apache-commons/beanutils/dist/commons-beanutils-31032009.jar:/srv/gump/public/workspace/apache-commons/collections/build/commons-collections-31032009.jar:/srv/gump/public/workspace/apache-commons/lang/target/commons-lang-3.0-SNAPSHOT.jar:/srv/gump/public/workspace/junit/dist/junit-31032009.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)

2009-03-31 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46948


kevinrmc...@hotmail.com changed:

   What|Removed |Added

 CC||kevinrmc...@hotmail.com




-- 
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 46948] New: java.lang.IllegalArgumentException: Unexpected ref arg class (org.apache.poi.ss.formula.LazyAreaEval)

2009-03-31 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46948

   Summary: java.lang.IllegalArgumentException: Unexpected ref arg
class (org.apache.poi.ss.formula.LazyAreaEval)
   Product: POI
   Version: 3.5-dev
  Platform: PC
OS/Version: Windows Vista
Status: NEW
  Severity: normal
  Priority: P2
 Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: kevinrmc...@hotmail.com


I have a formula in an Excel 97-2003 spreadsheet as follows
=AVERAGE(J6:OFFSET(I6,0,DAY(TODAY())-1))
which basically does an average on a number of cells dependant on todays date.

When I run the sample code at the bottom of 
http://poi.apache.org/spreadsheet/eval.html to recalculate all formulas in a
workbook (which I had to modify as follows to get it to compile properly)

FileInputStream fis = new FileInputStream("c:\\test.xls");
FileOutputStream fos = new FileOutputStream("c:\\test2.xls");
Workbook wb = new HSSFWorkbook(fis); //or new
XSSFWorkbook("/somepath/test.xls")
FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();
for(int sheetNum = 0; sheetNum < wb.getNumberOfSheets(); sheetNum++) {
Sheet sheet = wb.getSheetAt(sheetNum);
for(Row r : sheet) {
for(Cell c : r) {
if(c.getCellType() == Cell.CELL_TYPE_FORMULA) {
System.out.println(c.getCellFormula().toString());
evaluator.evaluateFormulaCell(c);
}
}
}
}
wb.write(fos);
fos.close();
fis.close();

I am getting an error at the above formula

Exception in thread "main" java.lang.IllegalArgumentException: Unexpected ref
arg class (org.apache.poi.ss.formula.LazyAreaEval)
at
org.apache.poi.hssf.record.formula.eval.RangeEval.evaluateRef(RangeEval.java:62)
at
org.apache.poi.hssf.record.formula.eval.RangeEval.evaluate(RangeEval.java:40)
at
org.apache.poi.ss.formula.WorkbookEvaluator.invokeOperation(WorkbookEvaluator.java:394)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:329)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:216)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:180)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:297)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluate(HSSFFormulaEvaluator.java:159)
at poitest.Main.main(Main.java:41)
Java Result: 1

Is this a bug, or something I'm doing wrong?

-- 
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 46918] RecordFormatException with Pivot table

2009-03-31 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46918


Josh Micich  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution||FIXED




--- Comment #5 from Josh Micich   2009-03-31 14:18:42 PST 
---
Axel supplied me with the hex of the offending
ExtendedPivotTableViewFieldsRecord:
00 01 0A 00 1E 14 00 0A FF FF FF FF 00 00

This is 10 bytes shorter than POI was expecting (existing test cases have 20
bytes of data in this record).  The 10 byte format is probably from earlier
Excel versions (perhaps 97) POI now reads both formats of this record.

Fixed in svn r760464 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=760464 )
junit added

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

2009-03-31 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46944





--- Comment #2 from criver...@gmail.com  2009-03-31 13:23:04 PST ---
(In reply to comment #0)
> I get the following exception when trying to refresh all formulas on an excel
> sheet.  I've attached an excel sheet and a java file that produce the error.
> 
> 
> java.lang.RuntimeException: Error Value can only be 0,7,15,23,29,36 or 42. It
> cannot be -30
> at
> org.apache.poi.hssf.record.BoolErrRecord.setValue(BoolErrRecord.java:101)
> at
> org.apache.poi.hssf.usermodel.HSSFCell.setCellErrorValue(HSSFCell.java:750)
> at
> org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.setCellValue(HSSFFormulaEvaluator.java:222)
> at
> org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateInCell(HSSFFormulaEvaluator.java:194)
> at
> com.tech_innovapr.poi.examples.UpdateFormulas.refreshWorkbookFormulas(UpdateFormulas.java:67)
> at
> com.tech_innovapr.poi.examples.UpdateFormulas.main(UpdateFormulas.java:25)

Ok I found that this doesn't happen when I use the
FormulaEvaluator.evaluateFormulaCell which should be the method used for
refreshing the sheet formulas instead of the one I was
using(FormulaEvaluator.evaluateInCell).  But I think the above error should be
checked out anyways.

-- 
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 46945] Eclipse won't comple BiffViewer

2009-03-31 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46945


Axel Rose  changed:

   What|Removed |Added

 Resolution|WORKSFORME  |REMIND




--- Comment #4 from Axel Rose   2009-03-31 
09:27:11 PST ---
Thanks, resolved by removing the jar used by poi-ruby

-- 
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 46945] Eclipse won't comple BiffViewer

2009-03-31 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46945


David Fisher  changed:

   What|Removed |Added

 Status|REOPENED|RESOLVED
 Resolution||WORKSFORME




--- Comment #3 from David Fisher   2009-03-31 08:49:23 
PST ---
Try taking out this:

path="src/contrib/poi-ruby/poi-2.0-final-20040126.jar"

That is another copy of poi. A very old one.

If Ruby support is important for you we should start a discussion on the poi
dev email list. As it looks like the Ruby contribution we have is missing
necessary glue.

Regards,
Dave

-- 
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 46945] Eclipse won't comple BiffViewer

2009-03-31 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46945


Axel Rose  changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|WORKSFORME  |




--- Comment #2 from Axel Rose   2009-03-31 
08:26:35 PST ---
I cannot get around this.

POI is the only project open in Eclipse.
My .classpath looks like this:






























This is what Eclipse sets up when importing a fresh svn tree.

OTOH I agree with Eclipse about the error.
BiffViewer uses
import org.apache.poi.hssf.record.*;

and references the type "AreaFormatRecord"

So I guess the import must be more explicit. AreaFormatRecord can be used
from anywhere within org.apache.poi.hssf.record, currently two places.

-- 
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 46945] Eclipse won't comple BiffViewer

2009-03-31 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46945


Nick Burch  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution||WORKSFORME




--- Comment #1 from Nick Burch   2009-03-31 07:45:26 PST ---
Eclipse compiles all of poi just fine for me

I suspect you've got two versions of poi on your eclipse path or something like
that, and it's getting confused between the old and new versions. You'll need
to just have one, consistent copy of poi

-- 
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 46945] New: Eclipse won't comple BiffViewer

2009-03-31 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46945

   Summary: Eclipse won't comple BiffViewer
   Product: POI
   Version: 3.5-dev
  Platform: All
OS/Version: All
Status: NEW
  Severity: normal
  Priority: P2
 Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: axel.roesl...@googlemail.com


Eclipse complains about 70 ambiguous types and refuses to compile BiffViewer.

$ svn status -v src/java/org/apache/poi/hssf/dev/BiffViewer.java
   760389   722401 josh
src/java/org/apache/poi/hssf/dev/BiffViewer.java

example error message

line #111
The type AreaFormatRecord is ambiguous

suggested solutions by Eclipse:
either explicetely import 'org.apache.poi.hssf.record.AreaFormatRecord'
or 'org.apache.poi.hssf.record.chart.AreaFormatRecord'

I fear that taking the Eclipse warning off results in unreliable execution.

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

2009-03-31 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46944





--- Comment #1 from criver...@gmail.com  2009-03-31 07:06:02 PST ---
Created an attachment (id=23431)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23431)
Excel and Java file to reproduce error

-- 
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] New: Error Value can only be 0,7,15,23,29,36 or 42. It cannot be -30

2009-03-31 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46944

   Summary: Error Value can only be 0,7,15,23,29,36 or 42. It
cannot be -30
   Product: POI
   Version: 3.2-FINAL
  Platform: PC
OS/Version: Windows XP
Status: NEW
  Severity: normal
  Priority: P2
 Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: criver...@gmail.com


I get the following exception when trying to refresh all formulas on an excel
sheet.  I've attached an excel sheet and a java file that produce the error.


java.lang.RuntimeException: Error Value can only be 0,7,15,23,29,36 or 42. It
cannot be -30
at
org.apache.poi.hssf.record.BoolErrRecord.setValue(BoolErrRecord.java:101)
at
org.apache.poi.hssf.usermodel.HSSFCell.setCellErrorValue(HSSFCell.java:750)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.setCellValue(HSSFFormulaEvaluator.java:222)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateInCell(HSSFFormulaEvaluator.java:194)
at
com.tech_innovapr.poi.examples.UpdateFormulas.refreshWorkbookFormulas(UpdateFormulas.java:67)
at
com.tech_innovapr.poi.examples.UpdateFormulas.main(UpdateFormulas.java:25)

-- 
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 46943] New: No display PromptBox in msExcel

2009-03-31 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46943

   Summary: No display PromptBox in msExcel
   Product: POI
   Version: 3.5-dev
  Platform: PC
OS/Version: Windows XP
Status: NEW
  Severity: normal
  Priority: P2
 Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: alcidesma...@gmail.com


DVConstraint dataValidation = null;
CellRangeAddressList region = new CellRangeAddressList(1, 10,
1, 10);
dataValidation = DVConstraint.createNumericConstraint(
ValidationType.DECIMAL, OperatorType.BETWEEN, String.valueOf
(-Double.MAX_VALUE),  String
.valueOf(Double.MAX_VALUE));

HSSFDataValidation ret = new HSSFDataValidation(region,
dataValidation);
ret.createPromptBox("Escriba un numero en esta casilla",
"");
ret.createErrorBox("Error de tipo de dato", "Se espera!!!");
ret.setShowPromptBox(true);
ret.setShowErrorBox(true);
currentSheet
.addValidationData(ret);


FileOutputStream fo= new FileOutputStream("excel.xls");
me.save(fo);
fo.close();

-- 
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 46938] Existing color palette is broken(or not used) when using cell styles from opened workbook and creating new

2009-03-31 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46938


Yegor Kozlov  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution||WONTFIX




--- Comment #7 from Yegor Kozlov   2009-03-31 06:12:52 PST ---
Maksym,

The problem seems to be specific to Excel 2007. Did you create the template in
Office 2007 and saved in the compatibility mode? Were there any warnings? 

If I open foo.xls in Excel 2007 then the foreground is light blue. If I open it
in Excel 2003 the foreground is white. It's not a bug of POI, rather a
"feature" of Excel. When saving custom colors in the .xls format, Excel 2007
does not translate them into the standard palette. That's why the foreground is
not recognized by Excel 2003.

The [XFEXT] (0x87D) record is not a part of the BIFF8 specification. It's a new
stuff introduced by Excel 2007. If you are fancy to decode it - patches are
welcome.  Otherwise, I would recommend you to create your templates in Excel
2003. This way it should always work.

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



DO NOT REPLY [Bug 46938] Existing color palette is broken(or not used) when using cell styles from opened workbook and creating new

2009-03-31 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46938





--- Comment #6 from Yegor Kozlov   2009-03-31 05:58:35 PST ---
Created an attachment (id=23430)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23430)
foo.xls opened in Excel 2007

-- 
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 46938] Existing color palette is broken(or not used) when using cell styles from opened workbook and creating new

2009-03-31 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46938





--- Comment #5 from Yegor Kozlov   2009-03-31 05:58:18 PST ---
Created an attachment (id=23429)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23429)
foo.xls opened in Excel 2003

Excel 2003 does not recognize custom palette saved in the compatibility mode in
Excel 2007. The foreground in A1 should be light blue.

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

2009-03-31 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 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-31032009.jar] identifier set to output 
basename: [poi-ooxml-gump]
 -DEBUG- Output [poi-contrib-gump-31032009.jar] identifier set to output 
basename: [poi-contrib-gump]
 -DEBUG- Output [poi-scratchpad-gump-31032009.jar] identifier set to output 
basename: [poi-scratchpad-gump]
 -DEBUG- Output [poi-gump-31032009.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=31032009 -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-31032009.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-31032009.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-api-31032009.jar:/srv/gump/public/workspace/apache-commons/beanutils/dist/commons-beanutils-31032009.jar:/srv/gump/public/workspace/apache-commons/collections/build/commons-collections-31032009.jar:/srv/gump/public/workspace/apache-commons/lang/target/commons-lang-3.0-SNAPSHOT.jar:/srv/gump/public/workspace/junit/dist/junit-31032009.jar:/srv/gump/public/workspace/xml-commons/java/external/build/xml-apis-ext.jar:/srv/gump/public/workspace/dom4j/build/dom4j.jar
-
Buildfile: /srv/gump/public/workspace/poi/build.xml

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
-

To subscribe to this information via syndic

DO NOT REPLY [Bug 46938] Existing color palette is broken(or not used) when using cell styles from opened workbook and creating new

2009-03-31 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46938


Maksym Symonov  changed:

   What|Removed |Added

 Status|NEEDINFO|NEW




--- Comment #4 from Maksym Symonov   2009-03-31 
00:23:43 PST ---
Yegor, problem is in row:
workbook.createCellStyle();
as you see created style isn't set to any of cells. Please, try commenting this
line in example code and look into results generated. Both cells A1 on on both
sheets should have light blue foreground as in existing.xls file which is some
kind of template for generating new.xls. If this row is commented all works
fine, style is fully copied to A1 on "test" sheet, if it is not both cells
loose their color and it becomes white.
After some more code exploring it was found that palette from original
existing.xls file after it is loaded by POI is stored at
HSSFWorkbook.workbook.records in a record of class UnknownRecord which has
toString() interpretation
[XFEXT] (0x87D)
  rawData=[7D, 08, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 3E, 00, 00,
00, 03, 00, 0D, 00, 14, 00, 03, 00, 00, 00, 01, 00, 00, 00, 04, 5F, 00, 2E, 00,
5F, 00, 2D, 0E, 00, 05, 00, 02, 04, 00, 14, 00, 02, 00, 00, 00, E7, EC, F4, FF,
23, 00, 30, 00, 2E, 00, 30, 00]
[/XFEXT]

needed light blue color is in this record in a rawdata field E7, EC, F4

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