![]() ![]() See Cell properties on how to set the alias. While you may use the row and column number in an expression to reference a cell, best practice is to give the cell an alias name and use that. A simple way to avoid this is to give the spreadsheet a meaningful name before starting to use it in expressions. The internal name of the spreadsheet is not readily available anywhere except within the expression editor, so if you use the internal name and later decide to rename the spreadsheets, you might have a hard time tracing your expression data back to its source.īe aware that when you create a new spreadsheet, the name and the label are the same, so it is easy to accidentally use the spreadsheet name instead of the label. If you decide to change the label of a spreadsheet, existing references to the contents of the spreadsheet will be updated, so you won't break your expressions by renaming the spreadsheet. It is also easier to identify the spreadsheet that is being used since the text in the expression matches the label shown in the model and property views. Using the spreadsheet label has the advantage that it can be freely changed to describe the contents of the spreadsheet. Autocompletion is available for all forms of referencing. ![]() You can identify spreadsheets by name or by label, and you can identify the cells by address or by alias. In order to use spreadsheet data in other parts of FreeCAD, you will usually create an Expression that refers to the spreadsheet and the cell that contains the data you want to use. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |