printing sheet (hssf)

2007-01-12 Thread Tono
is there a method to print the sheet ? thanx -- View this message in context: http://www.nabble.com/printing-sheet-%28hssf%29-tf2970244.html#a8311273 Sent from the POI - User mailing list archive at Nabble.com. - To unsubscri

Re: HSSF - Generating large spreadsheets in streaming manner?

2007-01-12 Thread Sanjiv Jivan
That seems to make sense. Thanks. On 1/12/07, David Fisher <[EMAIL PROTECTED]> wrote: Accept state and follow Michael's suggestion (which is how we do it with our dynamic PPT, XLS and PDF) is to build the file and then serve the file's bytes. While the content is creating we show a progress wit

Re: HSSF - Generating large spreadsheets in streaming manner?

2007-01-12 Thread David Fisher
Accept state and follow Michael's suggestion (which is how we do it with our dynamic PPT, XLS and PDF) is to build the file and then serve the file's bytes. While the content is creating we show a progress with a continue working button, if that is clicked then we have a menu bar spot that

RE: HSSF - Generating large spreadsheets in streaming manner?

2007-01-12 Thread Donahue, Michael
Since your question is leading off topic for the POI User list, I think we need to take this offline. If you would like, I'll be happy to continue this discussion in direct e-mails. -Original Message- From: Sanjiv Jivan [mailto:[EMAIL PROTECTED] Sent: Friday, January 12, 2007 2:33 PM To:

Re: HSSF - Generating large spreadsheets in streaming manner?

2007-01-12 Thread Sanjiv Jivan
When you go to download a file from the web you see a download dialog with a progress bar. Would you prefer that when you want to download ,say, a 50 MB zip file (which will take more than a second or two) off the internet that it follow the workflow you describe? The fact that the Excel spreadsh

RE: HSSF - Generating large spreadsheets in streaming manner?

2007-01-12 Thread Donahue, Michael
Sanjiv - Strictly speaking as a web developer, this is a very bad approach to dealing with a task that may take more than a second or two complete. Typically, a web application should never make the user wait for more than a few seconds to completely load the next page. I don't think I would want

Re: HSSF - Generating large spreadsheets in streaming manner?

2007-01-12 Thread Sanjiv Jivan
I think that having a streaming API would be very useful and its not because of trying to generate a massive non human readable spreadsheet. You have to factor in the time it takes to build that data to be used for the spreadsheet too. Consider a use case where a user is trying to download a spre

WARN. Unread -1 bytes of record 0x7d

2007-01-12 Thread Andrew J. Miller
This is more of a request/suggestion than a bug report... The same files that caused the "Worksheet/WORKSHEET" issue a month or two ago (excel files generated by Crystal Reports) also have a bad habit or triggering this println on line 98 of org.apache.poi.hssf.record.RecordInputStream.java (a

Re: [Announce] Support for excel comments

2007-01-12 Thread Sanjiv Jivan
This is great news, thanks! On 1/8/07, Yegor Kozlov <[EMAIL PROTECTED]> wrote: Hi All I'm glad to announce that the long-awaited support for excel comments in POI is implemented. The request to implement it has been in po-dev since June 2002 (see Bug 10215) and finally this feature is present.

Re: spreadsheet with form elements getting corrupt with poi 3.0

2007-01-12 Thread Sanjiv Jivan
Great, the issue seems to be fixed as the spreadsheet is generating fine with the latest nightly build. I'm now going to profile and compare the 2.5.1 and 3.0 versions with my app that generates a decent size spreadsheet ( 6000 rows, 15 columns). Any insight on what performance improvements were

Re: spreadsheet with form elements getting corrupt with poi 3.0

2007-01-12 Thread Nick Burch
On Fri, 12 Jan 2007, Sanjiv Jivan wrote: Do you think the fix was made after Dec 12th, 06? I can't remember the exact date, but it might well be after then If so, are nightly builds available anywhere or would I need to build off SVN? http://encore.torchbox.com/poi-svn-build/ Nick ---

Re: spreadsheet with form elements getting corrupt with poi 3.0

2007-01-12 Thread Sanjiv Jivan
I used the jar http://www.wmwweb.com/apache/jakarta/poi/dev/bin/poi-bin-3.0-alpha3-20061212.zip Do you think the fix was made after Dec 12th, 06? If so, are nightly builds available anywhere or would I need to build off SVN? Thanks, Sanjiv On 1/12/07, Yegor Kozlov <[EMAIL PROTECTED]> wrote: H

Re: spreadsheet with form elements getting corrupt with poi 3.0

2007-01-12 Thread Yegor Kozlov
Hi, Make sure you are using the latest POI jar. Looks like we fixed similar issue recently. If the problem persists, please create a bug in bugzilla and attache to it the ppt and sample code which produces the error. Regards, Yegor SJ> I am generating a spareadsheet by reading off a template ex

spreadsheet with form elements getting corrupt with poi 3.0

2007-01-12 Thread Sanjiv Jivan
I am generating a spareadsheet by reading off a template excel spreadsheet that has macro's and form elements like buttons, labels etc and then adding data to the spreasdheet with POI. This was working well with POI-2.5.1 but I tried to upgrade to the dev build of POI-3 and the generated spreadsh

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

How to get cell formula value when reading Excel file with EventModel.

2007-01-12 Thread Khanh Tran
Dear experts, I am using POI EventModel to read Excel file. All things works fiine but I could not get the value with formula cell. Is there any advice? Thanks.

RE: Numeric Cell Types.

2007-01-12 Thread Julien Bittard
Hello The type 2 is CELL_TYPE_FORMULA, and when you make getNumericCellValue on this cell, it returns the result of formula : if(cellType == CELL_TYPE_FORMULA) { return ((FormulaRecordAggregate)record).getFormulaRecord().getValue(); } -Message d'origine- De : [EMAIL PROTECTE

Numeric Cell Types.

2007-01-12 Thread jeroen.dijkmeijer
Hi I'm wondering.. Am i doing something stupid here or is my poi build (poi-2.5.1-final-20040804.jar) broken? It looks very basic, the behavior is unexpected, the lib is over 2 years old now and I havent found any claims on the internet normally making me very suspicious of my own qualities. I've