Issue 118963 - Seeing Double Quotes when an existing .CSV file from MS Office is saved after Opening from OpenOffice
Summary: Seeing Double Quotes when an existing .CSV file from MS Office is saved after...
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: version58
Hardware: Mac Mac OS X 10
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: Peggy Fobbe
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-02-23 09:25 UTC by Srinivas
Modified: 2017-05-20 11:55 UTC (History)
1 user (show)

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

Attachments
.CSV file Screen shot after Saving from OpenOffice (646.56 KB, image/png)
2012-02-23 09:30 UTC, Srinivas 		no flags Details
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 Srinivas 2012-02-23 09:25:17 UTC 
Hi,

Recently our company has decided to discontinue using MS Office & use Openoffice instead. We are facing an issue when an Existing .CSV file created using MS Excel is opened & saved in openoffice spreadsheet. When we save the file & reopen again 
we are able to see Double Quotes before & after every string.

Due to this we are unable to upload the .CSV file into Our database. Attached is the screen shot of a .CSV file which is for your reference. 

Please help us in resolving this issue & kindly send us the suggestions.

Please let me know if you have any questions or concerns.   

Thanks,
Srinivas
Mob: +91-97393 22280
Email: srinivasa.ae@exilant.com
Comment 1 Srinivas 2012-02-23 09:30:44 UTC 
Created attachment 77241 [details]
.CSV file Screen shot after Saving from OpenOffice

.CSV file Screen shot after Saving from OpenOffice
Comment 2 frank 2012-04-02 14:51:47 UTC 
Hi,

as far as I can tell now this is not a bug of OOo.
Please ask at the forums for assistance regarding this problem. It seems to me it's related to the filter settings either on Import or Export.

http://user.services.openoffice.org/en/forum/

Frank