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

Free Support Forum - aspose.com

Validating custom formats

Is there a way to validate a Custom style (NumberFormat) to see if MS. Excel will display it correctly? We have user generated format strings and need to know if they are not valid. In our current framework we use the Excel COM object model to do this but we are trying to get away from requiring Excel and it would be great if it can be done with Cells.

Hi,

Thanks for your posting and considering Aspose.Cells.

We are afraid, there is no such API in Aspose.Cells which could validate your custom format string. However, you can set your custom format using Aspose.Cells APIs.

Please use the Style.Custom property for setting the custom format of the cell. Please see the following documentation article for your more help.

http://www.aspose.com/docs/display/cellsnet/Setting+Display+Formats+of+Numbers+and+Dates