Re: POI 3.0 RC4

2007-05-30 Thread Andrew C. Oliver
That is really dumb if we added commons-lang as a dependency to have a nested exception. -andy I have added a comment here: http://jira.codehaus.org/browse/MEV-479 Hope they gonna fix this soon. I will do my best to push this toppic... BTW did you notice this one: http://jira.codehaus.org/b

Re: There has got to be a way

2007-05-02 Thread Andrew C. Oliver
Another possibility. Styling was applied via row or colinfo records instead of by blank records. Try using org.apache.poi.hssf.dev.BiffViewer on your files. you can also use it in concert with the unix Diff command (try cygwin if you're on Windows) or your favorite alternative. Levi Strop

Re: hi all regarding introducing new methods

2007-05-02 Thread Andrew C. Oliver
http://jakarta.apache.org/poi/getinvolved/index.html Rajeshwar Mothe wrote: Hi all i want to contribute to POI - HWPF Actually how i need to include my method in to API and what is the actual procedure what are all the conditions by jakarta.apache.org to include my methods in to their AP

Re: how to find style in existing workbook for cell position with

2007-05-02 Thread Andrew C. Oliver
und in a ColumnInfoRecord, a RowRecord, a merged region record, etc., that all cover the same cell position, then which one takes precedence? The last one created? If so, then how is the creation order determined? --Michael -Original Message- From: Andrew C. Oliver [mailto:[EMAIL PROTEC

Re: how to find style in existing workbook for cell position with

2007-04-27 Thread Andrew C. Oliver
That said if someone wanted to implement Sheet.findStyle(row,col) that wouldn't be silly. It would be silly to return HSSFCell however. Andrew C. Oliver wrote: Guys HSSF is a file format API not a spreadsheet DOM even though usermodel exhibits some of those features to make things easier

Re: how to find style in existing workbook for cell position with no cell

2007-04-27 Thread Andrew C. Oliver
Guys HSSF is a file format API not a spreadsheet DOM even though usermodel exhibits some of those features to make things easier. It doesn't make sense for HSSF to map anything to BlankRecord except BlankRecord. Besides, you want HSSF to suck down MORE memory be creating MORE objects? Seriou

Re: 3.0 release (and maven)

2007-04-25 Thread Andrew C. Oliver
No you clarified that Maven is an even more convoluted clusterfsck than I remembered. Joerg Hohwiller wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Nick, On Tue, 24 Apr 2007, Joerg Hohwiller wrote: bugzilla http://issues.apache.org/bugzilla/ Thanks, I've

Re: Please help - unknown grbit '16'

2007-04-25 Thread Andrew C. Oliver
pe Mirosft excel workbook (*.xls) with no luck - assumed that has to be Excel 2000 format since I have office 2000. "Andrew C. Oliver" <[EMAIL PROTECTED]> 04/25/2007 09:53 AM Please respond to "POI Users List" To POI Users List cc Subject Re: Please help - unknown

Re: Please help - unknown grbit '16'

2007-04-25 Thread Andrew C. Oliver
That means it saved as a pre 1997 version of excel file format. HSSF only supports Biff8+ (Excel97 + not 5.0/95 which is different) Sara Uppalapati wrote: Hi Tahir, Thanks for your response. I opened user's version of excel file on my machine(which has office 2000) and saved as of type Micr

Re: Is there a way to listen for cells with no formating?

2007-04-20 Thread Andrew C. Oliver
Preferably implement it and supply a patch. You can probably add an instanceof UnknownRecord at the top of your switch statement. However UnknwonRecord isn't a cell type it means POI doesn't yet parse that record type. You're looking for the blank records that have nothing in them. Most of

Re: Encryption/password protected excel/word files

2007-04-17 Thread Andrew C. Oliver
Guys lets stay away from encryption. We'd have to do all this registering with the government and a whole lot of hassle for not much benefit. Lame encryption to boot. Nick Burch wrote: On Tue, 17 Apr 2007, Justin Warren wrote: I should mention that the exceptions don't really tell if the fil

Re: problem with HSSF eventusermodel

2007-04-16 Thread Andrew C. Oliver
Theoretically col and row records can appear anywhere in that section out of order (but don't when coming from excel). You have to either write them in some kind of better format to disk -- such as a temporary db file -- and then read that (to avoid storing it all in memory) in a guaranteed so

Re: Getting "class file has wrong version" error on poi-scratchpad-3.0-rc2 jar

2007-03-30 Thread Andrew C. Oliver
-Original Message- From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] Sent: Thursday, March 29, 2007 12:47 PM To: POI Users List Subject: Re: Getting "class file has wrong version" error on poi-scratchpad-3.0-rc2 jar yeah unless we've dropped 1.42 then it should

Re: Getting "class file has wrong version" error on poi-scratchpad-3.0-rc2 jar

2007-03-30 Thread Andrew C. Oliver
; On Friday 30 Mar 2007 5:38:40 am Karr, David wrote: I assume you're only half serious. Dropping 1.4.2 at this point would be a big mistake. In any case, I tried manually building the jars from source with JDK 1.4.2, and it works fine. -Original Message- From: Andrew C. Ol

Re: Getting "class file has wrong version" error on poi-scratchpad-3.0-rc2 jar

2007-03-30 Thread Andrew C. Oliver
d manually building the jars from source with JDK 1.4.2, and it works fine. -Original Message----- From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] Sent: Thursday, March 29, 2007 12:47 PM To: POI Users List Subject: Re: Getting "class file has wrong version" error on poi-sc

Re: Getting "class file has wrong version" error on poi-scratchpad-3.0-rc2 jar

2007-03-29 Thread Andrew C. Oliver
yeah unless we've dropped 1.42 then it should be compiled on 1.42. So the last build is invalid or we need a vote to drop 1.42 and req 5+ -andy David Fisher wrote: That class file was compiled with JDK 5.0 See http://blogs.sun.com/sundararajan/entry/java_class_ic_errors On Mar 29, 2007, at 2:

Re: POI-Ruby

2007-03-21 Thread Andrew C. Oliver
bits from poi-ruby compiled with gcj, and am attempting to wrap that myself instead of using SWIG. As far as open office and gnumeric, I have been unable to find a fully featured discrete library for writing XLS files from ruby on linux. Would be most appreciative if you could point me to one.

Re: POI-Ruby

2007-03-21 Thread Andrew C. Oliver
Why? Why not just compile with GCJ and then wrap that? Seems weird to go 3 techs deep... Also there are C utils for OLE and XLS. Check out open office and gnumeric...use those...doesn't make sense to use C->Ruby->POI Jeff Swensen wrote: I am attempting to write my own C wrapper for the PO

Re: Is POI still under active development?

2007-03-15 Thread Andrew C. Oliver
Jerry Jalenak wrote: I'm looking to use POI to load MS-Excel data to a Lucene index for a major project that I have going on, and I wondering about the current development status. The last final release (2.5.1) was in 2004; the current 3.x release is still in alpha state, and appears to have

Re: Jexcel and xlsql performance issue

2007-03-15 Thread Andrew C. Oliver
raju wrote: Hi We are using Jexcel in combination with xlsql driver. Performance seems top be hit badly when we try to read in a sheet.Xlsql seems to read the entire file for every sheet in the file. Sheet sh= Workbook.getWorkbook(file).getSheet(fileName); Please let me know ways in which per

Re: Shifting columns

2007-03-12 Thread Andrew C. Oliver
Khanh Tran wrote: Dear POI users , I am using POI 3.0 alpha. Is there any API that shift columns left and right (similar to shiftRows method of HSSFSheet). I've looked for it everywhere in POI. Thanks. you're most likely being ignored because it is really rude to cross post a question in t

Re: Numeric Cell Type not consistent

2007-03-01 Thread Andrew C. Oliver
You do realize that floating point numbers are always approximates? Both of the numbers below are "correct" ;-) Are you sure this is not a bug of POI? This is not a random problem. It always does so for the file. Also I can't enforce the decimal places. Also when I save as CSV and then

Re: What is the state of the project?

2007-02-04 Thread Andrew C. Oliver
proof of concept up and running in very little time. Andrew C. Oliver wrote: No. That would require a VBA interpreter. HSSF is not a spreadsheet engine/app/whatever it is an API to deal with a file format. Tom Muldoon wrote: Andrew, by "Macros can be there if ...", do you mean t

Re: What is the state of the project?

2007-02-03 Thread Andrew C. Oliver
executed. Thanks again, Tom Andrew C. Oliver wrote: The project is active. We just haven't put out an official release in awhile. Partly because builds/milestones are reasonably stable. Macros can be there if you set the preserve flag off the hssf workbook constructor. Tom Muldoon wrote

Re: What is the state of the project?

2007-02-03 Thread Andrew C. Oliver
sk is that the Limitations page states simply ... "Macros cannot be created. However, reading and re-writing files containing macros will safely preserve the macros." In other words, it doesn't actually state whether or not macros can be invoked / executed. Thanks again, To

Re: What is the state of the project?

2007-02-03 Thread Andrew C. Oliver
The project is active. We just haven't put out an official release in awhile. Partly because builds/milestones are reasonably stable. Macros can be there if you set the preserve flag off the hssf workbook constructor. Tom Muldoon wrote: I'm wondering what the state of the POI-HSSF project

Re: Autosizing question:

2007-01-24 Thread Andrew C. Oliver
Its actually more compounded than that. You can basically do this with Java's AWT Font/FontMetrics classes but the sizes are incompatible with Windows fonts (let alone Mac et al). Someone has to record the data for Windows fonts and or an API that reads the font files and calculates them. -Andy

Re: Numeric Cell Types.

2007-01-12 Thread Andrew C. Oliver
The fact that a string encodes a number isn't what this tells you. It is a datatype. The POI equivalent of: String foo = ""+123; if (foo instanceof Integer) { } You can look at the structure of your file with org.apache.poi.hssf.dev.BiffViewer, i.e.: java -classpath poi.jar org.apach

Re: Problems with HSSF and character sets

2006-12-09 Thread Andrew C. Oliver
http://jakarta.apache.org/poi/faq.html#faq-N100A4 FAQ #11. -andy Alain Mowat wrote: Hello, I'm having problems using HSSF with czech files, and probably other languages that have special characters in them. If I open a file, and then simply write this same file to the hard disk wi

Re: Which POI - HPSF API to use when you need to handle document property updates...

2006-03-22 Thread Andrew C. Oliver
The answer to this is always "whatever version passes your unit tests verifying the functionality you're using is stable enough for production" -Andy Jonathan Rengifo wrote: Hi Rainer I am really thankful for your help! Do you think this snapshot is stable enough for production environme

Re: getStorageClsid()

2006-03-21 Thread Andrew C. Oliver
Marc (who wrote most of POIFS) said he didn't know what the clsid was so he just set it to 0. [EMAIL PROTECTED] wrote: The sequence, as far as I can tell, is: 1) POIFSFileSystem(stream) is called 2) POIFSFileSystem() is the first call, which sets the property table to be new PropertyTable() a

Re: HSSF SeriesTextRecord not included in RecordFactory?

2006-03-11 Thread Andrew C. Oliver
wait just re-read this.. What is special about this sheet that readwrite files? Just that it has the seriestextrecord? Andrew C. Oliver wrote: That's probably why its not included then. [EMAIL PROTECTED] wrote: Sorry about the silence, I didn't get a chance to run the tests unt

Re: HSSF SeriesTextRecord not included in RecordFactory?

2006-03-11 Thread Andrew C. Oliver
ME?"s a cursory glance at the printlns for the stRecord.getText() seems to indicate that it is correct though. So reading seems to be fine. Jeff Wang diCarta, Inc. -Original Message- From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 08, 2006 4:28 PM To: poi-user@j

Re: HSSF - Generating large spreadsheets in streaming manner?

2006-03-10 Thread Andrew C. Oliver
not yet. Demand for the cocoon serializer hasn't been very high so it is mostly deprecated (unless there is some massive uptake of support for it). Okay its time for my yearly rant on this subject (not aimed at you...you just reminded me I hadn't done it this year): I'm always a little curi

Re: HSSF - Exception thrown when processing Outlook export

2006-03-09 Thread Andrew C. Oliver
sage. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.1/278 - Release Date: 09.03.2006 -- Andrew C. Oliver SuperLink Software, Inc. Java to Excel using POI http://www.superlinksoftware.com/services/poi Commercial support including features adde

Re: HSSF SeriesTextRecord not included in RecordFactory?

2006-03-08 Thread Andrew C. Oliver
just wondering whether the fact that it's not in RecordFactory is just a oversight(bug?) or was there a deliberate reason for removing it. Thanks for the help. Jeff Wang diCarta, Inc. -Original Message----- From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 08, 2006 2

Re: HSSF SeriesTextRecord not included in RecordFactory?

2006-03-08 Thread Andrew C. Oliver
ld it be? Jeff Wang diCarta, Inc. - To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ -- Andrew C. Oliver Sup

Re: Can't read SQL server generated excel file

2006-02-14 Thread Andrew C. Oliver
(BiffViewer.java:110) I'm not sure what that means? -Original Message- From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 14, 2006 3:06 PM To: POI Users List Subject: Re: Can't read SQL server generated excel file Probably can figure that out if you use BiffView

Re: Can't read SQL server generated excel file

2006-02-14 Thread Andrew C. Oliver
what that means? -Original Message----- From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 14, 2006 3:06 PM To: POI Users List Subject: Re: Can't read SQL server generated excel file Probably can figure that out if you use BiffViewer. http://jakarta.apache.org/poi/hs

Re: Can't read SQL server generated excel file

2006-02-14 Thread Andrew C. Oliver
Probably can figure that out if you use BiffViewer. http://jakarta.apache.org/poi/hssf/hacking-hssf.html Wennberg, Mathias wrote: Is there a way to check that? -Original Message- From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 14, 2006 2:33 PM To: POI

Re: Can't read SQL server generated excel file

2006-02-14 Thread Andrew C. Oliver
-- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ -- Andrew C. Oliver SuperLink Software, Inc. Java to Excel using POI http://www.superlinkso

Re: HPSF update

2006-02-14 Thread Andrew C. Oliver
Rainer Klute wrote: Von: "Andrew C. Oliver" <[EMAIL PROTECTED]> yeah I think either the page hasn't re-gen'd in awhile or hasn't been updated. BTW, how do you regenerate the website? I am just preparing a significant update to HPSF (high-level writ

Re: Excel 2003?

2006-02-14 Thread Andrew C. Oliver
read and write capability. Please see the HSSF project page for more information. regards, Vincent -- Andrew C. Oliver SuperLink Software, Inc. Java to Excel using POI http://www.superlinksoftware.com/services/poi Commercial support including features added/implemen

Re: HSSF: IndexOutOfBoundsException getting cell formula

2006-02-06 Thread Andrew C. Oliver
idea of what causes this error? Daniel -- Andrew C. Oliver SuperLink Software, Inc. Java to Excel using POI http://www.superlinksoftware.com/services/poi Commercial support including features added/implemented, bugs fixed. ---

Re: POI & JAF?

2005-10-28 Thread Andrew C. Oliver
Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ -- Andrew C. Oliver SuperLink Software, Inc. Java to Excel using POI http://www.superlinksoftware.com/services/poi Commercial support including features added/implemented, bugs fixed.

Re: POI Installation

2005-07-20 Thread Andrew C. Oliver
If you're on windows you can get cygwin (cygwin.com). It is a bash shell for Windows. Moreover you can download all the wonderful Linux command line tools (and even X stuff)! Most importantly, you can get the best editor ever -- vi (emacs is a cult not an editor). If you want a GUI then you

Re: ColumnInfo records

2005-07-19 Thread Andrew C. Oliver
found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.9.2/52 - Release Date: 7/19/2005 -- Andrew C. Oliver SuperLink Software, Inc. Java to Excel using POI http://www.superlinksoftware.com/servi

Re: ColumnInfo records

2005-07-18 Thread Andrew C. Oliver
e/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ -- Andrew C. Oliver SuperLink Software, Inc. Java to Excel using POI http://www.superlinksoftware.com/services/poi Commercial support including features added/implemented, bugs fixed. -

CVS

2005-07-17 Thread Andrew C. Oliver
follow later on. We will send seperate notices once services are restored. We are estimating a window of 4 hours. Thanks on behalf of the Infrastructure Team, Sander " -- Andrew C. Oliver SuperLink Software, Inc. Java to Excel using POI http://www.superlinksoftware.com/services/po

Re: Nightly Builds

2005-05-05 Thread Andrew C. Oliver
We no longer do nightly builds. We will be doing a milestone release soon. -Andy Tsoloane Moahloli wrote: Are these available for POI. I am stuck behind a firewall/proxy that does not allow cvs through and want to have a look at the latest MS Word stuff. Thanks --

Re: Urgent~ why I can't insert an image into excel by poi

2005-05-04 Thread Andrew C. Oliver
POI supports image inclusion. Patrick Fidler wrote: [EMAIL PROTECTED] wrote: Dear all Does anyone can insert an image into a excel file? I use the quick guide in hssf help as my program code..but it not work! It can generate a excel successfully, but an empty content.. When I close this file, e

Re: how should we release the memory

2005-05-04 Thread Andrew C. Oliver
cell style, font and sheet point to the workbook. So long as you hold a reference to any of those, you hold a reference to the workbook. Firouz Bharthania wrote: Yes I meant exactly the same. I made the reference to workbook pointing to null but it seems the objects do not get collected by GC !!

Re: how should we release the memory

2005-05-04 Thread Andrew C. Oliver
Set wb, sheet, cell style, font to null when you're done. Firouz Bharthania wrote: Hi, It seems that the memory does not get released after the excel document is created and written into the file!!! I highly appreciate is anybody can help me with this issue. Here it is the code I used to create

Re: Problem writing xls

2005-04-07 Thread Andrew C. Oliver
This is a file format port. The file format does not have the blank line. It is merely the absence of a row. This is the difference between a GRID model/spreadsheet engine and an API that represents the file format. A lot of folks think HSSF is a spreadsheet engine or port of Excel or whatever.

Re: PowerPoint Support

2005-02-18 Thread Andrew C. Oliver
Hi! Welcome! We're very interested in getting that work moving forward. Attach to bugzilla for now. Also get a Committer License Agreement signed complete with a public promise that "I have not now nor ever been a signator or otherwise bound by a microsoft NDA or other exclusionary agreement

Re: why doesnt poi.hssf count all columns ?

2005-02-01 Thread Andrew C. Oliver
In the past it was because the Excel Dev Guide said that it was supposed to be one less than the number of columns in the row (don't ask me why -- this file format is crap hence the name calling). If what you're saying is true, either this changed later or the book lied and I believed it. Not sur

Re: Simple Excel Read

2004-05-10 Thread Andrew C. Oliver
ng usermodel :-) In the future the two will be probably be more unified (presently there is plumbing code in the eventmodel/eventusermodel that needs to become the basis for the usermodel but I haven't gotten around to it). :-) -andy -- Andrew C. Oliver http://www.superlinksoftware.com/po

Re: POI Optimizations

2004-05-01 Thread Andrew C. Oliver
In the HEAD there is code which combines all rows and columns into one object and uses the smallest possible type for each. Its not mature yet and some features aren't supported by it. -Andy -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Comme

Re: How to distinguish between different dates formats and decimals

2004-04-12 Thread Andrew C. Oliver
To the other committers: Obviously replying to him will encourage this kind of behavior in the future. -Andy -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got

Re: How to distinguish between different dates formats and decimals

2004-04-10 Thread Andrew C. Oliver
it. Don't play dumb either, I simply cannot believe that it wouldn't occur to you that we didn't all want a duplicate of this message. -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.ap

Re: need help

2004-04-07 Thread Andrew C. Oliver
ere: http://java.sun.com/developer/onlineTraining/Programming/BasicJava1/windows. html Learn Java and then come back later. -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Exce

Re: Regarding HSSF Optimization

2004-04-07 Thread Andrew C. Oliver
The other constructor immediately wraps it in a POIFSFileSystem object. The InputStream version is just a convenience method. -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and

Re: Corruption problem with Excel

2004-04-06 Thread Andrew C. Oliver
Its best to email me privately for commercial arrangements. I'll reply to you offline. -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got POI? The views expr

Re: Corruption problem with Excel

2004-04-05 Thread Andrew C. Oliver
* spreadsheets and thus funded primarily that work. I'm working on a quote for another client who wants more of a read centric system and that may stabilize it, but its going to take a lot of use cases from folks to get it perfect. Keep adding sample sheets onto the bug. -- Andrew C. Oliver

Re: Problem generating a large file when following the POIFSstandard

2004-02-26 Thread Andrew C. Oliver
of their reasons. We've been there, done that and I've got the T-Shirt. Now move on. -Andy -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got POI? &g

Re: Problem generating a large file when following the POIFSstandard

2004-02-26 Thread Andrew C. Oliver
If this is a discussion towards the development of POI and not on usage it should move to POI-dev. -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got POI? > F

Re: Problem generating a large file when following the POIFSstandard

2004-02-26 Thread Andrew C. Oliver
file, but I've not done it in awhile. Also to make that big of a file with POI 2.0 you'll find we'll consume an oppressive amount of memory. The garbage collector will run wild. 3.0 should answer some of that once it gets under way. -- Andrew C. Oliver http://www.superlinksoftware.c

Re: Problem generating a large file when following the POIFSstand ard

2004-02-26 Thread Andrew C. Oliver
be driven from there. Anyone who is interested in scalable analytical reporting for the enterprise is certainly welcome to join me and help kick off the design phase. Its still a few months out before I devote my full attention to it due to the Mail Services project which I'm pretty focused on

Re: Problem generating a large file when following the POIFSstandard

2004-02-25 Thread Andrew C. Oliver
oject? So far: Andrew C. Oliver - No. Glen Stampoultzis (expertise: HSSF, Graphing, Escher, Code generation, original advocate for unit tests, second oldest timer on the project) - No Rainer Klute Ryan Ackley Avik Sengupta Shawn Laubach Danny Mui Jason Height Assuming it isn't a majo

Re: Problem generating a large file when following the POIFSstandard

2004-02-25 Thread Andrew C. Oliver
herever I can help. The quesiton was not C++ specific, it was merely about > the POIFS standard, so I think it's perfectly acceptable. > > I dont think you should have to donate code in order to get an answer about > how existing code works, even if you are deriving something fro

Re: Problem generating a large file when following the POIFS standard

2004-02-25 Thread Andrew C. Oliver
Unless you plan to donate the C++ code to the project, I'm not sure this is the appropriate place to ask your question. The source is open and free, the service (like helping you work on a proprietary language fork of POI) isn't. -- Andrew C. Oliver http://www.superlinksoftware.c

Re: tracking down "Unknown Ptg" errors

2004-02-24 Thread Andrew C. Oliver
ow to work with it, and so forth. Start with the TestFormula.java test case and work your way backwards. Its pretty elegant the way it works. In the future I think we'll need something more like JACC...However, its good right now. -andy -- Andrew C. Oliver http://www.superlinksoftware.c

Re: tracking down "Unknown Ptg" errors

2004-02-23 Thread Andrew C. Oliver
27;t do in formulas. If you're not happy writing parsers and playing with hex dumps, you can still contribute to the cause by filing a bug report and attaching a sample sheet. -Andy -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementat

Re: Clarification regarding Excel file format structure

2004-02-15 Thread Andrew C. Oliver
to the menu. As for the first 511 bytes, you're probably talking about the OLE 2 Compound Document that encapsulates the BIFF file. You'll find that fully documented on our site. -Andy -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and

Re: Excel documentation

2004-02-11 Thread Andrew C. Oliver
Please do not attempt to use this as I'm not sure of the legals. The Excel 97 developers kit and open office docs are the only approved documentation for contributing to HSSF. -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementatio

Re: Excel documentation

2004-02-10 Thread Andrew C. Oliver
Microsoft deliberately ceased publication of all materials on their low level formats after 1997. This information was also in the MSDN and was removed. It is now up to us to help them in keeping it documented! -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and

Re: Page Breaks

2004-02-08 Thread Andrew C. Oliver
If it introduces incompatible API changes in a different release (meaning new methods are fine, but method signature changes are not) -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For

Re: Creating merged cells through the HSSF Serializer?

2004-01-30 Thread Andrew C. Oliver
Its linked from the cocoon site. There isn't support for merged regions. >From a revenue standpoint the HSSF Serializer was a bomb so I more or less dropped it. I may pick it back up for refactoring eventually. -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancem

Re: can POI create a PDF from an XLS?

2004-01-29 Thread Andrew C. Oliver
erReports. I'm going after Actuate. -Andy -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got POI? The views expressed in this email are those of the author and are al

Re: HWPF Howto page, in process of building

2004-01-15 Thread Andrew C. Oliver
While I greatly appreciate the effort, wouldn't it make more sense to use the wiki or submit patches? I'm never very comfortable with moving documentation out of the project. One day Ryan will learn that project documentation == help == publicity. -- Andrew C. O

Re: Excel charts [Long]

2004-01-08 Thread Andrew C. Oliver
> So that's why I think you need to implement the Escher layer first. > > It will be implemented in a few days. I think Escher records are just being used for placement. I could be wrong though. -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements

Re: Excel charts

2004-01-08 Thread Andrew C. Oliver
ime and documentation. Both are in great shortage. The latter exacerbates the former. > What were these difficulties? > Chart records are a "delta" against a known-only-to-excel super-graph. Most of these records are completely undocumented. > How can we avoid th

Re: Excel charts

2004-01-08 Thread Andrew C. Oliver
Start here: http://jakarta.apache.org/poi/getinvolved/index.html -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got POI? The views expressed in this email are

Re: Excel charts

2004-01-08 Thread Andrew C. Oliver
You are wrong about drawing. Actually it looks like most of the records require for charting are there. Just someone needs to create a high level API and low level model for putting them together. -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial

Re: Locking up Application Server when creating new HSSFWorkbook

2004-01-06 Thread Andrew C. Oliver
e for WebSphere. Not that we're not partially at fault. Our next major version will go after memory/object counts. -Andy -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Exce

Re: Locking up Application Server when creating new HSSFWorkbook

2004-01-06 Thread Andrew C. Oliver
se to 1?? 5. Do you have a fat synchronized block containing this code? -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got POI? The views expressed in this email are

Re: poi/hssf memory help please

2003-12-23 Thread Andrew C. Oliver
The event API runs in under 7MB for up to about a 4mb file. :-) The HEAD can do a 4MB file using the user model in around 32mb. -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java

Re: poi/hssf memory help please

2003-12-22 Thread Andrew C. Oliver
Holy crap it looks like your total heap size is 32MB? Default in Java is like 64MB. >java -Xmx128m -Xms128m... Would set it to 128mb with a min of the same. I didn't know WL would run in only 32 mb! Wow! -andy -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enha

Re: xls2xml task

2003-12-18 Thread Andrew C. Oliver
It would be welcome here as well. -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got POI? The views expressed in this email are those of the author and are almost

Re: HSSF: Sheet Reference Formula not working

2003-12-17 Thread Andrew C. Oliver
Nope. Any volunteers? First step: move from cocoon to POI -- cocoon voted +1 -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got POI? The views expressed in this

Re: AW: Bad Filedescriptor

2003-12-17 Thread Andrew C. Oliver
Ahh yes...Classloaders... I just spent 2 weeks explaining classloaders and packaging in 2 different trainings.. Good stuff :-) I eat this stuff up. -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http

Re: AW: Bad Filedescriptor

2003-12-17 Thread Andrew C. Oliver
We don't have control over the exception. Its coming from java.io.FileOutputStream. -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got POI? The views express

Re: Bad Filedescriptor

2003-12-17 Thread Andrew C. Oliver
Do you have permissions to write there? Are you out of file handles? Is the file already closed? -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got POI? The views

Re: HSSF: Sheet Reference Formula not working

2003-12-16 Thread Andrew C. Oliver
Then you haven't checked recently. -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got POI? The views expressed in this email are those of the author and are a

Re: Complex Workbook

2003-12-15 Thread Andrew C. Oliver
No, not really. Show us things that don't work and provide samples. -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got POI? The views expressed in this emai

Re: Very strange issue w/HSSF serializer

2003-12-10 Thread Andrew C. Oliver
gt;> >> >> >> >> >> >> >> >> >> I can go into more depth but I figure if someone else has run >> into this, they should knwo the answer right off. >> >

Re: Including images in Excel sheet

2003-12-09 Thread Andrew C. Oliver
ficewriter.softartisans.com/default.aspx?PageID=67 > > The latest versions of these products seem to support Excel charts as well > as images. I haven't actually used any of these products, (other than > looking at the demos), so I can't say how well they work. > &

Re: Is POI thread safe?

2003-12-02 Thread Andrew C. Oliver
;> Hello, >>> I would like to know if POI is thread safe? I'm using POI with Cocoon >>> 2.0.4! >>> >>> Thanks >> >> --------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EM

Re: setCellValue(Date) is displayed ahead by 1 day and 4 years

2003-11-25 Thread Andrew C. Oliver
with interpreting the zero's for > time (which day does midnight belong to...), but I have no clue what the > problem could be for the year offset. > > Any input would be greatly appreciated. Thank you! > > -Sasha Borodin > > > ----------

Re: How to Determine if a Spreadsheet Contains Macros or VBA

2003-11-19 Thread Andrew C. Oliver
ll pursue. But as you can tell, I'm very new to the office > document file structure and to POI -- but luckily not to Java. > > I have the event api example from the HSSF website working, could this just > be another record type that I put in the switch statement? Or is it not that

  1   2   3   4   5   6   7   8   9   >