Eric Wood wrote: > Ain Vagula wrote: > >>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. >> >> > > Ain, > > Simple rule, "if the file is some kind of delimited text (tab, comma, > pipe, colon, whatever), calc should try and open it". > In the real world , there is *so* many tab delimited files coming from > unlimited number of systems, that the simplest way to produce a quick > spreadsheet is to use delimited text and name the file extension to the > associated spreadsheet program. >
Yes. I know this. When right-click test.xls in file manager and choose 'Open with OpenOffice.org calc', file opens in Writer. When I rename file to test.csv and do the same operation, it opens in Calc, bringing up dialog asking for delimiter and other necessary import data. Hm, btw, using the filter in open-save dialog, delimiter is automatically detected and marked (tab), in described case not... ain --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
