Re: How to Modify the Title and Author names using POI

2005-06-09 Thread Srinivas
Hi Rainer, It's running but the problem is whenever opening the Document file it's asking the File Conversion -filename.and some encoding properties and the test is.

MS Word and Images

2005-06-09 Thread Rama Subba Reddy
Hi Friends, I am using HWPF and i created few classes to write images to word file. I am writing Data Stream Structure and am setting fSpec as 1. in CHP am making the special character as 0X01.In the output word file pictures are not there. Can somebody help to how to write pictures to

Fwd: MS Word and Images

2005-06-09 Thread Rama Subba Reddy
Note: forwarded message attached. Too much spam in your inbox? Yahoo! Mail gives you the best spam protection for FREE!http://in.mail.yahoo.com---BeginMessage--- Hi Friends, I am using HWPF and i created few classes to write images to word file. I am writing Data Stream Structure and am

Re: AW: comparison between POI API and JExcel

2005-06-09 Thread Marko Asplund
On 2005-06-02, at 11.39, KHZ (SAW) wrote: If you use the POI user model the whole workbook is read in at once and thus consumes a lot of memory. If you use the event model you can avoid this but you'll have more other work. A further alternative would be OpenOffice.org. There you fetch

AW: AW: comparison between POI API and JExcel

2005-06-09 Thread KHZ (SAW)
Hi Marco. If you download OOo and install it you've several sample code. From this you can start and add further things. For such things you've to search a lot in an avalanche of documentation in the internet. The programming at low level is similar to COM programming in C++ (although it's called

Corrupted Office format by POI when embedded objects in Office file ???

2005-06-09 Thread BURY Laurent ROSI/SICOR
Hello, I have a problem of data corruption if the Office file I want to modify contains an embedded object: once I saved it (even unmodified !!!) using the POIFSFileSystem.writeFilesystem(modifiedStream) method, POI is non longer able to reopen it without sending an error: java.io.IOException:

How do I read formula values??

2005-06-09 Thread Nishant Chandra
Hello I am writing a formula in an excel sheet but when i try to read in the calculated value, i get an error. But if I manually open it in excel, save it and then read the values, it works. Is there a task to do for updating the formula in order to get its result if I dont want to use VB cos I

AW: How do I read formula values??

2005-06-09 Thread KHZ (SAW)
Hi Nishant. Excel calculates the formula when opening. POI just stores the value. So POI needn't implement an avalanche of formula evaluations. Regards,Karl-Heinz. -Ursprüngliche Nachricht- Von: Nishant Chandra [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 9. Juni 2005 12:43

AW: How do I read formula values??

2005-06-09 Thread KHZ (SAW)
Hi Nishant. I don't know whether such things are planned in POI. With OpenOffice (where you start the program in a server mode) such things should be possible. Most functions are used both in Excel and OOo - a few with a bit different name. But changing to there will not be straightforward.

Re: Extensibility for functions in formulas on HSSF

2005-06-09 Thread Nishant Chandra
Michel Bertrand michel.bertrand at datasul.com.br writes: Hi ! I would like to add some of my business formulas in HSSF Formula Support, like financial mathematics. How can I do that ? I take a look on the code which loads all functions for HSSF and I would like to make it flexible to

Re: How to Modify the Title and Author names using POI

2005-06-09 Thread Rainer Klute
Hi Srinivas, I do not understand this. Please be precise in telling what you are doing and what is happening! Am Mittwoch, den 08.06.2005, 23:28 -0700 schrieb Srinivas: Hi Rainer, It's running but the problem is whenever opening the Document file it's asking the File Conversion

RE: AutoFilter in Excel

2005-06-09 Thread Iain.Shepherd
Thierry, see below. Thanks Iain Shepherd -Original Message- From: Avik Sengupta [mailto:[EMAIL PROTECTED] Sent: 22 November 2004 15:56 Subject: Re: HSSF - AutoFilter? Iain, Sorry, this feature doesn't exist as of now. We had at one point, some one willing to fund this, but that fell

RE: How do I read formula values??

2005-06-09 Thread Amol Deshmukh
Nishant, Can you give more details as to what you mean by read in calculated value. Maybe a snippet of your code would help better understand what you are attempting. I think I understand what you are attempting but code says it so much better than words - so if you can please post the relevant

RE: AutoFilter in Excel

2005-06-09 Thread avik . sengupta
Somebody said they were working on this, not sure of the status. see http://issues.apache.org/bugzilla/show_bug.cgi?id=35125 Quoting [EMAIL PROTECTED]: Thierry, see below. Thanks Iain Shepherd -Original Message- From: Avik Sengupta [mailto:[EMAIL PROTECTED] Sent: 22 November 2004

Re: How do I read formula values??

2005-06-09 Thread Nishant Chandra
Amol Deshmukh adeshmukh at hobsons-us.com writes: Nishant, Can you give more details as to what you mean by read in calculated value. Maybe a snippet of your code would help better understand what you are attempting. I think I understand what you are attempting but code says it so

RE: POI File size limitation

2005-06-09 Thread Bhattacharjee, Abhranil \(Cognizant\)
No my current setting is 200m .. I cant change this as other applications are also present in the same server... Have u got any other solution. Regards, Abhranil -Original Message- From: KHZ (SAW) [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 08, 2005 6:36 PM To: Bhattacharjee,

Out of memory exception

2005-06-09 Thread Bhattacharjee, Abhranil \(Cognizant\)
Hi I am also working on poi hssf.I am able to write excel files with 15000 rows, but beyound that its throwing out of memory exception. Is there any solution for this other than increasing JVM size. Regards, Abhranil This e-mail and any files transmitted with it are for the sole use of