Numbers turn into "#" signs

Aspose.Cells Product Family
1

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.

2

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.

3

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

4

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.

5

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.