Moving HWPF out of scratchpad
To all committers, I would like to get feel out everyones thoughts on moving HWPF out of scratchpad. More specifically, what requirements do you want me to meet before you would be willing to vote for this to happen? Avik and I are writing an article for JDJ and it will contain material on HWPF. For this article to have the maximum benefit, I feel that HWPF should be as easily accessible as possible. How about a 2.6 release containing HWPF? thoughts? -Ryan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 24925] - Nested IF Formula results in #VALUE! in Excel
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://issues.apache.org/bugzilla/show_bug.cgi?id=24925. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=24925 Nested IF Formula results in #VALUE! in Excel --- Additional Comments From [EMAIL PROTECTED] 2004-03-24 20:41 --- Created an attachment (id=10962) The REAL proposed fix for nested if #VALUE problem - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 24925] - Nested IF Formula results in #VALUE! in Excel
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://issues.apache.org/bugzilla/show_bug.cgi?id=24925. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=24925 Nested IF Formula results in #VALUE! in Excel [EMAIL PROTECTED] changed: What|Removed |Added Summary|Nested IF Formula results in|Nested IF Formula results in |#VALUE! in Excel |#VALUE! in Excel --- Additional Comments From [EMAIL PROTECTED] 2004-03-24 20:44 --- The problem is that cell references in the nested ifs were not getting their Token classes set properly because the recursion would bail out early when it reached nodes that were not AbstractFunctionPtgs. In fact, we want to recurse into the entire tree to push out this token munging stuff. NOTE: The second patch file i submitted is the one i am proposing. The other one is just cruft. Sorry. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Moving HWPF out of scratchpad
+0 Whilst I haven't a need to use HWPF, from what I have seen in the last few weeks it has some momentum behind it, and at a seemingly fit state for it to be promoted. Certainly judging by the number of bug reports filed against HSSF recently it couldn't be any worse ;-) Jason -Original Message- From: Ryan Ackley [mailto:[EMAIL PROTECTED] Sent: Thursday, 25 March 2004 5:31 AM To: POI Developers List Subject: Moving HWPF out of scratchpad To all committers, I would like to get feel out everyones thoughts on moving HWPF out of scratchpad. More specifically, what requirements do you want me to meet before you would be willing to vote for this to happen? Avik and I are writing an article for JDJ and it will contain material on HWPF. For this article to have the maximum benefit, I feel that HWPF should be as easily accessible as possible. How about a 2.6 release containing HWPF? thoughts? -Ryan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail (including attachments) is confidential information of Australian Submarine Corporation Pty Limited (ASC). It may also be legally privileged. Unauthorised use and disclosure is prohibited. ASC is not taken to have waived confidentiality or privilege if this e-mail was sent to you in error. If you have received it in error, please notify the sender promptly. While ASC takes steps to identify and eliminate viruses, it cannot confirm that this e-mail is free from them. You should scan this e-mail for viruses before it is used. The statements in this e-mail are those of the sender only, unless specifically stated to be those of ASC by someone with authority to do so.
DO NOT REPLY [Bug 27921] New: - Unicode format support hidden from user-model
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://issues.apache.org/bugzilla/show_bug.cgi?id=27921. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=27921 Unicode format support hidden from user-model Summary: Unicode format support hidden from user-model Product: POI Version: 2.0FINAL Platform: Other OS/Version: Other Status: NEW Severity: Normal Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] When using the HSSF* classes, there doesn't appear to be an easy way to get FormatRecords to support unicode. Analogous to Bug #22957, I propose that the FormatRecord automatically detect if unicode is needed. Then, you don't need to expose the explicit unicode support. I've attached a patch (including an extension to StringUtil to detect unicode required strings). - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 27887] - java.lang.NegativeArraySizeException
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://issues.apache.org/bugzilla/show_bug.cgi?id=27887. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=27887 java.lang.NegativeArraySizeException --- Additional Comments From [EMAIL PROTECTED] 2004-03-24 23:23 --- Created an attachment (id=10965) when trying to read the property set of this file I get the exception. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 27929] New: - Opening XLS file with drop down list throws ArrayIndexOutofBoundsException
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://issues.apache.org/bugzilla/show_bug.cgi?id=27929. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=27929 Opening XLS file with drop down list throws ArrayIndexOutofBoundsException Summary: Opening XLS file with drop down list throws ArrayIndexOutofBoundsException Product: POI Version: 2.0FINAL Platform: All OS/Version: All Status: NEW Severity: Major Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Using POI version 2.5 final. When given an XLS file with a drop-down list, the constructor call to HSSFWorkbook throws the following exception: java.lang.reflect.InvocationTargetException: java.lang.ArrayIndexOutOfBoundsException at java.lang.System.arraycopy(Native Method) at org.apache.poi.hssf.record.UnknownRecord.init (UnknownRecord.java:62) at org.apache.poi.hssf.record.SubRecord.createSubRecord (SubRecord.java:57) at org.apache.poi.hssf.record.ObjRecord.fillFields(ObjRecord.java:99) at org.apache.poi.hssf.record.Record.fillFields(Record.java:90) at org.apache.poi.hssf.record.Record.init(Record.java:55) at org.apache.poi.hssf.record.ObjRecord.init(ObjRecord.java:61) at java.lang.reflect.Constructor.newInstance(Native Method) at org.apache.poi.hssf.record.RecordFactory.createRecord (RecordFactory.java:224) at org.apache.poi.hssf.record.RecordFactory.createRecords (RecordFactory.java:160) at org.apache.poi.hssf.usermodel.HSSFWorkbook.init (HSSFWorkbook.java:165) at org.apache.poi.hssf.usermodel.HSSFWorkbook.init (HSSFWorkbook.java:132) at nas.components.nruf.poi25test.main(poi25test.java:14) Exception in thread main org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance, the fo llowing exception occured: null at org.apache.poi.hssf.record.RecordFactory.createRecord (RecordFactory.java:237) at org.apache.poi.hssf.record.RecordFactory.createRecords (RecordFactory.java:160) at org.apache.poi.hssf.usermodel.HSSFWorkbook.init (HSSFWorkbook.java:165) at org.apache.poi.hssf.usermodel.HSSFWorkbook.init (HSSFWorkbook.java:132) at nas.components.nruf.poi25test.main(poi25test.java:14) I will attach the simple Java program used and an offending XLS file. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 27929] - Opening XLS file with drop down list throws ArrayIndexOutofBoundsException
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://issues.apache.org/bugzilla/show_bug.cgi?id=27929. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=27929 Opening XLS file with drop down list throws ArrayIndexOutofBoundsException --- Additional Comments From [EMAIL PROTECTED] 2004-03-25 01:02 --- Created an attachment (id=10968) Java program that reproduces the bug - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 27929] - Opening XLS file with drop down list throws ArrayIndexOutofBoundsException
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://issues.apache.org/bugzilla/show_bug.cgi?id=27929. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=27929 Opening XLS file with drop down list throws ArrayIndexOutofBoundsException --- Additional Comments From [EMAIL PROTECTED] 2004-03-25 01:06 --- Created an attachment (id=10969) XLS file (with drop down) that causes bug - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 27933] New: - Unable to use a template (xls) file containing a wmf graphic
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://issues.apache.org/bugzilla/show_bug.cgi?id=27933. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=27933 Unable to use a template (xls) file containing a wmf graphic Summary: Unable to use a template (xls) file containing a wmf graphic Product: POI Version: 2.0FINAL Platform: PC OS/Version: Windows NT/2K Status: NEW Severity: Major Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] I was recommended to file this into Buzilla from someone on the POI User list. Note: The version I am using is POI 2.5 Final (which is not in the version list, so I chose 2.0 Final) -Original Message- From: Daniel Joshua [mailto:[EMAIL PROTECTED] Sent: Tuesday, 23 March, 2004 5:09 PM To: [EMAIL PROTECTED] Subject: RE: Unable to use a template (xls) file containing a wmf graphic Hi, I encountered a similiar problem as Mathieu. (I did a search on the archives and realised I am not the only one) Let me state my exact scenario in hopes that my added details will help. I use POI to create Excel spreadsheets with dynamic data using a template (.xls) file. Previously, I was using and older version of POI [File size: 605 KB (620,262 bytes)] which worked fine. However, I recently upgraded it to POI 2.5 Final, and it started having problems. I been using the same test files for both versions (if anyone want a copy I can send it to you). What happen is that there was a graphic in my excel which caused the produced Excel file which could not be opened. Also, there was NO exceptions/errors thrown from POI. Later when I read the below post, I tried to remove the graphic and 'viola' it worked correctly. Has anyone an idea why this is happening? Any quick remedies? My system specs: OS: Windows 2000 Server JRE: 1.4.1_02-b06 Excel 2000 (9.0.2720) Regards, Daniel -Original Message- From: mathieu . fretiere Subject: Unable to use a template (xls) file containing a wmf graphic Date: Thu, 04 Mar 2004 02:24:47 -0800 Hi, my web application creates an Excel sheet with HSSF. It reads first a template file (an xls file) containing a wmf (Windows Metafile) graphic. Sometimes it works fine, if I use a plain wmf (or emf) graphic. But if the wmf is more complex, Excel cannot read the generated file. This error message appears in a pop-up : Impossible to read the file. It doesn't work either if I use a jpg or tiff graphic. Where does this issue come from ? Is the wmf file too big ? For information, I use : - Tomcat 4.1.18 - Windows 2000 - IE 6, Excel 2000 thanks, Mathieu - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Moving HWPF out of scratchpad
Am Mit, 2004-03-24 um 20.00 schrieb Ryan Ackley: I would like to get feel out everyones thoughts on moving HWPF out of scratchpad. +0 Best regards Rainer Klute Rainer Klute IT-Consulting GmbH Dipl.-Inform. Rainer Klute E-Mail: [EMAIL PROTECTED] Körner Grund 24 Telefon: +49 172 2324824 D-44143 Dortmund Telefax: +49 231 5349423 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Moving HWPF out of scratchpad
I am very keen to see HWPF move out of scratchpad, it seems to have a lot of momentum recently. I was about to write a mail on this, Ryan beat me to it. So lets do that ASAP, i think. We should also do a dev release with this in, but I am -1 to calling it a 2.6. And I certainly disagree to adding HWPF to a bugfix release of 2.5.1. I dont think our long-suffering users would appreciate that :) Guys, I really think we really have to get our version numbering sane. We seem to have introduced a few regressions in 2.5, tho we called it a prod release. So I am all for doing a release, but calling it dev/beta whatever. What do you think? On Thu, 2004-03-25 at 00:30, Ryan Ackley wrote: To all committers, I would like to get feel out everyones thoughts on moving HWPF out of scratchpad. More specifically, what requirements do you want me to meet before you would be willing to vote for this to happen? Avik and I are writing an article for JDJ and it will contain material on HWPF. For this article to have the maximum benefit, I feel that HWPF should be as easily accessible as possible. How about a 2.6 release containing HWPF? thoughts? -Ryan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]