Pad a string with repeating characters such that the final string is size long. Examples: padString("12",5,'0',true).equals("00012")==true padString("Hi",4,' ',false).equals("Hi ")==true
Break the contents of a formula that are between parentheses into their constituent fields.
Note: Examples are as seen in code, so "\\\"how\\\"" creates the string \"how\" and Hello\\, creates the string Hello\,
Ex: "IIF(A
formulaSegment = "A
returnArray.get(0) == "A
returnArray.get(1) == "\"Hello there, \\\"how\\\" are you\""
returnArray.get(2) == "1.34"
Escaping a comma will cause the comma to be ignored.
Ex: "Hello\\, how are you,2"
returnArray.get(0) == "Hello\\, how are you"
returnArray.get(1) == "2"
Stop going down the current branch path and continue as if this were the end of a branch.
Ususally called because we were at the end of one of a branch.
Purge all variables above the specified level from the variable list
and clear out previously solved results from formulas where a level
higher than this one was used in the solution.
Go through entries in the stack and purge the results of any functions, formulas, or variable references, that used variables with a level higher than the specified level.