Philosophy of setCellData vs setCellText
For example, if you populate your array via setCellText, you can then have a numeric only column sort correctly by simply setting the column to NUMBER format. However in order to set a NUMBER format, you must MUST first populate the cells via setCellData. Else Formatting won't work..
So the question is, when is it approiate to use:
What is the downside to always using setCellData?
(and last lastly as an example, why do formating and sorting require differnt methods?)