Data Grid Helper 1.4.1 Formats your numbers
Sunday, 04 September 2011 00:22 | 
Written by The Slug | 
| 
| 
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 |
Last Updated (Friday, 16 September 2011 23:13)
Buy Two Get One FreeTuesday, 25 January 2011 23:00 | Written by The Slug | | |
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. Last Updated (Sunday, 10 July 2011 23:18) Data Grid Helper 1.3.4 Selects your columnsTuesday, 19 April 2011 00:22 | Written by 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.
Last Updated (Tuesday, 19 April 2011 13:48) Data Grid Helper 1.3.1 gives colours to your columns!Wednesday, 15 December 2010 00:22 | Written by The Slug | | |
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 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:
Last Updated (Thursday, 10 February 2011 22:00) Data Grid Helper 1.3.0 supports iOSWednesday, 15 December 2010 00:22 | Written by The Slug | | |
Add: 1. iOS support New iOS topic available in the properties palette with: - a ready to use script for managing an iOS scroller object linked to a datagrid First custom object available for the template area: the iOS Pick Wheel object. 2. New ready to use script for resizing a column depending of the length of its content by double clicking on the column separator. (Custom Header Behavior required) 3. New object in the classical objects topic of the template area: the line.
Last Updated (Tuesday, 25 January 2011 23:00) |
