.NET

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

format a table cell

493 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
Announcements
Are you interested in helping shape the future of the Autodesk Community? To participate in this brief usability study, please click here. Your time and input is greatly appreciated!