Aspose Cells with Accounting Format for different symbols are read as string and inconsistent whitespace

Aspose.Cells Product Family
1

Hi Team,

We have observed that the cells with formatting category as Accounting with different Symbol are read in different way i.e., a whitespace is added for few symbols and for few not added.
For example for symbol “$” the cell is read as $10,000.00 where there’s no space between symbol and number but for symbol € the cell is read as 10,000.00 € where there’s a space between symbol and number.

We have tried with multiple symbols we could observe the similar issue. Attached a sample file and screenshot of read data from cell.
Aspose.Accounting.Issue.zip (17.6 KB)

2

@shivanandchikkalli,

Thanks for the Excel file.

I opened your Excel file in MS Excel 2019 manually and found the same display as Aspose.Cells reads it, so it is expected behavior. See the attached screenshot.
sc_shot1.png (86.0 KB)