There were questions like “How to get a blank cell by formula?” and an old one of them has about 20 replies and the valid and accepted answer “impossible” given by @Regina.
On the other hand there are formulas like {=[]}
returning FALSE for all the given question-formulas except ISFORMULA()
.
Neither inspecting cell properties by user code nor studying the pdf-specifications for ISTEXT()
and ISNUMBER()
solved the puzzle for me.
Is the described situation
- a bug?
- intended but undocumented behaviour?
- misunderstood by myself?
Demonstrating sheet:
disaskOwnQu122055_VirtuallyBlankCells.ods (20.9 KB)