TechDraw SpreadsheetView: Difference between revisions

From FreeCAD Documentation
(→‎Notes: Added {{VersionMinus|19.0}} to the note. There is a fix that will be packported to V0.20.)
(Marked this version for translation)
Line 55: Line 55:
* {{PropertyData|Line Width|Float}}: The width of the cell borders.
* {{PropertyData|Line Width|Float}}: The width of the cell borders.


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


<!--T:17-->
* In {{VersionMinus|19.0}} 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.
* In {{VersionMinus|19.0}} 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 17:54, 5 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.

Notes

  • In version 19.0 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.