Author Topic: Independant style when export to excel.  (Read 1659 times)

kiwon34

  • Pro Ultimate
  • Jr. Member
  • *
  • Posts: 52
    • View Profile
Independant style when export to excel.
« 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.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6309
    • View Profile
Re: Independant style when export to excel.
« Reply #1 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?
« Last Edit: February 02, 2020, 11:10:25 am by paramvir »