Bug in Write To Spreadsheet File VI

[GuillaumeL]

Hello,

There is a bug in the Write To Spreadsheet File VI.

The delimiter field is said in the documentation to default to \t, while in reality it defaults to nothing -- which is useless.

By the way defaulting to comma is in my opinion a better choice, but that is secondary.

Guillaume

[Norbert_B]

Guillaume,

what version of LV are you using?

Nevertheless, i think that you are incorrect about this regardless of the LV version you are using. Please do the following:

1. Create a new VI, drop the "Write to spreadsheet file.vi". The Context Help states that \t is the default value for the delimiter.

2. Create a constant for the delimiter. Indeed it appears to be empty.

3. Right click the constant and select '\'-Codes Display.

Here you go!

Please note that spreadsheet is commonly understood as a file which delimits columns with a tabulator. Using a comma would result in a "comma seperated value" file (csv). As far as i know, csv is mainly used in the US where "normal" spreadsheets are more common to the rest of the world.....

hope this helps,

Norbert 

[elset191]

---

Norbert B wrote:

Guillaume,

what version of LV are you using?

Nevertheless, i think that you are incorrect about this regardless of the LV version you are using. Please do the following:

1. Create a new VI, drop the "Write to spreadsheet file.vi". The Context Help states that \t is the default value for the delimiter.

2. Create a constant for the delimiter. Indeed it appears to be empty.

3. Right click the constant and select '\'-Codes Display.

Here you go!

---

Alternatively, just try writing data.  When you open the file, the values are tab delimited.

[GuillaumeL]

Nay. Using Labview Professional Development 8.6 (.0 I suppose), and following the proposed procedure, the string constant is hopelessly empty. Definitely a bug I think.

Thanks,

Guillaume.

[Ben]

---

GuillaumeL wrote:

Nay. Using Labview Professional Development 8.6 (.0 I suppose), and following the proposed procedure, the string constant is hopelessly empty. Definitely a bug I think.

Thanks,

Guillaume.

---

Could someone with LV 8.6 verify the above?

If this can not be confirmed there is the possiblity that your version got saved with bad default values.

Ben

[elset191]

I use version 8.6.1f1 and have no trouble.  I used to use 8.6 and Write to Spreadsheet a lot, without problem.

I just checked on another computer in my office with 8.6.  \t is the default.

Message Edited by elset191 on 11-04-2009 11:04 AM

[Ben · Accepted solution]

---

elset191 wrote:
I use version 8.6.1f1 and have no trouble.  I used to use 8.6 and Write to Spreadsheet a lot, without problem.

---

Thank you Tim!

Guillaume,

You can either open the FP of the Write to... set it to \t (slash code dispaly) and then right click and choose data ... make current values default,

OR

Do a repair on your LV install.

Ben

[GuillaumeL]

Ok. Weird it's only me, but as long as I know it, its no big deal.

Thanks everyone,

G.

[Ben]

---

GuillaumeL wrote:

Ok. Weird it's only me, but as long as I know it, its no big deal.

Thanks everyone,

G.

---

Actually it is not too weird. Accidental changes to VIs in VI.lib have been around since I have been wiring (virtually, not physically, DOS wasn't even a twinkle in Bill Gates' eye when I started physical wiring )

Ben