[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] Variable table length
From: |
Michael Brand |
Subject: |
Re: [O] Variable table length |
Date: |
Mon, 3 Jun 2013 15:38:23 +0200 |
Hi Marcin
On Mon, Jun 3, 2013 at 2:54 PM, Marcin Borkowski <address@hidden> 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