This function changes a cell value from a numeric into a textual equivalent. This function is specifically tailored to the HTML authoring interface, so programmers would find the function AssignWordstoValuesSelectedColumns to be more useful.
Syntax:AssignWordsToValues, boolAllPages, tildeDelimitedWords, count, commaDelimitedColumnCaptions
Parameters:
boolAllPages – apply to all pages (true) or just the current page (false)
tildeDelimitedWords – tilde-delimited list for values 0 through 10
count – the number of columns to be affected
commaDelimitedColumnCaptions – a comma-separated list of column captions that are to be affected
Examples:
AssignWordsToValues,false,~low~medium~high~~~~~~~,3,Column 1,Column 2,Column 3
This example will substitute the word low wherever a cell value is 1, medium wherever a value is 2, and high wherever a value is 3 in columns captioned ‘Column 1’, ‘Column 2’, and ‘Column 3’.
Comments:
Only a limited range of values can be changed (0 through 10), so it is recommended to apply one of the ChangeValues operations prior to doing this.
|
