You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Danny Mui <da...@muibros.com> on 2004/12/06 18:41:27 UTC
Re: HSSF newbie questions
hmm, i thought this was taken care of already. when using copy/paste
functions (or dragged functions) it creates a "shared formula" in excel
to save disk space.
hssf doesn't know how to expand this shortened version but there is a
patch to extend the compressed formula. i think it might be in CVS so
check it out and give it a shot.
thanks!
Marko Asplund wrote:
> hi
>
> i've started experimenting using POI 2.5.1 (final-20040804) for
> processing spreadsheet files created with MS Excel 2004 for Mac (v11.1).
> things are working quite well but i'm having some problems with date
> field formatting and formulas.
>
> i'm using HSSFDateUtil.isCellDateFormatted() to identify date cells and
> then
>
> HSSFCellStyle style = cell.getCellStyle();
> String fmtStr = HSSFDataFormat.getBuiltinFormat(style.getDataFormat());
>
> to identify formatting. this doesn't seem to work properly. for a cell
> whose formatting is defined as Custom/yyyy-mm-dd the above method gives
> m/d/yy as the format string. how should the date format be identified?
>
> i'm also having some problems printing formulas as strings. manually
> entered formulas print out ok with cell.getCellFormula() but for formula
> cells that have been cut-n-pasted i get the following text instead of
> the formula content: NO IDEA SHARED FORMULA EXP PTG. is there a way to
> fix this?
>
> what's the recommended version of POI for processing MS Excel files?
>
>
> thanks & best regards,
> --
> aspa
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: HSSF newbie questions
Posted by Danny Mui <da...@muibros.com>.
ok i'll add that to the good old todo list. will try to fetch the patch
out of bugzilla and apply sometime after the new year.
Marko Asplund wrote:
>
> On 06 Dec, 2004, at 19:41, Danny Mui wrote:
>
>> hmm, i thought this was taken care of already. when using copy/paste
>> functions (or dragged functions) it creates a "shared formula" in
>> excel to save disk space.
>>
>> hssf doesn't know how to expand this shortened version but there is a
>> patch to extend the compressed formula. i think it might be in CVS so
>> check it out and give it a shot.
>
>
> i just checked out the code using:
>
> cvs -d :pserver:anoncvs@cvs.apache.org:/home/cvspublic co -D
> 2004-12-07 jakarta-poi
>
> and built the library but it still get 'NO IDEA SHARED FORMULA EXP PTG'
> messages when calling cell.getCellFormula().
>
> by the way, why resulting POI jar file gets named poi-2.1-20041207.jar
> which feels a bit confusing as the latest stable version is 2.5.1.
>
>
> best regards,
> --
> aspa
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: HSSF newbie questions
Posted by Marko Asplund <ma...@kronodoc.com>.
On 06 Dec, 2004, at 19:41, Danny Mui wrote:
> hmm, i thought this was taken care of already. when using copy/paste
> functions (or dragged functions) it creates a "shared formula" in
> excel to save disk space.
>
> hssf doesn't know how to expand this shortened version but there is a
> patch to extend the compressed formula. i think it might be in CVS so
> check it out and give it a shot.
i just checked out the code using:
cvs -d :pserver:anoncvs@cvs.apache.org:/home/cvspublic co -D
2004-12-07 jakarta-poi
and built the library but it still get 'NO IDEA SHARED FORMULA EXP PTG'
messages when calling cell.getCellFormula().
by the way, why resulting POI jar file gets named poi-2.1-20041207.jar
which feels a bit confusing as the latest stable version is 2.5.1.
best regards,
--
aspa
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org