Login Page - Create Account

Support Board


Date/Time: Sun, 22 Dec 2024 17:43:32 +0000



Post From: New Spreadsheets formulas sometimes cause SC to crash

[2015-05-10 17:01:10]
Sawtooth - Posts: 4141
This thread is a continuation of the off-topic here:
New Spreadsheets font is erroneously bolded in v1252

I just had SC crash a 3rd time when entering formulas.

Here is a recap of the 3 incidents:
1)
-I entered a not-very-complex formula and received a #SYNTAX! error.
-I visually and carefully verified the syntax and it was correct.
-I pressed Enter again (or OK, I don't remember) and SC crashed.
2)
- I copied a formula from another cell with Ctrl-c and pasted it is a different cell with Ctrl-v
- I pressed Enter again (or OK, I don't remember) and SC crashed.
3)
- I copied a formula from a cell with Ctrl-c and pasted it is a different cell with Ctrl-v
- I pressed Enter and only the cell in row3 updated (no cells below updated)
- I edited the formula to change one column reference, pressed Enter and SC crashed.
The attached pic is related to this. I changed column BS to AK in the formula.
Private File