- Welcome, Guest. Please Login or Register
  We have released initial version of MindFusion.JavaScript pack. It includes chart, diagram, calendar, map, virtual keyboard, gauge and UI components. Here are more details and live demo for anyone interested.  
Page Index Toggle Pages: 1 Send Topic Print  
Excel Export Formatting
Read 85 times

MindFusionUser47   Offline
YaBB Newbies
Posts: 9
Gender: male
I Love MindFusion!

Excel Export Formatting
Nov 3rd, 2019 at 9:27pm
Is there a way to change the border width and font of the spreadsheet before export?
Setting all the cells borders to increase by a certain amount. Right now the cells are set individually as they are created at width 1 for left, right, upper, and lower for normal data cells. Header cells are set thicker.
The thickness looks different in excel than in workbookview. Is there a elegant way to correct this so that the expectation of how it looks in mindfusion is matched in the excel equivalent export? 
Also is there a way to change the font before export elegantly?
IP Logged    

Slavcho   Offline
God Member
Posts: 1912
Gender: male

Re: Excel Export Formatting
Reply #1 - Nov 4th, 2019 at 6:24am
You can change the borders and font of whole cell blocks / whole spreadsheet via CellRange.Style. I can't see much difference in border thickness, what values are you using for your header cells?
IP Logged    
Page Index Toggle Pages: 1 Send Topic Print