From user-return-23381-archive-asf-public=cust-asf.ponee.io@poi.apache.org Wed Apr 10 17:30:30 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id EE988180626 for ; Wed, 10 Apr 2019 19:30:29 +0200 (CEST) Received: (qmail 85575 invoked by uid 500); 10 Apr 2019 17:30:28 -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 85564 invoked by uid 99); 10 Apr 2019 17:30:28 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Apr 2019 17:30:28 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 493C8C1A4D for ; Wed, 10 Apr 2019 17:30:28 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 4.285 X-Spam-Level: **** X-Spam-Status: No, score=4.285 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_PASS=-0.001, SPF_SOFTFAIL=0.972, URIBL_BLOCKED=0.001, URI_HEX=1.313] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id R7z1txfgc7TZ for ; Wed, 10 Apr 2019 17:30:26 +0000 (UTC) Received: from n5.nabble.com (n5.nabble.com [162.253.133.81]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 8C3695F5EF for ; Wed, 10 Apr 2019 17:30:26 +0000 (UTC) Received: from n5.nabble.com (localhost [127.0.0.1]) by n5.nabble.com (Postfix) with ESMTP id B1DF6D204BE8 for ; Wed, 10 Apr 2019 10:30:24 -0700 (MST) Date: Wed, 10 Apr 2019 10:30:24 -0700 (MST) From: Kumar Thotapally To: user@poi.apache.org Message-ID: <1554917424726-0.post@n5.nabble.com> In-Reply-To: References: <1554309042859-0.post@n5.nabble.com> <1554496396222-0.post@n5.nabble.com> <1554736260035-0.post@n5.nabble.com> Subject: Re: Cell Calculations by reference to other cells in hidden sheets within the same workbook MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_67723_1573401657.1554917424726" ------=_Part_67723_1573401657.1554917424726 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I used getCachedFormulaResultType() and it returned the type to be Numeric and numeric cell value returned a value 0.0 which is incorrect. When I get string value of the cell, it is returning reference to calculation formula on a separate sheet within the workbook. In this particular spreadsheet, I know all the cells that are of type formula. I am having difficulty getting the formula evaluated. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html ------=_Part_67723_1573401657.1554917424726--