In LibreOffice nulls are always propogated, except when a calculation is performed on a null field. The result of such an expression is always Null.