Return-Path: <user-return-22276-archive-asf-public=cust-asf.ponee.io@poi.apache.org>
X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io
Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io
Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183])
	by cust-asf2.ponee.io (Postfix) with ESMTP id 23362200B96
	for <archive-asf-public-internal@cust-asf2.ponee.io>; Thu,  6 Oct 2016 10:55:06 +0200 (CEST)
Received: by cust-asf.ponee.io (Postfix)
	id 16D2F160AE0; Thu,  6 Oct 2016 08:55:06 +0000 (UTC)
Delivered-To: archive-asf-public@cust-asf.ponee.io
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by cust-asf.ponee.io (Postfix) with SMTP id 52A02160AAD
	for <archive-asf-public@cust-asf.ponee.io>; Thu,  6 Oct 2016 10:55:05 +0200 (CEST)
Received: (qmail 15957 invoked by uid 500); 6 Oct 2016 08:55:03 -0000
Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@poi.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@poi.apache.org>
List-Post: <mailto:user@poi.apache.org>
List-Id: <user.poi.apache.org>
Reply-To: "POI Users List" <user@poi.apache.org>
Delivered-To: mailing list user@poi.apache.org
Received: (qmail 15938 invoked by uid 99); 6 Oct 2016 08:55:03 -0000
Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Oct 2016 08:55:03 +0000
Received: from localhost (localhost [127.0.0.1])
	by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id BBF9B180A56
	for <user@poi.apache.org>; Thu,  6 Oct 2016 08:55:02 +0000 (UTC)
X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org
X-Spam-Flag: NO
X-Spam-Score: -1.3
X-Spam-Level: 
X-Spam-Status: No, score=-1.3 tagged_above=-999 required=6.31
	tests=[KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_MED=-2.3]
	autolearn=disabled
Received: from mx2-lw-us.apache.org ([10.40.0.8])
	by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024)
	with ESMTP id sI-dVuI7mVCv for <user@poi.apache.org>;
	Thu,  6 Oct 2016 08:54:59 +0000 (UTC)
Received: from urchin.earth.li (urchin.earth.li [212.13.204.73])
	by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id 84C4E5FB82
	for <user@poi.apache.org>; Thu,  6 Oct 2016 08:54:59 +0000 (UTC)
Received: from nick (helo=localhost)
	by urchin.earth.li with local-esmtp (Exim 4.84_2)
	(envelope-from <apache@gagravarr.org>)
	id 1bs4SA-0007dj-6L
	for user@poi.apache.org; Thu, 06 Oct 2016 09:54:58 +0100
Date: Thu, 6 Oct 2016 09:54:58 +0100 (BST)
From: Nick Burch <apache@gagravarr.org>
X-X-Sender: nick@urchin.earth.li
To: POI Users List <user@poi.apache.org>
Subject: Re: Linking External Workbooks
In-Reply-To: <CAFGkfm1197-EuwQgb-sH_Kt03e5UacF66rdCyTfVvmq77JGWzw@mail.gmail.com>
Message-ID: <alpine.DEB.2.11.1610060948440.16003@urchin.earth.li>
References: <CAFGkfm1197-EuwQgb-sH_Kt03e5UacF66rdCyTfVvmq77JGWzw@mail.gmail.com>
User-Agent: Alpine 2.11 (DEB 23 2013-08-11)
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; format=flowed; charset=US-ASCII
archived-at: Thu, 06 Oct 2016 08:55:06 -0000

On Wed, 5 Oct 2016, Blake Watson wrote:
> I've also tried putting in "[1]" or "1" in the map rather than my
> spreadsheet name. I don't see in all this how the spreadsheet name in Excel
> comes out as "[1]" in POI.

That's just how Excel stores it for XLSX files. The link table provides 
the mapping between those indexes and the names shown in Excel. When POI 
hits one of those, it goes to the link table to find the name of the file, 
then checks for a setup referenced workbook with that name to resolve 
things with

Take a look at TestXSSFFormulaEvaluation method 
testReferencesToOtherWorkbooks() + referenced test files for how it ought 
to work

> 7. Vall evaluatorFormulaCell on the cell checked in step 3 and get:
> IllegalArgumentException Invalid sheetIndex: -1.
> org.apache.poi.ss.formula.SheetRefEvaluator.<init>
> (SheetRefEvaluator.java:36)

That doesn't look like the normal error for missing linked workbooks, so 
there might be a bug

Can you create two very simple workbooks, both with 2 sheets, one with a 
handful of data cells in, the other with your formula, which shows the 
problem? If so, please upload them to bugzilla along with a small junit 
unit test, and we'll take a look

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org