[ANN] rGrid released.

[wilstrand]

Dear LiveCoders!
I'm proud to announce rGrid a spread sheet inspired grid control.
rGrid is open source with a commercial license available.

Main features:
• Professional level, high performance.
• Very customizable (for ex. text styles, colors, borders).
• Sorting fully featured
• Filtering fully featured
• Set ranges of values or properties.
• Use formulas
• Freeze rows and columns
• Click and Drag to hilite cells, rows, columns or a whole sheet.
• Click and Drag to change column widths and row heights.
• Consistent, readable syntax.
• Import .xlsx with companion product SpreadLib
• Additional controls (templates) easily inserted into cells and fully scriptable.
• No need to add any code to your stack.
• No need for “start using stack”.
• No extra stacks or templates created.

The basics:
Use button "Copy rGrid to Clipboard" in the rGridEngine, which copies a clean rGrid from card "Templates". Paste it into your stack. That’s all.

Click in cells and start typing (works for headers also).
Navigate through cells by Tab Return or Arrow Keys.

An rGrid can be thought of as using four new objects: Sheets, Rows, Columns and Cells.
Sheets, Rows and Columns can be referenced by ID or number.
Cells can be referenced by ID, number or in a spread sheet style.

Examples:

Code: Select all

set the '["backColor of cell A1"] of grp "rGrid" to "brown"
set the '["value of cell 1,1"] of grp "rGrid" to "Hello cell!"
get the '["htmlText of cell ID 1,1"] of grp "rGrid"

To work with ranges of cells:

Code: Select all

set the '["value of cell A1 to B2"] of grp "rGrid" to "A1;A2;B1;B2"

Use colon (:) to work with ranges and semicolon (;) to separate single cells in a single line of code:

Code: Select all

set the '["value of cell A1:C7;D12"] of grp "rGrid" to myList

To insert a control into a cell:

Code: Select all

set the '["template of cell A1"] of grp "rGrid" to the name of btn "MyTemplate"

Additional to the rGrid specific properties described in the rGrid Dictionary, you can also use LiveCode’s native properties where applicable. For example:

Code: Select all

set the '["backgroundColor of cell A1 to B2"] of grp "rGrid" to “green”
set the '["textStyle of row 1"] of grp "rGrid" to “bold”

To update and render rGrid you send a command like this:

Code: Select all

send "render" to grp "rGrid"

To clear the Grid from all data:

Code: Select all

send "clearGrid" to grp "rGrid"

All feedback is most welcome!
Please download rGrid from here: http://www.tapirsoft.com

With my best regards

Mats Wilstrand

[sturgis]

Hey, am messing with rGrid, looks pretty nice, and seems to be a happy middle between the table field and data grid. I did find a small bug so far (in the demo, not an rgrid error) where if you go to gallery, then cancel without making a file choice the cancel is not caught so a script error occurs. Other than that it works pretty well!


Thanks for making it available dual license also, your efforts are much appreciated!

[Simon]

Well Done Mats!

happy middle between the table field and data grid

Something very much needed.

Simon

[mwieder]

Mats-

I'm amused to see that you've found that you can start variable names with a single quote.
That's clever, but I really wish you'd change that because I'm hoping that with the open-source release we'll be able to use single- and double- quotes interchangeably.
It would make SQL queries and such so much easier.

Edit: but yes, congratulations on this release.

[wilstrand]

Sturgis, Simon and Mark

Thank you all for taking a look at rGrid and kind words! It's really appreciated!

Sturgis, thanks for finding that bug! It will be squashed in next version which will be released next week.

Mark, I'm aware that creating a custom property set with only an apostrophe could have implications.
Before release I therefor asked Ben at RR to have a look at the syntax and tell me if RR:
"think this is a suitable approach or if you see downsides?"
Ben answered:
"Your approach to the syntax looks good in my option and makes the best use of get/set props."
I also implemented cp, cData and cProp as synonyms to the apostrophe. I hope that
this all will be a non issue when we have the Open Language! When developing rGrid I tried to think as if we
already had the Open Language. So, If things turn out right, the only thing we should need to do with rGrid code
when the Open Language is implemented is to remove the apostrophe, double qoutes and square brackets!

Best regards
Mats

[mwieder]

So, If things turn out right, the only thing we should need to do with rGrid code
when the Open Language is implemented is to remove the apostrophe, double qoutes and square brackets!

Nice. You've thought this all out already.
I can't wait for the future to arrive.