Just to be sure I understand this correctly;
You have a value of 1000 that is displayed formatted as thousand(s) in the EU 'Continental' style with no decimal places.
If it had decimals places it would appear as 1.000,00 for example.
Am I correct so far?
What you are actually seeing is 1000 displayed as
What you want is 1.000 after export to Excel.
I am assuming that you have the Input Options set to interpret the incoming report for the correct decimal point character and the exportable fields all set to have no decimal places.
Is that also correct?
Export to Excel has various options including the option to export as V8 Monarch in place of V9. How are your export Options set for the Excel export?
One final assumption is that your system has its Windows settings set to comma = decimal point and dot = thousands separator.
Have you already experimented with changing any settings to see what happens? If yes, which ones?
all your assumptions are right.
I still have this nerving problem with the export. I played with all possible options and came to the follwoing result.
The new export functionality in the Pro9 Version changes the field characteristics.
E.g. if I use in the Export file types menu, XLS-Files "Excel97+ (MonarchV8)" with the mark "Apply formatting to Excel files" the field characteristic of numeric fields changes in to character field via the Export to Excel 2003. The result is, that the figures doesn't have a thousand sepaerator (dot), but in Monarch I chose the thousands format with 2 decimals. So would expected to have the same number format in my excel output file.
E.g. a second much more strangerous result is in that way: All the settings are like described above, but only change in the options the export file type: "Excel97+ (MonarchV9)".
The result is like same above, but additional I now have 3 decimals, without thousands seperator but it didn't change the field characteristic. The field is still a numeric field. The nill value is shown ",000"
The model was created with V8 pro.
Within Windows i doublechecked the number settings. But this should be ok. I have a "." as a thousand separator and a "," for decimal seperation.
What can I do, to get the result like with V8 Pro. With this Version I hadn't this problem.
It certainly seems strange.
It is not something I can quickly replicate safely on my main system (changing the Windows display parameters) without confusing some other application and I will be away from this afternoon until later in the week.
I hope someone will be able to pick up the problem and help out in that time. I will check when I get back.
Sorry I have not had an opportunity to play with the settings on my systems to try to replicate your problem.
I would guess that no one else has been able to check it either.
It may be best to take the problem directly to Datawatch support at this point because it seems likely that no active member of the forum has an answer or is in a position to run representative tests.