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: Calc (show other bugs)
Version:
(earliest affected)
3.5.4 release
Hardware: x86-64 (AMD64) Windows (All)
: medium major
Assignee: Not Assigned
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:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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 ***