From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id qM0jDCsf+l6lGgAA0tVLHw (envelope-from ) for ; Mon, 29 Jun 2020 17:04:43 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0 with LMTPS id 2IHzBysf+l62XQAA1q6Kng (envelope-from ) for ; Mon, 29 Jun 2020 17:04:43 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 777EC9400C1 for ; Mon, 29 Jun 2020 17:04:40 +0000 (UTC) Received: from localhost ([::1]:50646 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jpxCx-0000wL-Dy for larch@yhetil.org; Mon, 29 Jun 2020 13:04:39 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:33408) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jpxCJ-0000vy-Rf for emacs-orgmode@gnu.org; Mon, 29 Jun 2020 13:04:00 -0400 Received: from latitanza.investici.org ([82.94.249.234]:25173) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jpxCH-0002sV-Ez for emacs-orgmode@gnu.org; Mon, 29 Jun 2020 13:03:59 -0400 Received: from mx3.investici.org (unknown [127.0.0.1]) by latitanza.investici.org (Postfix) with ESMTP id 2B0181201C0; Mon, 29 Jun 2020 17:03:54 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anche.no; s=stigmate; t=1593450234; bh=htKqynN366SMn+/620QTHBhfdG3IhJ7iyPa1L1ygBTk=; h=To:From:Subject:Date:From; b=cnKbhj2SYPkFONiDgicElfKWUss4UDLa5aJp8QUBvTQJnQ0Hb73Nd1PVLHLvpHYR4 Obu0uQ78cpSC7q59xA9DUT1ieLXpG4ZBLOmvPB9DX1r+JIngvKwYDB7r7EOq44L83E nmrynY811EnZIjLZHf6C3qfwzLnOwA0sACBmTepc= Received: from [82.94.249.234] (mx3.investici.org [82.94.249.234]) (Authenticated sender: mariotomo@inventati.org) by localhost (Postfix) with ESMTPSA id A387B1201B0; Mon, 29 Jun 2020 17:03:52 +0000 (UTC) To: emacs-orgmode@gnu.org From: Mario Frasca Subject: question on user-error reference leading out of table Message-ID: Date: Mon, 29 Jun 2020 12:03:13 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.9.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US Received-SPF: pass client-ip=82.94.249.234; envelope-from=mario@anche.no; helo=latitanza.investici.org X-detected-operating-system: by eggs.gnu.org: First seen = 2020/06/29 12:27:26 X-ACL-Warn: Detected OS = Linux 2.2.x-3.x [generic] [fuzzy] X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001 autolearn=_AUTOLEARN X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=anche.no header.s=stigmate header.b=cnKbhj2S; dmarc=none; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Spam-Score: -1.21 X-TUID: k8ugw5kUH/Fx Hi, I need some help understanding how to use org-mode/org-table for references leading outside my table. I have a series of daily figures, and I am computing the series of running sums.  column one is the daily data, column two is the running sum of the preceding 14 values from column 1. http://ix.io/2qu7 problem is the @-13$1 reference in the function for the second column: it hits a software-generated "user-error: Row descriptor -13 leads outside table". this happens even if the formula says (if (> @# 13) (apply '+ '(@-13$1..$1)) 0), that is, even if the formula is not evaluated on the cells where the reference does indeed lead out of the table. this happens around line 2809 of org-table.el, inside org-table--row-type I've tried to catch the user-error with a `condition-case', but even there, the error seems to happen before evaluation. I've replaced the `(user-error)' function with a `nil', and it works for me, but that's a very rough measure I'm afraid.