Bug 52366 - Numeric calculation of cells with mixed data-types leads into a calculation error
Summary: Numeric calculation of cells with mixed data-types leads into a calculation e...
Status: RESOLVED DUPLICATE of bug 50345
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.5.4 release
Hardware: x86-64 (AMD64) Windows (All)
: medium major
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-07-22 18:52 UTC by mathias.supp
Modified: 2012-07-22 20:31 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:

Attachments

Description mathias.supp 2012-07-22 18:52:56 UTC 
- create a new spreadsheet document
- put the numeric value 2 into cell A1
- put the formula =A1-A2 into cell B1
  - you'll get a "2" in B1
- now enter the formula =IF(1=1;"";"") into cell A2
  - B1 contains an error

As an empty string is often use as some kind of a default value it's irritating the formula isn't calculatable.

Works perfekt with OOo 3.0 and Excel (didn't check it with former version of LibO).

May be I missed a setting? (neither online-help, nor google, nor preferences helped me on this topic)

Please allow empty strings to be used in numeric operations (again).
Btw.: just tested it on LibO 3.5.5, too.
Comment 1 Regina Henschel 2012-07-22 20:31:59 UTC 
A similar problem is already tracked in issue 50345. A patch has been pushed to master. Please try it with a build, that contains the patch.

If it does not solve your issue, feel free to reopen it.

*** This bug has been marked as a duplicate of bug 50345 ***

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.