|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | Concatenate command doesn't evaluate cell values | ||
|---|---|---|---|
| Product: | Calc | Reporter: | woffie <carl> |
| Component: | editing | Assignee: | spreadsheet <spreadsheet> |
| Status: | CLOSED DUPLICATE | QA Contact: | issues@sc <issues> |
| Severity: | Trivial | ||
| Priority: | P3 | CC: | issues |
| Version: | OOo 3.0.1 | ||
| Target Milestone: | --- | ||
| Hardware: | Other | ||
| OS: | Windows XP | ||
| Issue Type: | DEFECT | Latest Confirmation in: | --- |
| Developer Difficulty: | --- | ||
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. 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 *** closed double |
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.