OWC11: How to set/change Date Format?

[Jörg Wolf]

Hi all,

I'm desparately trying to add/display date values from an array (or even a
tab separated string) as categories in a chart.
I'm using an english SBS2003, but the date values are in german standard
format (dd:mm:yy). As a result, the respecting values are not displayed in
the chart and the axis labels are improperly.

Is there any way to set the International property (which is read-only) to
fix the problem?

Is there any other solution?

Thanks in advance!

cheers
Jörg

 

[Alvin Bruney - MVP ASP.NET]

You can either set the locale on the machine to correct culture which should
force the date to display appropriately on the local machine. Or you can
force each item in the axis to display appropriately by looping thru the
items in the axis label property and using a numberformat. Ex .numberformat
= "MM/dd/yyyy"

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET

 

[Jörg Wolf]

Alvin,

thanks for your quick reply!

Unfortunately, it doesn't help: the local _is_ set to German and I can't
loop through the axis labels because CategoryLabels.GetEnumerator() throws
an System.NotImplementedException...

cheers

Jörg

You can either set the locale on the machine to correct culture which
should force the date to display appropriately on the local machine. Or
you can force each item in the axis to display appropriately by looping
thru the items in the axis label property and using a numberformat. Ex
.numberformat = "MM/dd/yyyy"

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

Hi all,

I'm desparately trying to add/display date values from an array (or even
a tab separated string) as categories in a chart.
I'm using an english SBS2003, but the date values are in german standard
format (dd:mm:yy). As a result, the respecting values are not displayed
in the chart and the axis labels are improperly.

Is there any way to set the International property (which is read-only)
to fix the problem?

Is there any other solution?

Thanks in advance!

cheers
Jörg