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

Free Support Forum - aspose.com

Number format is broken in the generated excel file with Aspose.Cells 21.9.0

Hi, After upgrading to Aspose.Cells 21.9.0 from 8.9.0, we are facing issues with the number format in the excel file. See the attached file which has the problem.
We closely looked and seemed
“All number fields have a custom data formatting which contains escape characters, this display the wrong output.”
Maybe number data formatting without escape characters will fix the issue???

image.png (33.9 KB)
image.png (50.1 KB)

@farukinfo,
You may please share your sample Excel file and runnable console application to reproduce this issue here. We will observe the problem and provide our feedback accordingly.

We found some workaround for this issue. We used to implement formatting like in this document: https://cosicimiento.blogspot.com/2008/11/styling-excel-cells-with-mso-number.html

But that this was not working for xlsx

@farukinfo,

As requested earlier, please share your sample Excel file and runnable console application to reproduce this issue here. We will check your issue and assist you to figure it out soon.

@Amjad_Sahi thanks for your reply. As we have found a workaround for this, we will go with that.
Hence, do not need to look further into the issue.

Thanks a lot :slight_smile:

@farukinfo,

Alright. Feel free to write us back if you have further queries or issue, we will be happy to assist you soon.

1 Like