If you are using a template, and all you want to do is enforce recalculation, use a startup macro to force recalc at opening.
On Wed, 2005-04-06 at 09:54 -0400, Randy Tate wrote: > Here is the exception info that was left out of yesterday's post. > > java.lang.StringIndexOutOfBoundsException: String index out of range: > 0 > at java.lang.String.charAt(String.java:1037) > at > org.apache.poi.hssf.util.CellReference.<init>(CellReference.java:49) > at > org.apache.poi.hssf.record.formula.ReferencePtg.<init>(ReferencePtg.java:55) > at com....... > > ************************************************************************** > Previous Post: > 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 > [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > -- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
