Expected Behaviour of Aspose Number Format String

[danilolekovic]

Hello,

When getting the number of a string, Aspose often times adds unnecessary backslashes. For example, when a cell’s number format is set to: _($* 0.00_);_($* (0.00);_($* "-"??_);_(@_),

Aspose returns that number format as: “("$" 0.00*);("$" (0.00);(”$" “-”??);(@_)".

As you can see from the above example, there are a lot of backslashes added. Is this normal/intended behaviour?

Thank you.

[Amjad_Sahi]

@danilolekovic,

This is expected behavior. Aspose.Cells gets the escaped custom numbers formatting/style of the cells. That’s why you will find some backslashes and other chars but output custom formatting would be same and works the same way. For confirmation, you may specify the retrieved custom formatting back to the cell and it will work as prior. MS Excel will eliminate the extra escape chars, etc.