imho a spreadsheet should be clear, precise and produce unique results,
(unless you work with random functions intentionally)
calc doesn’t, whenever you change the format of a cell with a formula from number to text and vice-versa it produces irritating results,
i’d like to see your comments before filing that as a bug.
enter “1” in A1, all values without the quotation marks!
enter “=A1” in B1,
enter “=2*B1” in C1,
you’ll see 1 | 1 | 2 in the row,
change format of B1 to text,
you’ll see the result changed in only one little point, the “1” in B1 is now ‘left aligned’, the cell shows the result! of the calculation formatted as text,
imho the error starts here, a cell formatted as text shall show text, a programmer told me “no, it’s your fault, you should explicitly change the content to text by adding a apostroph (’=A1)”, thus she insists that showing “1” in B1 is correct,
if neccessary i could possibly live with that, i have difficulties to accept the next step,
in the above sheet enter the cell B1 and edit the content !!!without changing it!!!, e.g. insert a space and delete it while in edit mode,
after pressing enter the sheet will show changed content:
1 | =A1 | #VALUE!
while the formulas in the cells and their formatting are unchanged!!! cell B1 changes to show the text! of the formula instead of evaluating it,
that is a fault against the idea of the programmer, and in total it’s certainly a fault having different results for the same input.
going back (formatting B2 as number and after that doing a ‘no-changing-edit’) will produce the same irritation, between the two steps the shown “=A1” in B1 is contradictionary to the formatting,
the behaviour is in plenty (all?) old versions of calc, it’s still in ver. 126.96.36.199 alpha0,
imho it’s based on ‘when and what’ is to be recalculated after changes, either you do! recalculation after changing the format, or you can omit it because the result won’t change, but then it shouldn’t change later on,
as one can see from the behaviour of C1 the evaluation is! important, as it does! affect the result of calculations …
pls. tell what you think about it …