Example

The following example sets the fpSpreadPreview control's gray area to yellow, with margins of 180 twips. The sheet pages display three pages across and two pages down.

C++

// Connect fpSpread control to fpSpreadPreview control
m_Preview.SetHWndSpread(m_Spread.GetHWnd());
// Set background color to yellow, RGB(255, 255, 0)
m_Preview.SetGrayAreaColor(0x0000FFFF);
// Set gray area margins to 180 twips
m_Preview.SetGrayAreaMarginH(180);
m_Preview.SetGrayAreaMarginV(180);
// Show pages reflecting actual size
m_Preview.SetGrayAreaMarginType(GrayAreaMarginTypeActual);
// Show multiple pages in the control
m_Preview.SetPageViewType(PageViewTypeMultiplePages);
// Display three pages across and two pages down
m_Preview.SetPageMultiCntH(3);
m_Preview.SetPageMultiCntV(2);

Visual Basic

Sub Form_Load()
    ' Connect fpSpread control to fpSpreadPreview control
    fpSpreadPreview1.hWndSpread = fpSpread1.hWnd
    ' Set background color to yellow, RGB(255, 255, 0)
    fpSpreadPreview1.GrayAreaColor = &H0000FFFF&
    ' Set gray area margins to 180 twips
    fpSpreadPreview1.GrayAreaMarginH = 180
    fpSpreadPreview1.GrayAreaMarginV = 180
    ' Show pages reflecting actual size
    fpSpreadPreview1.GrayAreaMarginType = GrayAreaMarginTypeActual
    ' Show multiple pages in the control
    fpSpreadPreview1.PageViewType = PageViewTypeMultiplePages
    ' Display three pages across and two pages down
    fpSpreadPreview1.PageMultiCntH = 3
    fpSpreadPreview1.PageMultiCntV = 2
End Sub