Have the same worksheet’s events as its sibling and several others events like StartEdit, EndEdit and Support autofiltering and sorting although on a primitive level.
Support relative and absolute cell references as well as range names. Support nearly all functions that Excel provides including functions in Analysis Toolpak. We can’t make a lookup in one worksheet and place the result Worksheets through functions and references. Can only support one active worksheet, which limit the possibility to have interaction between If the control is populated with data from a data source then only the columns and rows in use are viewed. Each worksheet can contain up to 702 columns and 262144 rows. Unfortunately it can’t handle Excel’s files. The control can only handle one open workbook at the time. However the name is (to som extend) misleading as it’s a container for workbooks and the workbooks are containers of worksheets. The control is on its face identical to the worksheet object in Excel and the programming object model shows the same similarity.
0 kommentar(er)
