Intersoft Community - DataFormatString

Different formatting for WebGrid

Nikolay — Fri, 16 Dec 2011 08:03:23 GMT

Hello!

I noticed strange behavior of WebGrid. If I use format string “0%” for decimal value (for example value = 0.2), than I see different results for WebGrid, that used clienside binding and serverside binding. Example is attached bellow.

Formatting cell for Accounting Format

bbucher — Wed, 13 Jul 2011 09:14:20 GMT

I'm formatting cells a read-only webgrid (one by one) in code-behind, and it's successful so far. The only bits I'm missing is that I need accounting formats:

negative numbers should be formatted like "(123)" instead of "-123", and

zeros should be "-" rather than "0".

I've tried the dataformatstring = "$#,##0.00;($#,##0.00);-" but that doesn't seem to work. Do you have any suggestions?

Many thanks!

Beryl

DataFormatString issue

qq397472251 — Sat, 25 Sep 2010 23:04:14 GMT

I use DataFormatString="$##,###.00", when the cell into EditState ,I can not see the oldvalue, but the other cells have not this problem,how to fix it???

<ISWebGrid:WebGridColumn Caption="FoodPrice" DataFormatString="$##,###.00" DataType="System.Decimal"  DataMember="price" Name="price"  Width="100px" >
</ISWebGrid:WebGridColumn>

why DataFormatString does not work?

rogerchen.tangshuo@gmail.com — Mon, 16 Nov 2009 20:27:35 GMT

In WebGrid 6.0

<ISWebGrid:WebGridColumn Caption="Caption1" DataMember="dm1" DataType="System.Decimal"

Name="dm1" Width="120px" DataFormatString="p">
<CellStyle HorizontalAlign="Right" Padding-Right="5px">
<Padding Right="5px"></Padding>
</CellStyle>
</ISWebGrid:WebGridColumn>

but display not right. why?

thanks