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/
