Re:Technical error with Excel.swapped names.Andreas Babler e...
by pc86 on Monday June 05, 2023 @02:33PM
(#36200890)
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?
[ Parent
| on HN ]
Re:Technical error with Excel.swapped names.Andreas Babler e...
by theshrike79 on Monday June 05, 2023 @03:51PM
(#36202537)
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?
Re:Technical error with Excel.swapped names.Andreas Babler e...
by mkishi on Monday June 05, 2023 @07:10PM
(#36205570)
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.