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
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2005-02-18 23:09 UTC by robinsonky
Modified: 2005-02-21 09:31 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
sample showing failed formulas in text fields (8.00 KB, application/vnd.ms-excel)
2005-02-18 23:18 UTC, robinsonky 		no flags Details
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 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 1.1.9.65 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
solution? 

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 
Hi,

this is a double to Issue 5658 .

Frank

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