Cross Table number Formatting resets


I face this: whenever a data source (flat file) for a data table gets refreshed, the Formatting (Spotfire v. 7.0-> Cross Table->Formatting->Value Axis) resets to its default (which is two decimals) whereas I want it to stay formatted as a integer number. There is no decimals in the underlying data so I don't see no reason for such behavior.

I thought it was caused by the Excel file but now I get the same even when I'm using a CSV file.

Anybody who might have a similar experience? Any help on that?

If not, I might want to try use python script triggered whenever the report gets loaded to set the filtering. Correct?



(1) Answer