×
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!

*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

UG Spreadsheet (EXCELL)Tabular notes

UG Spreadsheet (EXCELL)Tabular notes

UG Spreadsheet (EXCELL)Tabular notes

(OP)
Does anyone know how to get the formatting of
the spreadsheet to stat intact when using Tabular
notes?. If I create a tabular note in excell and
place it on the drawing... When I go back to edit
it, All formatting is lost. Very frustrating, seems
like it would be a good tool if it worked.

RE: UG Spreadsheet (EXCELL)Tabular notes

Me too, this is not a problem with V16, but it certainly is in V18.  Does anyone know of alternate forms (i.e. GRIP programs) of creating tablular notes?  In our case, we are in need of creating point tables for insert locations in honeycomb panels.  Does anyone have a source of GRIP libraries on the 'net?  Thanks!

RE: UG Spreadsheet (EXCELL)Tabular notes

I was wondering if there was any kind of setting to set what software is used for table editing such as using notepad or Microsoft word which are not grid based and could show merged cells in tables.

I'm currently using Tabular Notes and agree that there are many areas for improvement. I have a few workarounds that I'll list in case you want to try them.

For the table size issue there is an auto-size Cells option that is on the options menu in the linked spreadsheet. If you uncheck that it will help with table size on Drawing but excel row heights change unexpectedly. With options you can also change text format and size and chose whether or not to show grid lines. I've used this method with associative trimmed curves that will update if table size changes.

The other method is a bit more parametric and that is to make a sketch in the Drawing using the sketcher and add dimensions and equal length constraints to control size.

Michael

RE: UG Spreadsheet (EXCELL)Tabular notes

There are settings in the ug_*.def files for how UG treats fonts and character size when placing the taular note on the drawing.

Ben Loosli
CAD/CAM System Analyst
Ingersoll-Rand

RE: UG Spreadsheet (EXCELL)Tabular notes

Also in the spreadsheet, under Options-->Tabular Note Options you can specify your font mapping and other items. That may be all you need to do. It is possible, even though Excel usually will warn you, that you have two spreadsheet fonts set to be the same UG font/size, and when you return to the spreadsheet, your formatting has been lost.
-Derek

RE: UG Spreadsheet (EXCELL)Tabular notes

How do you control row height in tabular notes?  I've got it laid out how I want, I just want to change the height on the header.
-Al

RE: UG Spreadsheet (EXCELL)Tabular notes

put ur cursor on the grid line . Double arrow cursor comes on. Drag the grid line to where you want. Let it go.
fsi

RE: UG Spreadsheet (EXCELL)Tabular notes

I tried that in the spreadsheet and nothing happened.  When I put the cursor on the gridlines in drafting, I didn't get any arrows.  What command are you in when you do this?
Al

RE: UG Spreadsheet (EXCELL)Tabular notes

Change the text height.

You can try to change the row height in Excel, as described, but I don;t think any of the special formatting commands, row height, column width, cell merge, come trough when you apply the changes and reteun to UG.

"Wildfires are dangerous, hard to control, and economically catastrophic."

Ben Loosli
CAD/CAM System Analyst
Ingersoll-Rand

RE: UG Spreadsheet (EXCELL)Tabular notes

No, they don't carry over.  It's not that big of a deal, but it would be nice to be able to adjust row height in a tabular note.

Al Griego
Mech. Designer
Hamilton Sunstrand

PS:
Are you in San Diego, Ben?  Just wondering in regards to your tagline.

RE: UG Spreadsheet (EXCELL)Tabular notes

No, My tag line is from a report on PTC Pro/E Wildfire.

Corporate has 'forced' us to switch from UG.

"Wildfires are dangerous, hard to control, and economically catastrophic."

Ben Loosli
CAD/CAM System Analyst
Ingersoll-Rand

RE: UG Spreadsheet (EXCELL)Tabular notes

Make sure the Auto-size cells box is unchecked under Options + Tabular Note Options... when in the Excel spreadsheet. You should now be able to change the row heights, column widths and font sizes. One note of warning though, if you're using V18 UG will automatically reformat the tables with arbutraiy(sp?) heights and widths each time you open the drawing. Does anyone know if this has been fixed in NX?

Ken

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! Already a Member? Login


Resources

Solutions Brief - Protecting and Rescuing On-Ground Personnel
Keeping our warfighters safe and delivering them a competitive advantage is a key goal of departments of defense around the world. It’s a goal shared by embedded computing manufacturers like Abaco: we never forget who we serve.This case study describes how a major international contractor integrated an Abaco single board computer at the heart of its CAS/CSAR solution. Download Now
Datasheet - Top Enhancements Creo 7.0
PTC's Creo 7.0 has breakthrough innovations in the areas of generative design, real-time simulation, multibody design, additive manufacturing, and more! With Creo 7.0, you will be able to design the most innovative products faster than ever before, keeping you on the cutting edge of product design and ahead of your competition. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close