Text Import issues with Excel doc

Issues with installing under all versions of MS Windows

Text Import issues with Excel doc

Postby markgradley » Mon Sep 12, 2016 2:09 pm

Hi all

Absolute beginner here, trying to solve an issue which I know seems a common occurrence

Trying to open an excel document saved as Excel 97-2003 extension in Openoffice. I am unable to access the file as it comes up with a large window saying Text Import or on other occasions it says ASCII. Tried looking in other topics, but can't seem to find the relevant simple answer.

Any help would be gratefully received

Many thanks

Mark
Openoffice 4.1.2 on Windows 10
markgradley
 
Posts: 3
Joined: Mon Sep 12, 2016 1:39 pm

Re: Text Import issues with Excel doc

Postby Zizi64 » Mon Sep 12, 2016 2:25 pm

Trying to open an excel document saved as Excel 97-2003 extension in Openoffice. I am unable to access the file as it comes up with a large window saying Text Import or on other occasions it says ASCII.


In this case maybe
- the file is damaged
- the file is not really a MS .xls type file, but it is .CSV, .TSV, .RTF or .TXT type file with false file extension.

Can you upload the file here?
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.4; AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7972
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Text Import issues with Excel doc

Postby markgradley » Mon Sep 12, 2016 2:29 pm

Thanks for the reply

Its a .xls file extension, not sure how to upload on here and am a little concerned about confidentiality
Openoffice 4.1.2 on Windows 10
markgradley
 
Posts: 3
Joined: Mon Sep 12, 2016 1:39 pm

Re: Text Import issues with Excel doc

Postby Zizi64 » Mon Sep 12, 2016 2:34 pm

am a little concerned about confidentiality


Then you can try to rename a copy of your file to the described extensions, and then you can try it with a file viewer software (like the Notepad). If it will display az a structured, pure txt file (you can see the data values), then the file is CSV, TSV or TXT type one. If you see some header related to the RTF type, then the file is rtf type one.
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.4; AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7972
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Text Import issues with Excel doc

Postby RoryOF » Mon Sep 12, 2016 2:37 pm

Try opening it with a plain text editor. If you can see normal text, then it is internally one of the file types Zizi64 suggested. If OO is announcing that it needs an ASCII filter and it is not plain text internally, then the file is damaged and you should obtain another copy.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28939
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Text Import issues with Excel doc

Postby markgradley » Mon Sep 12, 2016 3:03 pm

Hi gents

Appreciate your continued help. I tried to open in Notepad and there was no data at all to see. It does announce that it needs an ASCII filter sometimes. How can I obtain another copy?

I really am not the technical type, so finding this a little challenging. Am I am to send the file to someone.... I guess the data I have there is emails and names etc, nothing of great concern, but obviously concerned

Continued thanks
Openoffice 4.1.2 on Windows 10
markgradley
 
Posts: 3
Joined: Mon Sep 12, 2016 1:39 pm


Return to MS Windows

Who is online

Users browsing this forum: No registered users and 7 guests