LB Booster
General >> General Board >> Spreadsheet for PNlawrence
http://lbb.conforums.com/index.cgi?board=general&action=display&num=1445698673
Spreadsheet for PNlawrence
Post by RNBW on Oct 24th, 2015, 2:57pm

I noticed in LB Conforums that you were looking at spreadsheet composition.

I just thought I'd bring to your notice some code that I developed with the help of Richard Russell that will run in LBB but not LB, at least partly because of the use of #maphandle.
The link in LBB conforums, where the whole thread goes into much more detail is:
Re: Variable Number Of Rows Of Texboxes
« Reply #23 on: Apr 15th, 2015, 3:55pm »

Hope it is of use to you.

Ray
Re: Spreadsheet for PNlawrence
Post by RNBW on Oct 24th, 2015, 3:01pm

Sorry, I didn't mention which section the link was in:

It's Liberty Basic Language.

Ray
Re: Spreadsheet for PNlawrence
Post by joker on Oct 24th, 2015, 4:56pm

Thanks, Ray. Very interesting reading. (I'm glad Richard is still hanging out here, too.)

I'll certainly be checking out the code for my program.
Re: Spreadsheet for PNlawrence
Post by joker on Oct 24th, 2015, 7:54pm

So, I see it is all derived from the "data grid" that Richard posted early on. Good stuff. Might work for me, too.
Re: Spreadsheet for PNlawrence
Post by RNBW on Oct 24th, 2015, 9:22pm

Yes. Richard was very helpful.
Re: Spreadsheet for PNlawrence
Post by RNBW on Oct 24th, 2015, 10:35pm

Richard also provided the following code in response to a query from me:

Code:
    number.of.rows = 8

    for row = 1 to number.of.rows
      for col = 0 to 4
        textbox #w.tb, 10+col*55, row*20, 55, 20
        maphandle #w.tb, "#w.tb";row;col
      next col
    next row
    open "Textbox grid" for window as #w
    #w.tb42 "Some text"
    wait


This was following posts in LB Conforums, where I was told that you can't use controls in loops. You can't in LB, but you can in LBB. After i investigated I found that it did everything that I wanted.

Ray