Intersoft Community - WebGrid Enterprise - Formatting Cell Number Value Separate From LayoutSettings Culture

Formatting Cell Number Value Separate From LayoutSettings Culture

PRISMAY — Tue, 07 Jun 2011 09:50:18 GMT

Great news. Thank you.

Formatting Cell Number Value Separate From LayoutSettings Culture

MarTin — Tue, 07 Jun 2011 09:48:57 GMT

Hello,

The developer team has given me the update of this issue.

This Feature Request has been noted by the team and will be added in the next release, which means that this culture setting will be applied in the 2011 R2.

Thank you.

Regards,
-Martin-

Formatting Cell Number Value Separate From LayoutSettings Culture

PRISMAY — Thu, 02 Jun 2011 09:11:00 GMT

Martin,

Sorry I never got around to providing the sample regarding the template column, but at this point, we still need the feature to format at the row and cell level as mentioned above using different cultures. Has this been added to 2011 R1? The export won't be an issue once this feature is added since the values will be native values and not templated objects. Thanks.

Formatting Cell Number Value Separate From LayoutSettings Culture

MarTin — Tue, 14 Dec 2010 22:22:33 GMT

Hello A Yousif,

I have forwarded your scenario to the development team to be investigated further.

You can provide me a sample based on your scenario after the new year. It would be easier for us to investigate the issue.

Meanwhile, I will let the development team to work on your issue.

Thank you.

Formatting Cell Number Value Separate From LayoutSettings Culture

PRISMAY — Tue, 14 Dec 2010 08:15:39 GMT

Thanks Martin. Sorry I didn't have time to provide a sample. The end of the year is crunch time and I'm buried right now. If you couldn't duplicate this based on my description, let me know after the new year starts and I should have time to put a sample for you.

Formatting Cell Number Value Separate From LayoutSettings Culture

MarTin — Mon, 13 Dec 2010 22:45:24 GMT

Hello A Yousif,

I have forwarded your issue to the development team.

However, about the exporting templated column issue, exporting only accepts native column type because it generally renders only textual content, while template column can contain graphics or more complex controls.

Thank you.

Formatting Cell Number Value Separate From LayoutSettings Culture

PRISMAY — Fri, 10 Dec 2010 08:49:15 GMT

I really don't have the time to create the sample, but you can create it as it's very simple per the info I've provided. Just create a grid and set it's culture to say ru-RU (Russian). Create one of your columns as a template that holds a label and then format that column's value, during the data binding, using the another culture like en-US. Once displayed, use the export and you'll see your template column formatted in the ru-RU culture. For our case we use currency, so don't forget to set your data type to "System.Decimal" if you're going to also use currency.

Formatting Cell Number Value Separate From LayoutSettings Culture

MarTin — Fri, 10 Dec 2010 04:27:53 GMT

Hello A Yousif,

I will forward and inform the development team on your issues. However, could you provide me a simple working sample that replicates the issue that you mentioned?

If you can zip and attach the sample, it would be easier for me to directly forward the sample to the development team to be investigated further.

Thank you.

Formatting Cell Number Value Separate From LayoutSettings Culture

PRISMAY — Thu, 09 Dec 2010 13:14:53 GMT

Thanks Martin. I found a partial workaround for now by using a template column which uses a label that's assigned the text we need formatted how we need it.

This still presents several issues that you might forward to your development team:

The column totals still use the grid culture so even though the total is there, it's incorrectly formatted
The export does not export the template column correctly. When exported, the column is formatted in the grid culture

Right now, we're having to drop the Export feature altogether as it's not usable with how we're implementing the grid. We really need to have the export work alongside the grid once the culture setting is added at the row/column/cell level please.

This is creating a lot more work for us as we now have to write our own export routines. Thanks.

Formatting Cell Number Value Separate From LayoutSettings Culture

MarTin — Thu, 09 Dec 2010 05:00:32 GMT

Hello,

I apologize for the misunderstanding of your issue.

I have discussed with the developer team regarding this issue. Currently, it is probably a limitation from WebGrid to perform different culture in the same instance. As you said, WebGrid can only apply 1 culture and you are not able to override the culture even using InitializeCell Server-side event.

I will create a Feature Request and submit it to the developer team, so that they can enhance WebGrid further.

Formatting Cell Number Value Separate From LayoutSettings Culture

PRISMAY — Fri, 03 Dec 2010 11:35:31 GMT

We have a few grids that require the user see the currency figures for a specific currency format which may not be the same as the grid's culture. For example, the user may have the grid culture set to en-US but wants to see the currency formatted in Euros via en-IE for Ireland or maybe formatted for pt-BR. The reason we can't set the entire grid culture is we don't want to affect any other columns like dates or other numbers that need to stay formatted for the en-US culture.

I can't find a way to do this right now so I need some help in doing this please. I've tried overriding the InitializeCell but this is not working. The grid overrides my format when it renders.

Here's my OnInitializeCell override.

public override bool OnInitializeCell(WebGridCell cell)
{
    bool bRet = base.OnInitializeCell(cell);

    if (cell.Column.ColumnType != ColumnType.Text)
    {
        return bRet;
    }

    DataRow[] drFilteredRows = m_dtColumns.Select(
	"columnName = \'" + cell.Column.Name + "\'");

    if (drFilteredRows != null && drFilteredRows.Length > 0)
    {
        DataRow dr = drFilteredRows[0];

        if (!string.IsNullOrEmpty(cell.Column.DataFormatString) &&
	   cell.Column.DataFormatString.StartsWith("C"))
        {
            if (!string.IsNullOrEmpty(cell.Text))
            {
                cell.Text = ((decimal)cell.Value).ToString(
		cell.Column.DataFormatString,new CultureInfo("pt-BR"));
            }
        }
    }

    return bRet;
}

The above is hard-coded to format using the Brazillian Real as an override but after rendering, it shows up in the US dollar format.

So 123456789.53 should show up as "R$ 123.456.789,53" and not "$123,456,789.53" as it does now. So how do I accomplish this please? Thanks.