- Companion:
- class
Value members
Concrete methods
Creates a list of target formula cell references
Creates a list of target formula cell references
Checks if the formula contains jointed cell references Jointed references have format U_(cell1, cell2) e.g. $[SUM(U_(F8,F13))]
Checks if the formula contains jointed cell references Jointed references have format U_(cell1, cell2) e.g. $[SUM(U_(F8,F13))]
Parses a "jointed cell" reference and extracts individual cell references
Parses a "jointed cell" reference and extracts individual cell references
Parses a formula and returns a list of cell names used in it E.g. for formula "B4*(1+C4)" the returned list will contain "B4", "C4"
Parses a formula and returns a list of cell names used in it E.g. for formula "B4*(1+C4)" the returned list will contain "B4", "C4"
Parses a formula to extract a list of so called "jointed cells" The jointed cells are cells combined with a special notation "U_(cell1, cell2)" into a single cell They are used in formulas like this "$[SUM(U_(F8,F13))]". Here the formula will use both F8 and F13 source cells to calculate the sum
Parses a formula to extract a list of so called "jointed cells" The jointed cells are cells combined with a special notation "U_(cell1, cell2)" into a single cell They are used in formulas like this "$[SUM(U_(F8,F13))]". Here the formula will use both F8 and F13 source cells to calculate the sum