Author Topic: Amount format problems when export to XLS  (Read 1924 times)

dcalvo

  • Pro Deluxe
  • Newbie
  • *
  • Posts: 7
    • View Profile
Amount format problems when export to XLS
« 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?

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Amount format problems when export to XLS
« Reply #1 on: September 15, 2016, 09:19:59 pm »
column format support in exported data is available since v3.3 only.

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