Decimal Point Problems with the Excel Easy Table VI and Excel 2007

[JUMO]

Hello,

we were using the Excel Easy Table VI to transfer some measurement data from LabView to Excel 2002. Now we have updated our Excel to Excel 2007. After that there is something going wrong during the transfer from LabView to Excel. It seems that excel is now ignoring the decimal Point.

[stefanwimmer · Accepted solution]

Hi Martin,

This is a known issue with LV, excel and european regional settings.

As a workaround, do the following:

To transfer correct data to excel you have to unset the "Use localized decimal point" in Tools->Frontpanel.

Then you have to use the " . "instead of " , " when you enter numbers, e.g. "0.99" instead of "0,99".

Stefan

[JUMO]

Hello Stefan,

thank you for your reply, we have tested this and it is working. But now we have to change our hole VI to . as decimal Point. Is there any possibility to search and replace any ( , ) in an array?