Macro for Spreadsheet Alias setup and Part Family Generation

[LoneTech]

Obviously, I'm late to the party. I grew annoyed with the roundabout way to set labels too, and cobbled together yet another script; this one has no GUI, but checks selected spreadsheets for A1="Label" and B1="Value", and then applies the labels in column A to cells in column B. I guess I could have saved myself the trouble by searching the forum, but perhaps it can serve as a scripting example?

Code: Select all

"""Spreadsheet labeling convenience script for FreeCAD

FreeCAD spreadsheets are a good way to collect parameters, 
which are then referred to by using formulae in data fields 
such as constraints, positions etc. 

However, the workflow for setting the parameters up is quite 
circuitous. One has to set a label for each cell, which 
requires opening a separate modal dialog box, and once set 
those labels are not visible in the sheet but only in the 
Data tab of the combo view (as with named constraints in 
sketches). 

This macro labels selected sheets by taking values from column A, 
marked Label, and applying them to column B, marked Value. 
Note that FreeCAD will try to turn entered values into formulae, 
and the sheet has a label called Label (its visible name, there 
is also an internal name called Name), so it's easier to enter 
Label as 'Label (prefixed with a single quote). 

Usage: set A1="Label" and B1="Value" in a spreadsheet. 
Fill in names for properties in the A column. 
With the spreadsheet selected, run this macro. 
Result: B column will be labeled with names based on A column. 

The yellow highlight for labeled cells only appears on filled in 
cells. The mouseover tooltip for cells shows their label. 
"""

# First, get a reasonable guess for which spreadsheet to label
import re
namematcher = re.compile(r'^A([0-9]+)$')
sheets = [s for s in Gui.Selection.getSelection()
          if s.TypeId=='Spreadsheet::Sheet']
if not sheets:
	print("No sheets selected to label.")
for sheet in sheets:
	# Sanity check that this sheet should be labeled
	if sheet.A1 != u'Label' or sheet.B1 != u'Value':
		print("Not labelling sheet {!r}: missing Label and Value header".format(sheet.Label))
		continue
	for m in filter(None, map(namematcher.match, dir(sheet))):
		row = m.group(1)
		if row == "1":
			continue	# header row
		label = sheet.get(m.string)
		if not isinstance(label, (str, unicode)):
			continue
		# Mangle into a suitable symbol name
		label = re.subn(r'[^A-Za-z0-9_]+', '', label.title())[0]
		cell = m.expand(r'B\1')
		currentalias = sheet.getAlias(cell)
		if currentalias
			print("Not labelling cell {}, already labelled {!r}"
				.format(cell, currentalias))
		else:
			try:
				sheet.setAlias(cell, label)
				print("Labelled cell {} {}".format(cell, label))
			except Exception, e:
				print("Failed to set sheet {!r} cell {!r} to {!r}: {}".format(
					sheet.Label, cell, label, e))
	print("Labelled sheet {!r}".format(sheet.Label))

[TheMarkster]

Obviously, I'm late to the party. I grew annoyed with the roundabout way to set labels too, and cobbled together yet another script; this one has no GUI, but checks selected spreadsheets for A1="Label" and B1="Value", and then applies the labels in column A to cells in column B. I guess I could have saved myself the trouble by searching the forum, but perhaps it can serve as a scripting example?

Here's a link to a macro I wrote a while back to address the same issue.

https://forum.freecadweb.org/viewtopic. ... =easyalias

[draenog]

Hi everyone,

I added the ability to set and clear aliases for rows (the alias is then the content of the column A of the corresponding row + the header of the others columns). The way I use it is to set the dimension, position informations in a spreadsheet and then apply them to an object.
And since this applying is tedious, I also added a button to set the properties of the selected object to the selected row values (I attached an example file).

freecad-table.png (157.41 KiB) Viewed 1994 times

Here is the code : 

Code: Select all

# ============================================================================================================
# ============================================================================================================
# ==                                                                                                        ==
# ==                                           alias Manager                                                ==
# ==                                                                                                        ==
# ============================================================================================================
# ============================================================================================================
# ABOUT
# ============================================================================================================
# version v1.0
# Macro developed for FreeCAD (http://www.freecadweb.org/).
# This macro helps managing aliases inside FreeCAD Spreadsheet workbench. It is able to:
#        - create aliases based on first column (A column)
#        - delete aliases placed on a column
#        - move aliases from one column to other one
#        - create a "part family", that's it, create different files for each column in a range. It will add
#          to the original name a suffix based on first row (1)
# More information might be found on FreeCAD forums: http://forum.freecadweb.org/
#
#
# LICENSE
# ============================================================================================================
# Original work done by tarihatari (https://github.com/tarihatari/FreeCAD_Macros)
# Improved by Pablo Gil Fernandez
#
# Copyright (c) 2016 tarihatari & Pablo Gil Fernandez
#
# This work is licensed under GNU Lesser General Public License (LGPL).
# To view a copy of this license, visit https://www.gnu.org/licenses/lgpl-3.0.html.
#
# ============================================================================================================
__title__   = "alias manager"
__author__  = "Pablo Gil Fernandez"
__version__ = "01.00"
__date__    = "20/11/2016"
 
__Comment__ = "This macro helps managing aliases inside FreeCAD Spreadsheet workbench. It is able to create, delete, move aliases and create a 'part family' group of files"
 
__Wiki__ = "https://github.com/pgilfernandez/FreeCAD_AliasManager"
__Help__ = "https://github.com/pgilfernandez/FreeCAD_AliasManager"
__Status__ = "stable"
__Requires__ = "FreeCAD 0.16"

from PySide import QtGui, QtCore
from FreeCAD import Gui
import os
import string
App = FreeCAD
Gui = FreeCADGui

# ========================================================
# ===== Info popup window ================================
# ========================================================
class infoPopup(QtGui.QDialog):
    def __init__(self, parent=None):
        self.dialog = None
        self.dialog = QtGui.QDialog()
        self.dialog.resize(360,400)
        self.dialog.setWindowTitle("About...")

        info = QtGui.QTextEdit("<h2>INFORMATION</h2><hr><br>This macro helps managing aliases inside FreeCAD Spreadsheet workbench. It is able to create, delete, move aliases and create a 'part family' group of files.<br><h2>USAGE</h2><hr><ul><li><b>set aliases</b>: based on first column (A column), it will create aliases for the range given. If an alias is already set for any other cell the command won't work, it will be needed to clear them before setting them again.</li><li><b>Clear aliases</b>: it will clear all aliases inside the given range of cells (only one column).</li><li><b>Move aliases</b>: it will clear and set aliases <b>from</b> a given column <b>to</b> a new one.</li><li><b>Generate part family</b>: it will create different files for each column in a range. It will add to the original name a suffix based on first row. If an alias is already set for any other cell the command won't work, it will be needed to clear them before running the command.</li></ul><h2>LICENCE</h2><hr>Original work done by <b>tarihatari</b> (<a href='https://github.com/tarihatari/FreeCAD_Macros'>https://github.com/tarihatari/FreeCAD_Macros</a>)<br>Improved by <b>Pablo Gil Fernandez</b><br><br>Copyright (c) 2016 tarihatari & Pablo Gil Fernandez<br><br>This work is licensed under GNU Lesser General Public License (LGPL).<br>To view a copy of this license, visit <a href='https://www.gnu.org/licenses/lgpl-3.0.html'>https://www.gnu.org/licenses/lgpl-3.0.html</a>.<br>")
        info.setReadOnly(True)
        info.setAlignment(QtCore.Qt.AlignLeft | QtCore.Qt.AlignTop)

        okbox = QtGui.QDialogButtonBox(self.dialog)
        okbox.setOrientation(QtCore.Qt.Horizontal)
        okbox.setStandardButtons(QtGui.QDialogButtonBox.Close)
        okbox.setFocus()

        grid2 = QtGui.QGridLayout()
        grid2.setSpacing(10)
        grid2.addWidget(info, 0, 0)
        grid2.addWidget(okbox, 1, 0)

        self.dialog.setLayout(grid2)

        QtCore.QObject.connect(okbox, QtCore.SIGNAL("rejected()"), self.close)
        QtCore.QMetaObject.connectSlotsByName(self.dialog)
        self.dialog.show()
        self.dialog.exec_()

    def close(self):
        self.dialog.close()


# ========================================================
# ===== Main code ========================================
# ========================================================


# ===== Global variables ==============================================
alphabet_list = list(string.ascii_uppercase)

class p():
    def aliasManager(self):
        try:

# ===== Variables ==============================================
            mode = self.d1.currentText()
            column_from = self.d2.currentText()
            column_to = self.d3.currentText()
            row_from = self.d4.value()
            row_to = self.d5.value()


# ===== Mode - Set ==============================================
            if mode == "Set aliases":
                for i in range(row_from,row_to+1):
                    cell_from = 'A' + str(i)
                    cell_to = str(column_from) + str(i)
                    alias = App.ActiveDocument.Spreadsheet.getContents(cell_from)
                    alias = alias.replace(" ","_")
                    App.ActiveDocument.Spreadsheet.setAlias(cell_to, '')
                    App.ActiveDocument.Spreadsheet.setAlias(cell_to, alias)
                    App.ActiveDocument.recompute()

                FreeCAD.Console.PrintMessage("\nAliases set\n")


# ===== Mode - Set row ==========================================
            elif mode == "Set row aliases":
                for i in range(row_from,row_to+1):
                    cell_from = 'A' + str(i)
                    index = ord(column_from)
                    for j in range(index, index+10):
                        alias = App.ActiveDocument.Spreadsheet.getContents(cell_from)
                        alias = alias.replace(" ","_")

                        cell_to = chr(j) + str(i)
                        App.ActiveDocument.Spreadsheet.setAlias(cell_to, '')

                        cell_alias_end= chr(j)+str(1)
                        alias_end = App.ActiveDocument.Spreadsheet.getContents(cell_alias_end)
                        alias += "_"+ alias_end

                        App.ActiveDocument.Spreadsheet.setAlias(cell_to, alias)
                        
                    App.ActiveDocument.recompute()

                FreeCAD.Console.PrintMessage("\nAliases set\n")


# ===== Mode - Clear ==============================================
            elif mode == "Clear aliases":
                for i in range(row_from,row_to+1):
                    cell_to = str(column_from) + str(i)
                    App.ActiveDocument.Spreadsheet.setAlias(cell_to, '')
                    App.ActiveDocument.recompute()

                FreeCAD.Console.PrintMessage("\nAliases cleared\n")               


# ===== Mode - Clear row ==========================================
            elif mode == "Clear row aliases":
                for i in range(row_from,row_to+1):
                    index = ord(column_from)
                    for j in range(index, index+10):
                        cell_to = chr(j) + str(i)
                        App.ActiveDocument.Spreadsheet.setAlias(cell_to, '')
                        App.ActiveDocument.recompute()

                FreeCAD.Console.PrintMessage("\nAliases cleared\n")


# ===== Mode - Move ==============================================
            elif mode == "Move aliases":

                self.d3.setDisabled(False)
                for i in range(row_from,row_to+1):
                    cell_reference = 'A'+ str(i)                        
                    cell_from = column_from + str(i)
                    cell_to = column_to + str(i)
                    App.ActiveDocument.Spreadsheet.setAlias(cell_from, '')
                    App.ActiveDocument.recompute()
                    App.ActiveDocument.Spreadsheet.setAlias(cell_to, App.ActiveDocument.Spreadsheet.getContents(cell_reference))
                    App.ActiveDocument.recompute()
                FreeCAD.Console.PrintMessage("\nAliases moved\n")


# ===== Mode - Set alias on selected object ==========================
           # elif mode == "Set alias on selected object":
                # work done in the function               



# ===== Mode - Generate part family ==================================
            elif mode == "Generate part family":
                doc = FreeCAD.ActiveDocument    
                if not doc.FileName:
                    FreeCAD.Console.PrintError('\nMust save project first\n')
                    
                docDir, docFilename = os.path.split(doc.FileName)
                filePrefix = os.path.splitext(docFilename)[0]

                def char_range(c1, c2):
                    """Generates the characters from `c1` to `c2`, inclusive."""
                    for c in xrange(ord(c1), ord(c2)+1):
                        yield str.capitalize(chr(c))

                fam_range = []
                for c in char_range(str(column_from), str(column_to)):
                    fam_range.append(c)

                for index in range(len(fam_range)):
                    # set aliases
                    for i in range(row_from,row_to+1):
                        cell_reference = 'A' + str(i)
                        cell_from = str(fam_range[index-1]) + str(i)
                        cell_to = str(fam_range[index]) + str(i)
                        App.ActiveDocument.Spreadsheet.setAlias(cell_from, '')
                        App.ActiveDocument.recompute()
                        App.ActiveDocument.Spreadsheet.setAlias(cell_to, App.ActiveDocument.Spreadsheet.getContents(cell_reference))
                        App.ActiveDocument.recompute()
                        sfx = str(fam_range[index]) + '1'

                    # save file
                    suffix = App.ActiveDocument.Spreadsheet.getContents(sfx)
                    filename = filePrefix + '_' + suffix + '.fcstd'
                    filePath = os.path.join(docDir, filename)
                
                    FreeCAD.Console.PrintMessage("\nSaving view to %s\n" % filePath)
                    App.getDocument(filePrefix).saveAs(filePath)

                # Clear last aliases created:
                for j in range(row_from,row_to+1):
                    cell_to = str(column_to) + str(j)
                    App.ActiveDocument.Spreadsheet.setAlias(cell_to, '')
                App.ActiveDocument.recompute()

                # Turn working file to original naming:
                filename = filePrefix + '.fcstd'
                filePath = os.path.join(docDir, filename)
                FreeCAD.Console.PrintMessage("\nSaving original view to %s\n" % filePath)
                App.getDocument(filePrefix).saveAs(filePath)
                FreeCAD.Console.PrintMessage("\nPart family files generated\n")



# ===== If errors ==============================================
            else:
                FreeCAD.Console.PrintError("\nError or 'TODO'\n")


        except:
            FreeCAD.Console.PrintError("\nUnable to complete task\n")
 
            self.close()
 

    def close(self):
        self.dialog.hide()


# ========================================================
# ===== GUI menu ========================================
# ========================================================
    def __init__(self):
        infoIcon = ['16 16 3 1',
                '   c None',
                '+  c #444444',
                '.  c #e6e6e6',
                '     ......    ',
                '   ..........  ',
                '  ......++.... ',
                ' .......++.....',
                ' ..............',
                '.....+++++......',
                '....+++++.......',
                '.......++.......',
                '.......++.......',
                '.......+........',
                '......++........',
                ' .....++.+.....',
                ' .....++++.....',
                '  .....++..... ',
                '   ..........  ',
                '     ......    ']

        # Hide/show "to column" label and spinbox based on mode type
        def disableWidget(currentIndex):
            if self.d1.currentText() == "Set alias on selected object":
                iN2a.hide()
                iN2b.hide()
                self.d2.setEnabled(False)
                self.d2.hide()
                iN3.hide()
                self.d3.setEnabled(False)
                self.d3.hide()
                iN5.hide()
                self.d5.setEnabled(False)
                self.d5.hide()
                in7.show()
            else:
                iN2a.show()
                iN2b.show()
                self.d2.setEnabled(True)
                self.d2.show()
                iN3.show()
                self.d3.setEnabled(True)
                self.d3.show()
                iN5.show()
                self.d5.setEnabled(True)
                self.d5.show()
                in7.hide()

            if (self.d1.currentText() == "Set aliases"
             or self.d1.currentText() == "Clear aliases"
             or self.d1.currentText() == "Set row aliases"
             or self.d1.currentText() == "Clear row aliases"
             or self.d1.currentText() == "Set alias on selected object"):
                iN3.hide()
                self.d3.setEnabled(False)
                self.d3.hide()
            else:
                iN3.show()
                self.d3.setEnabled(True)
                self.d3.show()




        self.dialog = None
        
        self.dialog = QtGui.QDialog()
        self.dialog.resize(400,140)
        
        self.dialog.setWindowTitle("Alias manager")
 
        iN1 = QtGui.QLabel("mode:")
        iN1.setAlignment(QtCore.Qt.AlignRight | QtCore.Qt.AlignVCenter)
        self.d1 = QtGui.QComboBox()
        self.d1.addItem("Set aliases")
        self.d1.addItem("Clear aliases")
        self.d1.addItem("Set row aliases")
        self.d1.addItem("Clear row aliases")
        self.d1.addItem("Move aliases")
        self.d1.addItem("Generate part family")
        self.d1.addItem("Set alias on selected object")
        self.d1.setCurrentIndex(0) # set default item
        self.d1.currentIndexChanged['QString'].connect(disableWidget)
 
        iN2a = QtGui.QLabel("column:")
        iN2a.setAlignment(QtCore.Qt.AlignRight | QtCore.Qt.AlignVCenter)
        iN2b = QtGui.QLabel("from")
        iN2b.setAlignment(QtCore.Qt.AlignCenter | QtCore.Qt.AlignVCenter)
        self.d2 = QtGui.QComboBox()
        for i in range(0,26):
            self.d2.addItem(alphabet_list[i])
        for i in range(0,26):
            for j in range(0,26):
                self.d2.addItem(alphabet_list[i] + alphabet_list[j])
        self.d2.setCurrentIndex(1) # set default item

        iN3 = QtGui.QLabel("to")
        iN3.setAlignment(QtCore.Qt.AlignCenter | QtCore.Qt.AlignVCenter)
        iN3.hide() # set initial state hidden
        self.d3 = QtGui.QComboBox()
        for i in range(0,26):
            self.d3.addItem(alphabet_list[i])
        for i in range(0,26):
            for j in range(0,26):
                self.d3.addItem(alphabet_list[i] + alphabet_list[j])
        self.d3.setCurrentIndex(2) # set default item
        self.d3.setEnabled(False) # set initial state to not editable
        self.d3.hide() # set initial state hidden

        iN4 = QtGui.QLabel("from row:")
        iN4.setAlignment(QtCore.Qt.AlignRight | QtCore.Qt.AlignVCenter)
        self.d4 = QtGui.QSpinBox()
        self.d4.setValue(2.0) # set default item
        self.d4.setSingleStep(1.0)
        self.d4.setMinimum(1.0)

        iN5 = QtGui.QLabel("to row:")
        iN5.setAlignment(QtCore.Qt.AlignRight | QtCore.Qt.AlignVCenter)
        self.d5 = QtGui.QSpinBox()
        self.d5.setValue(4.0) # set default item
        self.d5.setSingleStep(1.0)
        self.d5.setMinimum(1.0)

        # set aliases to part button
        in7=QtGui.QPushButton("set aliases on part")
        in7.clicked.connect(self.set_aliases_on_part)
        in7.hide()

        # Info button
        self.d6 = QtGui.QPushButton("")
        self.d6.setFixedWidth(40)
        self.d6.setIcon(QtGui.QIcon(QtGui.QPixmap(infoIcon)))
        self.d6.clicked.connect(self.popup)

        okbox = QtGui.QDialogButtonBox(self.dialog)
        okbox.setOrientation(QtCore.Qt.Horizontal)
        okbox.setStandardButtons(QtGui.QDialogButtonBox.Ok|QtGui.QDialogButtonBox.Close)

        grid = QtGui.QGridLayout()
        grid.setSpacing(10)

        # Mode
        grid.addWidget(self.d1, 0, 0, 1, 3)
        # column, column from
        grid.addWidget(iN2a,    2, 0, 1, 1)
        grid.addWidget(iN2b,    1, 1, 1, 1)
        grid.addWidget(self.d2, 2, 1, 1, 1)
        # column to
        grid.addWidget(iN3,     1, 2, 1, 1)
        grid.addWidget(self.d3, 2, 2, 1, 1)
        # from row
        grid.addWidget(iN4,     3, 0, 1, 1)
        grid.addWidget(self.d4, 3, 1, 1, 1)
        # to row
        grid.addWidget(iN5,     4, 0, 1, 1)
        grid.addWidget(self.d5, 4, 1)
        # set on part
        grid.addWidget(in7,     4, 2, 1, 1)
        # + info
        grid.addWidget(self.d6, 6, 0, 1, 1)
        # cancel, OK
        grid.addWidget(okbox,   6, 1, 1, 2)

        self.dialog.setLayout(grid)
 
        QtCore.QObject.connect(okbox, QtCore.SIGNAL("rejected()"), self.close)
        QtCore.QObject.connect(okbox, QtCore.SIGNAL("accepted()"), self.aliasManager)
        QtCore.QMetaObject.connectSlotsByName(self.dialog)
        self.dialog.show()
        self.dialog.exec_()


    def popup(self):
        self.dialog2 = infoPopup()
        self.dialog2.exec_()

    
    def set_aliases_on_part(self):
        # getting the selected part
        sel = Gui.Selection.getSelection()
        if sel:
            sel = sel[0]
                
        parts = Gui.Selection.getSelectionEx()
        part = parts[0]
        
        # getting the row
        chosen_row = self.d4.value()         

        
        # setting aliases
        part.Object.Label= App.ActiveDocument.Spreadsheet.getContents('A'+str(chosen_row))
        part.Object.setExpression('Length', u"Spreadsheet."+App.ActiveDocument.Spreadsheet.getAlias('B'+str(chosen_row)))
        part.Object.setExpression('Width', u"Spreadsheet."+App.ActiveDocument.Spreadsheet.getAlias('C'+str(chosen_row)))
        part.Object.setExpression('Height', u"Spreadsheet."+App.ActiveDocument.Spreadsheet.getAlias('D'+str(chosen_row)))
        part.Object.setExpression('Placement.Base.x', u"Spreadsheet."+App.ActiveDocument.Spreadsheet.getAlias('E'+str(chosen_row)))
        part.Object.setExpression('Placement.Base.y', u"Spreadsheet."+App.ActiveDocument.Spreadsheet.getAlias('F'+str(chosen_row)))
        part.Object.setExpression('Placement.Base.z', u"Spreadsheet."+App.ActiveDocument.Spreadsheet.getAlias('G'+str(chosen_row)))
        part.Object.setExpression('Placement.Rotation.Axis.x', u"Spreadsheet."+App.ActiveDocument.Spreadsheet.getAlias('H'+str(chosen_row)))
        part.Object.setExpression('Placement.Rotation.Axis.y', u"Spreadsheet."+App.ActiveDocument.Spreadsheet.getAlias('I'+str(chosen_row)))
        part.Object.setExpression('Placement.Rotation.Axis.z', u"Spreadsheet."+App.ActiveDocument.Spreadsheet.getAlias('J'+str(chosen_row)))
        part.Object.setExpression('Placement.Rotation.Angle', u"Spreadsheet."+App.ActiveDocument.Spreadsheet.getAlias('K'+str(chosen_row)))

        FreeCAD.Console.PrintMessage("\nAliases set on part\n")


p()

[soloquintett]

Hi everyone,

I added the ability to set and clear aliases for rows (the alias is then the content of the column A of the corresponding row + the header of the others columns). The way I use it is to set the dimension, position informations in a spreadsheet and then apply them to an object.
And since this applying is tedious, I also added a button to set the properties of the selected object to the selected row values (I attached an example file).

Hi, I was trying to use this Makro in the latest modiefied FreeCad 0.19 - asm3 by realthunder. Unfortunately this Makro is broken in this version. I realise this is probably not a problem of the macro, but of the modified FreeCad Version. However, i would like to find out why it is breaking. How can i (if possible) debug this? The python console only puts out the following:

Code: Select all

>>> Gui.runCommand('Std_DlgMacroExecute',0)

OS: Fedora 30 (Workstation Edition) (GNOME/gnome)
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.19.16830 +1496 (Git) AppImage
Build type: Release
Branch: LinkStage3
Hash: 1b29767b545440b7ab93f1a5f2b742d622f1b547
Python version: 3.7.3
Qt version: 5.9.7
Coin version: 4.0.0a
OCC version: 7.3.0
Locale: German/Germany (de_DE)

EDIT: I just realised there is a " ' " added in the Contents Field.

Bildschirmfoto von 2019-07-10 13-33-46.png (42 KiB) Viewed 1950 times

[chrisb]

Hi, I was trying to use this Makro in the latest modiefied FreeCad 0.19 - asm3 by realthunder. Unfortunately this Makro is broken in this version. I realise this is probably not a problem of the macro, but of the modified FreeCad Version.

You should discuss this in the Assembly subforum. I don't know if realthunder is watching this forum.

[soloquintett]

realthunder responded remarkebly by patching the makro within a few hours: https://github.com/realthunder/FreeCAD_ ... r_popup.py for anyone, who might have this issue.

[Aleks]

I like your work on this macro. I was using Catia V5 and especially the parameterlists (I cannot remember what they were called) for a long time and liked them very much. I have missed them using FreeCAD. Is there a particular reason why you set the instances to be columns and not rows. In data you usually define instances in rows.

[Tutorius]

I like your work on this macro. I was using Catia V5 and especially the parameterlists (I cannot remember what they were called) for a long time and liked them very much. I have missed them using FreeCAD. Is there a particular reason why you set the instances to be columns and not rows. In data you usually define instances in rows.

It is much easier to scroll a table up-downwards as scroll it from left to right (using a mousewheel), so it is much better wor workflow to have it this way...

Question I am trying to get the "Generate part family"-thing wirking, but no chance.

Any hints what can go wrong? I am assuming that the save of dreecad-files dows not work in my 0.20-version.

[YtzxR0Jg]

Seems that "xrange" used on row 117 no longer exists in later python versions. Change to "range" made it work.

But...
Operations in the macro resets aliases making expression references to it become something like "Spreadsheet.B2" instead.
Ability to change names of stuff (aliases/Assemly4 Variables) would be a great, me at least usually don't make things right the first time