Issue 65604 - text+number inconsistent with Excel
Summary: text+number inconsistent with Excel
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2006-05-20 04:03 UTC by pbjs212
Modified: 2006-05-22 08:42 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 pbjs212 2006-05-20 04:03:49 UTC
OO differs from Excel in adding a text cell and numeric cell.

Consider the following sheet:
  A1 12.3
  A2 =TEXT(A1;"###.###")
  A3 =A2+1

In A3, Excel has 13.3 but OO has 1, because it's treating all non-numeric cells
as zero instead of converting them
Comment 1 frank 2006-05-21 16:16:15 UTC
Not a bug !

Text is text and not a number so you can't calculate with text.

Also it's a double to another Issue.

Comment 2 pbjs212 2006-05-21 17:14:15 UTC
fst, sorry for duplication, but I didn't find the original issue. I didn't say
it was a bug, only that it's inconsistent with Excel. Perhaps you'll need to add
a "faithful Excel emulation" option setting then...
Comment 3 frank 2006-05-22 08:42:08 UTC
double to Issue 5658

*** This issue has been marked as a duplicate of 5658 ***
Comment 4 frank 2006-05-22 08:42:25 UTC
closed double