Christoph Roeder, this phenomenon is the same in LibreOffice Calc, Gnumeric, and Excel. The reason being is Calc and Gnumeric are designed to hold compatibility with Excel. Microsoft disclaims this issue noting "...add, divide, multiply, and subtract two or more numeric values.":
Despite this, this issue really is not a bug and requires more discussion, which should be done on an appropriate mailing list or forum. If you have a Microsoft support contract you can leverage, feel free to bring this to the attention of Microsoft and post the results to this bug. Otherwise, feel free to post to one or both of the following Microsoft forums and post a link of it to this bug:
Christoph Roeder, this phenomenon is the same in LibreOffice Calc, Gnumeric, and Excel. The reason being is Calc and Gnumeric are designed to hold compatibility with Excel. Microsoft disclaims this issue noting "...add, divide, multiply, and subtract two or more numeric values.":
http:// office. microsoft. com/en- us/excel- help/use- excel-as- your-calculator -HA010263680. aspx?CTT= 5&origin= HA010215738
A cell with a "" is not a numeric value.
Despite this, this issue really is not a bug and requires more discussion, which should be done on an appropriate mailing list or forum. If you have a Microsoft support contract you can leverage, feel free to bring this to the attention of Microsoft and post the results to this bug. Otherwise, feel free to post to one or both of the following Microsoft forums and post a link of it to this bug:
http:// social. msdn.microsoft. com/Forums/ en-US/exceldev/ threads answers. microsoft. com/en- us/office/ forum/excel? page=1
http://