![]() ![]() If the name of an object in the CAD model is changed, the change will automatically be propagated to any references in spreadsheet expressions using the name which was changed. This allows use of object properties like volume or area in the spreadsheet. Similarly, properties from CAD model objects may be used in expressions in spreadsheet cells. When values are changed in the spreadsheet, they are propagated throughout the model. Thus, a spreadsheet may be used as the source for parameter values used throughout a model, effectively gathering the values in one place. Interaction between spreadsheets and the CAD modelĭata in the cells of a spreadsheet may be used in CAD model parameter expressions. For more information on expressions and the available functions, see Expressions. Using spreadsheet cell values to define model properties are explained under Spreadsheet data in expressions below. References to objects in the model are explained under References to CAD-data below. The number of displayed decimals can differ from your preferences settings.But commas can also be used when entering values. The decimal separator is always a dot.Therefore, when you edit a cell the content you see may not follow your display settings: Note: Cell expressions are treated by FreeCAD as programming code. A cell can be referenced by its address (CAPITAL column letter + row number, e.g. Expressions must start with an equal sign '='.Ĭell expressions may contain numbers, functions, references to other cells, and references to properties of the model (But see Current limitations below). This alias can be used in cell formulas and also in general expressions see section Spreadsheet data in expressions for more information.Ī spreadsheet cell may contain a number, a text or an expression. Style: Text style: bold, italic, underline.Alignment: Text horizontal and vertical alignment.The following dialog pops up:Īs indicated by the tabs, the following properties can be changed: The properties of a spreadsheet cell can be edited by right-clicking the cell and selecting Properties. It is advisable to save your work before performing any paste operations. In FreeCAD version 0.19 and earlier there is a bug that can cause FreeCAD to hang if a non-rectangular cell range is pasted. Note that removing cells with data can break the spreadsheet and your model if it relies on the spreadheet. Other stored content is placed relative to that cell. The paste operation writes the data in such a way that the content of the top left cell of the stored data is dropped in the active cell. The cut and copy operations store the contents and properties of the cells on the Clipboard. To select multiple cells hold down the Ctrl key while selecting, or hold down the left mouse button and drag to select a rectangular cell range. You can use the normal shortcuts for these operations: Ctrl+ X, Ctrl+ C and Ctrl+ V respectively. You are not prewarned if this happens.Ĭut and copy-paste operations can be used on cells in FreeCAD spreadsheets. Note that removing rows or columns with data can break the spreadsheet and your model if it relies on the spreadheet. In FreeCAD version 0.20 you can specify the insertion side. In FreeCAD version 0.19 and earlier rows are inserted above the selected rows, and columns on the left of the selected columns. Either by holding down the Ctrl key while selecting the headers, or by holding down the left mouse button and dragging. It is possible to select multiple rows or columns first. Rows and columns can be inserted or removed by right-clicking a row or column header and selecting the appropriate option from the contex menu. Preferences: the preferences for the Spreadsheet Workbench.Black and White set the foreground and the background colors of selected cells.Set alias: set the alias for a selected cell.Style underline: set the contents of selected cells to underlined.Style italic: set the contents of selected cells to italic.Style bold: set the contents of selected cells to bold.Align bottom: top align the contents of selected cells to the bottom.Align vertical center: align the contents of selected cells to the center vertically.Align top: align the contents of selected cells to the top.Align right: align the contents of selected cells to the right.Align center: align the contents of selected cells to the center horizontally.Align left: align the contents of selected cells to the left.Split cell: split previously merged cells.Export: export a CSV file from a spreadsheet.Import: import a CSV file into a spreadsheet.Create sheet: create a new spreadsheet.A spreadsheet with certain cells filled with text and quantities Tools ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |