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 1715A1841D for ; Tue, 24 Nov 2015 11:43:42 +0000 (UTC) Received: (qmail 41451 invoked by uid 500); 24 Nov 2015 11:43:41 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 41391 invoked by uid 500); 24 Nov 2015 11:43:41 -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 41379 invoked by uid 99); 24 Nov 2015 11:43:41 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Nov 2015 11:43:41 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id B4CA6C0F3F for ; Tue, 24 Nov 2015 11:43:40 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.879 X-Spam-Level: ** X-Spam-Status: No, score=2.879 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id dbcUcnQmhugX for ; Tue, 24 Nov 2015 11:43:40 +0000 (UTC) Received: from mail-yk0-f181.google.com (mail-yk0-f181.google.com [209.85.160.181]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id 4CD4224E1A for ; Tue, 24 Nov 2015 11:43:39 +0000 (UTC) Received: by ykdr82 with SMTP id r82so14928680ykd.3 for ; Tue, 24 Nov 2015 03:43:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to:content-type; bh=GMAN0iH0vqZaFdtkO2bjgcQ8mE6kVvLqnLg8nc5HwLk=; b=wOi8GZqhujC3KmeL5xwv55Me+Gq2qe6z8cjPP7cyNwcZSlwI7grfyKYhRgX7BgzfGB B7dbupDGAOerxKFf5njjGD+3dzCSfU9X899E68Ab9q0vB+02yIqGpt3ih/EpSlWT4KJa N2bBHXDcQIBY1vdqtbn3NSAsfsEb7J5DflqoE5kb45pe2QizbaGZGjwGcL2QQx3dZOfK LU/xiyiuyw4WpWGpf1D2RK8+wkbslD3lSLsCX6W/g9f1KULuNEFivhyICX1lNBk6vmYw c4LAM0D7mNBXjF/NRg+3T3E+5zI8CrX77LCK5Uwr/fAllaNlYaoKNji5iaqgBlf93CrT Lnaw== X-Received: by 10.129.154.148 with SMTP id r142mr30179461ywg.291.1448365418410; Tue, 24 Nov 2015 03:43:38 -0800 (PST) MIME-Version: 1.0 Received: by 10.129.119.215 with HTTP; Tue, 24 Nov 2015 03:43:19 -0800 (PST) From: Tom Chiverton Date: Tue, 24 Nov 2015 11:43:19 +0000 Message-ID: Subject: Advice on tracking down an error thrown by evaluateAllFormulaCells() To: user@poi.apache.org Content-Type: multipart/alternative; boundary=94eb2c0b7cbe44f8e5052547dae0 --94eb2c0b7cbe44f8e5052547dae0 Content-Type: text/plain; charset=UTF-8 I am trying to evaluate all the formula's in an Excel file. There are about a dozen sheets, with several tens of formula on each, all driven by a few input fields on the first sheet. This all works fine in Excel 365 itself. However, when I try and run it via the latest POI, evaluateAllFormulaCells() is throwing "Unexpected ptg class (org.apache.poi.ss.formula.ptg.ArrayPtg)". What's the best way to track this down ? Is there a way to have POI log what it's doing, maybe find the specific cell that is causing issues ? I tried setDebugEvaluationOutputForNextEval() but this didn't seem to output anything ? -- Tom --94eb2c0b7cbe44f8e5052547dae0--