Inplace Excel

 

perhaps you need a bit more information and the sample code.

I develop with the XTP version 12.1.1 VS6 SP6 OS XP SP2.

I attach two projects both created with the Application Wizzard, one standard and one with the

XTP template (two more steps). I modified the CtrlItem class and the View class in both, so that at

the start Excel will be loaded inplace. In the standardproject everthing works fine in the XTP project

the Excel menu is visible but all items are disabled. The strange thing is, if I modify the OnSetMenu

function of the CtrlItem an set the menu of the main frame in the old style I will get two menus and

the new one will work.

 

void CTstConCntrItem::OnSetMenu(CMenu* pMenuShared, HOLEMENU holemenu, HWND hwndActiveObject)
{
   COleClientItem::OnSetMenu(pMenuShared, holemenu, hwndActiveObject);

// uncomment this line and the new menu will work
// thisMainFrm.SetMenu(pMenuShared);
}

 

Any ideas...

 

If I load a skin via XTPSkinManager()->LoadSkin I can see the menu,

but the submenus didn't work. If i use the style

 

  XTPSkinManager()->SetApplyOptions(xtpSkinApplyFrame|xtpSkinApplyColors|xtpSkinApplyMetrics|xtpSkinApplyMenus);

the submenus become visible but didn't work.

 

Thomas

 

This works

 

This menu don't work (nothing happens if you select a item)...

I found another hint. It's not a really a workaround, because on some menu commands

(eg Edit-Delete-All) Excel crashes in the background, but the most commands woks fine.

I implement the WindowProc function in my CMainFrame class like this

 

LRESULT CMainFrame::WindowProc(UINT message, WPARAM wParam, LPARAM lParam)
{
    if(message == WM_COMMAND)
    {
        CMDIChildWnd* pChild = (CMDIChildWnd*)GetActiveFrame();
        if(pChild)
        {

            CView* pView = pChild->GetActiveView();

            ASSERT_VALID(pView);
            // dispatch the WM_COMMAND messages to the Excel inplace
             if(pView->IsKindOf(RUNTIME_CLASS(CExcelView)))
                ::PostMessage(((CExcelView*)pView)->GetInplaceWnd(), message, wParam, lParam); 

        }

   }

   return CMDIFrameWnd::WindowProc(message, wParam, lParam);
}

 

Perhaps this could help you...Thomas