Return-Path: Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org Received: (qmail 68266 invoked from network); 5 Apr 2005 18:40:53 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 5 Apr 2005 18:40:53 -0000 Received: (qmail 89238 invoked by uid 500); 5 Apr 2005 18:40:52 -0000 Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org Received: (qmail 88744 invoked by uid 500); 5 Apr 2005 18:40:51 -0000 Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "POI Users List" Reply-To: "POI Users List" Delivered-To: mailing list poi-user@jakarta.apache.org Received: (qmail 88728 invoked by uid 99); 5 Apr 2005 18:40:51 -0000 X-ASF-Spam-Status: No, hits=0.4 required=10.0 tests=SUBJ_ALL_CAPS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mail5.labcorp.com (HELO mail5.labcorp.com) (12.145.92.27) by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 05 Apr 2005 11:40:48 -0700 Received: from mail5.labcorp.com (ZixVPM [127.0.0.1]) by Outbound.labcorp.com (Proprietary) with ESMTP id 4E0CBEC088 for ; Tue, 5 Apr 2005 14:40:46 -0400 (EDT) Received: from labcorp.com (unknown [10.127.1.15]) by mail5.labcorp.com (Proprietary) with ESMTP id 7BC8DEC081 for ; Tue, 5 Apr 2005 14:40:45 -0400 (EDT) Received: from ([172.30.1.21]) by mail01.labcorp.com with ESMTP id KP-NTG39.5199482; Tue, 05 Apr 2005 14:40:23 -0400 Received: from KOURYGWIA-MTA by kourygwia.labcorp.com with Novell_GroupWise; Tue, 05 Apr 2005 14:40:23 -0400 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.3 Date: Tue, 05 Apr 2005 14:40:04 -0400 From: "Randy Tate" To: Subject: NO IDEA SHARED FORMULA EXP PTG Mime-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline Content-Type: text/plain; charset="US-ASCII" X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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/