Suggestion/Functionality - Office Workbook/Worksheet to have similar operations as other components.

Geoff Darst of the VSTO team suggested that I post this suggestion here:

When clearing is required on other controls such as textboxes, one can simply call clear to clear the whole box. There is a similiarity found on other controls or even class components where the ability to clear the whole item is acheivable without defining specifics of what to clear. That similiarity ends with the classes that handle the operations found with dealing with's Office's Excel.

To clear an Excel Page one has to define a region, pass that info to the target object and then call its ClearContents. I feel it would make sense to have a clearcontents (or a different call such as a ClearAll) that when no region is defined (or has to be defined), allow for the whole sheet or workbook be allowed to be cleared. That action with give it the patterned similarity of other Microsoft Components.

Thanks for your time.

<Original Post on the VSTO forum>

Answer this question

Suggestion/Functionality - Office Workbook/Worksheet to have similar operations as other components.

Carl Meek

The best way to get your suggestions to the VC++ team is through the product feedback center at http://lab.msdn.microsoft.com/productfeedback/default.aspx

Thanks in advance for taking the time to report your suggestion!

Thanks,

Ayman Shoukry

VC++ Team
Suggestion/Functionality - Office Workbook/Worksheet to have similar operations as other components.

Answer this question