[EMAIL PROTECTED]: 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 [EMAIL PROTECTED] 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-contrib-gump-06052008.jar] identifier set to output basename: [poi-contrib-gump] -DEBUG- Output [poi-scratchpad-gump-06052008.jar] identifier set to output basename: [poi-scratchpad-gump] -DEBUG- Output [poi-gump-06052008.jar] identifier set to output basename: [poi-gump] -INFO- Failed with reason build failed -INFO- Failed to extract 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: 1 min 50 secs Command Line: /usr/lib/jvm/java-1.5.0-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=06052008 -f build.xml gump [Working Directory: /srv/gump/public/workspace/poi] CLASSPATH: /usr/lib/jvm/java-1.5.0-sun/lib/tools.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/test-classes:/srv/gump/public/workspace/poi/build/scratchpad-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-trax.jar:/srv/gump/public/workspace/ant/dist/lib/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-06052008.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-06052008.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-api- 06052008.jar:/srv/gump/public/workspace/apache-commons/beanutils/dist/commons-beanutils-06052008.jar:/srv/gump/public/workspace/apache-commons/collections/build/commons-collections-06052008.jar:/srv/gump/public/workspace/apache-commons/lang/commons-lang-06052008.jar:/srv/gump/public/workspace/junit/dist/junit-06052008.jar:/srv/gump/public/workspace/xml-commons/java/external/build/xml-apis-ext.jar - [junit] Running org.apache.poi.poifs.filesystem.TestDocumentInputStream [junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 3.624 sec [junit] Running org.apache.poi.poifs.filesystem.TestDocumentNode [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.027 sec [junit] Running org.apache.poi.poifs.filesystem.TestDocumentOutputStream [junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.005 sec [junit] Running org.apache.poi.poifs.filesystem.TestEmptyDocument [junit] written [junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.056 sec [junit] Running org.apache.poi.poifs.filesystem.TestOffice2007XMLException [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.06 sec [junit] Running org.apache.poi.poifs.filesystem.TestPOIFSDocumentPath [junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.006 sec [junit] Running org.apache.poi.poifs.filesystem.TestPOIFSFileSystem [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.047 sec [junit] Running org.apache.poi.poifs.filesystem.TestPropertySorter [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.065 sec [junit] Running org.apache.poi.poifs.property.TestDirectoryProperty [junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 0.106 sec [junit] Running org.apache.poi.poifs.property.TestDocumentProperty [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.012 sec [junit] Running org.apache.poi.poifs.property.TestPropertyFactory [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.02 sec [junit] Running org.apache.poi.poifs.property.TestPro
DO NOT REPLY [Bug 44898] Regression: Cannot remove block
https://issues.apache.org/bugzilla/show_bug.cgi?id=44898 --- Comment #8 from Trejkaz <[EMAIL PROTECTED]> 2008-05-06 16:01:24 PST --- It isn't really "hiding" the EOF, it's simply moving it to where the file is actually EOF. Previously it would be: * 512 byte block * ... * 512 byte block * short block (claims to be EOF) Whatever reads it from the outside said "oh, EOF... so discard the entire block." Now it's: * 512 byte block * ... * 512 byte block * short block * EOF I'm not really sure what's wrong with representing it how it really is. But if you want to pad the file, go ahead... not padding it doesn't seem to have any drawback either since if it's a short block then the document entry for it won't result in reading past the end of the data which is actually there. -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44944] Unable to construct record instance
https://issues.apache.org/bugzilla/show_bug.cgi?id=44944 Jen <[EMAIL PROTECTED]> changed: What|Removed |Added Status|NEW |RESOLVED Resolution||FIXED --- Comment #1 from Jen <[EMAIL PROTECTED]> 2008-05-06 14:18:51 PST --- Update: I have tried with the latest build poi-3.1-beta2-20080506.jar and the issue went away. Thanks. -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44944] New: Unable to construct record instance
https://issues.apache.org/bugzilla/show_bug.cgi?id=44944 Summary: Unable to construct record instance Product: POI Version: 3.0-dev Platform: PC OS/Version: Windows XP Status: NEW Severity: blocker Priority: P1 Component: HSSF AssignedTo: dev@poi.apache.org ReportedBy: [EMAIL PROTECTED] Created an attachment (id=21927) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=21927) sample excel sheet with data validation and formulas created with MS excel 2003 Hi, I am having trouble opening the attached excel file to read and write. I am getting the errors below. I am using POI poi-3.0.2-FINAL-20080204.jar. Any help would be appreciated. Thanks. Jen Exception in thread "main" org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:199) at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:117) at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:207) at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:148) at parseExcelToXML.ParseExcel.main(ParseExcel.java:48) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:494) at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:187) ... 4 more Caused by: java.lang.ArrayIndexOutOfBoundsException at org.apache.poi.hssf.record.RecordInputStream.checkRecordPosition(RecordInputStream.java:132) at org.apache.poi.hssf.record.RecordInputStream.readShort(RecordInputStream.java:152) at org.apache.poi.hssf.util.HSSFCellRangeAddress.fillFields(HSSFCellRangeAddress.java:77) at org.apache.poi.hssf.util.HSSFCellRangeAddress.(HSSFCellRangeAddress.java:65) at org.apache.poi.hssf.record.DVRecord.fillFields(DVRecord.java:207) at org.apache.poi.hssf.record.Record.(Record.java:55) at org.apache.poi.hssf.record.DVRecord.(DVRecord.java:134) ... 9 more -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 41906] bug in SUMIF formula
https://issues.apache.org/bugzilla/show_bug.cgi?id=41906 --- Comment #6 from Josh Micich <[EMAIL PROTECTED]> 2008-05-06 08:56:51 PST --- (In reply to comment #5) > I think that current POI behaviour (3.1-beta) has regression, Sorry I mis-typed. I meant "Re-tested in 3.1-beta2". Bug 44675 was completed after 3.1-beta1. You can either wait for the beta2 release, grab a nightly build, or build directly from svn trunk. > Why the second argument should be 'value' not 'reference'? > I seems Excel supports reference as the second argument. 'Operand classes' are different to token types. If the second arg is a reference, the token type will be 'tRef'. Depending on the operand class, it will be 'tRefR', 'tRefV', or 'tRefA'. -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44898] Regression: Cannot remove block
https://issues.apache.org/bugzilla/show_bug.cgi?id=44898 --- Comment #7 from Nick Burch <[EMAIL PROTECTED]> 2008-05-06 08:29:37 PST --- I don't like the idea of just hiding the EOF Maybe the right solution is that if we have a short last block, we detect this, then pad it out to the required 512 byte multiple? -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44524] Process embedded office documents
https://issues.apache.org/bugzilla/show_bug.cgi?id=44524 Nick Burch <[EMAIL PROTECTED]> changed: What|Removed |Added Status|ASSIGNED|RESOLVED Resolution||FIXED --- Comment #6 from Nick Burch <[EMAIL PROTECTED]> 2008-05-06 08:21:47 PST --- 3.1 beta 1 included support and documentation on working with embeded files -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 42564] org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance
https://issues.apache.org/bugzilla/show_bug.cgi?id=42564 --- Comment #18 from Peter J. Krum <[EMAIL PROTECTED]> 2008-05-06 08:14:17 PST --- Thanks! -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 42564] org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance
https://issues.apache.org/bugzilla/show_bug.cgi?id=42564 --- Comment #17 from Nick Burch <[EMAIL PROTECTED]> 2008-05-06 08:07:16 PST --- (In reply to comment #16) > Do you know when the next build will be? Nightly builds are available from http://encore.torchbox.com/poi-svn-build/ -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 42564] org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance
https://issues.apache.org/bugzilla/show_bug.cgi?id=42564 --- Comment #16 from Peter J. Krum <[EMAIL PROTECTED]> 2008-05-06 08:01:33 PST --- Thanks guys! This is much appreciated! Do you know when the next build will be? -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Does POI Support Streaming?
On Tue, 6 May 2008, Faisal Maqsood wrote: > There is no my own code inside. It is just the example code sent in the > link. >From your own trace: 79.6% - fm.poi.EventExample.processRecord that tells us that ~80% of the time is in _your own_ code. No idea where the rest is, as your profiler doesn't appear to be able to add up... Nick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Does POI Support Streaming?
There is no my own code inside. It is just the example code sent in the link. But yes by removing the "System.out.println..." lines from the code, it is much faster (around 8-9 times fast). Regards, Faisal Maqsood -Original Message- From: Nick Burch [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 06, 2008 6:30 PM To: Faisal Maqsood Cc: 'POI Developers List' Subject: RE: Does POI Support Streaming? On Tue, 6 May 2008, Faisal Maqsood wrote: > Thanks for your time and your comments can help to make our views better > about POI API but it seems profiler is showing different statistics. A > zip file is attached containing profiler snap shot and two images. If > you have not installed JProfiler4, images for CPU and VM view to show > where the time is consumed. Looking at that, at least 80% of the time is spent in your code, and around 60% of your time is spent printing stuff out Seems to me that the poi component of your cpu time is pretty negligable. You'll need to optimise your own code Nick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44893] [PATCH] autoSizeColumn doesn' t consider merged regions or indenting
https://issues.apache.org/bugzilla/show_bug.cgi?id=44893 Michael Hall <[EMAIL PROTECTED]> changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|FIXED | --- Comment #7 from Michael Hall <[EMAIL PROTECTED]> 2008-05-06 06:50:55 PST --- Reopened for new patch which provides an alternate method to auto-size using the content of merged cells. -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44893] [PATCH] autoSizeColumn doesn' t consider merged regions or indenting
https://issues.apache.org/bugzilla/show_bug.cgi?id=44893 Michael Hall <[EMAIL PROTECTED]> changed: What|Removed |Added Attachment #21871|0 |1 is obsolete|| --- Comment #6 from Michael Hall <[EMAIL PROTECTED]> 2008-05-06 06:50:06 PST --- Created an attachment (id=21926) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=21926) Added boolean flag to turn on use of merged columns in autosize Changed POI to create extra method signature: HSSFSheet#autoSizeColumn(short column, boolean useMergedCells) So that the default behavior can be to ignore them, to preserve backwards compatibility, while giving developers the option to use them when desirable. -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Does POI Support Streaming?
On Tue, 6 May 2008, Faisal Maqsood wrote: > Thanks for your time and your comments can help to make our views better > about POI API but it seems profiler is showing different statistics. A > zip file is attached containing profiler snap shot and two images. If > you have not installed JProfiler4, images for CPU and VM view to show > where the time is consumed. Looking at that, at least 80% of the time is spent in your code, and around 60% of your time is spent printing stuff out Seems to me that the poi component of your cpu time is pretty negligable. You'll need to optimise your own code Nick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44501] ArrayIndexOutOfBoundsException when extracting text from Visio Files on Linux .
https://issues.apache.org/bugzilla/show_bug.cgi?id=44501 [EMAIL PROTECTED] changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|FIXED | --- Comment #15 from [EMAIL PROTECTED] 2008-05-06 05:01:59 PST --- I have tried with the new release "poi-bin-3.1-beta1-20080428". I stil have the same problem. Stacktrace: java.lang.ArrayIndexOutOfBoundsException: 57 at org.apache.poi.util.LittleEndian.getNumber(LittleEndian.java:502) at org.apache.poi.util.LittleEndian.getDouble(LittleEndian.java:220) at org.apache.poi.hdgf.chunks.Chunk.processCommands(Chunk.java:174) at org.apache.poi.hdgf.chunks.ChunkFactory.createChunk(ChunkFactory.java:171) at org.apache.poi.hdgf.streams.ChunkStream.findChunks(ChunkStream.java:58) at org.apache.poi.hdgf.streams.PointerContainingStream.findChildren(PointerContainingStream.java:92) at org.apache.poi.hdgf.HDGFDiagram.(HDGFDiagram.java:92) at org.apache.poi.hdgf.extractor.VisioTextExtractor.(VisioTextExtractor.java:47) at org.apache.poi.hdgf.extractor.VisioTextExtractor.(VisioTextExtractor.java:51) -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Does POI Support Streaming?
Thank you for instant reply and to the point example code. I have following observations with this sample code: *** Whether parsing 38MB file or 6MB file, the example code consume around 50MB of heap memory *** It took around 6.5minutes for 6MB while for 38MB it took around 20 minutes in parsing and displaying the contents Your comments for how to improve these statistics will be highly appreciated. Optional: If there is any way to compute how much time will it need to complete the file parsing? Regards, Faisal Maqsood -Original Message- From: Nick Burch [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 06, 2008 3:02 PM To: POI Developers List Cc: 'Faisal Maqsood' Subject: Re: Does POI Support Streaming? On Tue, 6 May 2008, Faisal Maqsood wrote: > Can any of you guide us how to use this API in streaming i.e. a way that > instead of loading complete file http://poi.apache.org/hssf/how-to.html#event_api Nick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Does POI Support Streaming?
On Tue, 6 May 2008, Faisal Maqsood wrote: > I have following observations with this sample code: > > *** Whether parsing 38MB file or 6MB file, the example code consume around > 50MB of heap memory Sounds about right > *** It took around 6.5minutes for 6MB while for 38MB it took around 20 > minutes in parsing and displaying the contents Run a profiler and see where your time is being spent. I have a hunch it won't be in poi, as I've never noticed the event usermodel code take more than about a second Nick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Does POI Support Streaming?
On Tue, 6 May 2008, Faisal Maqsood wrote: > Can any of you guide us how to use this API in streaming i.e. a way that > instead of loading complete file http://poi.apache.org/hssf/how-to.html#event_api Nick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Does POI Support Streaming?
Hello Team, We found this API useful but it is putting us in out of memory problem using for excel files. Below are some statistics of memory consumed. Can any of you guide us how to use this API in streaming i.e. a way that instead of loading complete file, it load first n records and on accessing (n+1)th record, it unload n loaded records from the memory and load n+1 to 2n records and so on. File Type Records API Used for Excel Manipulation Operation File Size (MB) Memory Consumed (MB) Excel 25,000 Apache POI Load Only 2.35 MB Approx 60 MB I will appreciate if I some sample code or useful links in the reply. Regards, Faisal Maqsood
DO NOT REPLY [Bug 41906] bug in SUMIF formula
https://issues.apache.org/bugzilla/show_bug.cgi?id=41906 --- Comment #5 from enterit <[EMAIL PROTECTED]> 2008-05-06 00:51:12 PST --- Why the second argument should be 'value' not 'reference'? I seems Excel supports reference as the second argument. I am able to create cell with formula "=SUMIF(A1:A100;B1;C1:C100)" using Excel 2007. I think that current POI behaviour (3.1-beta) has regression, since it does not allow to create such formulas (neither "..;B1;.." nor "..;B1+0;.." can be created). -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]