From mboxrd@z Thu Jan  1 00:00:00 1970
From: Karl Voit <devnull@Karl-Voit.at>
Subject: table/calc: subscr() fails with date
Date: Sat, 3 Sep 2016 13:33:36 +0200
Message-ID: <2016-09-03T13-32-36@devnull.Karl-Voit.at>
Reply-To: Karl Voit <news1142@Karl-Voit.at>
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:36729)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1bg9EA-0004i7-2j
	for emacs-orgmode@gnu.org; Sat, 03 Sep 2016 07:35:15 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1bg9E6-0004pg-VQ
	for emacs-orgmode@gnu.org; Sat, 03 Sep 2016 07:35:14 -0400
Received: from [195.159.176.226] (port=43946 helo=blaine.gmane.org)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1bg9E6-0004l4-PL
	for emacs-orgmode@gnu.org; Sat, 03 Sep 2016 07:35:10 -0400
Received: from list by blaine.gmane.org with local (Exim 4.84_2)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1bg9Dz-0003OK-Uk
	for emacs-orgmode@gnu.org; Sat, 03 Sep 2016 13:35:03 +0200
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode/>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: "Emacs-orgmode"
	<emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: emacs-orgmode@gnu.org

Hi!

I've found a bug when using subscr() to get the value of the previous
row. With the following date values, it fails and I don't have an idea
why:

| date                   | previous date          |
|------------------------+------------------------|
| [2015-08-21 Fri 16.57] |                        |
| [2015-12-30 Wed 11:08] | [1986, Fri, 16.57]     |
| [2016-02-01 Mon 18:33] | <2015-12-30 Wed 11:08> |
| [2016-03-01 Tue 19:01] | <2016-02-01 Mon 18:33> |
| [2016-04-01 Fri 19:39] | <2016-03-01 Tue 19:01> |
| [2016-05-01 Sun 13:01] | <2016-04-01 Fri 19:39> |
| [2016-06-01 Wed 18:24] | <2016-05-01 Sun 13:01> |
| [2016-07-02 Sat 16:44] | <2016-06-01 Wed 18:24> |
| [2016-08-01 Mon 19:18] | <2016-07-02 Sat 16:44> |
| [2016-09-02 Fri 15:34] | <2016-08-01 Mon 19:18> |
#+TBLFM: @3$2..@>$2 = subscr(@<$1..@>$1, @# - 1)

Do you have any hint or idea?


At my side: Org-mode version 8.3.4 (release_8.3.4-33-gd522fc)

-- 
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
       > get Memacs from https://github.com/novoid/Memacs <

https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github