Christophe Nauwelaers wrote: > Hi, > > First thread on this mailing list. > > I make query/reports from php/mysql to .xls files (because people who I > work for use MSOffice). > I use the PHP "header : " function and the \t as the column separator. > The generated .xls file opens great in Excel, but in OOo : I'm asked to > set the language, font type, list separator and the file opens in ... > OOwriter ! > I'm quiet disappointed because I'd really like users of my company to > use OOo. > Strangely, Gnumeric opens the file as MSExcel do : no problem. > Is this an issue with OOo ? Or is there something to set differently ? > > thx for letting me know. > > Cheers, > > [EMAIL PROTECTED]
Because this format has nothing to do with Excel format and OO.o understands this as file has no xls structure. You can open this file in calc using right filter - File - Open, select file, then select filter: CSV text file (.csv, .txt) and click Open. Pure spreadsheet programs understand too, that is is simple text file but they try to convert this to spreadsheet, because they have no word processor. OO.o has one. When you rename random file, eg. mp3 to xls, this does not convert it xls-file anyway. ain --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
