Hi Hershel,
A possible solution consists to add this handler in the datagrid group
script:
*command* DG_ColorColumn pColName, pColor, pInk
* set* the opaque of grp pColName of me to (pColor is not empty)
set the backcolor of grp pColName of me to pColor
set the ink of grp pColName of me to
Dear Mark,
Due to this article, maybe?
https://livecode.com/xlsx-lib-a-bonus-library-included-with-excel-library-in-the-megabundle-offer/
On Sat, 3 Sept 2022 at 17:28, Mark Wieder via use-livecode <
use-livecode@lists.runrev.com> wrote:
> On 9/3/22 03:32, zryip theSlug via use-livec
Dear Mark,
Did you try the XLXS Lib instead of the Excel Lib?
On Sat, 3 Sept 2022 at 04:51, Mark Wieder via use-livecode <
use-livecode@lists.runrev.com> wrote:
> /sigh
> Got all excited about using the Excel Library for a new spreadsheet
> project and then discovered it doesn't work on linux,
Dear Matthias,
I do not have the answer but a possible workaround.
For debugging purposes I'm using the post message.
In LCB add this handler:
private handler throwWidgetError(in pError as String) returns nothing
post "catchWidgetError" with [pError]
end handler
Call it by using:
Dear LiveCode Users:
It has been a long time since I've come with something really new.
So, I'm pleased to announce our first widget generating one-dimensional
barcodes.
Here is the list of the barcodes styles supported:
- Code39
- Code128A, Code128B, Code128C
- EAN8, EAN13
- UPC-A, UPC-E
- ITF
hat was
> retrieved from a database and data that was entered but not yet stored. A
> datagrid is. Way overkill for what I’m doing, but the button that
> accesses the datagrid data to get the specific line is for testing only.
> >
> > William Prothero
> > https://earthle
Bill,
The example you mention is probably using a custom column behavior script
for accomplishing this.
Do you have copied the button in your project? The button must be linked to
your datagrid by using the following code:
set the dgProp["default column behavior"] of grp "myDatagrid" to the long
the datagrid columns and then filled in them with the
data.
Best Regards,
On Wed, May 6, 2020 at 2:42 PM Paul Dupuis via use-livecode <
use-livecode@lists.runrev.com> wrote:
> On 5/6/2020 7:58 AM, zryip theSlug via use-livecode wrote:
> > After each call to a column property such a
Paul,
After each call to a column property such as dgColumnWidth, the datagrid is
resized (header, column, rectangles, etc)
Instead of having them in the loop, prepare the column size, columns label,
etc and uses the table properties existing for setting all the values at
once. In this case the
The "Freeze pane" stack is available here:
https://www.aslugontheroad.com/download/category/4-lab
It demonstrates how to scroll, select and sort two datagrids synchronizaly.
On Thu, Mar 26, 2020 at 3:55 PM Paul Dupuis via use-livecode
wrote:
>
> On 3/26/2020 9:54 AM, zryip
Paul,
I have somewhere a stack demonstrating how to use a second datagrid
with the columns to freeze and how to synchronize this second datagrid
with the main datagrid when the rows are scrolled.
If you may interested I can share it.
On Wed, Mar 25, 2020 at 11:07 PM matthias rebbe via
Hi Klaus,
This should be "resetList"
*send* "resetList" to grp "datagrid 1"
Do you have a custom header script? You can check this by using this
command:
*put* the dgProp["default header behavior"] of grp "datagrid 1"
Best Regards,
On Wed, Nov 13, 2019 at 1:26 PM Klaus major-k via
Dear Livecode and DGH Users,
We have just released a new version of DGH!
New:
- Column header color and column color: - It is now possible to color
column headers (label and background) and column.
- The DGH_Properties script has changed to support columns colorization.
- Properties for
Ludovic,
Try:
on FillInData pData
if pData["email"] <> "" then show btn "sendmail" of me
else hide btn "sendmail" of me
end FillInData
On Wed, Feb 20, 2019 at 5:54 PM Ludovic THEBAULT via use-livecode <
use-livecode@lists.runrev.com> wrote:
> Hello,
>
> I have an address
Matthias,
A possible solution is to add an EditFieldText handler inside the datagrid
group script.
*command* EditFieldText pTheFieldEditor, pTheIndex, pTheCol
*end* EditFieldText
This message is invoked by the datagrid table prior to create the field
editor allowing to edit the cell.
Three
Henry,
I can confirm, the deleteLine behavior changed in dg2. Inside the dg2
library, deleteLine and deleteLines are different handlers now (deleteLine
is managing some animation now according to the comment I've seen in the
code). Inside dg1, deleteLine was just calling deleteLines.
Same remark
Marty,
You have to change the row template property of your datagrid to point it
to the template group located in your renamed substack.
set the dgProps["row template"] of grp "myDatagrid" to the long id of grp
"myGrpTemplate" of cd "myCardTemplate" of stack "myTemplateStack"
On Tue, Aug 28,
Dear List Members,
DGH 2.5.1 is now available.
New:
- Formulae Calculation: the installed script is now containing a new
handler: DGH_Formulae_RefreshAll. This handler is allowing to refresh the
calculation inside the datagrid. Call this function after having populated
an empty datagrid to have
Dear Swami,
Mobile scrollers should be natively added by the dg2 library when the stack
is executed inside a mobile device context. I've seen the corresponding
portion of code inside the dg2 library.
On Mon, Aug 20, 2018 at 5:09 PM, Sannyasin Brahmanathaswami via
use-livecode wrote:
> I am
the height of my custom
background. The margins between 2 rows are transparent, so I was able to
see the card's background without doing something specific with the
datagrid.
On Mon, Aug 6, 2018 at 9:03 PM, Sannyasin Brahmanathaswami via use-livecode
wrote:
> On 8/6/18 7:29 AM, zryip theSlug via
Bob,
A column template exists for each column of a dg table, so you can use any
control you want inside a datagrid column, including widgets.
Here is a link to a DGH's screenshot . On the left, we have properties for
a column (row or header). This is a datagrid table with two visible
columns.
The code you have in the default behavior is the one installed by the
inspector located in one of the behavior button (stack only script now,
since the dg2)
It contains the minimal example code to help the developer starting;
FillinData, preFillinData, LayoutControl, etc
If you are modifying the
A possible approach for updating only one row is described here:
Now, for some purpose, such as interacting with the row controls, it could
be interesting to have additional keys inside the data. Not I'm thinking a
click in a button is required in your case. But you might have the need to
hide or
Same remark than Mike, James and Jacque. When you have to change the value
of each row, populating the datagrid with a new data, seems to be the
better way to go.
Now for helping you with datagrids, I think you have to understand 2
importants concepts about datagrids:
- rows groups are created on
e explanation clear enough but if not,
> I'd be glad to expand on the subject.
>
> Thanks in advance.
> Doug
>
>
> > At $45.00 (cheap) and with your own endorsement (knowing that it is
> maintained)
> >
> > I'll get it!
> >
> > Brahmanatha
heap) and with your own endorsement (knowing that it is
> maintained)
>
> I'll get it!
>
> Brahmanathaswami
>
> Ps do you have a real name?
>
> On 8/2/18, 12:01 PM, "use-livecode on behalf of zryip theSlug via
> use-livecode" use-livecode@lists.runrev.com>
Dear Swami,
We have some free material about datagrids form or table.
1. A tutorial written long time ago before I created DGH, exploring the
very basic concepts of the datagrid control (form and table):
http://www.aslugontheroad.com/download/category/3-tutorials
2. Some demo stacks created for
Such as custom header templates? 8)
On Mon, Jun 25, 2018 at 5:50 PM, Tom Glod via use-livecode <
use-livecode@lists.runrev.com> wrote:
> thats a good tip for me as well..thanks Bob. you are right. looking at
> the handlers in there is pretty helpful, there may be a bunch of
> undocumented
Martin,
The already existing data grid controls will work directly with the new
library. You have nothing to change or to re-install. All the handlers,
functions or properties of the datagrid API are still existing in the dg2
Library even if they have been rewrote. The only problem I encounter
Hi,
I don't know if this would help, but I have native LC code for OAuth2
working with the google API on LC 8 and 9. I was using it with the google
calendar API in an experimental lib last year and the code still working.
Drop me a note and I could send you what I have.
On Thu, May 3, 2018 at
Dear LiveCode Users and more especially DGH Users:
A new major DGH 2.5 version is coming including lot of changes and features.
The list of changes would be to long if we have to be exaustive, so here is
some of the improvements we have in 2.5:
- widgets support in DGH template area
- dg2
We have nothing helpful for accomplishing that in DGH. But having a
look to the ColumnControlOfIndex function in the datagrid API could be
helpful:
http://lessons.livecode.com/m/datagrid/l/7344-data-grid-api
We have shared a stack demonstrating the usage of this function some
years ago. I just
I don't know, but you can create quickly and easily something similar,
for a test.
1. Create a new datagrid form
2. Populate it with some data, by using the inspector
3. By adding this script in a button, turn the datagrid in edit mode.
set the dgEditMode of grp "datagrid 1" to true
4. You
bbe.eu/>
>
>> Am 16.01.2018 um 21:32 schrieb zryip theSlug via use-livecode
>> <use-livecode@lists.runrev.com <mailto:use-livecode@lists.runrev.com>>:
>>
>> In the Excel Lib, the command XCEL_Range_FontStyle_Get is returning
>> the style of the who
In the Excel Lib, the command XCEL_Range_FontStyle_Get is returning
the style of the whole cell or range. We have no function to read the
style of each char, at this moment.
However, both VBA and AppleScript are offering this possibility, so
this is a function we can add. A possible solution would
Thanks to the logs shared, I was able to identify the problem with DGH
stoping the plugins loading process.
The problem is in the DGH_Help substack (the DGH documentation) which
the IDE is considering as locked. Don't ask me why, this is the only
substack in DGH which has a couple of properties
36 matches
Mail list logo
