Details

Published: 18 August 2022

Past year I met a team creating a big software using LiveCode. Among things I was surprised to see how they were creating barcodes using a javascript script and a web area.
Then, I looked around exploring the LiveCode forum and read about some technic such as using a special font, or creating barcode by grouping objects.

This gave me the idea to simplify this and to bring a new tool in the LiveCode developers toolbox.

Let me introduce the barcode generator widget:

Read more: Barcode Generator Widget 1.0.0 Ready for a Beta Test

Details

Published: 01 August 2022

In this version, we have fully rethought the XLSX_Range_Values_Set command.
It is now far quicker than previously.

We have also update the XLSX_Util_ExportData command for:
- more speed
- UTF-8 support

We fixed a memory leak.

And at last, we added a new XLSX_Range_Value_Set command dedicated to add single value in one cell.

Thanks a lot to Bernd Niggemann. He is in great help and good advices for optimizing things.

Details

Published: 23 July 2022

We still in the process to improve our XLSX Library:

We recently imprroved performances of the command XLSX_Range_Values_Set dedicated to export data from LiveCode as quickly as possible.
Some example of our test:
- 11 columns * 6700 rows in less of 2 seconds
- 4 columns * 21000 rows in less of 4 seconds (style and formulae included)

We have also a new command for changing row height
XSLX_Row_Height_Set

We were late to update the documentation. This now done and available.
Some of you reported also diffculties to download the version. We reorganised the download section and deleted the old XLSX Alpha version.

Here is the link to the XLSX 1.1.2

https://www.aslugontheroad.com/download/category/11-xlsx-library-for-livecode-beta-version

Keep also in mind the thing is actually in beta version. If something goes wrong, let's explore the issue and solve it.

Thanks!

Details

Published: 04 July 2022

After several attempts, hopes and deceptions, XLSX Lib is finally here!

This Lib capables to create new xlsx files and to import the content of any worksheet present in a xlsx file without the need of MS Excel on the device.

We have commands:
- to create new worksheets
- to export data in ranges or cells
- to format cells (color, style, background)
- to add fomula to a cell
- to change column width
- to read workbook data
- to read cell format or fomula

XLSX Lib is the little brother of Excel Lib, resourceful but limited. No pivot tables, no charts, no shapes, no old or exotic files format such as the old xls MS Excel format are availabled at this moment and will probably never come in the future. Using Applescript or Visual basic have some great avantages such as ensure the data imported will be conform to the Excel internal format. Doing this by hand trying to respect an often undocumented format is something made me hesitant to release a version. Selling that as a product and pretend the stuff is full reliable is something difficult to affirm in an objective point of view.
In the other hand the stuff seems to be capable of encouraging results and required a lot of work, resilience and passion.

This is a free solution for all whose bought the Excel Lib and needs to import or create xlsx files without the need of MS Excel install on devices.

For the reasons mentioned above, I'm hesistant to release it as an independant commercial product in the LiveCode Store. Maybe we will have this product here for a small amount of coins ($30 or $40 seems to be not excessive) to help update and support this Lib. Drop me a note if you may interested in helping with this and I will be able to take a final decision.

A free Lib is not a reason here, to not propose the best for potential users.

Here is a preview of what the Lib may capable in XLSX files creation:

As usually, we have also a documentation with ready to use examples:

And some examples stacks with opened code, we used to test, stress and benchmark the Lib:

1. A worbook viewer:

And a report generator:

Enjoy!

Details

Published: 11 June 2018

After some months of intensive work, we are happy to announce the final release of DGH 2.5. This version is fully compatible with LiveCode 8.x and 9.x, however due to the introduction of Widgets inside DGH, the version 2.5 is not working with LC 7.x and below. However in this case you can continue to use DGH 2.1.

In this DGH 2.5 version we have made numerous changes. Some of them are just cosmetics, but our main work in this version was to introduce new features such as:

• Properties for dg2 are now available.
• Data grid form: the templates introduced by dg2 are available.
• Form template: a new popup menu allows to choose whether to customize the classical row template or the new templates introduced by dg2.
• Widget controls are now supported.
• Now possible to customize the data grid table headers with controls (image, svg widget, checkbox), including the use of a svg icon for replacing the sort icons.
• Column calculation (formula and grand total).
• Spreadsheet behaviors: edit cell in one click, move through cells by using keyboard
• Now possible to define action buttons or fields.
• New search/find features available for forms and tables.

For more informations about DGH, how to purchase it or to upgrade to 2.5, please follow this link:

About DataGrid Helper (DGH) 2.5

And for a good preview of all the features and possibilities of DGH 2.5, please read our documention. Thanks to James Hale for his kind and great help with it:

Download the User Guide