Bug 117328

Summary:	OpenOffice Calc doesn't work with CSV files as it should
Product:	[openSUSE] SUSE LINUX 10.0	Reporter:	Chad Groneman <cgroneman>
Component:	OpenOffice.org	Assignee:	Mark Gordon <mtgordon>
Status:	RESOLVED WORKSFORME	QA Contact:	E-mail List <qa-bugs>
Severity:	Normal
Priority:	P5 - None	Keywords:	Built
Version:	Final
Target Milestone:	---
Hardware:	Other
OS:	All
Whiteboard:
Found By:	Beta-NTS	Services Priority:
Business Priority:		Blocker:	---
Marketing QA Status:	---	IT Deployment:	---
Attachments:	CSV output from Novell's TSATEST.NLM CSV output from Novell's SEG.NLM (better to show problem)

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.