Roger, 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. Jim, Thanks for the kind words and for the tests! Best Regards, On Thu, Dec 1, 2016 at 3:33 PM, Roger Eller <roger.e.el...@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.thes...@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@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 http://www.aslugontheroad.com _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
