My scenario is that I am exporting a report to Excel, and I need to format one of my columns that display numerical data with a specific culture.
I can achieve this with the FormatWithCulture text function but then Excel does not treat the values in that column as numbers which is why I have to use the Format property of the item, and return a number in the Value of the textbox.
Unfortunately, the Format property does not allow specifying a culture that will be used for the formatting so the culture on the server is always used. I need to change that dynamically with a report parameter.