I am having same problem with formulas showing - NO IDEA SHARED FORMULA EXP PTG. I try to use 3.x alpha version of POI but still got same result. Is this really fixed and working with some patch for 3.x or 2.x? I did not try the fix the link pointing to for 2.x but it stated that 3.x has this rectified. Since 3.x did not work for me I did not think 2.x Fix will work iether. Any ideas?
Igor --- Thomas Herre <[EMAIL PROTECTED]> wrote: > Andreas, > > 2) The error message you've seen is related to the > shared formula > problem. See: > http://mail-archives.apache.org/mod_mbox/jakarta-poi-user/200406.mbox/[EMAIL PROTECTED] > > Hope this helps, > Thomas > > > Andreas Korthaus schrieb: > > > Hi! > > > > I have a sheet like: > > > > A1 B1 C1 > > A2 B2 C2 > > A3 B3 C3 > > > > When I use: HSSFSheet.getLastRowNum() > > > > it returns "2" - so it starts counting rows from 0 > = first row. > > > > When I use: HSSFRow.getLastCellNum() > > > > it returns "3" for every row, so it seems to start > counting from 1 = > > first col. > > > > Why is there a different behaviour? > > And why this way? > > Perhaps the other way around I could understand > it... > > > > And another issue (another, more complex > workbook), I try to read > > formulas using > > > > HSSFCell.getCellFormula() > > > > which works nice, but in one Excel-Sheet I have a > column with a lot of > > formulas like: > > > > =C61*F61 > > > > And some of these really simple formulas can't be > displayed (problems > > only in row 60-65?!?!). The output of > HSSFCell.getCellFormula() is: > > > > NO IDEA SHARED FORMULA EXP PTG > > > > what's that? > > What could be the problem? > > The excel sheet is not really big or complex. If I > copy all the cells > > to another sheet the problem is still there. > > > > best regards > > Andreas > > > > > --------------------------------------------------------------------- > > 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/ > > > > > > > > > > -- > Mit freundlichen GrEen / Best Regards > > Thomas Herre > > ABOSCO GmbH > Schlossmattenstraße 9a > 79268 Bötzingen > > Phone: +49 (0)7663/9140 - 13 > Fax: +49 (0)7663/9140 - 29 > > eMail: [EMAIL PROTECTED] > Web..: www.abosco.com > > > --------------------------------------------------------------------- > 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/ > > __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com --------------------------------------------------------------------- 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/
