Page Index Toggle Pages: 1 Send TopicPrint
Normal Topic Excel Export Formatting (Read 478 times)
YaBB Newbies

I Love MindFusion!

Posts: 9
Location: Illinois
Joined: Jan 23rd, 2018
Excel Export Formatting
Nov 3rd, 2019 at 9:27pm
Print Post  
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?
Back to top
IP Logged
God Member

Posts: 2162
Joined: Oct 19th, 2005
Re: Excel Export Formatting
Reply #1 - Nov 4th, 2019 at 6:24am
Print Post  
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?
Back to top
IP Logged
Page Index Toggle Pages: 1
Send TopicPrint