https://bugs.documentfoundation.org/show_bug.cgi?id=154101
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|3.3.0 release |Inherited From OOo Status|UNCONFIRMED |RESOLVED Resolution|--- |WONTFIX --- Comment #2 from Eike Rathke <[email protected]> --- Result 0 for a reference to an empty cell is standard behaviour in all major spreadsheet implementations, for interoperability we will not deviate from that. As you already noted, =IF(ISBLANK(A1);"";A1) suppresses that, and also excludes the cell from operations that expect a number sequence like AVERAGE(). You could also use =IF(ISBLANK(A1);NA();A1) that displays #N/A and use =AGGREGATE(1;6;cellrange) for an average that excludes error values. See https://help.libreoffice.org/7.5/en-GB/text/scalc/01/func_aggregate.html?DbPAR=CALC -- You are receiving this mail because: You are the assignee for the bug.
