CellValueFormat - Number Formats

[Mark]

I currently need to format some columns to use the "Accounting format". In your documentation, you talk about the document model exposing number formats. However none of your examples show how to access the document model (def, they show how to create custom number formats. Can you please tell me how I can access the Accounting format?

worksheet.Cells[2, 5].SetFormat(new CellValueFormat(  SomeEnum/Class.AccountingFormat   ));

[Mark]

Found the answer after poking around a bit more. Hopefully this helps someone else out.There is a class AccountingFormatStringBuilder.

worksheet.Columns[2, 5].SetFormat(new CellValueFormat(AccountingFormatStringBuilder.BuildFormatString(CurrencyInfo.Symbol, 2)))

[Tanya]

Hi Mark,

Thank you for bringing this to our attention.

Indeed, the AccountingFormatStringBuilder class is not included in the documentation. I logged a task to add information about it and updated your Telerik points as a token of appreciation for your cooperation.

Regards,
Tanya
Telerik by Progress

[Stephen]

Thank you, Mark!

How did stumble upon that wizardry?  Just by scouring the API docs?

The number formatting docs have not been updated yet to describe how to use the pre-defined types.  They don't even really describe the custom formats fully, but I'm assuming we can use the same specifiers as .NET.

[Tanya]

Hello Stephen,

Indeed, we haven't still managed to update the documentation about format strings. The AccountingFormatStringBuilder class and its members are listed in the API Reference and we would much appreciate it if you share what would you expect to find in our documentation so we can ensure it will be described when we update the information.  

Regards,
Tanya
Progress Telerik