topic Re: Editing Rows and Columns in AutoCAD in AutoCAD Forum

Editing Rows and Columns in AutoCAD

RalphBrown99 — Mon, 28 Nov 2016 08:30:47 GMT

Hi:

I am editing a table that was created originally in Excel but the change is that big that I had to detach the Excel Source and unlock all the cells. Now I have to add and delete rows and columns. Adding or deleting rows is not a problem, the options are available every time I do click in any cell, the problem is when I am trying to add or delete columns: The options in the contextual menu are not available.... how come?

Just in case you know the reason in how is possible to edit rows but not possible to edit columns, please let me know. I have to edit the table using the 2 options. I am adding a .png file so you can have a better idea about was going on

Thank in advance

Ralph

Re: Editing Rows and Columns in AutoCAD

TheCADnoob — Mon, 28 Nov 2016 14:15:36 GMT

The only way i have been able to duplicate this behavior is by having data links intact.

Would you be able to provide a file so that we can look at it?

Re: Editing Rows and Columns in AutoCAD

john.vellek — Mon, 28 Nov 2016 23:35:31 GMT

Hi @RalphBrown99,

Does this behave differently if you select the column header cell instead of a data cell?

I too would like to see a sample file if you can attach one.

Re: Editing Rows and Columns in AutoCAD

RalphBrown99 — Tue, 29 Nov 2016 07:34:08 GMT

Hi John and "TheCADnoob":

It looks that the same is happening if I choose either a cell or a column header. For sure I am sending the file that opens in Paper Space with the table on it. Please have a look and let me know your comments

Thanks in advance

Ralph Brown

Re: Editing Rows and Columns in AutoCAD

TheCADnoob — Tue, 29 Nov 2016 13:24:47 GMT

your column headers are all still locked and linked.

Re: Editing Rows and Columns in AutoCAD

RalphBrown99 — Thu, 01 Dec 2016 07:02:41 GMT

Hi CADnoob, thanks for your time.

I was able to unlock the column but I still have problems to break the link. In the most of the tables that I have worked before, I do right click>Data Links>Detach Data Link

In the file that I sent you I do no have this option available.

I am sending you 2 .png so you can see the difference in between the option available in the first file and the option not available in the second file

Again, thanks in advance

Re: Editing Rows and Columns in AutoCAD

TheCADnoob — Thu, 01 Dec 2016 14:00:10 GMT

Yea, i saw the same thing the other day. For the size and content of the table i think you might be better off just recreating the table. (Use MATCHPROP to get it close to the table you currently have) It seems like something is screwy with it. I have seen some elements get corrupted before, like view ports, but i haven't heard of table doing it but id imagine if a viewport can do it so could other elements.

If re-starting the table is not an option you can create a new link and re link the table and then you can regain the ability to add remove rows and columns but the screwey link issue will live on.

Re: Editing Rows and Columns in AutoCAD

john.vellek — Thu, 01 Dec 2016 21:52:01 GMT

Hi RM,

Can you try removing the link using the Data Link Manger?

Re: Editing Rows and Columns in AutoCAD

TheCADnoob — Fri, 02 Dec 2016 13:42:51 GMT

There are no links in the Data Link Manager of the file he uploaded

Re: Editing Rows and Columns in AutoCAD

john.vellek — Fri, 02 Dec 2016 15:53:10 GMT

Hi @RalphBrown99,

Try this please:

Remove the DXE file

type this in the command line: (dictremove (namedobjdict) "ACAD_Datalink")

Then close the drawing and reopen it

Please select the Accept as Solution button if my post solves your issue or answers your question.

Re: Editing Rows and Columns in AutoCAD

john.vellek — Mon, 05 Dec 2016 17:49:33 GMT

Hi @RalphBrown99,

I am checking back to see if my post or others helped you with your problem.
Please add a post with how you decide to proceed and your results so other Community members may benefit.

Please select the Accept as Solution button if a post or posts fully solved your issue or answered your question.

Re: Editing Rows and Columns in AutoCAD

RalphBrown99 — Fri, 30 Dec 2016 23:00:22 GMT

Hi John:

Thank you very much for your help. I know that it was long time ago but just now I could see that the solution is working very well.

Thanks again

Rafael