ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: kiwon34 on January 31, 2020, 04:42:26 pm

Title: Independant style when export to excel.
Post by: kiwon34 on January 31, 2020, 04:42:26 pm

Hello param,

I am working on exporting data to Excel 2010.
I am looking for a way to apply different style to the excel that is different from the grid.
For example, my font size is 12px in the actual grid, but I want to change it to 9px in the excel.  I tried giving font size before exporting, and it works fine in the excel, but I found out that my original grid's font size is also changed to 9px when row is refreshed by scrolling.

1. So, I want to ask if there is a way only affecting style for the excel, and not affect the original grid style.

2. Another questions is, when I apply border to cell when exporting to the excel, it seems it is not compatible with Excel 2010 version. Is there a version limit to use border option?

I'm testing with version 7.1.0. Thank you.

Title: Re: Independant style when export to excel.
Post by: paramvir on January 31, 2020, 10:37:33 pm

1. Excel export is a 2 step process with js workbook as intermediate step, so you can change font size of cells in js workbook instead of grid.

2. There is no known version limit.  Are you able to import borders from Excel 2010 into grid?