DataGrid Helper 2.5 Preview

Moderators: heatherlaine, robinmiller, kevinmiller, Zryip TheSlug

teriibi
Posts: 252
Joined: Mon Nov 13, 2017 3:49 pm
Location: Bolivia

Re: DataGrid Helper 2.5 Preview

Post by teriibi » Wed Feb 14, 2018 1:31 am

..if any extra empty line meant for Category ordering is ever possible (!!!)
Would be a BIG PLUS
:1) saves column number.
2) Makes content presentation even clearer. (*see : Food types / Car brands )
Image

...well better stop now with great idea´s list !
:x :x :x
Attachments
cat grouping 2.png
cat grouping 2.png (6.65 KiB) Viewed 508 times
cat grouping.png
cat grouping.png (10.45 KiB) Viewed 508 times

Zryip TheSlug
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 133
Joined: Tue Jan 26, 2010 10:15 pm
Contact:

Re: DataGrid Helper 2.5 Preview

Post by Zryip TheSlug » Thu Feb 15, 2018 12:05 am

teriibi wrote:
Wed Feb 14, 2018 12:15 am
Sure looks really cool, already can see how I could use it... :idea: :wink:
..if then condition ...Col1 = Col2 + Col3 possible ?
..and count too ?!
(number of items in a column based on criteria count text, count numbers, count empty space., null...)
This is something to consider, but I have not the pretension to reinvent Excel or the rGrid control :), just to implement some script for doing basic calculation based of the feedbacks I received from DGH users.
But thanks for the suggestions. Will thought to this.
teriibi wrote:
Wed Feb 14, 2018 12:15 am
PS: if for small devices screen, I bet the navigation buttons would be very usefull. especially if you can freeze the first(s) columns (as well as the horizontal - Title line) :wink: :idea:
i.e, first column has students name : next columns on the rights side , contains notes for each month.
(scroll datas to the right...to see each month..Last column, sums up anual Average/number of exams yearly.
Originally the datagrid control has been developed for displaying datagrid records, not for creating spreadsheet, so freezing a column is not something we can do by using the datagrid API. This is like trying to fly with a car... This may possible with numerous workarounds but the result is not really convincing and safe.
However, for a DGH user I demonstrated a solution based on 2 synchronized datagrids, one emulating the freeze pane.
Freezing column.png
I'm not sure this is the better solution for accomplishing the task but this was a solution.
teriibi wrote:
Wed Feb 14, 2018 12:34 am
Would it be possible to customize a partial editing on selected columns like in 1 or 2 columns only.
In the datagrid API we have a property for locking columns (set the dgColumnIsEditable["Col 1"] of grp "datagrid 1" to false), so this is already possible without the need of DGH.
teriibi wrote:
Wed Feb 14, 2018 1:31 am
..if any extra empty line meant for Category ordering is ever possible (!!!)
DGH Properties Palette.png
DGH is using a datagrid table with two visible columns for displaying properties sorted by categories. At this time I've not found the convenient approach for translating this in a DGH features. Maybe one day when I will be inspired....

Anyway thanks for your suggestions Teriibi!
TheSlug
http://www.aslugontheroad.com - Tutorials, demo stacks and plugins for LiveCode
Data Grid Helper - An intuitive interface for building LiveCode's Data Grids
Excel Library- Extends the LiveCode language for controlling MS Excel

teriibi
Posts: 252
Joined: Mon Nov 13, 2017 3:49 pm
Location: Bolivia

Re: DataGrid Helper 2.5 Preview

Post by teriibi » Thu Feb 15, 2018 7:54 pm

Your welcome ,
Ive no programing background but I guess that adding a Category feature to a DataGrid view,
is like, Hiding the first column content / selecting the first value of each group / Display this value on top of the other columns content...and Voila ! :lol:
...how easy it is to code that - I have no clue about that !
Rrrrrsss :mrgreen:
Image
Attachments
cat group .png
cat group .png (28.41 KiB) Viewed 470 times

mrcoollion
Posts: 261
Joined: Thu Sep 11, 2014 1:49 pm
Location: The Netherlands

Re: DataGrid Helper 2.5 Preview

Post by mrcoollion » Sun Apr 08, 2018 9:51 am

Looking good,
Hope you are making good progress.
If you need someone to test let me know :mrgreen:

Kind regards,

Paul

Zryip TheSlug
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 133
Joined: Tue Jan 26, 2010 10:15 pm
Contact:

Re: DataGrid Helper 2.5 Preview

Post by Zryip TheSlug » Tue Apr 10, 2018 11:24 pm

Paul,

I'm still in the process to improve DGH, to test it and to provide a convenient documentation before the final release.

I've just finished to add a "Columns Picker" working with the new "Search / find" feature.
Attachments
Columns Picker Preview.png
TheSlug
http://www.aslugontheroad.com - Tutorials, demo stacks and plugins for LiveCode
Data Grid Helper - An intuitive interface for building LiveCode's Data Grids
Excel Library- Extends the LiveCode language for controlling MS Excel

Post Reply

Return to “Data Grid Helper”