Resizing the Excel OLE object in DOORS

How to Resize an Excel OLE object in DOORS

Problem/Issue :
When an Embedded Excel OLE object is inserted in to a Requirement(Object), the size cannot be changed as the inApp-Edit is not possible for Excel-OLE.
When new column or rows are included, the view area is not increased automatically.


Solution : 
Unlike the other OLE object, we can edit the excel only in Excel Window, not in the DOORS module window.

Check out the below explanation in IBM-Support:
http://www-01.ibm.com/support/knowledgecenter/SSYQBZ_9.6.1/com.ibm.doors.requirements.doc/topics/t_activateoleobjects.html

Follow the below steps to resize :






1. Double click to enter the Requriement.
2. Select the Excel OLE object
3. Double Click the Excel OLE Object. An Excel Window will be opened to edit the OLE object.
4. Now without closing the Excel window, move to the DOORS module window by ALT+TAB
5. Now the OLE object is displayed in shaded mode with size Handlers (Square pointer on all corners and side)
6. Use the selector to size the OLE object.
Note : Enable the cell boundaries in Excel to resize to the cell borders.