Localization issue in OWC pivot table

[praveen]

HI,

We have created a pivot table using owc component.It was working fine.
Each cell in pivot table is prefixed by "$" sign.

PivotView.DataAxis.Totals("Budget Amount").NumberFormat = "$#,##0"

This was working correctly if the culture of the system is "US" .For
other user having specific local culture the "$" sign is chaged wrt to
their setting.
For ex, if the person using a sys with culture setting as Uk or japan,
for those ppl the $ sign
appears as "pound sign/Yen sign".
we want the $ sigh to be shown irrespective of the setting of the
culture.

we tried with SETLOCALE() function. its not working.
Can anyone help us in this?

Thanks in advance
~Praveen.M.S

 

[Alvin Bruney [MVP]]

Well, that's really an impossible task if you understand localization
correctly since '$' is most likely not the currency symbol in middle-estearn
languages for instance. I'm really not sure how you would attempt such a
feat. Maybe somebody else can be of help here.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin