''Space'' as currency delimiter

[Marcus Olsson]

Hi,

How do I set the 'space' character as a delimiter when formatting a cell?

I tried the following:

sheet.Range[row, col].Value = "123000000000000000";
sheet.Range[row, col].NumberFormat = "# ##0";

But this results in:

123000000000000 000

and the desired result is

123 000 000 000 000 000

When inspecting the applied format it has actually been set to
"#\ ##0"
where the backslash seems to cause the problem. When removing the backslash the correct format is applied.
Why is the backslash added and how do I solve it?

[Sridhar]

Hi Marcus,

Thank you very much for using Syncfuion products.

We have tried with MSExcel to set space delimiter in Custom format and it belongs to Accounting type format.
In Currency format type we are not able to set 'space' delimiter.
We can set the Number formats and Text format types of the cell with 'space' delimiter.

Here, we are unable to set the 'space'delimiter for the number format using XlsIO, and this can be suspected to be an issue.
We have forwarded to the development team for more analysis.

So we request you to open a new direct-trac incident with a simple issue reproducing sample for further follow up on this issue.

Direct-Trac Link:

https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents


The backslash(\) used to display any character other than "space" in between the numbers in XlsIO.



Please, let us know if you require any further clarifications.

Thanks,
Sridhar.S