.NET
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

format a table cell

7 REPLIES 7
Reply
Message 1 of 8
Allen_Hart
933 Views, 7 Replies

format a table cell

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
7 REPLIES 7
Message 2 of 8
Hallex
in reply to: Allen_Hart

Not tested

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

~'J'~
_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Message 3 of 8
Allen_Hart
in reply to: Allen_Hart

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
Message 4 of 8
Hallex
in reply to: Allen_Hart

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'~
_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Message 5 of 8
Allen_Hart
in reply to: Allen_Hart

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
Message 6 of 8
Hallex
in reply to: Allen_Hart

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

~'J'~
_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Message 7 of 8
Hallex
in reply to: Allen_Hart

[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'~
_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Message 8 of 8
shih
in reply to: Allen_Hart

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

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk DevCon in Munich May 28-29th


Autodesk Design & Make Report

”Boost