Hi Marcin On Mon, Jun 3, 2013 at 2:54 PM, Marcin Borkowski <mb...@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
