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

Free Support Forum - aspose.com

Documentation for "Built-in Number Formats" out of date?

Using latest version of Aspose Cells for Java.

The documentation at https://docs.aspose.com/display/cellsjava/Setting+Display+Formats+of+Numbers+and+Dates seems to suggest that using built-in number format 39 will display negative numbers using a minus sign, and without parentheses.

However, when I open the resulting Excel file, the value is shown as “(1,234,567.89)”.
The result is what I actually want :slight_smile:
But just to double-check, could it be that the sample value for built-in number format 39 is incorrect in the linked article?

Sample code:

Workbook workbook = new Workbook();
Worksheet worksheet = workbook.getWorksheets().get(0);
Cells cells = worksheet.getCells();
Cell cell = cells.get(0, 0);

cell.setValue(-1234567.89);
Style style = cell.getStyle();
style.setNumber(39);
cell.setStyle(style);

worksheet.autoFitColumns();
workbook.save("format.xlsx");

format.zip (6.3 KB)

@TarasTielkes,

Thanks for the template file and details.

Yes, you got it right. It looks like the table values in the document became wrong when we upgraded to new Wiki Conf. Docs. We will fix it soon.

Please try using the API Reference page’ table for the API here which is correct:
https://apireference.aspose.com/java/cells/com.aspose.cells/style#Number

Hope, this helps a bit.

Thanks for checking and confirming.
Things make more sense now I know that the documentation I was looking at was incorrect.

@TarasTielkes,

Good to know that you have sorted it out now. Feel free to write us back if you have further questions or issue, we will be happy to assist you soon.