You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Randy Tate <Ta...@labcorp.com> on 2005/04/05 20:40:04 UTC

NO IDEA SHARED FORMULA EXP PTG

I am reading in a spreadsheet template with formulae in it. None of the
formulae have been copied/pasted nor created by the excel wizard. They
have been hand keyed. I can have 15 cells with a formula and have no
problem. When I assume all is well and continue to hand key in the rest
of the formulae I get the "NO IDEA SHARED FORMULA EXP PTG" error on a
cell that previously return the correct formula.

The only reason I am doing cell.setCellFormula(cell.getCellFormula())
is the spreadsheet will not recalculate on being opened. The retrieved
data is in place as are the formulae. My code would be quite smaller if
I didn't have to loop through everything and insert formulae where
needed.

So there are a couple of problems I am seeing. The version is
poi-2.5.1-final-20040804.

Any insight into these 2 observations would be appreciated,
Randy

-----------------------------------------
This e-mail and any attachments may contain CONFIDENTIAL information,
including PROTECTED HEALTH INFORMATION. If you are not the intended
recipient, any use or disclosure of this information is STRICTLY
PROHIBITED; you are requested to delete this e-mail and any attachments,
notify the sender immediately, and notify the LabCorp Privacy Officer at
privacyofficer@labcorp.com or call (877) 23-HIPAA / (877) 234-4722.


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/