Re: HSSF newbie questions

[Danny Mui]

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]