Issue 69158

Summary:	number formatted as text on import and OOo doesn't calculate with text - thus calculation fails
Product:	Calc	Reporter:	yarco <yarco2000>
Component:	open-import	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues, lohmaier
Version:	OOo 2.0.3	Keywords:	ms_interoperability, oooqa
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description yarco 2006-09-01 01:04:49 UTC

Just found out that when I open my local companies computer price I cant see 
the prices for some reason. They are all 0.0. When I use Excel though, I can 
view them perfectly. Just wanted you guys to know..thats all;) Keep up the good 
work!
http://www.neoservice.ua/fileadmin/prices/rprice.rar

Comment 1 lohmaier 2006-09-04 20:37:30 UTC

confirming.

Please try to use a more telling summary next time and please attach the file
directly to the issue.

The problem is that cell E4 gets imported as text. Remove the ' from the 5,3 and
you'll get the same values as in Excel.

Comment 2 lohmaier 2006-09-04 20:39:00 UTC

and try to use the matching component the next time - reassigning

Comment 3 frank 2006-09-05 10:19:05 UTC

double to Issue 5658

*** This issue has been marked as a duplicate of 5658 ***

Comment 4 frank 2006-09-05 10:20:27 UTC

closed double

You may use Value Highlighting (CTRL+F8) to check for such problems. Black is
text, blue are numbers and green are formula results.

Frank