OpenOffice.org – Calc replace empty cells as zero

Use cell function.

= CELL(“contents”;A1)

A1 = cells data

Link of Reference: //user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=6619