Difference between revisions of "User Defined Variables"
Jump to navigation
Jump to search
Siyuan wei (talk | contribs) |
Siyuan wei (talk | contribs) |
||
| Line 4: | Line 4: | ||
# This shows how to use the form<br> | # This shows how to use the form<br> | ||
| − | [[File:UserDefinedVariable.gif|frame|user defined variable form]]<br> | + | [[File:UserDefinedVariable.gif|frame|left|user defined variable form]] |
| + | <br> | ||
# this shows how to change on the sheet<br> | # this shows how to change on the sheet<br> | ||
| − | [[File:UserDefinedVariable-sheet input.gif|frame|software behaviour when changing quantity on sheet]] | + | [[File:UserDefinedVariable-sheet input.gif|frame|left|software behaviour when changing quantity on sheet]] |
Revision as of 22:30, 9 January 2023
- This form will allow you to self define variable value and use in quantity column
- when variable is changed the workbook will calculated again
- then variable deleted, you will be forced to reselect the variables, so be cautious not to do this.
- This shows how to use the form
user defined variable form
- this shows how to change on the sheet
File:UserDefinedVariable-sheet input.gif
software behaviour when changing quantity on sheet