Issue 69158 - number formatted as text on import and OOo doesn't calculate with text - thus calculation fails
Summary: number formatted as text on import and OOo doesn't calculate with text - thus...
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Keywords: ms_interoperability, oooqa
Depends on:
Reported: 2006-09-01 01:04 UTC by yarco
Modified: 2006-09-05 10:20 UTC (History)
2 users (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 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 
Comment 1 lohmaier 2006-09-04 20:37:30 UTC

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.