Return-Path: X-Original-To: apmail-poi-user-archive@www.apache.org Delivered-To: apmail-poi-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 147C310FF9 for ; Wed, 5 Feb 2014 23:05:30 +0000 (UTC) Received: (qmail 55752 invoked by uid 500); 5 Feb 2014 23:05:29 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 55727 invoked by uid 500); 5 Feb 2014 23:05:29 -0000 Mailing-List: contact user-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Users List" Delivered-To: mailing list user@poi.apache.org Received: (qmail 55716 invoked by uid 99); 5 Feb 2014 23:05:29 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Feb 2014 23:05:29 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [212.13.204.73] (HELO urchin.earth.li) (212.13.204.73) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Feb 2014 23:05:23 +0000 Received: from nick (helo=localhost) by urchin.earth.li with local-esmtp (Exim 4.80) (envelope-from ) id 1WBBWf-0005j9-4C for user@poi.apache.org; Wed, 05 Feb 2014 23:05:01 +0000 Date: Wed, 5 Feb 2014 23:05:01 +0000 (GMT) From: Nick Burch X-X-Sender: nick@urchin.earth.li To: POI Users List Subject: Re: FW: End of Line character in formula throws exception in XSSFFormulaEvaluator.evaluate() In-Reply-To: <2F9262B77E8EAE43A85D1138CAC6CDE53DA11FC8AE@MAILBOX1.nrel.gov> Message-ID: References: <2F9262B77E8EAE43A85D1138CAC6CDE53DA11FC8AE@MAILBOX1.nrel.gov> User-Agent: Alpine 2.02 (DEB 1266 2009-07-14) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Checked: Checked by ClamAV on apache.org On Wed, 5 Feb 2014, Crocker, David wrote: > The real problem is that POI isn't handling the reference version of the > MS Excel Index function. I could see this when I ran the updated > library. I got the following error: > > Incomplete code - don't know how to support the 'area_num' parameter yet. > > But after staring at the source, I think that it isn't too bad to solve. If you're interested in helping fix this, the best resource to get started with is a Talk Yegor gave at ApacheCon a few years ago: http://people.apache.org/~yegor/apachecon_us2010/Evaluation_Of_Excel_Formulas_In_POI.pptx That should help you understand a bit more about how it all fits together! We'd love a patch once you have it all figured out, BTW :) Nick --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org