Migration VB.6 to VB.NET

Posted by: tioz on 8 September 2017, 1:42 pm EST

  • Posted 8 September 2017, 1:42 pm EST

    Hi,

     

    we are migrating a vb.6 project to vb.net. We started with Spread 3.0 and now we ordered FarPoint Spread for Windows Forms 4 (.NET 3.5). Beside many problems with the vb6 -> vb.net migration, we also consider some issues with FarPoint. Some properties are renamed or do not exist anymore.

    Examples are MaxRows, ColWidth, Col2, SetText, Action, BlockMode, ...

     Is there any documentation how to handle those properties/methods?

     

    Kind regards,

    TioZ

  • Replied 8 September 2017, 1:42 pm EST

    There is a version comparison guide in the on-line help that will help you with this.  MaxRows is Rows.Count, use fpspread1.sheets(0).cells(0,0,5,5).Backcolor instead of blockmode and so on...
  • Replied 8 September 2017, 1:42 pm EST

    TioZ -

    There is an SpWinVerComp.pdf file that ships with the product that explains the differences.

  • Replied 8 September 2017, 1:42 pm EST

    You may also need this information from the 3.5 readme:

     

    The following properties are supported for backwards compatibility in Spread 3.5, but might not be supported in future versions. Please review your existing projects and update them according to the options described in the following table.

    Property    Instead use …
    Action    0 - Activate Cell
        1 - Go To
        2 - Select Block
        3 - Clear
        4 - Delete Col
        5 - Delete Row
        6 - Insert Col
        7 - Insert Row
        8 - Load
        9 - Save All
        10 - Save Values
        11 - Recalculate
        12 - Clear Text
        13 - Print
        14 - Deselect Block
        15 - Data Save
        16 - Set Border
        17 - Add MultiSel Blocks
        18 - Get MultiSel Blocks
        19 - Copy Range
        20 - Move Range
        21 - Swap Range
        22 - Clipboard Copy
        23 - Clipboard Cut
        24 - Clipboard Paste
        25 - Sort
        26 - Combo Clear
        27 - Combo Remove String
        28 - Reset
        29 - Select Mode Clear
        30 - VRefresh Buffer
        32 - Smart Print    SetActiveCell method
    ShowCell method
    SetSelection method
    ClearRange method
    DeleteCols method
    DeleteRows method
    InsertCols method
    InsertRows method
    N/A (was VBX only)
    N/A (was VBX only)
    N/A (was VBX only)
    ReCalc method
    ClearRange method
    PrintSheet method
    ClearSelection method
    DataSave method
    SetCellBorder method
    AddSelection method
    GetSelection method
    CopyRange method
    MoveRange method
    SwapRange method
    ClipboardCopy method
    ClipboardCut method
    ClipboardPaste method
    Sort method
    TypeComboBoxClear method
    TypeComboBoxRemoveItem method
    Reset method
    ClearSelection method
    VirtualRefresh method
    PrintSheet method

  • Replied 8 September 2017, 1:42 pm EST

    Thanks for the fast response & good support. I may ask more questions when I consider more problems ;-)
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels