A Slug On the Road

A new "Format" topic has been added in the column builder's properties. This topic adds 3 DGH's special properties for the
datagrid object:
- the format pattern
- the thousands separator
- the decimal separator

The pattern property allows the definition of three patterns separated by commas:
- one for positive numbers
- one for negative numbers
- one for zero values

This pattern supports the following symbols:
- spaces: separator (replaced by the thousands separator property)
- # Digit placeholder. This code does not display extra zeros.
- 0 Digit placeholder. This code pads the value with zeros to fill the format.
- . Decimal number (replaced by the decimal separator property)
- $ - + / ( ) :
- [color] where color is any color name supported by the LiveCode syntax.

A format, only changes the way a number is displayed in the column. The corresponding number remains unchanged in the data. This means one
can continue sorting a column or editing the full number, as if the format was not existing in the cell.

For more informations about this feature please read these three lessons:

- How Do I Format a Number In a Column?

- How Do I Create a Formatting Pattern for a Column?

- How Do I Change the Number Format of a Column By Script?

 

######0.00,(######0.00)	### ##0.00[blue],-### ##0.00[red]	$### ##0.00,$#####0.00[red],$0.00

July is the month for Saving Time, Money and Effort.

LiveCode, our partner, has a special offer in its store: Pay two 3rd party addons and add a third addon for free in your basket.

Our plugin Data Grid Helper, is ready to be one of this three, and why not the free one? 

 

For joining the LiveCode store, click on our partner banner  on the right of this home page.

 

Best July,

The Slug.

Add

New ready to use script avaible, for column selection. Column selection makes the datagrid behave like any spreadsheet when one click on column header.
To have the script working properly, you must comment or delete the dgHilite property and the mouseUp handler of the standard header behavior script.

Fix

Fix a bug with the sort by column local menu. The menu was not properly working.

Change

The DGH's data substack is renamed DGH_Data to insure compatibility with possible existing project.

Add:

This version of DGH adds properties for coloring columns (alternating color, color for not editable column).
The column properties topic of DGH allows to define these new properties directly in the DGH interface.
The new column properties are persistent, so no need to define them every time you open the datagrid card!

The properties are also scriptable with a couple of special new datagrid keywords:

- Alternate column colors
- Column Color
- Alternate Column Color
- Not Editable Column Color
- Column Ink

And we have a DGH syntax to set them:

set the dghProp[pDGHProperty] of myDataGrid to pValue

 

Preview of a DataGrid with a special color for two not editable columns:

Preview of a DataGrid with an alternated color:

 

Change:

The custom sort column script comes now with more indications for the usage of SortDataByKey.