dcsimg
Results 1 to 9 of 9
  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2012
    Posts
    986

    [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)

    This is the ActiveX Control version that comes out of the Std-EXE version.

    Current version: 1.1.6

    The development state of the ActiveX Control version does not necessarily match to the Std-EXE version.
    That comes because the Std-EXE version is the "leading source" and the ActiveX Control version is derived from the Std-EXE version after a certain time.
    Reason why is that it is not practicable to release a new ActiveX Control after each new feature.
    However, certain bugfixes can and will be implemented into the current ActiveX Control version. (Revision)

    It is not recommended to use the source code to compile another binary.
    If own modification is necessary please rename the library to avoid redundancies.
    The source code of the project can also be viewed on GitHub.

    All controls are marked as "Safe for Initialization and Scripting" by the IObjectSafety interface.

    Also everything is 100% IDE-Safe.

    Here is a solution to use the VBFLXGRD11.OCX Registration-Free. (Side-by-side)
    Keep in mind that this technology needs at minimum Windows XP SP2 or Windows Server 2003.

    Tutorial:
    The "Development" machine needs to register the VBFLXGRD11.OCX as usual and use the components for e.g. in a Std-EXE project.
    The source project needs to include the Side-by-side resources. (see below)
    Then on the "End user" machine you only need the VBFLXGRD11.OCX and the .exe (Std-EXE project) on the same folder.
    It will work then without any registration.

    The source code of "VBFLXGRD11SideBySide.res" is:

    Code:
    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">
       <file name="VBFLXGRD11.OCX">
          <typelib tlbid="{024E7654-EC20-495A-862B-08B52EF814CE}" version="1.0" flags="control" helpdir="" />
          <comClass clsid="{1A43B0CF-BC3B-46BA-A0C7-6A1FB8DFEF79}" tlbid="{024E7654-EC20-495A-862B-08B52EF814CE}" threadingModel="Apartment" progid="VBFLXGRD11.VBFlexGrid" />
          <comClass clsid="{37A45248-A7A3-491A-862C-CE0D7571A69A}" tlbid="{024E7654-EC20-495A-862B-08B52EF814CE}" threadingModel="Apartment" />
          <comClass clsid="{3E4E51A3-ADCD-4F12-B37B-4CC8E6FF4ADA}" tlbid="{024E7654-EC20-495A-862B-08B52EF814CE}" threadingModel="Apartment" />
       </file>
    </assembly>
    Attached Files Attached Files
    Last edited by Krool; Jul 9th, 2018 at 01:20 PM.

  2. #2
    Addicted Member
    Join Date
    Oct 2008
    Posts
    220

    Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)

    Hello Krool,
    I have just downloaded and tried your VBFlexGrid
    It is nice!
    However, using late-binding slows down the grid performance drastically compared to MSFlexGrid
    May I know the reason behind it? Also, what can be done to improve speed?

    The following code takes about 10 seconds to execute.( 10 times more than MSFlexGrid)
    Code:
    Dim objGrid As Object
    Dim w as Long
    
    Set objGrid = VBFlexGrid1 'Grid added in design
    
    With objGrid
        .Rows = 5000
        .Cols = 50
        For i = 0 To 4999
            For j = 0 To 49
                w = objGrid.ColWidth(j)
            Next j
        Next i
    End With

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2012
    Posts
    986

    Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)

    Update released to version 1.1

    Quote Originally Posted by winman View Post
    using late-binding slows down the grid performance drastically compared to MSFlexGrid
    Did you also try
    Code:
    Dim objGrid As VBFlexGrid
    instead of
    Code:
    Dim objGrid As Object
    ?

  4. #4
    Addicted Member
    Join Date
    Oct 2008
    Posts
    220

    Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)

    Yes, I did
    Here is the report of time taken in seconds for early bound and late bound VBFlexGrid and MSFlexGrid as in the code snippet below

    Case1: VBFlexGrid (early bound), time = 7.271313 s
    Case2: MSFlexGrid (early bound), time = 6.834063 s
    Case3: VBFlexGrid (late bound), time = 20.11294 s
    Case4: MSFlexGrid (late bound), time =7.252 s

    Code:
    Dim objGrid As VBFlexGrid   ' Case1
    
    'Dim objGrid As MSFlexGrid  ' Case2
    
    'Dim objGrid As Object  	 ' Case3
    'Set objGrid = VBFlexGrid1 ' Case3
    
    
    'Dim objGrid As Object	 ' Case4
    'Set objGrid = MSFlexGrid1  ' Case4
    
    
    Dim s as String
    
    With objGrid
        .Rows = 5000
        .Cols = 50
        For i = 0 To 4999
            For j = 0 To 49
                s = objGrid.TextMatrix(i,j))
            Next j
        Next i
    End With

  5. #5
    Addicted Member
    Join Date
    Oct 2008
    Posts
    220

    Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)

    Hi Krool,

    I have checked the new update. It is really good
    The new sort options and the row/column autofit features are awesome and very useful

    I have also checked the speed for the late bound grid in the latest update. It is found to be same as the previous update. We have managed to use early bound VBFlexGrid for now. Any improvements in speed for the late bound grid would be of great use for our requirements here.

    Thank you

  6. #6

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2012
    Posts
    986

    Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)

    Included LinkSwitch /OPT:NOWIN98 on the VBCompiler which reduced the file size of the OCX binary by about ~16KB

  7. #7
    Frenzied Member gibra's Avatar
    Join Date
    Oct 2009
    Location
    ITALY
    Posts
    1,537

    Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)

    I've add a Spread class (made by FlyGuy) for in-cell editing and formulas (Excel-like)
    It seems that it works very well!
    Attached Files Attached Files

  8. #8
    PowerPoster
    Join Date
    Oct 2013
    Posts
    3,133

    Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)

    Quote Originally Posted by gibra View Post
    I've add a Spread class (made by FlyGuy) for in-cell editing and formulas (Excel-like)
    It seems that it works very well!
    Hey thatís my nickname on XtremeVBTalk
    I bet you downloaded it from the FlexGrid functions thread.

  9. #9
    Frenzied Member gibra's Avatar
    Join Date
    Oct 2009
    Location
    ITALY
    Posts
    1,537

    Re: [VB6] ActiveX VBFlexGrid (Replacement of the MSFlexGrid control)

    Quote Originally Posted by Arnoutdv View Post
    Hey thatís my nickname on XtremeVBTalk
    I bet you downloaded it from the FlexGrid functions thread.
    Yes!
    Flexgrid functions - Xtreme Visual Basic Talk
    http://www.xtremevbtalk.com/code-lib...functions.html

    A lot of usefull routines.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width