- Welcome, Guest. Please Login or Register
MindFusion  
  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.  
  HomeHelpSearchLoginRegister   
     
     
   
 
Page Index Toggle Pages: 1 Send Topic Print  
Excel Export Formatting
Read 85 times

MindFusionUser47   Offline
YaBB Newbies
*
Posts: 9
Gender: male
Illinois
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
tech.support


   
     
 
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