Ask Your Question
1

xls file mistakenly imported as csv file [closed]

asked 2012-04-06 08:22:12 +0200

vaah gravatar image

updated 2015-10-19 19:45:30 +0200

Alex Kemp gravatar image

Hi guys, I'm running ubuntu 10.10 64 bit, I used LO 3.5 when i encounter this problem. I wanna open xls file, however "text import" dialog pop up as if I opened a csv file. I thought this was a bug in LO 3.5 so i upgraded to the latest version LO 3.5.2, same problem persist.

This is however doesn't apply to all xls files. Is there anyway so I can force LO to open this XLS file like standard excel file, instead of treating this particularly xls like a csv file? thank you.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 19:46:15.070096

Comments

Can you share the file?

Pedro gravatar imagePedro ( 2012-04-07 08:50:17 +0200 )edit

>>...so i upgraded to the latest version 3.5.2... The latest LibO version 3.6.2. I had similar problem - for me it appeared in version 3.5.6, but transition to 3.6.1 helped to solve all problems (files were opened in 3.6 and resaved). In version 3.6.2 problem also does not rise.

Timon gravatar imageTimon ( 2012-10-30 13:45:24 +0200 )edit

8 Answers

Sort by » oldest newest most voted
0

answered 2012-11-13 04:37:39 +0200

vaah gravatar image

Hi Guys sorry for the late response. I downloaded the xls file from partner's website for my work, so I guess it's just bad formatted file or the web dev wrongly creates the file structure(not sure) because if I change the extension name to .ods then the file opens just fine. That being said I notice that in LO 3.6.2.2 this problem goes away, well in my case.

edit flag offensive delete link more

Comments

Did you try once to open the file without any extension? If so what was the result?

ROSt52 gravatar imageROSt52 ( 2012-11-29 16:56:35 +0200 )edit
0

answered 2012-11-29 15:22:03 +0200

WvV gravatar image

updated 2012-11-29 16:30:19 +0200

For me it started when I upgraded on openSUSE x86_64 12.1 from:

Version: 3.5.4.7-4.8.1 Build Date: Sat Jul 14 03:45:10 2012

To:

Version: 3.5.4.13-4.11.1 Build Date: 22-Nov-2012 10:57

This was with a .xls file my banking website generates for me. It definitely is a binary file and not a renamed .html or other text format file.

I've also tested with this file on Windows with versions 3.6.2, 3.6.3 and 3.6.4.1, which all exhibit the same fault...

I've opened a bug for it with an example file showing the behaviour: Bug 57689

edit flag offensive delete link more

Comments

See my comments in Bugzilla.

Pedro gravatar imagePedro ( 2012-11-29 17:57:11 +0200 )edit

I can confirm this bug has been fixed. I tested this with the daily build of 3.6.4.3. So coming releases should be ok...

WvV gravatar imageWvV ( 2012-11-30 12:41:17 +0200 )edit
0

answered 2012-04-07 16:27:17 +0200

m.a.riosv gravatar image

Or is a broken file or is a text file with xls extension. Some webs produce xls files to download which are html file or text files with xls extension.

edit flag offensive delete link more
0

answered 2013-01-03 17:52:02 +0200

I have the same problem with a file downloaded from a financial instition. When opened in Excel the file is 7621 rows. When opened in Calc, I get a pop up that the file needs to be imported. When the "Wizard" finishes, there are only 6060 rows :(

edit flag offensive delete link more
0

answered 2012-10-31 04:54:37 +0200

Sonolin gravatar image

updated 2012-10-31 17:46:00 +0200

I'm having a similar problem (see my question for more details). When I open a file as an XLS it tries to do a "Text Import" (like its a CSV file) and the data is corrupt.

Any fix for this? I don't know if this is actually just a txt/csv file, with some sort of XLS encryption, but whatever it is Microsoft Office, Google Docs, and I'm sure open office opens the file fine.

EDIT: My version is 3.6.2.2

ADDITIONAL EDIT: This is definitely not a CSV/txt file, I've opened it in a hex editor and the contents are much unlike a normal CSV/TXT file

edit flag offensive delete link more

Comments

see my comment above and give it a try.

ROSt52 gravatar imageROSt52 ( 2012-11-29 16:57:43 +0200 )edit
0

answered 2012-10-30 00:48:09 +0200

BobZef gravatar image

I'm having this too. It started somewhat recently since I updated LibreOffice recently to 3.5.6.2.

The spreadsheets open in OpenOffice, NeoOffice, and Excel. Only LibreOffice treats them as CSV files. Other speadsheets open fine in LibreOffice.

edit flag offensive delete link more
0

answered 2012-10-30 16:30:36 +0200

ROSt52 gravatar image

As I don't remember having had any problem with opening xls-files, I just tested several files. Result: all files open in LibO as xls.

I am using: LibO 3.5.7 on XP/SP3

It seems not to be a LibO bug except in a Linux version.

edit flag offensive delete link more
0

answered 2012-11-06 02:17:48 +0200

Antonio gravatar image

i have the some problem on 3.6.3.2 mac version. And i know the xls files are ok. The problem is the some on .xls and .xlsx files.

edit flag offensive delete link more

Question Tools

2 followers

Stats

Asked: 2012-04-06 08:22:12 +0200

Seen: 2,080 times

Last updated: Jan 03 '13