We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Numbers turn into "#" signs

Hi,

I'm trying to convert the attached Excel file, but I'm getting the "###" signs instead of numbers in the title row.

Can you please advice?

Thanks in advance,
Rotem.

Hi Rotem,

I think you may try to add the following lines of code before saving the .xml file

e.g..,

//Autofit the first worksheet columns.

wb.Worksheets[0].AutoFitColumns();

Thank you.

I saw the above solution in one of the posts inthe forum.

But the problem is that I can not change the original file... I have a bulk of files I do not know and do not want to change...

Is there another solution for that?

Thanks,
Rotem

Hi Rotem,

OK, we will soon check and try to figure out the issue so that you don't really use Worksheet.AutoFitColumns API to automatically expand the columns width.

Thank you.

Hi Rotem,

Please try this fix.

We have fixed the bug of the first page.

But we could not fix the bug in the column "R" of the worksheet "Best of 7" soon. We are still looking into how to display a numberic value if the column could not display all digits of the numberic value in MS Excel.

Could you set the number formart "0.0" for the column "R" of the worksheet "Best of 7"? You can use Cells.ApplyColumnStyle() to apply the style to the column.