How Change each individual Axis Value format in a Cross Table

I'm looking for a way to change the format of each axis value within a Cross Table via IronPython.  The reason for doing this via script instead of through the Formatting screen is that our Spotfire guide is used worldwide and it appears that regional settings are trumping the saved format we initially set.

Consider the following example:

Region Sum(Budget) Sum(Actuals) % Variance

North

9600000.00 10530631.00 .0969
South 2272000.00 1247706.00 -.451

 

I would like a script that would apply a particular format in this fashion:

Region Sum(Budget) Sum(Actuals) % Variance

North

9,600,000 10,530,631 9.69%
South 2,272,000 1,247,706 -45.08%

 

Despite my best efforts, I was only able to create script that would apply a single format for all columns.  However, I really need a script that can set the format for individual values and not as a whole.

Any assistance you can offer is greatly appreciated.

 

 

(1) Answer

Login