TechDraw SpreadsheetView: Difference between revisions

From FreeCAD Documentation
(Marked this version for translation)
No edit summary
Line 55: Line 55:
* {{PropertyData|Line Width|Float}}: The width of the cell borders.
* {{PropertyData|Line Width|Float}}: The width of the cell borders.


== Limitations ==
Some characters in a spreadsheet cell may cause errors in TechDraw, whole cell contents can be omitted. These characters have to be quoted in the HTML-style.

'''Example:''' The character '&' has to be entered as "<code>&amp;amp;</code>" in the Spreadsheet cell.
See also this [https://forum.freecadweb.org/viewtopic.php?p=629853#p629885 discussion] in the forum.


<!--T:12-->
<!--T:12-->

Revision as of 15:25, 1 October 2022

TechDraw SpreadsheetView

Menu location
TechDraw → Insert Spreadsheet View
Workbenches
TechDraw, Spreadsheet
Default shortcut
None
Introduced in version
-
See also
None

Description

This 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 spreadsheet in the Tree view.
  2. Press the Insert Spreadsheet View button.

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.

Limitations

Some characters in a spreadsheet cell may cause errors in TechDraw, whole cell contents can be omitted. These characters have to be quoted in the HTML-style.

Example: The character '&' has to be entered as "&amp;" in the Spreadsheet cell. See also this discussion in the forum.