Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Building a form with a speadsheet grid (Visual Basics 2005 Express)

    Hello,

    I am new to the VB studio program and playing with it,

    So i am trying to build a grid like a spread sheet and want to add a few formulas in the columns which calculate. How do i add the formulas to a column?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Building a form with a speadsheet grid (Visual

    Hi Seaner

    I think it best you research the flexigrid control as starter for 10. This mimics the look and feel of a grid.....it will not be a spreadsheet but it will hold data in it that the code creates
    Jerry

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Building a form with a speadsheet grid (Visual Basics 2005 Express)

    If you don't mind, I'm going to move this thread to .Net, which is where VB 2005 questions belong. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Charlotte

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Building a form with a speadsheet grid (Visual Basics 2005 Express)

    The best (and easiest) way to display grid data in the .NET world is with the DataGrid control (for 1.1, or the GridView control for 2.0).

    To get formulas in the grid, you'll actually have to add the formulas to the data source that populates the grid. You can do this either in the original data source, or within the code that manipulates the data prior to stuffing it in the grid. However, there's no easy way to emulate Excel functionality that allows a user to enter their own formulas into the grid. Also, keep in mind that the grid is based on data fields and records (like Access), not columns and rows (like Excel).

    You'll want to use Google for the exact details on how to work with data controls. If you're new to .NET, this may take quite a bit of work...

Posting Permissions

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