Issue 50772 - Excel calculates with string, Calc doesn't
Summary: Excel calculates with string, Calc doesn't
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0 Beta
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
Depends on:
Reported: 2005-06-15 15:48 UTC by besecke
Modified: 2005-06-16 09:19 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description besecke 2005-06-15 15:48:48 UTC
If a cell (A1) contains ...

=IF(2>1;"2 %";"0 %")      (critical is the part "2 %")

.... an anther cell contains ...


... Excel will calculate with the "2 %", but Calc will take it as text and will
show '0' as the result.

I wanted to send the *.xls file, but don't know, how. 

Greetings from Germany
Rüdiger Geese
Comment 1 kla 2005-06-16 08:29:12 UTC
Wrong Component 
Comment 2 frank 2005-06-16 09:18:25 UTC
... and not a bug from calc.

Also a double to Issue 5658 .


*** This issue has been marked as a duplicate of 5658 ***
Comment 3 frank 2005-06-16 09:18:46 UTC
closed double
Comment 4 frank 2005-06-16 09:19:18 UTC
You may have a look at the value() function.