Bug#403677: openoffice.org: Opening .xls file puts me in OOo writer instead of in calc
On 06-Dec-19 20:36, Jim Watson wrote:
> >>It doesn't happen to all the .xls files, only the ones I have
> >>received.
> >>So probably there is something special in the files, that makes
> >>OOo open them in writer.
>
> It sometimes happens that files with .xls extension are actually html
> or csv files. Such files may be created by some internet download
> process. These files are plain text so try and open the problem files
> with a simple text editor such as gedit, vi or whatever, and see what
> happens - if it is text then report here the first few lines is
> enough. Also try rename the file to end with ".csv" and then try to
> open in calc.
Hi,
I think you were right. I don't know how real .xls files look like, but
my files look like this:
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40"
lang="hu">
<head>
<title>OTPdirekt Internet</title>
<META content='application/vnd.ms-excel; charset=ISO-8859-2' http-equiv='Content-type'>
<meta name='ProgId' content='Excel.Sheet'>
So it seems to be html.
I have tried to change the extension to .csv and .html. .csv is
completely bad, .html also opens in writer, just as .xls
Can I somehow tell the program to open the file in Calc anyway?
Now that I have checked it seems that even all the old files I have
received were the same html stuff, but it seems that until around August
2006 my OpenOffice.org has opened them in Calc. (At least until that
point I have .sxc or .ods versions of the same files, because it was
easy to open and save as .ods). Since August I have the .xls files only.
Regards,
Gabor
Reply to: