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
Depends on:
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: ---


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.


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