Hi Ain Thanks, I totally agree with you and you just made the comment I was about to write. I like OOo very much and use it as often as I can, but this problem is one of its limits, especially when you look forward for other people to use OOo instead of MSOffice.
Rod : yes, I first made a .csv file from my PHP script. But the users where to lazzy to change the separator list character in their "Regional settings". The first goal of my report is to be easily open in Excel for my users, that's why a generate a .xls instead of a .csv. Cheers, On 11/16/05, Ain Vagula <[EMAIL PROTECTED]> wrote: > > 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] > >
