From mboxrd@z Thu Jan 1 00:00:00 1970 From: Luke Swart Subject: can't assign to hline relative reference Date: Sun, 30 Aug 2015 19:47:50 -0700 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=089e0112d07ebfb0c1051e92764e Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:48699) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ZWF8n-0002hU-Fw for emacs-orgmode@gnu.org; Sun, 30 Aug 2015 22:48:14 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1ZWF8m-0007v6-48 for emacs-orgmode@gnu.org; Sun, 30 Aug 2015 22:48:13 -0400 Received: from mail-wi0-x234.google.com ([2a00:1450:400c:c05::234]:37143) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ZWF8l-0007ua-PF for emacs-orgmode@gnu.org; Sun, 30 Aug 2015 22:48:12 -0400 Received: by wicfv10 with SMTP id fv10so57257259wic.0 for ; Sun, 30 Aug 2015 19:48:10 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org --089e0112d07ebfb0c1051e92764e Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello, There seems to be an error when using hline-relative references in an org-mode table=E2=80=99s formula. For example, I have the following org-mod= e table: #+BEGIN: columnview :hlines 1 :id global | /Project/ | Mon | Tue | Wed | Thu | Fri | Sat | Sun | /Total/ = | |----------------+-----+-----+-----+------+-----+------+-----+---------= | | AnotherProduct | | | | | | 2.50 | | = | | Prototype | | | | 3.50 | | | | = | |----------------+-----+-----+-----+------+-----+------+-----+---------= | | /Daily/ | | | | | | | | = | #+TBLFM: @I$9..@II$9=3Dvsum($2..$8);%.2f;::@II$2..@III$9=3D'(format "%3.2f" (apply '+ '(@I..@II)));N; and I get the error can't assign to hline relative reference when I run M-x org-table-recalculate. I looked over the org-mode references documentation and the gmane.org forums , but I did not find any reasons as to why the hline relative references could not be assigned. This issue is related to the timesheet package on MELPA. I have filed an issue here: https://github.com/tmarble/timesheet.el/issues/3 but hopefully I have found the underlying problem, and hopefully it is reasonably fixable= . Here is some relevant info: - Org-mode version 8.3.1 (8.3.1-87-g4ef2c0-elpa @ /home/luke/.emacs.d/elpa/org-20150824/) - emacs-version: 24.5.1 - ArchLinux OS: Linux 4.1.6-1-ARCH #1 SMP PREEMPT Mon Aug 17 08:52:28 CEST 2015 x86_64 GNU/Linux This is a copy of my question posted here: http://emacs.stackexchange.com/questions/15185/cant-assign-to-hline-relativ= e-reference Any suggestions or guidance would be appreciated. I am happy to clarify anything as well. Thanks, Luke =E2=80=8B --089e0112d07ebfb0c1051e92764e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Hello,

There seems to be an error when= using hline-relative references in an org-mode table=E2=80=99s formula. Fo= r example, I have the following org-mode table:

    #+BEGIN: columnview :=
hlines 1 :id global
    | /Project/      | Mon | Tue | Wed |  Thu | Fri |  Sat | Sun | /Total/ =
|
    |----------------+-----+-----+-----+------+-----+------+-----+---------=
|
    | AnotherProduct |     |     |     |      |     | 2.50 |     |         =
|
    | Prototype      |     |     |     | 3.50 |     |      |     |         =
|
    |----------------+-----+-----+-----+------+-----+------+-----+---------=
|
    | /Daily/        |     |     |     |      |     |      |     |         =
|
    #+TBLFM: @I$9..@II$9=3Dvsum($2..$8);%.2f;::@II$2..@III$9=3D'(format=
 "%3.2f" (apply '+ '(@I..@II)));N;

and I get the erro= r can't assign to hline relative reference when= I run M-x org-table-recalculate. I looked over the= org-mode references = documentation and the gmane.org forums, but I did not find any reasons as to w= hy the hline relative references could not be assigned.

This issue is related to the timesheet package on MELPA. I have filed an issue her= e: https://git= hub.com/tmarble/timesheet.el/issues/3 but hopefully I have found the un= derlying problem, and hopefully it is reasonably fixable.

Here is some relevant info:

  • Org-mode version 8.3.1 (8.3.1-87-g4ef2c0-elpa @ = /home/luke/.emacs.d/elpa/org-20150824/)

  • emacs-version: 24.5.1

  • ArchLinux OS: Linux 4.1.6-1-ARCH #1 SMP PREEMPT = Mon Aug 17 08:52:28 CEST 2015 x86_64 GNU/Linux

This is a copy of my question p= osted here: http://emacs.stackexchange.com/question= s/15185/cant-assign-to-hline-relative-reference

Any suggestions or guidance wou= ld be appreciated. I am happy to clarify anything as well.

Thanks,
Luke

=E2=80=8B
--089e0112d07ebfb0c1051e92764e--