If you formerly used the Spread version 3.5 ADO ActiveX control and now want to use the Spread version 8.0 ADO ActiveX control, complete the following steps.
![]() |
Note: Back up your project before making any changes. |
{F6F0030F-7A0D-4106-849A-264C2F6D4052}To:
{8E5109F0-F4FF-42E7-AF24-907A9D532476}
{EB9080DF-CA3B-4EDF-B515-27E0F2ED3AB6}To:
{29CCEDC9-B3FD-4376-A14B-F058E5271E6C}
long GetColHeaderDisplay(); void SetColHeaderDisplay(long); BOOL GetDisplayColHeaders(); void SetDisplayColHeaders(BOOL); long GetRowHeaderDisplay(); void SetRowHeaderDisplay(long); BOOL GetDisplayRowHeaders(); void SetDisplayRowHeaders(BOOL);Add to spreadsheet.cpp:
long CSpreadSheet::GetColHeaderDisplay() { long result; GetProperty(0x18, VT_I4, (void*)&result); return result; } void CSpreadSheet::SetColHeaderDisplay(long propVal) { SetProperty(0x18, VT_I4, propVal); } BOOL CSpreadSheet::GetDisplayColHeaders() { BOOL result; GetProperty(0x2c, VT_BOOL, (void*)&result); return result; } void CSpreadSheet::SetDisplayColHeaders(BOOL propVal) { SetProperty(0x2c, VT_BOOL, propVal); } long CSpreadSheet::GetRowHeaderDisplay() { long result; GetProperty(0x68, VT_I4, (void*)&result); return result; } void CSpreadSheet::SetRowHeaderDisplay(long propVal) { SetProperty(0x68, VT_I4, propVal); } BOOL CSpreadSheet::GetDisplayRowHeaders() { BOOL result; GetProperty(0x2d, VT_BOOL, (void*)&result); return result; } void CSpreadSheet::SetDisplayRowHeaders(BOOL propVal) { SetProperty(0x2d, VT_BOOL, propVal); }