decimal delimiter and excel report generation

[JensM]

Hello,

I've a problem with the "Report Generation Toolkit" while trying to generate reports in MS Excel.
I first select data from an Access database table. Although the database table contains information
in string-format as well as numbers, in the first instance it'll be passed as an array of strings to the
report generation vi's (generate easy table).

While my computer's region settings (WinXP) are always set to german standard I now get different
results if I on the one hand try to generate a report table in Word-format (Word Easy Table)  and
on the other hand a report in Excel-format (Excel Easy Table).

While all numbers are displayed correctly within the Word-table, they aren't within the Excel-table.
Thereby (Excel-table) the numbers are converted falsely as shown below:

0,12345 -> 0,12345 (values < 1 are displayed correctly)
1,2345   -> 12.345 (false)

In my opinion there's a problem with the decimal delimiter. Does anybody have an idea of how to maybe
modify this way of working only within my application without changing my computer's region settings?

Thanks & Greets

Michael

[Andre_Saller]

On the one hand you can configure LabView to either use the localized decimal point or not (Menu Tools-->Options->Frontpanel->Use localized decimal point), on the other hand you can format singlse strings either with or without using the localized decimal point. The VI "format sting.vi" can use the format-sting %.; or %,; to define the decimal point. (Just make a double-left click on the VI to start the format-string editor for help).

[emc2006]

I am having the same problem. I tried what you suggested, but it did not work.
Instead, I'm using "Number to fractional string" ("use system decimal point" set as False) to transfrm a DBL array into a string before exporting it to Excel with "MS office report".