If you formerly used the Spread version 3.0 ADO ActiveX control and now want to use the Spread version 8.0 Unicode ADO ActiveX control, complete the following steps.
![]() |
Note: Back up your project before making any changes. |
{D166EE70-4D87-11D2-B8B2-0000C00A958C}To:
{DE52502E-F837-492B-AE14-A182531AFAF4}
{35C82C71-7984-11D2-B464-00AA00B42B7C}To:
{6C30120B-5FF5-4352-8873-B8B2366348C2}
long GetAction(); void SetAction(long); unsigned long GetCellBorderColor(); void SetCellBorderColor(unsigned long); long GetCellBorderStyle(); void SetCellBorderStyle(long); short GetCellBorderType(); void SetCellBorderType(short); long GetDestCol(); void SetDestCol(long); long GetDestRow(); void SetDestRow(long); long GetMultiSelCount(); void SetMultiSelCount(long); long GetMultiSelIndex(); void SetMultiSelIndex(long); long GetPosition(); void SetPosition(long); long GetSelModeSelCount(); void SetSelModeSelCount(long); long GetSortBy(); void SetSortBy(long);Add to spreadsheet.cpp:
long CSpreadSheet::GetAction() { long result; GetProperty(0x1, VT_I4, (void*)&result); return result; } void CSpreadSheet::SetAction(long propVal) { SetProperty(0x1, VT_I4, propVal); } unsigned long CSpreadSheet::GetCellBorderColor() { unsigned long result; GetProperty(0xf, VT_I4, (void*)&result); return result; } void CSpreadSheet::SetCellBorderColor(unsigned long propVal) { SetProperty(0xf, VT_I4, propVal); } long CSpreadSheet::GetCellBorderStyle() { long result; GetProperty(0x10, VT_I4, (void*)&result); return result; } void CSpreadSheet::SetCellBorderStyle(long propVal) { SetProperty(0x10, VT_I4, propVal); } short CSpreadSheet::GetCellBorderType() { short result; GetProperty(0x11, VT_I2, (void*)&result); return result; } void CSpreadSheet::SetCellBorderType(short propVal) { SetProperty(0x11, VT_I2, propVal); } long CSpreadSheet::GetDestCol() { long result; GetProperty(0x29, VT_I4, (void*)&result); return result; } void CSpreadSheet::SetDestCol(long propVal) { SetProperty(0x29, VT_I4, propVal); } long CSpreadSheet::GetDestRow() { long result; GetProperty(0x2a, VT_I4, (void*)&result); return result; } void CSpreadSheet::SetDestRow(long propVal) { SetProperty(0x2a, VT_I4, propVal); } long CSpreadSheet::GetMultiSelCount() { long result; GetProperty(0x48, VT_I4, (void*)&result); return result; } void CSpreadSheet::SetMultiSelCount(long propVal) { SetProperty(0x48, VT_I4, propVal); } long CSpreadSheet::GetMultiSelIndex() { long result; GetProperty(0x49, VT_I4, (void*)&result); return result; } void CSpreadSheet::SetMultiSelIndex(long propVal) { SetProperty(0x49, VT_I4, propVal); } long CSpreadSheet::GetPosition() { long result; GetProperty(0x4d, VT_I4, (void*)&result); return result; } void CSpreadSheet::SetPosition(long propVal) { SetProperty(0x4d, VT_I4, propVal); } long CSpreadSheet::GetSelModeSelCount() { long result; GetProperty(0x77, VT_I4, (void*)&result); return result; } void CSpreadSheet::SetSelModeSelCount(long propVal) { SetProperty(0x77, VT_I4, propVal); } long CSpreadSheet::GetSortBy() { long result; GetProperty(0x7e, VT_I4, (void*)&result); return result; } void CSpreadSheet::SetSortBy(long propVal) { SetProperty(0x7e, VT_I4, propVal); }