TechDraw SpreadsheetView: Difference between revisions

From FreeCAD Documentation
(More elements have internal geometry.)
(Moved the Notes paragraph.)
Line 35: Line 35:
# Select a spreadsheet in the [[Tree_view|Tree view]].
# Select a spreadsheet in the [[Tree_view|Tree view]].
# Press the {{Button|[[Image:TechDraw SpreadsheetView.svg|16px]] [[TechDraw_SpreadsheetView|Insert Spreadsheet View]]}} button.
# Press the {{Button|[[Image:TechDraw SpreadsheetView.svg|16px]] [[TechDraw_SpreadsheetView|Insert Spreadsheet View]]}} button.

== Notes == <!--T:16-->

<!--T:17-->
* In {{VersionMinus|0.19}} 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: {{Incode|&}} (replace with {{Incode|&amp;amp;}}) and {{Incode|&lt;}} (replace with {{Incode|&amp;lt;}}). See also this [https://forum.freecadweb.org/viewtopic.php?p=629853#p629885 discussion] in the forum.


==Properties== <!--T:6-->
==Properties== <!--T:6-->
Line 54: Line 59:
* {{PropertyData|Text Size|Float}}: The font size of texts.
* {{PropertyData|Text Size|Float}}: The font size of texts.
* {{PropertyData|Line Width|Float}}: The width of the cell borders.
* {{PropertyData|Line Width|Float}}: The width of the cell borders.

== Notes == <!--T:16-->

<!--T:17-->
* In {{VersionMinus|0.19}} 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: {{Incode|&}} (replace with {{Incode|&amp;amp;}}) and {{Incode|&lt;}} (replace with {{Incode|&amp;lt;}}). See also this [https://forum.freecadweb.org/viewtopic.php?p=629853#p629885 discussion] in the forum.





Revision as of 08:13, 26 July 2023

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

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.