0

Using GemBox to take an existing .xlsx excel file to populate with data and save it to an .xlsx file.

The issue I am having is this when trying to set the font name and font size using documentation on Gembox website I am getting the following results.

Error when Excel file is open

Data inside the Excel file

Here is how I am setting font name 

.Style.Font.Name = "Calibri";
.Style.Font.Size = 8;

Can change any other style except when changing Font Name or Font Size I get the error.

1 Answers1

1

Note that a Size property is in twip units (1/20th of a point), see the Size property's help page. Can you try setting its value to 8 * 20, does this solve your issue?

In case it does not then can you send us your file by submitting a support ticket.

GemBox Dev Team
  • 669
  • 5
  • 18
  • "Size property is in twip units (1/20th of a point)" thank you for point it out. Yes, it works as expected now. –  Oct 29 '15 at 15:26