DO NOT REPLY [Bug 30714] HSSFSheet.setRowSumsBelow is not working

2009-02-27 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=30714


Adam ak.apa...@a9k.co.uk changed:

   What|Removed |Added

 CC||ak.apa...@a9k.co.uk




-- 
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 46774] Extreme memory usage in XSSF workbook

2009-02-27 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46774


Nick Burch n...@torchbox.com changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution||WONTFIX




--- Comment #4 from Nick Burch n...@torchbox.com  2009-02-27 04:45:54 PST ---
XSSF is xml based, so processing the files will always take more memory than
using HSSF. Also, in the interests of developer time, we use XML Beans, which
allows faster development at the expense of more memory used.

If this is proving to be a problem for you, do please do some profiling to
identify the heavy memory use areas, and contribute back patches to reduce the
memory use!

-- 
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 45260] Excel file unreadable due to applyFont()

2009-02-27 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=45260


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

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|REMIND  |




--- Comment #13 from Yegor Kozlov ye...@dinom.ru  2009-02-27 06:25:13 PST ---
Is there anything special in the way you create / set rich text strings? Can
you post the code you used to generated the attached files? 

Compare two code snippets:

HSSFRichTextString str1 = new HSSFRichTextString(Andritz AG, Graz
Short Name: AAG);
str1.applyFont(0, 16, FONT_CELL_HEADER_BLUE.getIndex());
str1.applyFont(17, 29, FONT_ITALIC.getIndex());
str1.applyFont(29, 32, FONT.getIndex());
cell.setCellValue(str1);


HSSFRichTextString str2 = new HSSFRichTextString(Andritz AG, Graz
Short Name: AAG);
cell2.setCellValue(str2);
str2.applyFont(0, 16, FONT_CELL_HEADER_BLUE.getIndex());
str2.applyFont(17, 29, FONT_ITALIC.getIndex());
str2.applyFont(29, 32, FONT.getIndex());

They are not equivalent. The second one is incorrect and can produce wrong
results. Once a HSSFRichTextString  is assigned, it is supposed to be
immutable. I would say in the latter case the code should throw
IllegalStateException. We don't do that only because of backwards
compatibility. 

One of the problems with beta5fileMissingFonts.xls is that the internal cache
of strings is incorrect. There are duplicate entries and as result,
beta5fileMissingFonts.xls is 504 KB while beta3fileAllFonts.xls is just 331 KB. 
Internally, Excel stores all strings in a shared string table which is shared
across workbook. Text cells just contain indexes into the string table as the
value of a cell, instead of the full string. If the string cache is broken, it
is very likely to be the reason why some fonts are missing. 

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 46774] Extreme memory usage in XSSF workbook

2009-02-27 Thread bugzilla
https://issues.apache.org/bugzilla/show_bug.cgi?id=46774





--- Comment #5 from Yegor Kozlov ye...@dinom.ru  2009-02-27 06:29:32 PST ---
There was a discussion about it some time ago. See
http://markmail.org/thread/vqut6wy3ashguz6x

A possible workaround is to stream your data directly in XML.  See an example
demonstrating my idea: 
http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/BigGridDemo.java

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



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

2009-02-27 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 Failed'.
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-27022009.jar] identifier set to output 
basename: [poi-ooxml-gump]
 -DEBUG- Output [poi-contrib-gump-27022009.jar] identifier set to output 
basename: [poi-contrib-gump]
 -DEBUG- Output [poi-scratchpad-gump-27022009.jar] identifier set to output 
basename: [poi-scratchpad-gump]
 -DEBUG- Output [poi-gump-27022009.jar] identifier set to output basename: 
[poi-gump]
 -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: 2 secs
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=27022009 -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-27022009.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-27022009.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-api-27022009.jar:/srv/gump/public/workspace/apache-commons/beanutils/dist/commons-beanutils-27022009.jar:/srv/gump/public/workspace/apache-commons/collections/build/commons-collections-27022009.jar:/srv/gump/public/workspace/apache-commons/lang/commons-lang-27022009.jar:/srv/gump/public/workspace/junit/dist/junit-27022009.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
  [get] Error opening connection java.io.FileNotFoundException: 
http://mirrors.ibiblio.org/pub/mirrors/maven2/commons-logging/commons-logging/1.1/commons-logging-1.1.jar
  [get] Error opening connection java.io.FileNotFoundException: 
http://mirrors.ibiblio.org/pub/mirrors/maven2/commons-logging/commons-logging/1.1/commons-logging-1.1.jar
  [get] Error opening connection java.io.FileNotFoundException: 
http://mirrors.ibiblio.org/pub/mirrors/maven2/commons-logging/commons-logging/1.1/commons-logging-1.1.jar
  [get] Can't get 
http://www.ibiblio.org/maven/commons-logging/jars/commons-logging-1.1.jar to 
/srv/gump/public/workspace/poi/lib/commons-logging-1.1.jar

BUILD FAILED
/srv/gump/public/workspace/poi/build.xml:331: The following error occurred 
while executing this line:
/srv/gump/public/workspace/poi/build.xml:313: Can't get