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

[Will.D]

I'm sure if you posted it a number of people would be happy to have a look.

[Carnot]

I've changed it further using the Write to Spreadsheet.vi vi, still no joy.

[Carnot]

Here's the file.  Thank you.

[altenbach]

Don't you want to autoindex and the loop boundary and write a 2D array?

[Dennis_Knutson]

When you wire something out of a while loop, the only thing passed is the value in the last iteration. This is true whether it's a scalar or array. To automatically save the results of each iteration, you can turn on auto-indexing. right click on the exit tunnel and select Enable Indexing. Now, you are creating a 2D array so you have to wire the results to the 2D array input of Write to Spreadsheet. You could also move the Write to Spreadsheet inside the while loop so that with every iteration, you save the results. This will slow down the acquisition though.

[Carnot]

Man! That's awesome!  I'm teaching this baby myself so... Thanks very much for that tip.  But the OO prob still persists?  Any thoughts on that?

[johnsold]

If you post one of the files which does not work with OpenOffice, I will take a look at it. I have OO1.1.2 on my Mac.

Lynn

[Carnot]

Hi Lynn,

It's already there.  Check Reply 13.

I'm off just now I'll c you guys l8r.

Cheers.

[Dennis_Knutson]

You need to post one of the data files and the not the VI that creates it.

[johnsold]

OpenOrg is somewhat particular about filename extensions. When I created a test file with no extension (routine on Macs), OO would only recognize the file if the File Type in the Open File dialog was set to *.*. And then it opened the file in Writer. However, if the extension was .csv, it opened in the spreadsheet mode. For the .txt extension to open as a spreadsheet, select File type... Text CSV (*.csv; *.txt). Then the file will open as a spreadsheet. There is another dialog that allows selection of the field separator (tab, comma, etc.).

The OO help got me to this point, but it is not entirely clear. I had to try several things.

Lynn