emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Michael Brand <michael.ch.brand@gmail.com>
To: Marcin Borkowski <mbork@wmi.amu.edu.pl>
Cc: Org-mode mailing list <emacs-orgmode@gnu.org>
Subject: Re: Variable table length
Date: Mon, 3 Jun 2013 15:38:23 +0200	[thread overview]
Message-ID: <CALn3zognm8p20uvw2N4_LNBLYeFSBEP0fygD_s7mKRV=SuXCrw@mail.gmail.com> (raw)
In-Reply-To: <20130603145428.6180b013@aga-netbook>

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

  reply	other threads:[~2013-06-03 13:38 UTC|newest]

Thread overview: 5+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2013-06-03 12:54 Variable table length Marcin Borkowski
2013-06-03 13:38 ` Michael Brand [this message]
2013-06-03 14:32   ` Michael Brand
2013-06-03 18:07     ` Marcin Borkowski
2013-06-03 19:15       ` Nick Dokos

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to='CALn3zognm8p20uvw2N4_LNBLYeFSBEP0fygD_s7mKRV=SuXCrw@mail.gmail.com' \
    --to=michael.ch.brand@gmail.com \
    --cc=emacs-orgmode@gnu.org \
    --cc=mbork@wmi.amu.edu.pl \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).