×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Editing tabular note using spread sheet

Editing tabular note using spread sheet

Editing tabular note using spread sheet

(OP)
Hi,

Trying to edit tabular note using spread sheet. When I add object attribute to the tabular note by selecting cell and importing object attributes and editing the note using spread sheet I can see the formulas like =ugattr("PART", "MATERIAL",0). Here the part is PART itself and I was adding Material attribute. Now if I type the same formula into other cell its not working. Is it not possible to use the same formula in the spread sheet. Will it not take these formulas this way? Kindly clarify

Thanks,
Sravan

RE: Editing tabular note using spread sheet

If you're saying that the contents of cell B1 and C1 are the same, they are not. Take another look at your image file.

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Digital Factory
Cypress, CA
Siemens PLM:
UG/NX Museum:

To an Engineer, the glass is twice as big as it needs to be.

RE: Editing tabular note using spread sheet

(OP)
Yes JohnRBaker,

That is because I have tried copying attribute value from part list just to check. The value must be same in C1 for all cells, and still I cant manually give the same formula.

Thanks,
Sravan

RE: Editing tabular note using spread sheet

Do you have to use the "spreadsheet edit" function? If you want to add attribute text to the cell, right click the cell and choose "edit text", choose "relationships" and select the attribute or expression that you want to reference.

I don't recommend using the "ugattr" function.

www.nxjournaling.com

RE: Editing tabular note using spread sheet

(OP)
Thank you cowski,

As you said it is the best method to use right click and edit text. But I am checking if I can prepare a spreadsheet with ugattr formulas
and directly export it to the table, so that I no need to right click on each cell of table to add the object attribute through edit text. My intention was to maintain a common spreadsheet with the formulas in which I can add the part numbers at a single time and export the same into tabular note.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources