We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Format Grid Column

Thread ID:

Created:

Updated:

Platform:

Replies:

96762 Oct 4,2010 03:41 PM UTC Oct 3,2014 10:54 AM UTC ASP.NET Web Forms (Classic) 5
loading
Tags: GridGroupingControl
harshini
Asked On October 4, 2010 03:41 PM UTC

I have a column in the grid Asset Size

currently it is displaying the values int he column as follows
38469002.00000

i want to display it as $38,469,002

can you please help me with this issue


Bharath M [Syncfusion]
Replied On October 5, 2010 07:35 AM UTC

Hi Harshini,

Thank you for your interest in Syncfusion products.

We suggest you to change the “CellType” of concern column as “Currency” to achieve your requirement. Please refer the below code snippet to describe this

[CS]
GridGroupingControl1.TableDescriptor.Columns[index].Appearance.AnyRecordFieldCell.CellType = “Currency”;


Let me know if you have any concerns.

Regards,
Bharath M




harshini
Replied On October 8, 2010 09:15 PM UTC

thanks!


Eswari S [Syncfusion]
Replied On August 30, 2012 10:47 AM UTC

Hi Harshini,

 

Thanks for your update.

 

Let us know if you have any queries. We are happy to assist you.

 

Regards,

Eswari.S


Prasanna Kumar
Replied On October 2, 2014 10:52 AM UTC


Hi,

 Instead of USD symbol I would like to display in INR symbol.

 How can it be done, If INR symbol is not available; How can I suppress showing $

Thanks,
Prasanna

Shalini Thangavel [Syncfusion]
Replied On October 3, 2014 10:54 AM UTC

Hi Prasanna,

 

Thanks for your interest in Syncfusion products.

 

Query : Instead of USD symbol I would like to display in INR symbol, How can it be done. If INR symbol is not available; How can I suppress showing $?

 

We have analyzed the query and your requirement could be achieved by setting Globalized culture as “en-IN” in web config file and we suggest you to change the “CellType” of concern column as “Currency” in aspx file. Please refer the code snippets below.

 

[web config]

<system.web>

    <globalization uiCulture="en" culture="en-IN" />

system.web >

 

 

[aspx]

<TableDescriptor>

    <Columns>

      <syncfusion:GridColumnDescriptor MappingName="SaleAmount" Appearance-AnyRecordFieldCell-CellType="Currency">syncfusion:GridColumnDescriptor>

      <syncfusion:GridColumnDescriptor MappingName="OrderID">syncfusion:GridColumnDescriptor>

      <syncfusion:GridColumnDescriptor MappingName="CompanyName">syncfusion:GridColumnDescriptor>

    Columns>

 TableDescriptor>

 

 

For your convenience we have created a sample and the same could be downloaded from the following link.

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ColumnFormatting_96762-43387681.zip

 

Let us know if you need any further assistance.

Regards,

Shalini AT.


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;