[Solved] Can't access a s/sheet ... ASCII/text dialog
Posted: Mon Apr 17, 2017 6:11 am
hello ...
hope i'm not in the wrong forum area ... i have a calc problem thus i clicked 'calc'.
this only started about 10 days ago and is to do with ascii and text import etc., the result of which stopped me seeing the text that i'd originally entered appearing either as a blank page or lines and lines of #'s across and down the page.
to elaborate, when i usually want to access a file ... any file ... i click on the file in windows explorer and it appears on screen. this time, i clicked on an .xls file, an hour glass was added to the cursor, a couple of seconds passed, the h/glass vanished and it acted like the actual programme wasn't even installed.
so then i activated openoffice ... which was fine ... and clicked the open file icon on the toolbar and a window appeared with the title 'text import (plus the required file name + a couple of % characters) plus a choice of character sets. first was 'unicode' and then unicode(UTF-7 & separately UTF-8). the UTF-8 rang a bell so i clicked on that and again nothing happened.
then, can't exactly recall what happened but a small window ultimately appeared headed 'Ascii Filter Options' showing, amongst others, Windows Europe (Windows-1252/Win Latin 1) which, when clicked, gave a choice of CR & LF or CR or LF. when i clicked CR & LF, the file opened showing lines of #'s.
What i would like to happen is a return to normality ... when clicking a file via a shortcut or in windows explorer ... i am able to read the file.
would be grateful for any help please ...
hope i'm not in the wrong forum area ... i have a calc problem thus i clicked 'calc'.
this only started about 10 days ago and is to do with ascii and text import etc., the result of which stopped me seeing the text that i'd originally entered appearing either as a blank page or lines and lines of #'s across and down the page.
to elaborate, when i usually want to access a file ... any file ... i click on the file in windows explorer and it appears on screen. this time, i clicked on an .xls file, an hour glass was added to the cursor, a couple of seconds passed, the h/glass vanished and it acted like the actual programme wasn't even installed.
so then i activated openoffice ... which was fine ... and clicked the open file icon on the toolbar and a window appeared with the title 'text import (plus the required file name + a couple of % characters) plus a choice of character sets. first was 'unicode' and then unicode(UTF-7 & separately UTF-8). the UTF-8 rang a bell so i clicked on that and again nothing happened.
then, can't exactly recall what happened but a small window ultimately appeared headed 'Ascii Filter Options' showing, amongst others, Windows Europe (Windows-1252/Win Latin 1) which, when clicked, gave a choice of CR & LF or CR or LF. when i clicked CR & LF, the file opened showing lines of #'s.
What i would like to happen is a return to normality ... when clicking a file via a shortcut or in windows explorer ... i am able to read the file.
would be grateful for any help please ...