TechDraw SpreadsheetView: Difference between revisions

From FreeCAD Documentation
No edit summary
No edit summary
 
(19 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<languages/>
<languages/>
<translate>
<translate>

<!--T:11-->
<!--T:11-->
{{Docnav
{{Docnav
Line 7: Line 8:
|[[TechDraw_Workbench|TechDraw]]
|[[TechDraw_Workbench|TechDraw]]
|IconL=TechDraw_ArchView.svg
|IconL=TechDraw_ArchView.svg
|IconR=TechDraw-MoveView.svg
|IconR=TechDraw_MoveView.svg
|IconC=Workbench_TechDraw.svg
|IconC=Workbench_TechDraw.svg
}}
}}
Line 14: Line 15:
{{GuiCommand
{{GuiCommand
|Name=TechDraw SpreadsheetView
|Name=TechDraw SpreadsheetView
|MenuLocation=TechDraw → Insert Spreadsheet View
|MenuLocation=TechDraw → Views From Other Workbenches → Insert Spreadsheet View
|Workbenches=[[TechDraw_Workbench|TechDraw]], [[Spreadsheet_Workbench|Spreadsheet]]
|Workbenches=[[TechDraw_Workbench|TechDraw]], [[Spreadsheet_Workbench|Spreadsheet]]
}}
}}
Line 21: Line 22:


<!--T:3-->
<!--T:3-->
This tool allows you to place a view of a selected [[Spreadsheet_Workbench|spreadsheet]] on a [[TechDraw_Workbench|Page]].
The '''TechDraw SpreadsheetView''' tool allows you to place a view of a selected [[Spreadsheet_Workbench|spreadsheet]] on a [[TechDraw_Workbench|Page]].


</translate>
</translate>
Line 32: Line 33:


<!--T:5-->
<!--T:5-->
# Select a spreadsheet in the [[Tree_view|Tree view]].
# Select a single spreadsheet in the [[Tree_view|Tree view]].
# If there are multiple drawing pages in the document: optionally add the desired page to the selection by selecting it in the [[Tree_view|Tree view]].
# Press the {{Button|[[Image:TechDraw SpreadsheetView.svg|16px]] [[TechDraw_SpreadsheetView|Insert Spreadsheet View]]}} button.
# There are several ways to invoke the tool:
#* Press the {{Button|[[Image:TechDraw_SpreadsheetView.svg|16px]] [[TechDraw_SpreadsheetView|Insert Spreadsheet View]]}} button.
#* Select the {{MenuCommand|TechDraw → Views From Other Workbenches → [[Image:TechDraw_SpreadsheetView.svg|16px]] Insert Spreadsheet View}} option from the menu.
# If there are multiple drawing pages in the document and you have not yet selected a page, the {{MenuCommand|Page Chooser}} dialog box opens: {{Version|0.20}}
## Select the desired page.
## Press the {{Button|OK}} button.
# Adjust the cell range of the view by changing its {{PropertyData|Cell Start}} and {{PropertyData|Cell End}} properties.

== 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-->

<!--T:13-->
See also [[TechDraw_View#Properties|TechDraw View]].

=== Data === <!--T:14-->

<!--T:15-->
{{TitleProperty|Spreadsheet}}


<!--T:7-->
<!--T:7-->
* {{PropertyData|Source}}: The spreadsheet to be added to the page
* {{PropertyData|Source|Link}}: The spreadsheet to be added to the page.
* {{PropertyData|Cell Start}}: The top left cell of the cells range to be included in this view
* {{PropertyData|Cell Start|String}}: The top left cell of the cell range to be included in this view.
* {{PropertyData|Cell End}}: The bottom right cell of the cells range to be included in this view
* {{PropertyData|Cell End|String}}: The bottom right cell of the cell range to be included in this view.
* {{PropertyData|Font}}: The name of the font used for texts
* {{PropertyData|Font|Font}}: The name of the font used for texts.
* {{PropertyData|Color}}: The color of lines and texts that have no color specified in the spreadsheet
* {{PropertyData|Text Color|Color}}: The color of texts and lines that have no color specified in the spreadsheet.
* {{PropertyData|Font Size}}: The font size of texts
* {{PropertyData|Text Size|Float}}: The font size of texts.
* {{PropertyData|Line Width}}: The width of the cell borders
* {{PropertyData|Line Width|Float}}: The width of the cell borders.



<!--T:12-->
<!--T:12-->
Line 52: Line 74:
|[[TechDraw_Workbench|TechDraw]]
|[[TechDraw_Workbench|TechDraw]]
|IconL=TechDraw_ArchView.svg
|IconL=TechDraw_ArchView.svg
|IconR=TechDraw-MoveView.svg
|IconR=TechDraw_MoveView.svg
|IconC=Workbench_TechDraw.svg
|IconC=Workbench_TechDraw.svg
}}
}}
Line 59: Line 81:
{{TechDraw Tools navi{{#translation:}}}}
{{TechDraw Tools navi{{#translation:}}}}
{{Userdocnavi{{#translation:}}}}
{{Userdocnavi{{#translation:}}}}
{{clear}}

Latest revision as of 08:20, 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 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.