Editing tabular note using spread sheet

[srav1]

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

 

[JohnRBaker]

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.

 

[srav1]

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

 

[cowski]

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

 

[srav1]

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.