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
URL: http://www.besecke.de
Keywords:
Depends on:
Blocks:
 
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: ---

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

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 ...

=A1*A2

... 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
r.geese@besecke.de
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 .

Frank

*** 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.