What can we do about isBlank failing on cells referencing isBlank cells?
macOS, 12.7.6 (Monterey), using Numbers.
An empty cell becomes non-empty when referenced from another cell.
This example has both A2 and B2 formatted as text. If they are formatted automatic (default)
then the result is even worse -- the referenced automatic cell becomes the number 0.
This 'feature' makes copying working tables and cross-referencing much harder than it need be, and the function isBlank virtually useless.
{I would like isBlank to be renamed isEmpty, and references to preserve emptiness. Also isBlank should be broadened to recognise blank cells (as its name implies), for example, text cells of length 0.
B2 above turns out to be a cell which has len(B2)=0, and so a complete re-write of my formulae solved my particular problem.}
What does the community do about this?
MacBook
