Issue 18548 - Wrong number format after importing a xls file
Summary: Wrong number format after importing a xls file
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC Windows 98
: P3 Trivial (vote)
Target Milestone: ---
Assignee: john.marmion
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-22 21:37 UTC by hwoarang
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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

Attachments
xls file that Ooo display the numbers in wrong format (10.00 KB, patch)
2003-08-22 21:38 UTC, hwoarang 		no flags Details | Diff
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 hwoarang 2003-08-22 21:37:47 UTC 
Hi guys!
When Ooo import this file (attached) all columns that contain numbers in 
currency format (C, D, E, F, G and H) is displayed like time format
The column that contain a simple number format (B) is displayed like date format

Thanx and keep on moving with these hard work guys!

Hwoarang
Comment 1 hwoarang 2003-08-22 21:38:58 UTC 
Created attachment 8681 [details]
xls file that Ooo display the numbers in wrong format
Comment 2 john.marmion 2003-08-23 16:07:22 UTC 
I had a quick look at this. The attached doc is an Excel 5.0/95 file.
Saving this to any later Excel version and OOo will correctly display
the cells.
Comment 3 john.marmion 2003-08-23 16:07:55 UTC 
set to new
Comment 4 john.marmion 2003-09-02 11:14:26 UTC 
This document looks like it was originally created by Lotus 123 and
converted to xls. Many of the fields have a leading "'" indicating a
lotus style formatting. Anyway, saving this in Excel as Excel 5.0 or
later and this will display successfully in Calc. I am going to close
this as not a bug.
Comment 5 john.marmion 2003-09-02 11:15:06 UTC 
mark as closed