Issue 6768 - Excel compatibility problem - joined string not interpreted as number
Summary: Excel compatibility problem - joined string not interpreted as number
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-08-05 21:52 UTC by ostkamp
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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

Attachments
ZIPfile including example Excel spreadsheet and converted OOo spreadsheet demonstrating the bug (7.81 KB, application/octet-stream)
2002-08-05 21:54 UTC, ostkamp 		no flags Details
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 ostkamp 2002-08-05 21:52:10 UTC 
The attached table describes an MS Excel compatibility bug:

The operation "VERKETTEN" (German OOo version, must be JOIN in english) 
joins together to things; e.g. strings, numbers etc.

In Excel, the content of such cell can be used in a formula in another cell
and is interpreted as number. In OOo this is not the case, leading to entirely
different calculations.

In the attached example look at the following:

Cell A1 holds a number 20.333
Cell A3 holds a "VERKETTEN" formula and shows +10.33
Cell C3 uses A3 and adds 20

Now in C3, Excel shows 30.33 while OOo shows 20.
Comment 1 ostkamp 2002-08-05 21:54:00 UTC 
Created attachment 2444 [details]
ZIPfile including example Excel spreadsheet and converted OOo spreadsheet demonstrating the bug
Comment 2 frank 2002-08-06 09:31:29 UTC 
Hi Guido,

this is not a bug !

OOo Calc just do not calculate with text. CONCATENATE (verketten)
produces text, so this can't be used as value for a calculation.

Nevertheless we have a discussion to change this behaviour. So I set
this Issue as double and close it.

Frank

*** This issue has been marked as a duplicate of 5658 ***
Comment 3 frank 2002-08-06 09:31:53 UTC 
closed duplicate
Comment 4 daniel.rentz 2002-08-06 09:56:41 UTC 
@Guido: In cell C3, use the function WERT (VALUE) to convert the text
in A3 to a value: =WERT(A3)+20