Table formulas are broken! Simple subtraction no longer works

[stevencohn]

Problem to Solve

Oh! The shame!! Relative cell references breaks simple subtraction.

From a user:

Release 6.5.0 has introduced a bug into OneMore Formulas. It may be easily demonstrated as follows:
It appears that the minus operator is no longer supported when referencing cells.
This issue caused problems with a complex page template which I have been using for more than a year.
The problems disappear when I revert to OneMore v6.1.0 (I don't have the installer for 6.4.0)

To Reproduce

1. Create a table with a single column and three rows
2. Enter any numbers into cells A1 and A2
3. In cell A3, attempt to enter the formula "A1-A2" - it will be flagged as "Status - Invalid"

Workaround

Add spaces before and after the minus sign. For example, change A1-A2 to A1 - A2

Proposed Solution

Relative cell references will be replaced by a new function, cell(), and two variables, tablerows and tablecols. While the next release will break the relative cell reference feature, the new functions will be much more powerful, allowing both column offset and row offset, as well as forward looking relative references. The full syntax of the cell function will be

• cell(colOffset, rowOffset)

Offsets are always relative to the current cell, i.e., 0,0 refers to the current cell. Both positive and negative offsets are allowed.

Examples

To add a reverse-looking summary cell to the bottom of a table, something like sum(A1,cell(0,-1)) will total all cells in the column from the first row (A1), down to the row just prior to the formula cell.

To add a forward-looking summary cell to the top of a table in cell A1, something like sum(A2, cell(0, tablerows-1)) will total all cells in the column from the second row (A2), down to the cell in the last row of the table; note that rowOffset parameter still needs to be expressed as an offset from the current cell, hence tablerows-1.