Can't reduce table's height

[syanchuck]

Hi,
I am creating BOM using Excel tables; the height of the cell must be 0.2. I am trying to play with the cell's properties, I've created the text height 0.1; however something is limiting me and the smallest height of the cell can me only 0.2533, whenever the requirements, as I've mentioned are: the cell height is 0.2 and the text is 0.1.

Is it solvable?

Thank you in advance!

[pendean]

Share your DAG with your table in it here please, let's touch your creation in person.

[syanchuck]

Here is it!

Thank you!

[pendean]

Thanks for the DWG file.

Also, your TABLE is defined using a taller text style (0.15), and in your TABLESTYLE it is defined as 0.18 (and a different STYLE to boot), very large cell margins, and you did an height override down to 0.1. You must spend a lot of time constantly resetting and manually changing, yes? 

Start over with the correct TABLESTYLE settings, see if you can get a lot closer to your exact and specific needs. Post back if you get stuck somewhere. it's so much easier. Don't forget to do the math between your text height from your STYLE and the margins sizes for all three table lines (DATA, HEADER, TITLE). Then you just do this

[syanchuck]

Thank you for your response.
I've created this ADS-BOM style.
I still don't understand what I need to do for reduce the height of the cell. I've changed everything on the style, but it is still 0.2533 (see the attached file).

[pendean · Accepted solution]

[syanchuck]

Thank you! That worked!
And if I want organize the running items by some order like we are doing it in Excel, can I do it?

I am attaching the example I did it manually. Is it possible instead of typing it manually, to create a formula?

[pendean · Accepted solution]

---

@syanchuck wrote:

...And if I want organize the running items by some order like we are doing it in Excel, can I do it?...

---

Not that I am aware of, sorry. if this is a dire business need, you should be using EXCEL instead then OLE link-it to a table in AutoCAD.

[syanchuck]

Thank you! Just wanted to be sure that it won't work for now.

[syanchuck]

Sorry, last question..
If we can't build up a references with formulas, what it used for:???

[pendean]

@syanchuck  why not try those options out nd find out for yourself? That's a good next step for your exploration. Come back if you get stuck using them. Those match Excel's abilities on a basic level.

[syanchuck]

Sorry, I've really tried, but nothing worked. 

If I find the answer, I will post it here.

[syanchuck]

I think I know what the issue was...
There is very limited options; If we wanna insert formula, we have to type everything manually. And also, we have to set up the cell Data as a "data", not as a "text" as I did... But if so, how I configure it with dashes ("-") or zeros (00) before the numbers?

[pendean · Accepted solution]

---

@syanchuck wrote:

... If we wanna insert formula, we have to type everything manually....

---

That depends on if you are following any tutorials from HELP (or on the web), for example

---

@syanchuck wrote:

...also, we have to set up the cell Data as a "data", not as a "text" as I did...

---

DATA is for numbers.

TEXT is for words.

You are correct in your observations for how tables work. And any of these types

---

@syanchuck wrote:

....how I configure it with dashes ("-") or zeros (00) before the numbers?

---

If what you want is available, select the cell/cells, right-click (remember that?), then choose

OR...

As I noted in one or more previous replies, if you need EXCEL then use EXCEL all the time. Explore DATALINK command and tutorials in HELP in the program.

[syanchuck]

Thank you very much! I very appreciate your hint!!!