Ubuntu
openoffice.org package

  1. Bug #210153
  2. Comment #21

Comment 21 for bug 210153

Revision history for this message
penalvch (penalvch) wrote : Re: [upstream] [3.2] calc: sum show #VALUE or err:529

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
http://answers.microsoft.com/en-us/office/forum/excel?page=1