topic Re: format a table cell in .NET Forum

format a table cell

Allen_Hart — Thu, 22 Apr 2010 20:22:36 GMT

How do you format cells in a table to show numbers as 3-digit decimals?
I've tried this...

myTable.Cells(r, c).DataFormat = "#0.000" ' this does not work.

Is there more to it than this?

Allen

Re: format a table cell

Hallex — Fri, 23 Apr 2010 08:19:55 GMT

Not tested

{code}
myTable.Cells(r, c).DataFormat = "%lu2%pr3%"
{code}

~'J'~

Re: format a table cell

Allen_Hart — Mon, 26 Apr 2010 12:59:35 GMT

Thanks for the idea, but it does not work either.
There must be some special setup required prior to the assignment statement, but I can't find it.
Any other ideas?
Thanks,
Allen

Re: format a table cell

Hallex — Tue, 27 Apr 2010 19:24:45 GMT

This code is working for me
just need to set DataType before:
{code}
oTable.SetDataType(i, j, DataType.Double, UnitType.Distance);
oTable.SetDataFormat(i, j, "%lu2%pr3");
{code}

~'J'~

Re: format a table cell

Allen_Hart — Wed, 28 Apr 2010 13:48:47 GMT

Here is what I have now, which works OK.

{code}
Dim oDTP As New DataTypeParameter
oDTP.DataType = DataType.Double
oDTP.UnitType = UnitType.Unitless

'oTable.SetDataType(r, c, DataType.Double, UnitType.Distance) 'obsolete
'oTable.SetDataFormat(r, c, "%lu2%pr3%") 'obsolete

oTable.Cells(r, c).DataType = oDTP
oTable.Cells(r, c).DataFormat = "%lu2%pr3%"
{code}

If I assign a value to the cell like this:
oTable.Cells(r, c).Value = 1.0
it will ignore the format and display the number in 6 decimals.

Is there a list somewhere of defined dataformat strings?

Thanks for all your help.
Allen

Re: format a table cell

Hallex — Wed, 28 Apr 2010 14:04:49 GMT

I'm still using A2008/Visual Studio2005
so it's not obsolete for me
Glad you have solved by yourself

~'J'~

Re: format a table cell

Hallex — Mon, 03 May 2010 19:30:56 GMT

[SOLVED]

{quote}
If I assign a value to the cell like this:
oTable.Cells(r, c).Value = 1.0
it will ignore the format and display the number in 6 decimals.
{quote}

{code}oTable.Cells(r, c).DataFormat ="%lu2%pr2%th44" '<-- double with 2 decimals, %th44 = dot separated{code}

Works like a sharm

~'J'~

Re: format a table cell

Anonymous — Thu, 22 Mar 2012 16:17:01 GMT

How to set data type to TEXT and format to Uppercase? Please help. Thanks!