Bug: EXTREMELY bizarre behavior

J. Craig Williams

After the release a little while ago, the first thing I noticed was a simple sum of 7 cells was giving the incorrect value. That resolved itself when I closed and reopened the Sheet for the second time.

And then the KPI's I was working on went 'bonkers' and I noticed the attached values coming from a calculation on a cell that had a cross-sheet reference.

Further testing revealed that a formula like this:

=IFERROR(some formula based on text coming from x-sheet ref, "")

was blank. The cell used in the formula was OK.

Changing the formula to this

=IFERROR(some formula based on text coming from x-sheet ref, "err")

resulted in the formula returning the correct value (not "err")

I have a video to send to support.

My formulas are returning incorrect values. X-Sheet References are toggling (and apparently have been doing so all weekend as I worked)

I'll try again in the morning.

Craig

Paul Newcome

Any update on this? I haven't run across this issue yet, but I'm sure it's only a matter of time.

J. Craig Williams

I've run 4 tests this morning (8:10, 8:25, 8:40, 10:15) and so far, so good.

I have not experienced any of the additional odd behavior (SUM() not working!!?) but the day has just begun.

Craig

J. Craig Williams

No response to my email to support sent Sun, Jul 29, 2018 at 9:44 PM

Craig