ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: dcalvo on September 15, 2016, 10:13:40 am

Title: Amount format problems when export to XLS
Post by: dcalvo on September 15, 2016, 10:13:40 am

Hi everyone.

Right now, I´m using ParamQuery 3.1.0 for a website developed with ASP 3.0 over IIS 7.0. This site allows users to create diferent kinds of budget, and export it then to CSV and XLS format.

I`m using ParamQuery grid for preview and export propouses (method exportExcel), but I have a problem with amount format. I need use Spanish currency format: "," decimal separator and "." thousand separator, but exportExcel() method only apply  USA format.

Could you help me?

Title: Re: Amount format problems when export to XLS
Post by: paramvir on September 15, 2016, 09:19:59 pm

column format support in exported data is available since v3.3 only.

format: "##.###,00"