Spreadsheet file created using "Write Characters to File" doesn't open with Openorg 1.1.4 Spreadsheet

[Carnot]

Hi there,

I'm using "Write charaters to file.vi" in my Labview application.  I'm using Openorg 1.1.4 to open the spreadsheet so created, but each time I do that, the file created opens only with Openoffice Text Document and not with Openoffice Spreadsheet.  Anybody knows why this is?  Is this because of any initial file associations?

Mny thanks for your help.

[Will.D]

When you specify a file path, are you doing it programmatically or manually?  If programmatically, are you including the proper extension?  If manually, are you selecting ".txt" or something of the like?  Why not use the "write characters to spreadsheet file"... 

[Carnot]

I'm specifying the file name manually as it comes up with a dialog box.  But the file save as extension that comes up is "All files *.*"  When I open the file manually it asks me to choose a file to open with and this is where I'm trying my Spreadsheet, but doesn' work.  I can see all the data in the Text Doc of Openoffice though.

[Will.D]

I'm not entirely familiar with Openoffice, but try appending whatever file extension that Openspreadsheet uses.  For instance, if you were using excel, when the dialog comes up to save the file, save it under all files, but something like "Spreadsheetfile.xls".  Except in your case, replace .xls with whatever extension Openspreadsheet uses.  Also, is the file properly delimited (tabs, commas, etc.)?  That may affect whether or not Openspreadsheet would open it. 

[Dennis_Knutson]

What's the format of the text file? Creating a spreadsheet file with Write Characters to File is a bit unusual. Most people use Write to Spreadsheet to get a comma or tab delimited file. If it's correctly formated and it can be opened with Excel, then I'd say that it's a problem with the OpenOffice app. Post the file and someone can have a look at it.

[Carnot]

I've just tried saving the file with a .xls extension and when I opened it double clicking in the the Windows folder it open with the Document file.  I'll c what Openoffice extension for a Spreadsheet is.  But it is supposed to open Windows .doc with the Document pgm and the .xls with the Spreadsheet pgm.

[altenbach]

Since openoffice is multiplatform, you should probably tell us if you're e.g. on windows or linux.

Your question is not quite clear to me.

• Do you have problems assigning the right application to trigger when you double-click the file or...
• Do you manually open it as text document and it looks fine, but you get garbage formatting if you open in in OO Spreadsheet?

Write characters to file does not imply any kind of formatting! Is the string formatted as table (e.g. values speerated by tab or comma, lines seperated by linefeed characters, etc.)?

[Carnot]

I'm currently experimenting with Append Header to Spreadsheet File.vi, an eg vi from the Dev Zone to see how it works as it claims that it can write data to an Excel type spreadsheet and also puts in the headings for each col.  The file is located here:http://sine.ni.com/apps/we/niepd_web_display.display_epd4?p_guid=B123AE0CBB60111EE034080020E74861&p_node=DZ52027&p_source=external

Many thanks.

[Carnot]

I'm runnign OO on Windows and I'm not using MS-Office at all.

[Carnot]

I've changed my program using arrays and clusters within the same vi and this time my output file only shows the last iteration, there's no header information or anything.  I can now post my vi is there anybody wanting to look at it?

Cheers.