JsonLayoutOptions() --------> NumberFormat

Aspose.Cells Product Family
1

Hello,

I have an issue that is derived from the following ticket that I raised a while back:
Issue ID(s): CELLSNET-52690

I have been trying to set the number format for converted JSON to Excel number properties using the following two articles, but I’m not able to get the numbers to format:

Number Settings|Documentation (aspose.com)

Standard numeric format strings | Microsoft Learn

JsonLayoutOptions options = new JsonLayoutOptions();
options.NumberFormat = “2”;

As numbers are not formatting, I can only conclude that either I am not setting the NumberFormat correctly or that the property is still broken from the earlier support ticket that I raised.

If I’m not using the correct documentation, could you link it to me, please?

Kind regards,

djs

2

@djsomers,

You need to specify string format for NumberFormat attribute. I guess you want the numeric values formatted with two decimal places (i.e., “0.00”). If this is the case, kindly try the line:

JsonLayoutOptions options = new JsonLayoutOptions();
options.NumberFormat = "0.00";

Let us know with sample project and sample files to reproduce the issue if you still find the issue.