Smartstaff, administrator
3,579
edits
Changes
→Adding a formula to a XML cell (working with data in the different sections)
So if you wanted to add the values of row 1 and 2 together in column 1 you would enter '''=[1,1]+[2,1]'''.
==Adding a formula to a XML cell (working with data in the different sections)==
Refer to cells in different sections using this syntax
e.g. '''=[@section.''expense''.id@_''Total_Amount'']-[@section.''income''.id@_''Existing-funds''_''Amount'']'''
==Validate XML values when saving the worksheet==