topic Re: How to copy paste formula with fields? in AutoCAD Forum

How to copy paste formula with fields?

yutianchen86 — Mon, 25 Nov 2019 16:01:41 GMT

I want to copy a formula and paste into mtext with field intact. However, these fields turned into numbers when I paste. Is there a system variable or a method that can be done to make paste as field possible?

Thanks.

Copy this

paste into this

Re: How to copy paste formula with fields?

Patchy — Mon, 25 Nov 2019 16:10:20 GMT

What you showed doesn't look like formula.

https://knowledge.autodesk.com/support/autocad-lt/learn-explore/caas/CloudHelp/cloudhelp/2019/ENU/AutoCAD-LT/files/GUID-15E0C775-6E60-456D-B5C7-4726E0C586B7-htm.html

Re: How to copy paste formula with fields?

yutianchen86 — Mon, 25 Nov 2019 16:29:54 GMT

Not formula in table, I am referring to formula in fields.

Re: How to copy paste formula with fields?

ВeekeeCZ — Mon, 25 Nov 2019 16:40:38 GMT

Copy-paste this part:

But we usually use the other way around. Create/edit an MTEXT, Mouse RightClick, pick Insert Field...

Re: How to copy paste formula with fields?

yutianchen86 — Mon, 25 Nov 2019 18:04:09 GMT

I copyed it but pasted into this.

Re: How to copy paste formula with fields?

ChicagoLooper — Mon, 25 Nov 2019 18:38:26 GMT

What does 533.41 represent? And what does 74.62 represent? What do those numbers measure?

Re: How to copy paste formula with fields?

yutianchen86 — Mon, 25 Nov 2019 19:29:42 GMT

They are areas of closed polylines. I don't think this matters because these fields can be any properties of any objects.

Re: How to copy paste formula with fields?

pendean — Mon, 25 Nov 2019 19:52:44 GMT

This is the actual field code, aka formula:

Re: How to copy paste formula with fields?

ChicagoLooper — Mon, 25 Nov 2019 20:39:28 GMT

Yes, it does make a difference. Why? Because you are giving AutoCAD a specific set of instructions when you want to generate the field AREA.

You want a specific piece of mtext to insert a specific field, or a value. In order to do this, it must evaluate a specific object and insert the result (the property AREA) as the mtext contents. You, on the other hand, are merely pasting the RESULTS of the operation, not the operation itself. You need to re-run, or recreate, the operation. The operation, or the steps, constitutes the FIELD area.

Make another field. Start a new mtext, at your flashing cursor, go to Objects=>Formula=> and PASTE each formula like shown below, then click Evaluate, then OK to exit.

Re: How to copy paste formula with fields?

yutianchen86 — Mon, 25 Nov 2019 23:41:19 GMT

Please see the original post again. the 1st screen shot is what I have. I need to copy this (circled in red). The 2nd screen shot is what I want to paste it into. However, when I pasted it only numbers show up, not the fields. I want the fields link to remain in the mtext.

Re: How to copy paste formula with fields?

vinodkl — Tue, 26 Nov 2019 08:46:02 GMT

I have created two closed polyline and inserted the area of closed polyline as field in mtext. Is this what you were after?

830f75a3-9125-49ab-bc88-541a81007e8d,640,710

Re: How to copy paste formula with fields?

cadffm — Tue, 26 Nov 2019 09:01:13 GMT

@yutianchen86

First question: why?
Why do not you create the title block in MText? (inside TEXT MTEXT TEXT ATTRIBUTE .. -> RightClick -> add field)

If you have existing formular fields and would therefore like to copy:

Open the object to edit (example: Double click a TEXT or whereever your formular field is),

copy the field from there.

Re: How to copy paste formula with fields?

vinodkl — Tue, 26 Nov 2019 09:33:36 GMT

screencast was missing in my earlier post.

Re: How to copy paste formula with fields?

yutianchen86 — Tue, 26 Nov 2019 14:56:31 GMT

Sorry for the confusion, I need to further explain my case.

This single fields within a field is generated is by Lee Mac's Length & Area Field LISP. It automatically sums all geometry area into one single field.

http://www.lee-mac.com/lengthfield.html

I want to extract the calculation of these areas in a printed drawing.

I have many operation like this I want to be able to copy and paste directly into "field"+"field"+"field"....

However, when I copy and paste, the fields turned into numbers with no link. It would be ideal to paste into fields so in the future they will update upon regen when I modify the geometries.

Samething when copying mtext with fields.

Again Autocad might night have such function or system variable. I am just wondering.

Thanks.

Re: How to copy paste formula with fields?

yutianchen86 — Fri, 29 Nov 2019 15:16:44 GMT

For those of you is also looking for solution to this, I was able to find a work around using Lee Mac's Copy Field Lisp.

http://www.lee-mac.com/copyfield.html

Execute the lisp, pick the origin field, then click the target text twice. exit out of the command. Double click into the new field, then delete front cExpr text.

Re: How to copy paste formula with fields?

ya312 — Mon, 22 May 2023 02:31:43 GMT

How to get formulas without copying?

Re: How to copy paste formula with fields?

cadffm — Mon, 22 May 2023 06:26:22 GMT

Start FIELD command and create a formula field.

Not the answer you are after? Then explain it better please.

For your search engine: autocad field formula

Re: How to copy paste formula with fields?

yutianchen86 — Thu, 01 Jun 2023 13:46:28 GMT

refer to my comment above, see link to lee mac's website with lisp script.

Re: How to copy paste formula with fields?

pbelon — Sat, 25 Oct 2025 19:52:12 GMT

I think Lee-Mac is a marvelous programer. I will make a stupid modification to get it works ....

The program "COPYFIELD", I dont know why, fails sometimes when you have and mtext field. The solution is simple in the program "CopyFieldV1-1.lsp" between the lines 88 and 89 include the line (vla-put-t88extstring obj "XXX"). That convert the mtext in normal text and then permits update de field correctily in the next line.