Hi,
Do we have a way to check is the custom format for cell is valid before we set it to the cell, the reason I ask this is I cannot control which format user can input, if user input a wrong format, it will result an openning error for a excel. Please check the screenshot below:
image.png (54.7 KB)
image.png (5.0 KB)
It seems excel does not allow us to input a invalid format, so I want to know if Aspose.cells has this method too.
image.png (38.3 KB)
We are afraid there is no such kind of apis to validate the custom format. In fact the custom format that can be applied is so diverse and variable in ms excel, it is hard for us to check whether it is invalid. Currently we are afraid we cannot get enough knowledge and samples to distinguish those custom formats that may cause error from all possible user inputs, so we cannot support this feature in near future.
Thanks for your support