.NET

Reply
Valued Contributor
54 Posts
5 Kudos
Registered: ‎09-18-2006
Post 1 of 8

format a table cell

484 Views, 7 Replies
04-22-2010 01:22 PM
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
*Expert Elite*
1,569 Posts
171 Kudos
Registered: ‎10-08-2008
Post 2 of 8

Re: format a table cell

04-23-2010 01:19 AM in reply to: Allen_Hart
Not tested

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

~'J'~
_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Valued Contributor
54 Posts
5 Kudos
Registered: ‎09-18-2006
Post 3 of 8

Re: format a table cell

04-26-2010 05:59 AM 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
*Expert Elite*
1,569 Posts
171 Kudos
Registered: ‎10-08-2008
Post 4 of 8

Re: format a table cell

04-27-2010 12:24 PM 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
Valued Contributor
54 Posts
5 Kudos
Registered: ‎09-18-2006
Post 5 of 8

Re: format a table cell

04-28-2010 06:48 AM 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
*Expert Elite*
1,569 Posts
171 Kudos
Registered: ‎10-08-2008
Post 6 of 8

Re: format a table cell

04-28-2010 07:04 AM 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
*Expert Elite*
1,569 Posts
171 Kudos
Registered: ‎10-08-2008
Post 7 of 8

Re: format a table cell

05-03-2010 12:30 PM 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
New Member
2 Posts
0 Kudos
Registered: ‎11-13-2006
Post 8 of 8

Re: format a table cell

03-22-2012 09:17 AM in reply to: Allen_Hart

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

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post