LiveCode Forums.

An update to my previous post, because I have really the bad feeling that Richmond is trying to burn all the work provided on this Library. What would be the relation between the fact that someone is not able to express itself correctly, and the quality of his work? Why reduce the Excel Lib to just ...

Thanks a lot Richmond, for the kindness of your remarks. This is always a pleasure to be part of a tolerant community. Fortunately, with the Bernd's help, Emmanuel contacted me directly by email with his question, because I'm not reading the forum very often. And oddly, more I'm coming here, less I ...

Hi Michael, You can update the content of a cell by using the SetDataOfIndex or SetDataOfLine commands of the datagrid API. Usage: 1. By using index reference SetDataOfIndex pIndex, pKey, pValue where pIndex if the index of the line, pKey is the name of the column and pValue is the value to update 2...

Hi Michael,

Note the DataGrid Helper plugin is capable of applying various Grand Total functions to a DataGrid

http://lessons.livecode.com/m/4068/l/85 ... l-function

This should work. Do your columns are named "id" and "client"? Don't confuse column name and column label. Try with a fresh datagrid and three new columns: Both codes: on selectionChanged local tLine, theDataA put the dghilitedline of me into tLine put the dgDataOfLine[tLine] of me into theDataA put...

Hi Gagsoft, Have a look to this lesson: http://lessons.livecode.com/m/datagrid/l/7313-how-do-i-get-data-associated-with-a-row-or-column Note the dghilitedline is returning the number of the selected line, not the content data of the corresponding row. You need to deal with the array notation for tha...

Another approach would consist in using the datagrid API http://lessons.livecode.com/m/datagrid/l/7313-how-do-i-get-data-associated-with-a-row-or-column put 1 into theLine put the dgDataOfLine[theLine] of group "European Currency Conversion table" into theDataA put theDataA["Column 41 "] into THE_VA...

For adding an empty row at the end of the datagrid, you can use: send "AddData" to grp "datagrid 1" Where "datagrid 1" is the name of your datagrid. For editing the first cell of the new added line you need 2 things: - the name of the first column - the number of the new added row For the name of th...

Because nobody answers to my post, I searched by myself... Probably because you was not in the right place for posting your question. :) This part of the forum is the place for questions about the "Data Grid Helper" Plugin, a commercial product for interfacing datagrids. Anyway, I just seen your qu...

Hi Bernd,

Thanks for your reply. I will think to all of that.
I had a look to the Hermann's widgets in HTML5. Very impressive result!

By the way, the better place where you will find me is in gardens.


Best Regards,

Hi Bernd, Thanks. I never thought to push and combine several lines to compose the script like with the do command. This is changing my approach of things. May be you might have other answers for me: If the exercice would consist to replace the Eleanor's library by another one, based this time on th...

I've just have a look to the Eleanor's calendar widget in comparison to my attempt, one year ago. Creating a calendar widget was my second exercice experience with widgets and here is a feedback in case it would be useful for the Team. 1. First I found the com.livecode.date library really poor for t...

"Destination out", ok thanks hh.

Thanks hh, This is exactly what I'm trying to create since 2015. With the label transparent. Very frustrating as I was far of the logic and far of the insetRect handler. I have some experience with dynamic SVG, was full of widget projects trying to adapt what I have already done in DSVG, but all my ...

[#50] Community LCB orientable text v1.0.0 A simple "orientable label" widget with the following parameters: - label - font name - font size - font color - background color - orientation - label opacity (a value from 0 to 1) - background opacity (a value from 0 to 1) My original intention was to pl...