TechDraw SpreadsheetView

    From FreeCAD Documentation

    TechDraw SpreadsheetView.svg 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.

    TechDraw Spreadsheetview.png

    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 TechDraw SpreadsheetView.svg Insert Spreadsheet View button.
      • Select the TechDraw → Views From Other Workbenches → TechDraw SpreadsheetView.svg 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.