[ANN] XLSX Library ready for a test - Looking for testers

zryip theSlug zryip.theslug at gmail.com
Thu Dec 1 14:34:33 EST 2016


Thanks for your feedback.

1. In my experience, the #### is due to the column width. When the
column is not large enough to display the content, instead of
truncating the number, the #### are displayed. The app sample is only
resizing the first column. I can apply a resize to the others columns.
2. Will have a look to the difference in cell content with Libre
Office. Thanks for the screenshot.
3. Will probably add a callback message inside XLSX_Range_Values_Set
and XLSX_Range_Styles_Set, to help inform about processing large data.


Thanks for the kind words and for the tests!

Best Regards,

On Thu, Dec 1, 2016 at 3:33 PM, Roger Eller <roger.e.eller at sealedair.com> wrote:
> Zyrip,
> The report looks similar in Excel 2010 (Win), and Libre Office 4.3 (Mac).
> Mac Preview didn't render any of the totals.
> I had to reduce the font size in Libre Office to have a similar appearance,
> otherwise the totals were shown as ####.
> There was one difference
> <https://dl.dropboxusercontent.com/u/54789013/differences.png> in cell
> content.
> And lastly, the sample executable should either show progress, or use a
> busy cursor when generating the report.
> VERY NICELY DONE!!  This library could be quite useful in business apps!
> ~Roger
> On Wed, Nov 30, 2016 at 6:36 PM, zryip theSlug <zryip.theslug at gmail.com>
> wrote:
>> Dear LiveCode Users,
>> We are working on a new Library capable to read / write / update xlsx
>> files without the help of MS Excel.
>> The Library is dealing natively with LiveCode (and the help of revXML
>> and revZip) with the Office Open XML format.
>> We are actually in alpha version and we have prepared a small
>> application for validating our capability to generate xlsx files
>> readable by every solution capable of opening an xlsx file: MS Excel
>> standalone or online, OpenOffice, LibreOffice, Google Sheets, etc
>> For extending our tests to different environments and applications we
>> are looking for some testers ready to help:
>> - by playing with our "Salestore report generator" application. Few
>> clicks are required for preparing the report + 30 secs to 1 minute,
>> the time for the Lib to create a report of about 700 lines * 8 columns
>> with styles and formulae.
>> - opening the generated xlsx file with the solution they have.
>> - reporting the result of their tests by dropping me a small note.
>> We have prepared different versions of our test application: linux,
>> mac and windows.
>> All the versions are available by following this link:
>> http://www.aslugontheroad.com/download/category/9-salestore-
>> report-generator-xlsx-lib-test
>> Thanks in advance for any help.
>> Best Regards,
>> --
>> Zryip TheSlug
>> http://www.aslugontheroad.com
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

Zryip TheSlug

More information about the use-livecode mailing list