Issue 101306 - Concatenate command doesn't evaluate cell values
Summary: Concatenate command doesn't evaluate cell values
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.0.1
Hardware: Other Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-04-23 13:05 UTC by woffie
Modified: 2009-04-23 14:06 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 woffie 2009-04-23 13:05:58 UTC 
The following expression doesn't evaluate correctly. Value of D3 is 1.

=CONCATENATE("..."; 23 - D3 + 1; "...")

Correct result when D3 = 1:   ...23...
Incorrect result when D3 = 1: ...24...

Even if the math expression is the sole content of concatenate, same faulty
result is given.
Comment 1 woffie 2009-04-23 13:20:54 UTC 
When opened the same file in Excel it said that the cell D3 was saved as text
instead of number - but still evaluated the result correctly.

However, no sign of this notification in OOcalc other than left adjusted value.
Comment 2 frank 2009-04-23 14:06:23 UTC 
Calc does not calculate with text values, therefore this Issue is a double to
Issue 5658 and will be closed as such.

Frank

*** This issue has been marked as a duplicate of 5658 ***
Comment 3 frank 2009-04-23 14:06:50 UTC 
closed double