Quote:
Originally Posted by kcz
For some reason using F2 in the custom column creation does not work. I'm on a Mac, so maybe that's the reason. Anyway, if I paste your second example into the field, it works perfectly. Thank you.
|
To use F2 (edit field) you must have already created the composite column. Create the column with a simple template. While looking at the books spreadsheet, click in any cell in the new column then do what the mac expects to edit the column.
Quote:
|
Ok, this seems pretty straight forward. I guess it makes more sense to use a user defined template function when the code is more complex or the function is used more often.
|
Defining a user-defined function is usually driven by complexity or performance. Sometimes the template language doesn't have the power to do what is needed or the solution is so cumbersome that it is absurd. Sometimes the performance of the template language solution is unacceptable, which can happen when several "test" conditions are being evaluated because the template interpreter does not shortcut. All arguments (conditions) are computed, then the conditions are evaluated.