Issue 6768

Summary:

Excel compatibility problem - joined string not interpreted as number

Product:

Calc

Reporter:

ostkamp <guido.ostkamp>

Component:

code

Assignee:

Status:

CLOSED DUPLICATE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues

Version:

OOo 1.0.1

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

ENHANCEMENT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
ZIPfile including example Excel spreadsheet and converted OOo spreadsheet demonstrating the bug	none

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