TechDraw SpreadsheetView
|
|
| Menu location |
|---|
| TechDraw → Views From Other Workbenches → Insert Spreadsheet View |
| Workbenches |
| TechDraw, Spreadsheet |
| Default shortcut |
| None |
| Introduced in version |
| - |
| See also |
| None |
Description
The TechDraw SpreadsheetView tool allows you to place a view of a selected spreadsheet on a Page.
introduced in version 1.0: The TechDraw View tool can also create a Spreadsheet View.
Spreadsheet element inserted in the TechDraw drawing page
Usage
- Select a spreadsheet in the Tree view.
- If there are multiple drawing pages in the document: optionally add the desired page to the selection by selecting it in the Tree view.
- Select the TechDraw → Views From Other Workbenches →
Insert Spreadsheet View option from the menu. - If there are multiple drawing pages in the document, and if no page is displayed in the Main view area and you have not yet selected a page, the Page Chooser dialog box opens:
- Select the desired page.
- Press the OK button.
- A Spreadsheet View is inserted.
- Adjust the cell range of the view by changing its DataCell Start and DataCell End properties.
Properties
See also: Property editor.
A Spreadsheet View, formally a TechDraw::DrawViewSpreadsheet object, has the properties that are common to all View types. It also has the following additional properties:
Data
Drawing view
- Data (Hidden)Symbol (
String): The SVG code defining this symbol. - Data (Hidden)Editable Texts (
StringList): Substitution values for the editable strings in this symbol. Not used. - DataOwner (
Link): Feature to which this symbol is attached. introduced in version 1.0
Spreadsheet
- DataSource (
Link): The spreadsheet to be added to the page. - DataCell Start (
String): The top left cell of the cell range to be included in this view. - DataCell End (
String): The bottom right cell of the cell range to be included in this view. - DataFont (
Font): The name of the font used for texts. - DataText Color (
Color): The color of texts and lines that have no color specified in the spreadsheet. - DataText Size (
Float): The font size of texts. - DataLine Width (
Float): The width of the cell borders.
TechDraw
- Pages: Insert Default Page, Insert Page using Template, Update template fields, Redraw Page, Print All Pages, Export Page as SVG, Export Page as DXF
- Views:
- TechDraw views: Insert View, Insert Broken View, Insert Section View, Insert Complex Section View, Insert Detail View, Insert Projection Group, Insert Clip Group, Insert SVG Symbol, Insert Bitmap Image, Share View, Turn View Frames On/Off, Project Shape
- Views from other workbenches: Insert Active View, Insert Draft Workbench Object, Insert BIM Workbench Object, Insert Spreadsheet View
- Stacking: Move view to top of stack, Move view to bottom of stack, Move view up one level, Move view down one level
- Dimensions: Insert Dimension, Insert Length Dimension, Insert Horizontal Dimension, Insert Vertical Dimension, Insert Radius Dimension, Insert Diameter Dimension, Insert Angle Dimension, Insert 3-Point Angle Dimension, Insert Area Annotation, Create Arc Length Dimension, Insert Horizontal Extent Dimension, Insert Vertical Extent Dimension, Create Horizontal Chain Dimensions, Create Vertical Chain Dimensions, Create Oblique Chain Dimensions, Create Horizontal Coordinate Dimensions, Create Vertical Coordinate Dimensions, Create Oblique Coordinate Dimensions, Create Horizontal Chamfer Dimension, Create Vertical Chamfer Dimension, Insert Balloon Annotation, Insert Axonometric Length Dimension, Insert Landmark Dimension, Dimension Repair, Link Dimension to 3D Geometry
- Hatching: Hatch Face using Image File, Apply Geometric Hatch to Face,
- Annotations: Insert Annotation, Add Leaderline to View, Insert Rich Text Annotation, Add Cosmetic Vertex, Add Midpoint Vertices, Add Quadrant Vertices, Add Centerline to Faces, Add Centerline between 2 Lines, Add Centerline between 2 Points, Add Cosmetic Line Through 2 points, Add Cosmetic Circle, Change Appearance of Lines, Show/Hide Invisible Edges, Add Welding Information to Leader, Add Surface Finish Symbol, Add Hole or Shaft Tolerances
- Extensions:
- Attributes and modifications: Select Line Attributes, Cascade Spacing and Delta Distance, Change Line Attributes, Extend Line, Shorten Line, Lock/Unlock View, Position Section View, Position Horizontal Chain Dimensions, Position Vertical Chain Dimensions, Position Oblique Chain Dimensions, Cascade Horizontal Dimensions, Cascade Vertical Dimensions, Cascade Oblique Dimensions, Calculate the area of selected faces, Calculate the arc length of selected edges, Customize format label
- Centerlines and threading: Add Circle Centerlines, Add Bolt Circle Centerlines, Add Cosmetic Thread Hole Side View, Add Cosmetic Thread Hole Bottom View, Add Cosmetic Thread Bolt Side View, Add Cosmetic Thread Bolt Bottom View, Add Cosmetic Intersection Vertex(es), Add an offset vertex, Add Cosmetic Circle, Add Cosmetic Arc, Add Cosmetic Circle 3 Points, Add Cosmetic Parallel Line, Add Cosmetic Perpendicular Line
- Dimensions: Insert '⌀' Prefix, Insert '□' Prefix, Insert 'n×' Prefix, Remove Prefix, Increase Decimal Places, Decrease Decimal Places
- Miscellaneous: Remove Cosmetic Object
- Additional: Line Groups, Templates, Hatching, Geometric dimensioning and tolerancing, Preferences
User documentation
- Getting started
- Installation: Download, Windows, Linux, Mac, Additional components, Docker, AppImage, Ubuntu Snap
- Basics: About FreeCAD, Interface, Mouse navigation, Selection methods, Object name, Preferences, Workbenches, Document structure, Properties, Help FreeCAD, Donate
- Help: Tutorials, Video tutorials
- Workbenches: Std Base, Assembly, BIM, CAM, Draft, FEM, Inspection, Material, Mesh, OpenSCAD, Part, PartDesign, Points, Reverse Engineering, Robot, Sketcher, Spreadsheet, Surface, TechDraw, Test Framework
- Hubs: User hub, Power users hub, Developer hub