From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: Variable table length
Date: Mon, 3 Jun 2013 15:38:23 +0200
Message-ID: <CALn3zognm8p20uvw2N4_LNBLYeFSBEP0fygD_s7mKRV=SuXCrw@mail.gmail.com>
References: <20130603145428.6180b013@aga-netbook>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:43351)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1UjUxw-00029E-2x
	for emacs-orgmode@gnu.org; Mon, 03 Jun 2013 09:38:29 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1UjUxs-00048M-QX
	for emacs-orgmode@gnu.org; Mon, 03 Jun 2013 09:38:27 -0400
Received: from mail-la0-x22c.google.com ([2a00:1450:4010:c03::22c]:65283)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1UjUxs-00047l-K1
	for emacs-orgmode@gnu.org; Mon, 03 Jun 2013 09:38:24 -0400
Received: by mail-la0-f44.google.com with SMTP id er20so1351715lab.31
	for <emacs-orgmode@gnu.org>; Mon, 03 Jun 2013 06:38:23 -0700 (PDT)
In-Reply-To: <20130603145428.6180b013@aga-netbook>
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-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Marcin Borkowski <mbork@wmi.amu.edu.pl>
Cc: Org-mode mailing list <emacs-orgmode@gnu.org>

Hi Marcin

On Mon, Jun 3, 2013 at 2:54 PM, Marcin Borkowski <mbork@wmi.amu.edu.pl> wrote:
> and one more question.  I'd like to use Org's spreadsheet to create an
> amortization schedule for a loan.  It would be best if the number of
> rows (excluding the header and footer row) could be variable ande.g.
> derived from some property.  Is it possible in Org?  If so, how?

This is not possible. At least checking the number of rows is possible
with "vlen(@I..@>>) or similar.

I would use one row per payback and manually add/remove rows until the
last row is the only one with a different sign for the floating loan.

Michael