![]() ![]() in fact you should even be able to specify inches in the formula if the user so desired and it be converted. The user is left to guess what unit of measurement is used because its unspecified anywhere guessing doesn't sound clear to me.Īnd secondly, if you could specify m, mm or cm such as you put it, it would be a programmatic cakewalk to interpret the meaning and calculate accordingly. Presently, using a formula provides absolutely no way of specifying the unit of measurement whatsoever. You mentioned clarity of intent? ok lets talk about that. reopening.įirst of all sir thank you for commenting. You asked a question then closed the ticket. OS: Debian GNU/Linux 11 (bullseye) (KDE/plasma) but only if i manually put the value of those cells into the equation, then it will work. result = Says "unit must be empty or an angle. ![]() If i enter this simple formula =B1 - 2 * tan(1 * B2) it doesnt work. Note that you will not need to use the path SPREADSHEET because you are already in it.0004783: Spreadsheet: Cannot Reference Cell(s) in formula The second option is easyer because you can correct these figure more quickly.Ĭreate in the sheet a second aera that will use the primary data you have entered Or you can make these calculation in the SpreadSheet Soon you will realise that you loose the all picture of these calculations ! You can make the calculation inside the formula editor using various operation. Professional 3d always want to have an object centered. That is usefull if you want to put your model in the middle so you can easely use symetric function. You might want to position your model according to specific calculation. You can go on like this with all three fieldsĬhanging the value in the SpreadSheet will change the 3D Then we must add the name of the correct field we just createdįor this ewample the "LENGTH" of the Cube is the Length of the low pannel.īegin typing in the name of this field we created ("Len_Low_Pan") and this field will appear in the dropdown list.Īs soon as we enter the correct path with the correct field we created, the Formula Editor finds the value we just wroteĬlick OK and you will see that the value is correct and is linked to the SpreadSheet Just start typing in the beginning of the word "Spreadsheet" and the correct beginning of the path we are looking for will appear. The Formula Editor will permit us to link anything with anything just using simple formulas. Go to the first field of the box and click on itĪ tiny yet powerfull icon will appear, click on it If you have accidently left the spreadsheet because you clicked too strongly, just get back to it using the TAB in the bottom Step 4: Linking SpreadSheet to 3D modelĬlic just once on the part " cube" That you have renamed so that the fields of this part appears.We will proceed to this link in the next step These fields are not related yet to anything in our 3D If you go over the cell without moving or clicking the name of the field will appear, you can always change whatever you want : name of the field or value. Select an official short name (without space) of this field, it will be this field we will use in formulas, better make it short and explicit.Īs you proceed with every field, the cells will become YELLOW Note that I am putting this information just next to the Label, once again, I had no need for a label, or putting this information in this particular cell, this is just a way of making the sheet easy to read for further uses.Ģ) Then click on "SET ALIAS" (you can also access the alias name of this cell with de rightclic + property) Type in "=425" or wathever the dimension are Note that this description will only be a label, you can make it long and descriptive, it will not be used in the formula calculator The only difference is that you have to press enter, just leaving the cell to another one will not save it (at first you will have to get use to this) Select the " SPREADSHEET" menu in the selectorĭouble-Click on Spreadsheet in the tree structureĮnter your field description by just typing in the text as you would do with an Excel or Libre office Calc sheet The aim of this step is to create fields dimension in a SpreadSheet (wich is a sort of Excel sheet embed in Freecad with wich you can pilot your data) You can not rename these fields, just consider them as abstract fields name) The aim of this choose a part of your model wich will be the main symetrical partĪs you can see the cube is not at a symetrical position, we will correct this later on.Ģ) Change dimension approximatly for now just to get an idea of each dimension in front of each field (maybe the field "length" will be your real Width or Height. Example : creating a kitchen cabinet furniture driven by a Spreadsheet. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |