Hi Thomas, Thanks. But I decide to give up using POI for its some limitation and bugs.
I have implemented a command line tools using .Net to convert xls to csv. Then I just need to deal with csv file in Java. Anyway, thank you. Best wishes, xudong -----Original Message----- From: Thomas Herre [mailto:[EMAIL PROTECTED] Sent: 2005å5æ19æ 0:14 To: POI Users List Subject: Re: NO IDEA SHARED FORMULA EXP PTG Hi xudong, This is a known issue. See http://mail-archives.apache.org/mod_mbox/jakarta-poi-user/200406.mbox/[EMAIL PROTECTED] I didn't try out this patch though. Anyone else? It should also be able to remove those shared formulas by first removing the cell content and then manually entering your formula in each cell (don't drag and drop from first cell). You can also detect such shared formulae by running a BiffViewer against your workbookk (Class org.apache.poi.hssf.dev.BiffViewer). Hope this helps, Thomas xudong schrieb: >hi, > >While I try to get formula from cells, I got such string rather than >the formula itself? > >Anyone can tell me how to resolve this problem? > > >Thanks in advance. > >best wishes, >xudong > >--------------------------------------------------------------------- >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 GrÃÃen / Best Regards Thomas Herre ABOSCO GmbH SchlossmattenstraÃe 9a 79268 BÃtzingen Phone: +49 (0)7663/9140 - 13 Fax: +49 (0)7663/9140 - 28 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/ --------------------------------------------------------------------- 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/
