Hacker News Reader

I've had columns filled with a formula and intentionally replaced one cell with a static value. You immediately get a warning on that cell that can be ignored/cleared but takes a handful of clicks to do so. Granted, there's no overall place to view the warnings (that I am aware of) so if you have 100k lines and one cell replaced you can't easily see it without inspecting everything. Is this no longer the case?

View on HN

I just made an Excel sheet, put in formulas and I could just type over any formula with numbers without any notifications or errors.

How do you manage to require "a handful of clicks" to do it?

This only happens in "proper" tables. When you add a formula to a table column, Excel will automatically convert it into a "calculated column," so overridden values will have a green mark denoting an "inconsistent formula."

It's still a pretty minor warning and it only requires two clicks to ignore.

Reply on news.ycombinator.com