From ooo-users-return-2757-apmail-incubator-ooo-users-archive=incubator.apache.org@incubator.apache.org Sun Sep 16 22:57:46 2012 Return-Path: X-Original-To: apmail-incubator-ooo-users-archive@minotaur.apache.org Delivered-To: apmail-incubator-ooo-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3DAF7D469 for ; Sun, 16 Sep 2012 22:57:46 +0000 (UTC) Received: (qmail 53437 invoked by uid 500); 16 Sep 2012 22:57:45 -0000 Delivered-To: apmail-incubator-ooo-users-archive@incubator.apache.org Received: (qmail 53380 invoked by uid 500); 16 Sep 2012 22:57:45 -0000 Mailing-List: contact ooo-users-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ooo-users@incubator.apache.org Delivered-To: mailing list ooo-users@incubator.apache.org Received: (qmail 53370 invoked by uid 99); 16 Sep 2012 22:57:45 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 16 Sep 2012 22:57:45 +0000 X-ASF-Spam-Status: No, hits=0.7 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_NEUTRAL,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [77.238.189.211] (HELO nm4-vm0.bullet.mail.ird.yahoo.com) (77.238.189.211) by apache.org (qpsmtpd/0.29) with SMTP; Sun, 16 Sep 2012 22:57:36 +0000 Received: from [212.82.105.245] by nm4.bullet.mail.ird.yahoo.com with NNFMP; 16 Sep 2012 22:57:16 -0000 Received: from [212.82.108.224] by tm17.bullet.mail.ird.yahoo.com with NNFMP; 16 Sep 2012 22:57:16 -0000 Received: from [127.0.0.1] by omp1001.bt.mail.ird.yahoo.com with NNFMP; 16 Sep 2012 22:57:16 -0000 X-Yahoo-Newman-Id: 294888.69637.bm@omp1001.bt.mail.ird.yahoo.com Received: (qmail 45505 invoked from network); 16 Sep 2012 22:57:16 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=btinternet.com; h=DKIM-Signature:Message-ID:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:X-Mailer:Date:To:From:Subject:In-Reply-To:References:Mime-Version:Content-Type; b=Sl3SqiVhi9QhROwfx7yZhGvJ0vM9i5oC4CyfDl+4XdHxkQbk4NyivGWDqFSAWC/WMXBn+x5ZLAyPq4WVhQ6fJ3UCTtYsU0gAYf27cpathmqmL1EmhG4Kk/3TQbY0AeTddnGXV+BlDWEfX1lu4yjFAiXH1bcqKVSWE/RdKY0uHzY= ; DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=btinternet.com; s=s1024; t=1347836236; bh=BaPXKOaDPvghb0R3p1qPe1zf3QTyphstn7GM58d0k4k=; h=Message-ID:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:X-Mailer:Date:To:From:Subject:In-Reply-To:References:Mime-Version:Content-Type; b=NxFUZcbfjUt9gFSHVq+JdVaUNnokBc5UFjWImjKMK2ZhDlXFu5Tn6JoYrpWxlJUKrwuiyjI3Fys+Ga4GlaR8NSqCBTOmvtrQj59U+SXiKCP3CGmzJ4lXKN9esNcPPQvEj0oFTcEYvSf29RPuEzhPaa9I5zMY+a+kwnoxPtJz9W8= Message-ID: <132662.95444.qm@smtp827.mail.ukl.yahoo.com> X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: CGMSCSYVM1ni8_acTxtSfXu1GiJVMVlu1CFY7FzlnDBYYxE Isya0.ltiKBkGuix_solAJ0OPmVUOUcb5rb3MkkrHZOJuch8lvNG4qwUi25U Neoqft35SXZQW9twCyjq8rzY33zM4rv1.RC2glhWGXsC5npAQsQkQO2xO7F_ 1mBi8J7LP4gU6nsafhbxYpEFpM.t8WNzSPjYttOTO2bn2rr4bM6kXRJEU3aS V96Xz2n.0NbfCV_yB.QUiF46Z7NMXTuLwoF4xH8i_w7YQ.R1pHHdlIpUD3VS 1uZ1eDKQuUKoPT8Fg.bXL0ZP.20BCzgXX8u67cv_UpyvaFQfJdCO36jEexTW zQ4fLyWZCJQzCU6OoAkKnac.FPcBHEXyegi7E3iwq6JB90jwKBGaatyyWfnj Xj9oHhhJBr1DXfGGMx_L9wO8fnXdpBp_PWjVETRt9REX0UCPZlnEm.0DNju0 SFwnTABy9y08dMpS6.Io- X-Yahoo-SMTP: Tq4.kDyswBA5nH8XRdvM30ZqM7XL0zLGIi0p75iiIVw8hdFKC6c- Received: from D9X6FX0J.btinternet.com (b.m.barker@109.158.133.160 with login) by smtp827.mail.ukl.yahoo.com with SMTP; 16 Sep 2012 15:57:15 -0700 PDT X-Mailer: QUALCOMM Windows Eudora Version 7.1.0.9 Date: Sun, 16 Sep 2012 23:57:13 +0100 To: ooo-users@incubator.apache.org From: Brian Barker Subject: Re: Links to other spreadsheet not always working? In-Reply-To: References: <742027.23633.qm@smtp823.mail.ukl.yahoo.com> <947357.81694.qm@smtp827.mail.ird.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed At 01:56 12/09/2012 +0200, Ennio Sr wrote: >The structure of the three files is very simple: all of them have a >'named range' ("last_bal") in cell Hn (Nn for the bank_short.ods) >and a reference to it in cell 'B1' . >In files First.ods and Second.ods there is a 'Summary of links to >other ss': ='file:///home/ennio/prove/filename.ods'#$Sheet1.B1 >The link to bank short.ods gives '0' as a result in both First or >Second, but, if I change this link to cell Nn of bank_short file >(instead of B1 like the other two) the correct result appears. There may still, of course, be an odd error you have made somewhere in what you have constructed or a misunderstanding you have which is causing the problem you are seeing. >That's all and these are the facts. You know that, but no-one else does, of course! You'll have to provide someone with copies of files which actually show the problem if someone is to be able to confirm that what you are seeing is a bug. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org For additional commands, e-mail: ooo-users-help@incubator.apache.org