Results 1 to 19 of 19

Thread: RCFlexGrid Control (vbRichClient)

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2020
    Posts
    1,482

    RCFlexGrid Control (vbRichClient)

    Krool wrote a really great control, VBFlexGrid. For vbRichClient users, we also really needed a component like VBFlexGrid, so I rewrote Krool's VBFlexGrid with RC6.

    I developed RCFlexGrid (cwFlexGrid) for 3 purposes:

    (1) With the help of vbForums' experts, RCFlexGrid can be optimized and transformed into a grid control that is comparable in performance to Farpoint-Spread.

    (2) With the help of vbForums' experts, RCFlexGrid can provide very powerful and smooth input features/capabilities, so that the application scenarios of RCFlexGrid will be greatly expanded, for example, RCFlexGrid/VBFlexGrid can be used to simulate and replace RichTextBox and Excel.

    (3) Provide an example for vbRichClient users to rewrite GDI controls. Since we can use RC6 to rewrite the extremely complex VBFlexGrid, we can also use RC6 to rewrite Krool's ComCtls, so that we can have two sets of components at the same time: GDI-ComCtls and Cairo-ComCtls. My cloned VB6-IDE will use both sets of components.

    At present, RCFlexGrid only implements 90% of the features of VBFlexGrid, and RCFlexGrid has not been rigorously tested, and there are still many bugs in the current version, which need to be tested and fixed by vbRichClient enthusiasts. Any feedback, suggestions and guidance would be greatly appreciated.

    Note:
    RCFlexGrid provides a solution to integrate and use WinTheme in RC6.Cairo (maybe Olaf has a better way).


    Problems that need to be addressed by community experts and vbRichClient enthusiasts
    Code:
    (1) Reduce the number of draws (refreshes) of RCFlexGrid to the same as that of VBFlexGrid
    - RCFlexGrid draws (refreshes) too often, especially in the editing state. When the CellEditBox is moved from one cell to another, Focus will frequently switch between cwFlexGrid and CellEditBox, which causes the GotFocus event and LostFocus event of the cwFlexGrid and CellEditBox to be triggered frequently, which also causes the cwFlexGrid to have to be refreshed frequently, and the DrawGrid procedure of thousands of lines of code is called frequently.
    - Currently, the DrawGrid procedure is repeated 9 times each time the CellEditBox is moved from one cell to another. Although I could add some member-variables and conditional controls to reduce the DrawGrid call, even then the DrawGrid procedure will be called at least 3-4 times.
    - Krool's VBFlexGrid, on the other hand, will always only call DrawGrid procedure once when moving a CellEditBox from one cell to another.
    
    (2) Draw (refresh) a cell instead of drawing the whole grid
    - Currently, every time the DrawGrid procedure is executed, the entire grid is redrawn. If only draw (refresh) a certain number of cells that needs to be refreshed, then the drawing efficiency will be greatly improved.
    
    (3) Provide cell-level Owner-Drawn
    - 
    
    (4) Increase the performance of RCFlexGrid to a level comparable to that of Fapoint-Spread
    - At present, RCFlexGrid loads large data 3-8 times faster than VBFlexGrid, but further optimization of RCFlexGrid is still needed to further improve its performance.
    
    (5) Make RCFlexGrid the best alternative to RichTextBox
    Making RCFlexGrid the perfect alternative to RichTextBox will greatly expand the range of uses for RCFlexGrid.
    List of revisions:
    Code:
    15-Apr-2024
    - Add AppearanceStyle (Now RCFlexGrid has a similar appearance to Farpoint-Spread)
    
    13-Apr-2024
    - Removed a large number of unused Win32-APIs
      Add CellFlooding
      Add Grid WallPaper (When the wallpaper is exist, the merged cells are drawn abnormally)
    
    10-Apr-2024
    - First release.
    Attached Images Attached Images  
    Attached Files Attached Files
    Last edited by SearchingDataOnly; Apr 24th, 2024 at 05:34 AM.

  2. #2

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2020
    Posts
    1,482

    Re: RCFlexGrid Control (vbRichClient)

    Problems that need to be addressed by community experts and vbRichClient enthusiasts

    • (1) Reduce the number of draws (refreshes) of RCFlexGrid to the same as that of VBFlexGrid
      RCFlexGrid draws (refreshes) too often, especially in the editing state. When the CellEditBox is moved from one cell to another, Focus will frequently switch between cwFlexGrid and CellEditBox, which causes the GotFocus event and LostFocus event of the cwFlexGrid and CellEditBox to be triggered frequently, which also causes the cwFlexGrid to have to be refreshed frequently, and the DrawGrid procedure of thousands of lines of code is called frequently.

      Currently, the DrawGrid procedure is repeated 9 times each time the CellEditBox is moved from one cell to another. Although I could add some member-variables and conditional controls to reduce the DrawGrid call, even then the DrawGrid procedure will be called at least 3-4 times.

      Krool's VBFlexGrid, on the other hand, will always only call DrawGrid procedure once when moving a CellEditBox from one cell to another.

      (2) Draw (refresh) a cell instead of drawing the whole grid
      Currently, every time the DrawGrid procedure is executed, the entire grid is redrawn. If only draw (refresh) a certain number of cells that needs to be refreshed, then the drawing efficiency will be greatly improved.

      (3) Provide cell-level Owner-Drawn
      -

      (4) Increase the performance of RCFlexGrid to a level comparable to that of Fapoint-Spread
      At present, RCFlexGrid loads large data 3-8 times faster than VBFlexGrid, but further optimization of RCFlexGrid is still needed to further improve its performance.

      (5) Make RCFlexGrid the best alternative to RichTextBox
      Making RCFlexGrid the perfect alternative to RichTextBox will greatly expand the range of uses for RCFlexGrid.
    Last edited by SearchingDataOnly; Apr 24th, 2024 at 05:35 AM.

  3. #3

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2020
    Posts
    1,482

    Re: RCFlexGrid Control (vbRichClient)

    RCFlexGrid performance testing

    RCFlexGrid's properties and data structure are exactly the same as VBFlexGrid's, and without changing any of VBFlexGrid's data loading algorithms, RCFlexGrid loads large data 3-8 times faster than VBFlexGrid, I don't know why. Maybe it's because of the difference in the read/write efficiency between class-properties and usercontrol-properties.

    Attached is an example of my test of Krool's VBFlexGrid, please check it.
    Attached Files Attached Files
    Last edited by SearchingDataOnly; Apr 24th, 2024 at 05:35 AM.

  4. #4
    Fanatic Member
    Join Date
    Aug 2016
    Posts
    608

    Re: RCFlexGrid Control (vbRichClient)

    Is it just a demo using RC6?
    Full of bugs, nobody will use it. (I don't want waste my time to write details, because you even haven't yet done full test for this simple demo)
    Last edited by DaveDavis; Apr 11th, 2024 at 07:07 PM.

  5. #5
    PowerPoster
    Join Date
    Aug 2010
    Location
    Canada
    Posts
    2,466

    Re: RCFlexGrid Control (vbRichClient)

    Quote Originally Posted by DaveDavis View Post
    Is it just a demo using RC6?
    Full of bugs, nobody will use it. (I don't want waste my time to write details, because you even haven't yet done full test for this simple demo)
    That's a bit harsh I think considering this:

    Quote Originally Posted by SearchingDataOnly View Post
    RCFlexGrid has not been rigorously tested, and there are still many bugs in the current version, which need to be tested and fixed by vbRichClient enthusiasts. Any feedback, suggestions and guidance would be greatly appreciated.
    Most doubted that SDO would ever release any concrete code. Now here it is, and I think it should be given a fair shake. IMO it's better to waste time writing details of what you didn't like/what didn't work than to waste time writing that you won't waste time.

  6. #6
    PowerPoster wqweto's Avatar
    Join Date
    May 2011
    Location
    Sofia, Bulgaria
    Posts
    5,233

    Re: RCFlexGrid Control (vbRichClient)

    They probably don't want to waste their time but instead work and polish all of their submissions to CodeBank. . . Don't stop these people from contributing here with your half-baked codes :-))

    cheers,
    </wqw>

  7. #7

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2020
    Posts
    1,482

    Re: RCFlexGrid Control (vbRichClient)

    Deleted ...
    Last edited by SearchingDataOnly; Apr 15th, 2024 at 08:46 AM.

  8. #8

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2020
    Posts
    1,482

    Re: RCFlexGrid Control (vbRichClient)

    Deleted ...
    Last edited by SearchingDataOnly; Apr 15th, 2024 at 08:47 AM.

  9. #9
    PowerPoster wqweto's Avatar
    Join Date
    May 2011
    Location
    Sofia, Bulgaria
    Posts
    5,233

    Re: RCFlexGrid Control (vbRichClient)

    Quote Originally Posted by SearchingDataOnly View Post
    Would you consider Krool's release of ComCtls in 2012 to be half-baked code?
    Would you consider Krool's VBFlexGrid release in 2017 to be half-baked code?
    Would you think that twinBasic is half-baked code?
    Are you operated from sense of humor or your understanding of English language is lacking?

    Satire -- go check the meaning of this word. And it's not your work which is getting ridiculed here if you read the thread more carefully.

    Admin action required: go cleanup the humor, it's not getting accross.

    cheers,
    </wqw>

  10. #10

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2020
    Posts
    1,482

    Re: RCFlexGrid Control (vbRichClient)

    Quote Originally Posted by wqweto View Post
    Are you operated from sense of humor or your understanding of English language is lacking?

    Satire -- go check the meaning of this word. And it's not your work which is getting ridiculed here if you read the thread more carefully.

    Admin action required: go cleanup the humor, it's not getting accross.

    cheers,
    </wqw>
    I see that your comment in post#6 is mocking and sarcastic, am I misunderstood?

  11. #11
    Frenzied Member VanGoghGaming's Avatar
    Join Date
    Jan 2020
    Location
    Eve Online - Mining, Missions & Market Trading!
    Posts
    1,543

    Talking Re: RCFlexGrid Control (vbRichClient)

    Quote Originally Posted by SearchingDataOnly View Post
    I see that your comment in post#6 is mocking and sarcastic, am I misunderstood?
    It wasn't addressed to you!

  12. #12

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2020
    Posts
    1,482

    Re: RCFlexGrid Control (vbRichClient)

    Quote Originally Posted by VanGoghGaming View Post
    It wasn't addressed to you!
    Why did I think wqweto was mocking me? For the first time, I had doubts about my ability to read English. Until now, I still don't seem to be able to understand what wqweto meant.

    It took me three weeks to rewrite VBFlexGrid with RC6, which is not an easy task for someone who is extremely busy at work and in getting worse health. So when I saw the aggressive words and the mocking words, I felt very angry.

  13. #13
    Frenzied Member VanGoghGaming's Avatar
    Join Date
    Jan 2020
    Location
    Eve Online - Mining, Missions & Market Trading!
    Posts
    1,543

    Red face Re: RCFlexGrid Control (vbRichClient)

    Well, neither of you is a native English speaker (nor am I for that matter) so subtle nuances can sometime escape our grasp.

  14. #14

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2020
    Posts
    1,482

    Re: RCFlexGrid Control (vbRichClient)

    Quote Originally Posted by VanGoghGaming View Post
    Well, neither of you is a native English speaker (nor am I for that matter) so subtle nuances can sometime escape our grasp.
    Yes, but I should apologize to wqweto anyway. I've seen wqweto's sarcastic comments about me many times before, and maybe many of them were due to my misunderstandings.

  15. #15

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2020
    Posts
    1,482

    Re: RCFlexGrid Control (vbRichClient)

    Update released.

    - Removed a large number of unused Win32-APIs
    - Add CellFlooding
    - Add Grid WallPaper

    Note:
    When the wallpaper is exist, the merged cells are drawn abnormally.
    This issue will be left for a later date (Or rather, it should be left to the vbRichClient enthusiasts in the community to figure it out)
    Last edited by SearchingDataOnly; Apr 13th, 2024 at 07:23 AM.

  16. #16

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2020
    Posts
    1,482

    Re: RCFlexGrid Control (vbRichClient)

    At present, only three features of RCFlexGrid have not yet been added, which are Cell-Tooltip and Scroll-Tip and Dropdwon-Calendar. But these three features are not urgently needed, and I plan to defer them until later, maybe in the future I will provide a rich text Cell-Tooltip.

    That said, with RCFlexGrid, what I was able to do was basically done. The rest needs to be done by vbForums experts and vbRichClient enthusiasts. I'll continue my job: scripting language compiler and Cloned-VB6IDE.
    Last edited by SearchingDataOnly; Apr 13th, 2024 at 07:22 AM.

  17. #17

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2020
    Posts
    1,482

    Re: RCFlexGrid Control (vbRichClient)

    Update released.

    - Add AppearanceStyle property. Now RCFlexGrid has a similar appearance to Farpoint-Spread.
    Last edited by SearchingDataOnly; Apr 15th, 2024 at 08:49 AM.

  18. #18

  19. #19

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2020
    Posts
    1,482

    Re: RCFlexGrid Control (vbRichClient)

    Thank you, wqweto. I used to sign up for a GitHub account a few years ago, but I never used it. Now, not only have I forgotten the password for my account, but I don't even remember the name of my account. In six months, I'll have a major product launch, at which point I'll be re-signing up for a GitHub account and building my own website.

Posting Permissions

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



Click Here to Expand Forum to Full Width