RE: HSSFRichText

2007-03-14 Thread Khanh Tran
Hi, Please use HSSFCell.setCellValue(new HSSFRichTextString(String value)) instead. Regards, Khanh -Original Message- From: Theo Antonopoulos [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 14, 2007 8:50 PM To: POI Users List Subject: HSSFRichText Hi people, Anyone else a bit annoyed

Shifting columns

2007-03-12 Thread Khanh Tran
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.

Deleting column

2007-03-12 Thread Khanh Tran
Dear experts, Is there any way to delete a column/row in Excel file using POI? Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project:

Inserting row, column

2007-03-10 Thread Khanh Tran
Is there any way to insert a column berofe an existing column in HSSFSheet? - To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakar

RE: Unable to see value in the formula cell

2007-03-09 Thread Khanh Tran
I am facing the same problem. I couln't programatically read the values of formula cells created programatically. -Original Message- From: Davis Varkey Koottala [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 2:37 PM To: poi-user@jakarta.apache.org Subject: Unable to see value in t

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

2007-01-16 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.

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.

POI formula syntax checking?

2007-01-02 Thread Khanh Tran
Dear experts, I am using Formula Evaluator package to evaluate some Excel functions. When I enter the correct formula syntax, it works fine. But when I enter incorrect formula syntax, it does not throws any error message. I want to retreive the error messages related to my wrong syntax. Here is

Add non-Excel functions ?

2006-12-13 Thread Khanh Tran
Dear experts, I am wonder if is it possible to add non-excel simple function, ie user-defined functions and have FormulaParser evaluate it. Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://