French numbers in Excel

Aspose.Cells Product Family
1

Hello,


I am having a small problem using French formatted numbers with Aspose.Cells. I have attached an example project for you to test.

I have also tested that Excel can indeed support French formatted numbers and it seems to have no issues with it.

Example:

English format : 9999.99
French format: 9999,99

Instead of a decimal you use a comma in French. This is causing a NumberFormatException when I try to create an Aspose worksheet as you will see in the example project.

How can I create an Aspose workbook that works with French formatted numbers?

Thank you for your help!

Daniel
2

Hi,


Please add a line to your code, i.e.,

asposeWorkbook.getSettings().setRegion(CountryCode.FRANCE); //or setLocale(Locale.FRANCE)

it should work fine.

Thank you.