[Solved] .CSV spreadsheets won't open in 4.6.1

Discuss the spreadsheet application

[Solved] .CSV spreadsheets won't open in 4.6.1

Postby BrianR » Sun Dec 02, 2018 4:39 pm

I have a number of spreadsheets compiled using Calc, in the .csv format. They are simply columns of data. since upgrading to 4.6.1 these have refused to open. However, on uninstalling the upgrade and reinstalling 4.5.1, they still wont open. Other spreadsheets are not affected. Attached
Croatia and Slovenia POIs.csv
(2.43 KiB) Downloaded 18 times
is one of the files that won't open - trying to open it gives this
Open Office problem 3 (FILEminimizer).png
. On trying to open a file you get this window
Open Office problem 2 (FILEminimizer).png
. Any help would be appreciated.

I have just discovered that if I create a new .csv file, it works OK.
Last edited by BrianR on Sun Dec 02, 2018 6:13 pm, edited 2 times in total.
AOo 4.0.1 Vista
BrianR
 
Posts: 17
Joined: Mon Oct 22, 2012 9:01 pm

Re: .CSV spreadsheets won't open in 4.6.1

Postby Villeroy » Sun Dec 02, 2018 4:49 pm

The file is NOT unicode encoded. Switch from Unicode to "Western Europe" (Windows 1252)"
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26727
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: .CSV spreadsheets won't open in 4.6.1

Postby merlijn » Sun Dec 02, 2018 4:54 pm

Opens fine on my AOO 4.1.6, even with character set unicode utf 8
OpenOffice 4.1.6 on Windows 10 x64
merlijn
 
Posts: 26
Joined: Mon Jun 11, 2018 8:29 pm

Re: .CSV spreadsheets won't open in 4.6.1

Postby Villeroy » Sun Dec 02, 2018 4:59 pm

merlijn wrote:Opens fine on my AOO 4.1.6, even with character set unicode utf 8

Yes, but the "Unicode" might refers to UTF-16. It is not a UTF-16 encoded file.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26727
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: .CSV spreadsheets won't open in 4.6.1

Postby merlijn » Sun Dec 02, 2018 5:07 pm

:bravo:
OpenOffice 4.1.6 on Windows 10 x64
merlijn
 
Posts: 26
Joined: Mon Jun 11, 2018 8:29 pm

Re: .CSV spreadsheets won't open in 4.6.1

Postby John_Ha » Sun Dec 02, 2018 5:27 pm

When you open the file you must specify what separators are being used.

Examining the file with Notepad shows it is using commas. So untick everything else, and tick comma.

Clipboard01.gif

This is it saved as a .odt.
Attachments
Croatia and Slovenia POIs.ods
(17.19 KiB) Downloaded 6 times
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6614
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: .CSV spreadsheets won't open in 4.6.1 SOLVED

Postby BrianR » Sun Dec 02, 2018 6:19 pm

Thanks for these replies. I have reopened the file and set the character set to Western European 1252 and it now works. Strange that somehow this got changed in all the ,csv files :?
AOo 4.0.1 Vista
BrianR
 
Posts: 17
Joined: Mon Oct 22, 2012 9:01 pm


Return to Calc

Who is online

Users browsing this forum: Imul, robleyd and 46 guests