I was wondering, in excel when recording %type we often put the formual (eg 66% => “=2/3”) it help us keeping both value in case of investigation of the numbers.
Do not know but maybe adding a type cell formula (not column) that executes the local formula and keep the formula would help (it is also sometimes easy for short draft calculation). Needs to be safe, not overridding the column type, avoiding messing stuff also,…, but for (non formula column & numeric value) could be usefull.
Now when you type anything, it will try to evaluate it as a python expression (so you can enter a math expression like 2 + 10). When it fails or you enter a text, it will just store the value you typed in.
@jarek I do like the idea of the “cleaning eval”, but in case one has sensitive data, it should be noted that it opens a “security” hole: it would allow editors whose access to some tables, columns or records is restricted to “reveal” them indirectly.