CODEWITHSUNDEEP
c#excel
Tom Miller
Tom Miller

Reputation: 451

Bytescout.Spreadsheet Number Formatting Multiplying By 100

I'm currently using the bytescout library to generate a PDF document. Here is some pseudo code of me setting the cell in question:

cell.Value = 20;
cell.NumberFormatString = "0.00%";

When the Excel document is generated the Cell displays as 2000.00%

Does anyone have experience with this library?

Upvotes: 1

Views: 54

Answers (1)

Tom Miller
Tom Miller

Reputation: 451

Simple answer is to divide by 100. Seems Excel expects the % decimal value. The lightbulb eventually came on.

Upvotes: 2

Related Questions