Posted 8 September 2017, 2:19 pm EST

I have a spreadsheet that I thought I could quickly integrate into Farpoint Spread. It is a simple calculator of sorts with no macros.

There are three cells like so:

[Number of Rolls] [Rolls Total] [Number of Coins in a Roll]

The input cell is the first one, the number of rolls. I have defined Number of Rolls as a Number, Rolls Total as a Currency, and Number of Coins in a Roll as a number.

The Rolls total formula looks like this: =PRODUCT([Number of Rolls Cell], [Number of Coins in a Roll Cell], .25)

When entering the number of rolls in this cell, it works if a correct, whole number is inputted. However, if one backspaces all of the input characters and presses enter, the Farpoint Spread evaluates this cell as a '1', not a '0'., and so the PRODUCT formula calculates the [Number of Rolls Cell] just like there were a '1' in there.

Also, I use the SetNull Property as 0. However, this evaulates as a string, and whenever the cell is blanked out, a '0' appears left-justified in the cell AND the cell gets evaluated as a 1 rather than a 0.

It seems like standard form for spreadsheets to evaluate a blank cell as a '0'. This configuration works just fine in Excel. I don't know what I can do to fix this problem. Please provide the simplest possible fix. Thanks.

--