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 ** Changed in: libreoffice (Ubuntu) Status: New => Opinion ** Changed in: libreoffice (Ubuntu) Importance: Undecided => Wishlist ** Changed in: openoffice.org (Ubuntu) Importance: Medium => Wishlist ** Changed in: openoffice.org (Ubuntu) Status: Triaged => Opinion -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/210153 Title: Calc =""+1 shows error #VALUE or err:529 -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
