Just doesn’t live up to expectations. Entering an alias always feels like a double chore, even with the macro.

  • ScottE@lemm.ee
    link
    fedilink
    arrow-up
    9
    ·
    1 year ago

    I think it would be nice if there was a more constrained, or specialized, spreadsheet option with only 2 columns, where the value of the first column is always the alias and the second column is always the value. I guess there could be other fixed optional columns like units as well.

    99% of the time this is all I want - a simple list of variables. It’s definitely tedious to create parameters in the current design, as great and powerful a feature as it is.

    I’m not familiar with the macro mentioned - I need to look into that. If it saves one or two steps it’d be worth it.

  • JustEnoughDucks
    link
    fedilink
    arrow-up
    7
    ·
    edit-2
    1 year ago

    There really needs to be a variable system like there is on Assembly4, you can’t even see the aliased value in spreadsheets without clicking into the cell (which constitutes a change so the entire project recomputes) so I end up having to make another adjacent with the variable name in text. But no, that doesn’t work to just put in the name because the spreadsheet will interpret it as the variable since it is within the spreadsheet, you have to put quotes around it.

    Also, changing an alias’d value in the spreadsheet on anything larger than an extremely basic part can take upwards of 5 minutes, even when solving the entire model only takes on the order of 10 seconds.

    Spreadsheets are horrible in freecad.

    • funkyfourier@lemmy.world
      link
      fedilink
      arrow-up
      4
      ·
      1 year ago

      This absolutely. Using variables is a very powerful feature which enables robust, solid and parametric modelling. The way it is implemented currently, however, is very crude. I have also had issues where when a cell refers to another cell further down in the spreadsheet, all sorts of mysterious bugs occur.

      Would be nice if someone would implement a proper solution for this. I’d be willing to chip in on financial support if that would be required.