I am using DOORS 9.4 to go through a module, and if I find an OLE at a certain spot,identified by a header that does not change, then I export this OLE to Excel.
I can list the module name in one cell, followed by the OLE.
However, if you look at the attachment, you will see that the OLE covers many additional cells.
How can I force the Excel cell to expand to fit the size of the OLE?
I already have the pixel size of the OLE, are there some perms that will allow me to do this?
This topic has been locked.
1 reply Latest Post - 2013-04-05T15:48:21Z by Gedinfo
Pinned topic How do I size an OLE to fit a cell in Excel?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-04-05T15:48:21Z at 2013-04-05T15:48:21Z by Gedinfo
Gedinfo 2700037HTW87 PostsACCEPTED ANSWER
Re: How do I size an OLE to fit a cell in Excel?2013-04-05T15:48:21Z in response to GedinfoI have found the VBA settings of RowHeight and ColumnWidth, which solved my problem.
By the way, there is a Microsoft restriction of 409 for row height. Any values greater than this cause the row to use the default value.