FreeCad Macro for creating of alias-names in a data-table from the row and column header cells.
Go to file
Kurt Ludikovsky 660949b260 ReadMe added
2020-12-24 11:45:44 +01:00
.gitignore .gitignore added 2020-12-24 10:38:31 +01:00
EasyAreaAlias.FCMacro First working version 2020-12-24 10:36:30 +01:00
Readme.md ReadMe added 2020-12-24 11:45:44 +01:00

EasyAreaAlias

A FreCAD macro to create Aliasis for a selected range of cells from the row and column headings

Installation

See How to install macros

Usage

1. Create a data-table

In a FreeCAD spreadsheet create a data-table with row- and column-headers.

Eg. have the part-name in the rows and in the columns the dimension category.

X Y Z
Part 1 10 20 30
Part 2 20 30 10
Part 3 40 30 30
Part 4 60 50 20
Part 5 30 60 60

2. Select the data

Select the data only, excluding the headings

3. Execute the macro

The macro will now check and correct[^1] the headings (replace specail characters, blanks, etc.) so that a proper alias can be generated and generate and set the alias for each cell in the selected range.

Eg. in the tabel above the first cell will get the alias "Part_1_X", and so on.

[^1] The corretiong is done to assure there are no differencies between the displayed text and the generated alias.