Thanks. I didn't know about the skip recomputes option, but unfortunately it isn't helpful in this case. As pointed out in the article, I need recomputes to be done within the spreadsheet, but not in the overall model. There was a comment about putting the spreadsheet in its own file, but it's not clear to me how that works. For small parts it would be inconvenient but workable. But I don't see how to reference the spreadsheet from the sketch if the spreadsheet is in a separate file.Roy_043 wrote: ↑Sat May 23, 2020 9:20 pmSee:
https://www.forum.freecadweb.org/viewto ... =3&t=37060
Code: Select all
Working with the spreadsheet itself is fine; it's working with the model in the other file that then is a problem:kisolre wrote: ↑Sun May 24, 2020 3:39 pmCould you give an example why? You can type your formulas, aliases, values, ... and then the single recompute will sort and update everything in one go.
Because sadly (as I understand it) now the spreadsheet i treated as a single object and every change is treated as "Object changed, recompute dependencies.". If only aliased cells could be referenced then limiting the status change to those cells would help a lot. But you can also reference cells by their name. So now every cell change is potential trigger. Maybe if there was a way for the spreadsheet to know which cells were referenced and trigger changed state only on those it will be better. Not sure how hard it will be to implement "referenced" state to cells and receive that info from expression engine.garya wrote: ↑Sun May 24, 2020 5:39 pmIf I open up a new line in the spreadsheet, the whole model recomputes. If I type in a comment in the newly opened up line, the whole model recomputes. If I type in a new formula, as soon as I hit <enter> the whole model recomputes. If I set the alias name, the whole model recomputes