Re: Reading from xls or xlsx - with style

2018-01-16 Thread Richmond Mathewson via use-livecode
If you could find a way to export a tab-delimited RTF file from your spreadsheet program you might be laughing. Richmond. On 16/1/2018 10:54 pm, Richmond Mathewson wrote: Open Office can read Excel files and successfully export them to .html preserving ALL formatting! As Open Office is open

Re: Reading from xls or xlsx - with style

2018-01-16 Thread Richmond Mathewson via use-livecode
If you export html from Open Office Calc / Excel, then import it into a textfield, and then move it into a Basic Table Field like this: set the columnDelimiter to TAB set the htmlText of fld "fSPREAD" to the text of fld "fTEXT" where field "fSPREAD" is a table field all the styling from your

Re: deploying to multiple mobile devices

2018-01-16 Thread J. Landman Gay via use-livecode
On 1/16/18 2:22 PM, Nicolas Cueto via use-livecode wrote: Some of my stacks are for a classroom situation, so would like to deploy to the various smartphones of class sizes of 3 to 20 students (1) preferably cable-free (Wifi?), (2) easily for the end-user, and (3) as simultaneously as

Re: Reading from xls or xlsx - with style

2018-01-16 Thread Matthias Rebbe via use-livecode
As i wrote “ at least i am not aware of it” ;) good to know. That this is possible. Btw.: Do you know if it is also possible to read/get the tooltip of a cell of better said of a range of cells? Regards Matthias Matthias Rebbe Tel +49 5741 31 ‌https://matthiasrebbe.eu

RE: deploying to multiple mobile devices

2018-01-16 Thread Ralph DiMola via use-livecode
Copying the apk to the server and sending the email is a manual operation but could be added to AirLaunch? Just to add to what JLM said. I ran into this problem last night after a call from some testers. Installing on the device can now be a little trickier if the Chrome browser is installed. The

OT: Idiot UX

2018-01-16 Thread Mark Wieder via use-livecode
https://boingboing.net/2018/01/16/bad-design-this-is-the-menu-w.html From the comments: * Acronym stew * Not alphabetized * No clear separation between “production” and “test” messages * Arbitrary classifications * Arbitrary word ordering * No distinction of event severity * Wall of text

Re: Reading from xls or xlsx - with style

2018-01-16 Thread Richmond Mathewson via use-livecode
It is amazing how many online xls to html converters are available . . . if only one could get at their code . . . This loooks a bit "dicky" as it is either to a barebones html file and a load of connected files or to something called an .mht or .mhtml file. Here's something else:

Re: Reading from xls or xlsx - with style

2018-01-16 Thread zryip theSlug via use-livecode
In the Excel Lib, the command XCEL_Range_FontStyle_Get is returning the style of the whole cell or range. We have no function to read the style of each char, at this moment. However, both VBA and AppleScript are offering this possibility, so this is a function we can add. A possible solution would

Re: Reading from xls or xlsx - with style

2018-01-16 Thread Richmond Mathewson via use-livecode
Open Office can read Excel files and successfully export them to .html preserving ALL formatting! As Open Office is open source code . . . . https://www.openoffice.org/ I have just imported a styled .html file exported from an Open Office Spreadsheet into a textField in LiveCode 7.1.4

deploying to multiple mobile devices

2018-01-16 Thread Nicolas Cueto via use-livecode
Some of my stacks are for a classroom situation, so would like to deploy to the various smartphones of class sizes of 3 to 20 students (1) preferably cable-free (Wifi?), (2) easily for the end-user, and (3) as simultaneously as possible. On Mac and for iOS, it seems the best (only?) choice is

Re: Naive Question time again

2018-01-16 Thread Richmond via use-livecode
Because I want to play "silly games" swapping engines around. Richmond. On 16.01.2018 01:07, Tom Glod via use-livecode wrote: i'm curious why you need to know that On Mon, Jan 15, 2018 at 3:49 PM, J. Landman Gay via use-livecode < use-livecode@lists.runrev.com> wrote: On 1/15/18 1:03

Re: use-livecode Digest, Vol 172, Issue 22

2018-01-16 Thread Mark Waddingham via use-livecode
On 2018-01-11 20:50, Richard Gaskin via use-livecode wrote: Richard Burkett wrote: Nice, but not as nice as: copy I appreciate that we have the flexibility to do arcane things with the Clipboard when needed, but shouldn't the copy command handle the most common cases without requiring new

Re: use-livecode Digest, Vol 172, Issue 22

2018-01-16 Thread Mark Waddingham via use-livecode
On 2018-01-16 05:13, Brian Milby via use-livecode wrote: The code for MacOS is simpler (the 2 put's following the itemdel are not needed, the format name is "public.html", not sure about Linux). I copied the above code in LC and then clicked the button to fix it before pasting here.

Dropbox help

2018-01-16 Thread Klaus major-k via use-livecode
Hi freidns, now I created a new "app" at my Dropbox account and received an app ID and an app "secret". Now I want to simply upload a file to my dropbox but what on earth has the infamous "pAccessToken" to do with the app ID and app "secret"? If nothing where can I get my "pAccessToken"? ...

Re: Dropbox help

2018-01-16 Thread Mike Kerner via use-livecode
Klaus, The good news is that this is all fairly straightforward. appKey, appSecret, tokenKey, and tokenSecret are all obsolete and should not do anything. You need the “Generated Access Token”. 1) Go to www.dropbox.com/developers/apps 2) Tap on your app 3) Scroll down to the “Generated access

Reading from xls or xlsx - with style

2018-01-16 Thread Ben Rubinstein via use-livecode
I'm aware that there are a couple of libraries floating around for reading Excel documents - do any of them allow the formatting of runs of text within cells to be read? I want to import some data where some of the text in a cell may contain some parts which are in italics or bold. Are there

Re: Reading from xls or xlsx - with style

2018-01-16 Thread zryip theSlug via use-livecode
Matthias, if by tooltip, you meant the comment associated to a cell, yes this is something potentially possible, too. On Tue, Jan 16, 2018 at 9:52 PM, Matthias Rebbe via use-livecode wrote: > As i wrote “ at least i am not aware of it” ;) > > good to know. That

Re: Roadmap: "Automated REST API wrapping"?

2018-01-16 Thread Mike Kerner via use-livecode
This was discussed at LCG but I'll get the month wrong - August? On Tue, Jan 16, 2018 at 9:40 PM, Richard Gaskin via use-livecode < use-livecode@lists.runrev.com> wrote: > The LC Roadmap at includes > under "Planned": > > Automated REST API wrapping >

Re: deploying to multiple mobile devices

2018-01-16 Thread Richard Gaskin via use-livecode
Nicolas Cueto wrote: > Some of my stacks are for a classroom situation, so would like to > deploy to the various smartphones of class sizes of 3 to 20 students > (1) preferably cable-free (Wifi?), (2) easily for the end-user, and > (3) as simultaneously as possible. Is this a classroom you

Re: Roadmap: "Automated REST API wrapping"?

2018-01-16 Thread Richard Gaskin via use-livecode
Mike Kerner wrote: > On Tue, Jan 16, 2018 at 9:40 PM, Richard Gaskin wrote: > >> The LC Roadmap at includes >> under "Planned": >> >> Automated REST API wrapping >> >> Sounds enticing. What is it? >> And is there even a loose,

Re: deploying to multiple mobile devices

2018-01-16 Thread Nicolas Cueto via use-livecode
> Is this a classroom you work with directly, or a product for others to use in their own classrooms? Directly. On 17 January 2018 at 12:38, Richard Gaskin via use-livecode < use-livecode@lists.runrev.com> wrote: > Nicolas Cueto wrote: > > > Some of my stacks are for a classroom situation, so

Roadmap: "Automated REST API wrapping"?

2018-01-16 Thread Richard Gaskin via use-livecode
The LC Roadmap at includes under "Planned": Automated REST API wrapping Sounds enticing. What is it? And is there even a loose, no-I-won't-hold-you-to-it-but-just-curious target version? If it's what I think it is it may be a real boon to

Sending from mobile hotspot to WLAN enabled IoTs

2018-01-16 Thread Pyyhtiä Christer via use-livecode
Is there any way in LiveCode to direct the mobile device (Android / iOS) to send calls to WLAN enabled IoT devices. For example to detect such devices? Christer Pyyhtiä MindCrea Ltd chris...@mindcrea.com ___ use-livecode mailing list

Re: Reading from xls or xlsx - with style

2018-01-16 Thread Curry Kenworthy via use-livecode
Ben wrote: > I want to import some data where some of the text in a > cell may contain some parts which are in italics or bold. SpreadLib doesn't have styles for IMPORT yet, but SpreadOut already has them for EXPORT. Text size, bold/italic/etc, pics. At least my dev version does! I need to

Re: Dropbox help

2018-01-16 Thread AndyP via use-livecode
Does this help? https://blogs.dropbox.com/developers/2014/05/generate-an-access-token-for-your-own-account/ - Andy Piddock My software never has bugs. It just develops random features.

Re: Dropbox help

2018-01-16 Thread Klaus major-k via use-livecode
Hi Andy, > Am 16.01.2018 um 15:09 schrieb AndyP via use-livecode > : > > Does this help? > > https://blogs.dropbox.com/developers/2014/05/generate-an-access-token-for-your-own-account/ >

Re: Reading from xls or xlsx - with style

2018-01-16 Thread Matthias Rebbe via use-livecode
Ben, i am uising Spreadlib and Excel Libary. Both do not take care for text format. At least i am not aware of it. Regards, Matthias Matthias Rebbe Tel +49 5741 31 ‌https://matthiasrebbe.eu ‌ > Am 16.01.2018 um 19:10 schrieb Ben Rubinstein via use-livecode >