In LibreOffice 4.3 the user will be able to select how textual cell content shall be treated in arithmetic operations.
This setting determines how to treat text when encountered as operand in an arithmetic operation or as argument to a function that expects a number instead.