I am in a bit of a hurry so I will test more tomorrow. I have since upgraded, my version data for this test is now at the end of this post.Įnter does not seem to be working now, but it was before, unless I did something different.
#Freecad spreadsheet formulas update#
If you update the data box by double clicking on the box, then just press enter key when finished and the whole spreadsheet will update including the formulae. If you changed the data box via the input box at the top of the spreadsheet then you have to press Apply twice to get the formulae boxes to update. If you click on the formula box, yes you get the answer, but if you look at the edit box at the top you will see the formula.Īlso if you change the value in a referenced data box, the formula box does update, but it also depends on exactly how you changed the data box. But I think you will find yours is the same. I tested this in a slightly newer version from master than yours. You will be pleased, no doubt, to find that you are mistaken!Īlthough there is a bug it would seem.
#Freecad spreadsheet formulas code#
The code however seems to replace the formula by the value, which menas when I change the value in A1, the calculated value is no more true. When hitting apply, the calculation is executed, the value is correct. Let me know your thoughts in the comments below.Alex::freecad wrote:I use a spreadsheet and in there cells which compute e.g. Excel does not show that a cell has been named making it easy to forget to name a cell which is then not available for use in the FreeCAD model.Functions may have different numbers of parameters causing an error to occur.Function names are imported in uppercase causing an error to occur.Spreadsheets are not linked to the model meaning that any change must be made in all models using the spreadsheet.Models can be easily created from the spreadsheet.Component dimensions are consistent between models.You would probably be better off modelling all the details in these situations as it will provide more information to the manufacturer. It was a bit painful to have to fix the imported spreadsheet each time but it was not an insurmountable problem.ĭesigning the joinery without much detail may not be appropriate if you are modelling components that are going to be produced by a third party or on say a CNC machine. Overall the design process worked well, the limitations of the FreeCAD Spreadsheet Workbench not withstanding. Excel seems to deal with it correctly, but FreeCAD doesn't always. I have seen mixed results with the BIMDAS rules in FreeCAD's Spreadsheet Workbench so I explicitly insert parentheses in every formula when I have mixed multiplication/division and addition/subtraction operations. A better option would have been to simply model the top, bottom, and sides as a solid board and leave the placement of the dovetails to the construction of the cabinet. For example, I modelled the dovetails used to join the sides of the cabinet to the top and bottom, but this consumed a fair bit of time. I chose to design most of the detail that goes into the construction of the cabinet to understand the time required to do so, but I discovered that most of the components do not need to be modelled to that degree. I didn't want to design one-off components so I chose to design a cabinet that is relatively simple in appearance but has a lot of design elements from in practice. I wanted to explore how the Spreadsheet Workbench could be used in my furniture design workflow because it may help to increase my productivity. A small cabinet would give me a sufficiently complex project to understand the pro's and con's of this method. I wanted to understand the extents to which I could use an Excel spreadsheet in FreeCAD before it started to become too unwieldy. This is a follow-up article to my Designing with spreadsheets in FreeCAD article. This article will describe how I used Excel and FreeCAD's Spreadsheet Workbench to design a small cabinet. The spreadsheets can be imported and exported allowing them to be shared between projects and models, allowing reuse and consistency between designs. FreeCAD incorporates a spreadsheet workbench that allows you to create a spreadsheet of design parameters that can be used in your models.
0 kommentar(er)
