calc: whats's the meaning of '{}'
hello out there,
who knows what's the meaning / function of '{}' in calc formulas?
i couldn't immediately find what they meant,
(i'm not shure if it's named 'curly braces' or 'curly brackets' correctly)
they seem responsible for a 'not recalculation' or 'stuck in not recalculation' in the third sample in
https://bugs.documentfoundation.org/s...
(it's used in E23:E57 on that sheet, and once one of theese cells calculates to that result on a change of F20, it's not anymore taken into account on further changes, neither comes back to it's old value on undo ... funny ...)
(change F20 to '2' and back to '3' or undo, results in E30:E33 are 'lost')
the function wizard calculates 'better' results in that sample, using '0' instead of '{}' makes the formula work better, thus i'm curious what '{}' stands for. 'NULL'? '0' not to be displayed and no further touch? 'out of the game''?
tia
b.