Table Format issue with decimal numbers

Table Format issue with decimal numbers

Amriya_Exe
Advocate Advocate
1,427 Views
6 Replies
Message 1 of 7

Table Format issue with decimal numbers

Amriya_Exe
Advocate
Advocate

I fixed my table value round to 0 decimal.

 

 

when I close and reopen my drawing file or edit the value of this L=9975 marked in square entire table getting disturbed like this. I have locked formatting and content both for rest of the table.

 

 

0 Likes
Accepted solutions (1)
1,428 Views
6 Replies
Replies (6)
Message 2 of 7

pendean
Community Legend
Community Legend

@Amriya_Exe May I ask, why is your DWG file saved down to R2000 format? What year version of AutoCAD are you using please?

 

Back to the topic: I am not able to replicate your issue here in the updated AutoCAD2023.1.4 in Windows10Pro when I edit that top cell

pendean_0-1704983090864.png

 

What other steps should I try that you may have not mentioned in your post?

Message 3 of 7

TheCADnoob
Mentor
Mentor

This is a head-scratcher at the moment. I can hypothesize a guess, but it's just a guess as to why this is happening. 

 

It looks like most of your fields started as text. If you convert text to decimal, often programs will add their baseline precision. Often when you get far out in the floating point world, noise can get added to numbers. Im guessing that is why your number of 9975 has all the trailing digits. That said, i would have thought that changing the data would alleviate that issue but it doesnt seem to be the case with this. 

 

Is there are reason you are using decimals? it looks like all your data is whole numbers. If you used that instead of decimal formatting it may help. 

CADnoob

EESignature

0 Likes
Message 4 of 7

TheCADnoob
Mentor
Mentor

@pendean I think part of the problem is the automatic resizing of the table which is present in your drawing

 

TheCADnoob_0-1704990344166.png

 

CADnoob

EESignature

0 Likes
Message 5 of 7

Amriya_Exe
Advocate
Advocate

No I am not using any decimal I simply editing cell writing 9975 and d= 316.

And my table properties I change all cell type data > Decimal Number > precision = 0

 

This shouldn't convert to 9975.000000000

Due to this other values / cell without any formula getting converted to 10.00000

30.0000 die to this my table cell. Heights getting changed and arrangements getting spoiled. 

0 Likes
Message 6 of 7

Amriya_Exe
Advocate
Advocate

This auto resizing due to decimals getting 0.00000 even I selected precision 0.

0 Likes
Message 7 of 7

TheCADnoob
Mentor
Mentor
Accepted solution

What i am saying is that you are using decimal number data type as opposed to whole number data typer. If you are not using any decimal numbers in your table or calculations an no division, you could probably just use the whole number data type. This doesn't require precision and should truncate your number. You would have to do this to all the cells though. 

 

TheCADnoob_0-1705111391471.png

 

CADnoob

EESignature

0 Likes