Topic
1 reply Latest Post - ‏2013-04-05T15:48:21Z by Gedinfo
Gedinfo
Gedinfo
87 Posts
ACCEPTED ANSWER

Pinned topic How do I size an OLE to fit a cell in Excel?

‏2013-04-03T21:23:42Z |
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?

Thank you.
Updated on 2013-04-05T15:48:21Z at 2013-04-05T15:48:21Z by Gedinfo
  • Gedinfo
    Gedinfo
    87 Posts
    ACCEPTED ANSWER

    Re: How do I size an OLE to fit a cell in Excel?

    ‏2013-04-05T15:48:21Z  in response to Gedinfo
    I 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.