Author |
Topic: Spreadsheet for PNlawrence (Read 275 times) |
|
RNBW
Full Member
member is offline
Gender: 
Posts: 106
|
 |
Spreadsheet for PNlawrence
« Thread started 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
|
|
 Logged
|
|
|
|
RNBW
Full Member
member is offline
Gender:
Posts: 106
|
|
Re: Spreadsheet for PNlawrence
« Reply #1 on: Oct 24th, 2015, 3:01pm » |
|
Sorry, I didn't mention which section the link was in:
It's Liberty Basic Language.
Ray
|
|
Logged
|
|
|
|
joker
Global Moderator
member is offline
Gender:
Posts: 157
|
|
Re: Spreadsheet for PNlawrence
« Reply #2 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.
|
|
Logged
|
|
|
|
joker
Global Moderator
member is offline
Gender:
Posts: 157
|
|
Re: Spreadsheet for PNlawrence
« Reply #3 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.
|
|
Logged
|
|
|
|
RNBW
Full Member
member is offline
Gender:
Posts: 106
|
|
Re: Spreadsheet for PNlawrence
« Reply #4 on: Oct 24th, 2015, 9:22pm » |
|
Yes. Richard was very helpful.
|
|
Logged
|
|
|
|
RNBW
Full Member
member is offline
Gender:
Posts: 106
|
|
Re: Spreadsheet for PNlawrence
« Reply #5 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
|
|
Logged
|
|
|
|
|
