TechDraw SpreadsheetView

From FreeCAD Documentation

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.

Spreadsheet element inserted in the TechDraw drawing page

Usage

  1. Select a single spreadsheet in the Tree view.
  2. If there are multiple drawing pages in the document: optionally add the desired page to the selection by selecting it in the Tree view.
  3. There are several ways to invoke the tool:
    • Press the Insert Spreadsheet View button.
    • Select the TechDraw → Views From Other Workbenches → Insert Spreadsheet View option from the menu.
  4. If there are multiple drawing pages in the document and you have not yet selected a page, the Page Chooser dialog box opens: introduced in version 0.20
    1. Select the desired page.
    2. Press the OK button.
  5. Adjust the cell range of the view by changing its DataCell Start and DataCell End properties.

Notes

  • In version 0.19 and below some characters in spreadsheet cells will cause errors when displayed in a Spreadsheet View. These characters have to be XML encoded. Currently known characters are: & (replace with &amp;) and < (replace with &lt;). See also this discussion in the forum.

Properties

See also TechDraw View.

Data

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.