Bug 46465 - File created (csv) in Libreoffice, cause in R programming error "Incomplete end of file" and strange data in MS office 2010
Summary: File created (csv) in Libreoffice, cause in R programming error "Incomplete e...
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-02-22 09:17 UTC by Ravi
Modified: 2012-07-20 13:18 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
test file for bugg (11.49 KB, application/vnd.ms-excel)
2012-02-22 09:17 UTC, Ravi
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ravi 2012-02-22 09:17:09 UTC
Created attachment 57469 [details]
test file for bugg

The attached (test.csv) file was created using Libreoffice 3.5. The file can be opened in libreoffice easily but if you try to open in MS office 2010, you will find some strange data.  

I try to open this file in R programming language(To access data for my program) and it has thrown an error "Incomplete end of file".

Although, I was not able to open most of the files that i have created in Libreoffice. 

This file can be open in libreoffice.
Comment 1 Urmas 2012-02-22 09:42:51 UTC
It is ODS file, not CSV.
Comment 2 Ravi 2012-02-23 07:09:21 UTC
(In reply to comment #1)
> It is ODS file, not CSV.

OK, I got the problem, when i saved the file, the name was test.csv
and Automatic file extension was tick marked but save type was ODF spreadsheet(.ods)


So, the automatic extension dos'nt work and it saved the file name but internal coding was .ODS structure.
Comment 3 sasha.libreoffice 2012-05-23 05:26:33 UTC
Thanks for bugreport
Please, verify if in last version of LibreOffice still reproducible
Comment 4 bfoman (inactive) 2012-07-20 13:18:47 UTC
Checked with:
LO 3.5.5.3 
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit

Could not reproduce. File is in ods format.
Automatic file name extension option, when turned on, will change filename extension depending of which save format is selected.
If you have test.csv file then when you change filetype to dBase, its name will be changed to test.dbf. 
If you disable this function then test.csv file will be saved as test.csv in selected dbf filetype.
Please check "Automatic extension to the file name" topic in Help for more informations. 
If you think that there is a bug in this mechanism, please fill new report.