Issue 43116 - OOo differs from Excel in handling of numbers in text fields
Summary: OOo differs from Excel in handling of numbers in text fields
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.1.4
Hardware: PC Windows XP
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: bettina.haberer
QA Contact: issues@sc
Keywords: oooqa
Depends on:
Reported: 2005-02-18 23:09 UTC by robinsonky
Modified: 2005-02-21 09:31 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

sample showing failed formulas in text fields (8.00 KB, application/
2005-02-18 23:18 UTC, robinsonky
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description robinsonky 2005-02-18 23:09:49 UTC
In an .xls spreadsheet created by excel 95/97 a vendor has sent us a price list.
He has unfortunately set all cells to text format. 
Excel (all versions) recognises the content as numeric (despite warning text to
the contrary) and 'correctly/intuitively' allows a formula referencing two such
cells to calculate the correct value.
OOo 1.1.4 and both fail to calculate, showing a result of 0, until the
cell types are chnaged to currency. It doesn't even work if the cell is changed
to numeric.
F2 in Excel shows the number eg: 35.00 whereas in OOo it appears as '35.00.
Comment 1 robinsonky 2005-02-18 23:18:49 UTC
Created attachment 22806 [details]
sample showing failed formulas in text fields
Comment 2 Rainer Bielefeld 2005-02-21 09:05:58 UTC
I see the problem, but the solution is not easy: I am afraid there are to many
cases how those "text containing numbers" fields can be handled. May be an input
filter with checkbox "change text fields only containing number" could be a

Change to  "Enhancement".
Comment 3 Rainer Bielefeld 2005-02-21 09:08:52 UTC
I do not see that as a defect, OOo behaviour is correct.
Comment 4 frank 2005-02-21 09:31:24 UTC

this is a double to Issue 5658 .


*** This issue has been marked as a duplicate of 5658 ***
Comment 5 frank 2005-02-21 09:31:45 UTC
closed double