TechDraw SpreadsheetView: Difference between revisions

From FreeCAD Documentation
(Removed Version=0.19. Tool exists in V0.17 and maybe even in an earlier version.)
No edit summary
(28 intermediate revisions by 7 users not shown)
Line 1: Line 1:
<languages/>
<languages/>
<translate>
<translate>

<!--T:11-->
<!--T:11-->
{{Docnav
{{Docnav
|[[TechDraw_ArchView|Insert Arch Workbench Object]]
|[[TechDraw_ArchView|ArchView]]
|[[TechDraw_MoveView|MoveView]]
|[[TechDraw_ClipGroup|Insert Clip Group]]
|[[TechDraw_Module|TechDraw]]
|[[TechDraw_Workbench|TechDraw]]
|IconL=TechDraw_ArchView.svg
|IconL=TechDraw_ArchView.svg
|IconR=TechDraw_MoveView.svg
|IconC=Workbench_TechDraw.svg
|IconC=Workbench_TechDraw.svg
|IconR=TechDraw_ClipGroup.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_Module|TechDraw]]
|Workbenches=[[TechDraw_Workbench|TechDraw]], [[Spreadsheet_Workbench|Spreadsheet]]
|SeeAlso=[[Spreadsheet_Workbench|Spreadsheet Workbench]]
}}
}}


Line 22: Line 22:


<!--T:3-->
<!--T:3-->
This tool allows you to place a view of a selected [[Spreadsheet Workbench|spreadsheet]] on a [[TechDraw Module|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 33: Line 33:


<!--T:5-->
<!--T:5-->
# In the tree, select a spreadsheet you wish to put on a drawing sheet
# 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-->
{{Docnav
{{Docnav
|[[TechDraw_ArchView|Insert Arch Workbench Object]]
|[[TechDraw_ArchView|ArchView]]
|[[TechDraw_MoveView|MoveView]]
|[[TechDraw_ClipGroup|Insert Clip Group]]
|[[TechDraw_Module|TechDraw]]
|[[TechDraw_Workbench|TechDraw]]
|IconL=TechDraw_ArchView.svg
|IconL=TechDraw_ArchView.svg
|IconR=TechDraw_MoveView.svg
|IconC=Workbench_TechDraw.svg
|IconC=Workbench_TechDraw.svg
|IconR=TechDraw_ClipGroup.svg
}}
}}


Line 60: Line 81:
{{TechDraw Tools navi{{#translation:}}}}
{{TechDraw Tools navi{{#translation:}}}}
{{Userdocnavi{{#translation:}}}}
{{Userdocnavi{{#translation:}}}}
{{clear}}

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.