Display text value in excel

Aspose.Cells Product Family
1

Hi,

I am putting value in excel cell as 023 but when we see the output it shows 23 only.how to show the whole value .I am using C# and Aspose.

2

Hi,


Well, this is MS Excel behavior as it will eliminate the leading zeros with a number/numeric value. If you still persisting to retain leading zero, you have to put the value as text e.g

//Number
cell.PutValue(023);

//Text
cell.PutValue(“023”);

Thank you.
3

Hi,

Thanks for the quick reply.i have another doubt when i save the excel as HTML and open .net Web browser control and while scrolling some lines are showing darker(i have applied border for the range).

4

Hi,


Please try with v7.4.0.3 (latest fix): Aspose.Cells for .NET v7.4.0.3

If you still find the issue, kindly give us your template Excel file and output HTML file (you may zip the archive). We will check your issue soon.

Thank you.