Ubuntu
libreoffice package

  1. Bug #1263326
  2. Comment #5

Comment 5 for bug 1263326

Revision history for this message
penalvch (penalvch) wrote : Re: #VALUE doesn't propagate correctly subtracting text from numbers

Ray DeCampo, thank you for your comments. I'm comparing the results to Excel from a feature parity expectation perspective, so this is why my expectations were different. However, LibreOffice has on a number of occasions developed past Excel for the better (ex. making functions more precise than equivalent ones in Excel, letting functions calculate larger values than Excel functions, etc.), and this would be an example of that.

In Microsoft Office Excel Viewer (12.0.6219.1000 MSO (12.0.6213.1000), it propagates the #VALUE error due to the malformed subtracting of numbers and text. However, LibreOffice has done work to develop past this limitation. So, your expectation would be correct, in that cell H6 should show $4,081.03 despite the malformed subtraction. I'll correct the Bug Description to this.

Hence, the issue you are reporting is an upstream one. It would be nice if somebody having it could send the bug to the developers of the software by following the instructions verbatim at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about the status. Thanks in advance.

Helpful bug reporting tips:
https://help.ubuntu.com/community/ReportingBugs