.
...
Table of Contents | |
|---|---|
|
Use InsertRows/Columns
...
Instead of InsertRow/Column
Why this might happen:
- Someone is adding multiple rows into a template file yet is unaware that both InsertRow and InsertRows are legitimate functions (same with InsertColumn(s)).
...
- If adding more than just one or two rows, use InsertRows/InsertColumns instead of looping through InsertRow/Column multiple times.
- InsertRow/Column can still be used, but as grid updates are expensive, they should be retained only for calls of one or two new lines.
Avoid
...
Calling AutoFitWidth on a
...
Large Amount of
...
Data
Why this might happen:
- As AutoFitWidth sets the width of a column to just beyond the length of the longest cell, and as such can be seen as a very simple way to format items.
...