Bug 117328 - OpenOffice Calc doesn't work with CSV files as it should
Summary: OpenOffice Calc doesn't work with CSV files as it should
Status: RESOLVED WORKSFORME
Alias: None
Product: SUSE LINUX 10.0
Classification: openSUSE
Component: OpenOffice.org (show other bugs)
Version: Final
Hardware: Other All
: P5 - None : Normal
Target Milestone: ---
Assignee: Mark Gordon
QA Contact: E-mail List
URL:
Whiteboard:
Keywords: Built
Depends on:
Blocks:
 
Reported: 2005-09-15 20:12 UTC by Chad Groneman
Modified: 2005-10-18 00:17 UTC (History)
0 users

See Also:
Found By: Beta-NTS
Services Priority:
Business Priority:
Blocker: ---
Marketing QA Status: ---
IT Deployment: ---

Attachments
CSV output from Novell's TSATEST.NLM (1.69 KB, text/x-comma-separated-values)
2005-09-15 20:13 UTC, Chad Groneman 		Details
CSV output from Novell's SEG.NLM (better to show problem) (15.22 KB, text/x-comma-separated-values)
2005-09-15 20:14 UTC, Chad Groneman 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Chad Groneman 2005-09-15 20:12:22 UTC 
If I open a csv file in OOo calc, it doesn't show it properly.  It also does not
allow scrolling (not sure if this is csv specific - I've only used csv files so
far).  If I open the file with Gnumeric, it is how it should be.  I will attach
a couple sample csv files.
Comment 1 Chad Groneman 2005-09-15 20:13:15 UTC 
Created attachment 50071 [details]
CSV output from Novell's TSATEST.NLM
Comment 2 Chad Groneman 2005-09-15 20:14:41 UTC 
Created attachment 50073 [details]
CSV output from Novell's SEG.NLM (better to show problem)
Comment 3 M Nagashree 2005-09-16 10:55:36 UTC 
This works fine with out any issues and opens up as same as its opened in gnumeric.

There might be a possiblilty that you might have missed checking the checkbox
associating to appropriate separators. 
Just check if checkbox for comma separator was checked.
Comment 4 Chad Groneman 2005-09-16 13:28:56 UTC 
You're right - I didn't see the checkbox.  It works with that checked.

However, I think the comma box should be checked by default when opening a csv
file, because csv stands for Comma Separated Value.
Comment 5 M Nagashree 2005-09-19 05:19:14 UTC 
Resolving the bug as works for me and closing it.