Re: Reading from xls or xlsx - with style

[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 wrap up this version for public release - I'll 
try to speed that up and get it posted soon.


(Depending on how close they are to completion, FieldTrip may be first 
in line for update, because I had several requests for it and haven't 
forgotten.)


SpreadOut was lucky and got the style features and pics implemented 
first, and it's pretty cool to save stylin' spreadsheets from Livecode. 
I'll have to add those features to the import code in another version. 
Perhaps italic and bold can come sooner than the rest, we'll see.


There's so much that Excel and other spreadsheets can do, really amazing 
and handy. Using the genuine and original SpreadLib library, it's easy 
to import to a LiveCode field or array and use the data to empower all 
sorts of projects.


Best wishes,

Curry Kenworthy

WordLib: Take charge of MS Word and OpenOffice documents
SpreadLib: "Excel-lent" spreadsheet import/export for LC
http://livecodeaddons.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

Sending from mobile hotspot to WLAN enabled IoTs

[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
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

Re: deploying to multiple mobile devices

[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 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 work with directly, or a product for others to use
> in their own classrooms?
>
> --
>  Richard Gaskin
>  Fourth World Systems
>  Software Design and Development for the Desktop, Mobile, and the Web
>  
>  ambassa...@fourthworld.comhttp://www.FourthWorld.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
>
___
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

Re: deploying to multiple mobile devices

[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 work with directly, or a product for others to 
use in their own classrooms?


--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.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

Re: Roadmap: "Automated REST API wrapping"?

[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, no-I-won't-hold-you-to-it-but-just-curious
>> target version?
>
> This was discussed at LCG but I'll get the month wrong - August?

I could go hunt it down, but since we're here and for the benefit of 
those who may not have access to those for-fee-only sessions, could 
someone working on that offer at least a brief summary here?


--
 Richard Gaskin
 Fourth World Systems

___
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

Re: Roadmap: "Automated REST API wrapping"?

[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
>
> 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 getting people to
> adopt good REST practices.
>
> --
>  Richard Gaskin
>  Fourth World Systems
>  Software Design and Development for the Desktop, Mobile, and the Web
>  
>  ambassa...@fourthworld.comhttp://www.FourthWorld.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
>



-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
___
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

Roadmap: "Automated REST API wrapping"?

[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 getting people to 
adopt good REST practices.


--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.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

OT: Idiot UX

[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 (should have bullets or some other separator between records)

--
 Mark Wieder
 ahsoftw...@gmail.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

RE: deploying to multiple mobile devices

[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 Chrome download manager no
longer lets you install an apk. When my users(testers) clicked on the apk on
the Chrome Downloads page the users are now receiving this message "Cant
Open File". That is why some users may need to use a file explorer app("OS
built in" or "ES file explorer" or "Astro") in order to install the app.

At first I thought it was the apk copy to the server or the web server was
at fault until I found out it was Chrome's new security protocol.
 
Ralph DiMola
IT Director
Evergreen Information Services
rdim...@evergreeninfo.net


-Original Message-
From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf
Of J. Landman Gay via use-livecode
Sent: Tuesday, January 16, 2018 5:30 PM
To: How to use LiveCode
Cc: J. Landman Gay
Subject: Re: deploying to multiple mobile devices

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 possible.
> 
> On Mac and for iOS, it seems the best (only?) choice is Jacqueline 
> Landman Gay's AirLaunch 
> ,
> specially since it does so from withing LC itself.
> 
> But for Android? and on Windows?

Android apps can be downloaded from anywhere if the user has turned on the
option to download apps from "unknown sources", so all you need to do is put
the apk file on a server somewhere and give out the link. The user goes to
the link in a browser on their mobile device and when they click it, the app
will install. If their device prefs do not allow installation from "unknown
sousrces", they can turn the option on temporarily in the Security section
of the Android system settings.

On iOS, no distribution is possible until you have built the app with a
profile that contains the UUID for each user device. AirLaunch, or any other
third-party solution, will prepare the app for distribution but iOS won't
install it without the correct distribution profile. Apple provides
TestFlight which overcomes some of this limitation but I have never used it
so I'm not sure exactly how it works. Someone more familiar with it would
know more.

-- 
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.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


___
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

Re: deploying to multiple mobile devices

[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 possible.

On Mac and for iOS, it seems the best (only?) choice is Jacqueline Landman
Gay's AirLaunch ,
specially since it does so from withing LC itself.

But for Android? and on Windows?


Android apps can be downloaded from anywhere if the user has turned on 
the option to download apps from "unknown sources", so all you need to 
do is put the apk file on a server somewhere and give out the link. The 
user goes to the link in a browser on their mobile device and when they 
click it, the app will install. If their device prefs do not allow 
installation from "unknown sousrces", they can turn the option on 
temporarily in the Security section of the Android system settings.


On iOS, no distribution is possible until you have built the app with a 
profile that contains the UUID for each user device. AirLaunch, or any 
other third-party solution, will prepare the app for distribution but 
iOS won't install it without the correct distribution profile. Apple 
provides TestFlight which overcomes some of this limitation but I have 
never used it so I'm not sure exactly how it works. Someone more 
familiar with it would know more.


--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.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

Re: Reading from xls or xlsx - with style

[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 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 ‌
>
>> Am 16.01.2018 um 21:32 schrieb zryip theSlug via use-livecode 
>> mailto:use-livecode@lists.runrev.com>>:
>>
>> 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 consist to
>> explore the style of each chars in a cell, then return the result in
>> html to have it directly usable in LiveCode. I'm not sure of the
>> performances of this approach, though. It will depend on how many
>> cells the sheet have and how many text each cells are containing.
>>
>> On Tue, Jan 16, 2018 at 8:23 PM, Matthias Rebbe via use-livecode
>> mailto:use-livecode@lists.runrev.com>> wrote:
>>> 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 
 mailto:use-livecode@lists.runrev.com> 
 >>:

 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 
 existing libraries that support this use?

 Many thanks,

 Ben

 ___
 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 
 
>>>
>>> ___
>>> 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 
>> 
> ___
> 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

Re: Reading from xls or xlsx - with style

[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 original spreadsheet file [ .ods / .xls ] will 
be preserved.


The ONLY problem is that the data is spreas apart over many "cells", but 
that should be capable

of being cleared up comparatively simply.

Richmond.


On 16/1/2018 11:32 pm, Richmond Mathewson wrote:
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 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


Richmond.

On 16/1/2018 10:32 pm, zryip theSlug via use-livecode wrote:

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 consist to
explore the style of each chars in a cell, then return the result in
html to have it directly usable in LiveCode. I'm not sure of the
performances of this approach, though. It will depend on how many
cells the sheet have and how many text each cells are containing.

On Tue, Jan 16, 2018 at 8:23 PM, Matthias Rebbe via use-livecode
  wrote:

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 
mailto:use-livecode@lists.runrev.com>>:

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 existing 
libraries that support this use?

Many thanks,

Ben

___
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

___
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






___
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

Re: Reading from xls or xlsx - with style

[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 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


Richmond.

On 16/1/2018 10:32 pm, zryip theSlug via use-livecode wrote:

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 consist to
explore the style of each chars in a cell, then return the result in
html to have it directly usable in LiveCode. I'm not sure of the
performances of this approach, though. It will depend on how many
cells the sheet have and how many text each cells are containing.

On Tue, Jan 16, 2018 at 8:23 PM, Matthias Rebbe via use-livecode
  wrote:

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 
mailto:use-livecode@lists.runrev.com>>:

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 existing 
libraries that support this use?

Many thanks,

Ben

___
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

___
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






___
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

Re: Reading from xls or xlsx - with style

[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


Richmond.

On 16/1/2018 10:32 pm, zryip theSlug via use-livecode wrote:

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 consist to
explore the style of each chars in a cell, then return the result in
html to have it directly usable in LiveCode. I'm not sure of the
performances of this approach, though. It will depend on how many
cells the sheet have and how many text each cells are containing.

On Tue, Jan 16, 2018 at 8:23 PM, Matthias Rebbe via use-livecode
 wrote:

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 
mailto:use-livecode@lists.runrev.com>>:

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 existing 
libraries that support this use?

Many thanks,

Ben

___
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

___
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





___
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

Re: Reading from xls or xlsx - with style

[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 ‌

> Am 16.01.2018 um 21:32 schrieb zryip theSlug via use-livecode 
> mailto:use-livecode@lists.runrev.com>>:
> 
> 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 consist to
> explore the style of each chars in a cell, then return the result in
> html to have it directly usable in LiveCode. I'm not sure of the
> performances of this approach, though. It will depend on how many
> cells the sheet have and how many text each cells are containing.
> 
> On Tue, Jan 16, 2018 at 8:23 PM, Matthias Rebbe via use-livecode
> mailto:use-livecode@lists.runrev.com>> wrote:
>> 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 
>>> mailto:use-livecode@lists.runrev.com> 
>>> >> >>:
>>> 
>>> 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 
>>> existing libraries that support this use?
>>> 
>>> Many thanks,
>>> 
>>> Ben
>>> 
>>> ___
>>> 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 
>>> 
>> 
>> ___
>> 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 
> 
___
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

Re: Reading from xls or xlsx - with style

[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: 
http://www.softinterface.com/Convert-XLS/Features/Convert-XLS-To-HTML-XML.htm


Thinking . . .

Richmond.

On 16/1/2018 10:32 pm, zryip theSlug via use-livecode wrote:

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 consist to
explore the style of each chars in a cell, then return the result in
html to have it directly usable in LiveCode. I'm not sure of the
performances of this approach, though. It will depend on how many
cells the sheet have and how many text each cells are containing.

On Tue, Jan 16, 2018 at 8:23 PM, Matthias Rebbe via use-livecode
 wrote:

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 
mailto:use-livecode@lists.runrev.com>>:

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 existing 
libraries that support this use?

Many thanks,

Ben

___
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

___
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





___
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

Re: Reading from xls or xlsx - with style

[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 consist to
explore the style of each chars in a cell, then return the result in
html to have it directly usable in LiveCode. I'm not sure of the
performances of this approach, though. It will depend on how many
cells the sheet have and how many text each cells are containing.

On Tue, Jan 16, 2018 at 8:23 PM, Matthias Rebbe via use-livecode
 wrote:
> 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 
>> mailto:use-livecode@lists.runrev.com>>:
>>
>> 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 existing 
>> libraries that support this use?
>>
>> Many thanks,
>>
>> Ben
>>
>> ___
>> 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
>
> ___
> 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

deploying to multiple mobile devices

[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 Jacqueline Landman
Gay's AirLaunch ,
specially since it does so from withing LC itself.

But for Android? and on Windows?

--
Nicolas Cueto
___
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

Re: Reading from xls or xlsx - with style

[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 
> mailto:use-livecode@lists.runrev.com>>:
> 
> 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 existing 
> libraries that support this use?
> 
> Many thanks,
> 
> Ben
> 
> ___
> 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

___
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

Reading from xls or xlsx - with style

[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 existing 
libraries that support this use?


Many thanks,

Ben

___
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

Re: Dropbox help

[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 token” button.  Hit the button,
copy the code
4) This is your oauth2 token that you will use in your code
4.5) I have “allow implicit grant” set to “Allow” for several of my apps,
because it makes the process less complicated, but YMMV.  I do not fiddle
with the URL’s, redirects, webhooks, etc.
5) If you’re using 9, use LC’s dropbox library that is built into LC. If
you’re using 8, you can copy it from 9 or you can grab it from my github
repo (I’m a couple commits ahead of LC’s version due to a couple bug
fixes).  www.github.com/macmikey/lcdropboxlibrary
6) Grab Gerard’s dropbox 2 stack either from his repo or from mine so you
can do some testing with something we know works.  His api is slightly
different b/c Monte modified it when he added it to LC, but the syntax is
close enough and the mapping is 1:1.  Gerard has a couple of new features
he just added that have not been integrated into LC’s library, yet.

On Tue, Jan 16, 2018 at 09:04 Klaus major-k via use-livecode <
use-livecode@lists.runrev.com> wrote:

> 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"?
> ...
> put url("binfile:" & path_to_pdf_file_here) into pData
> dropboxUpload ?, "name_of_target_file.pdf", "overwrite", "", "",
> pData
> ...
>
> As you see, i have no idea so far, any help much appreciated! :-)
>
>
> Best
>
> Klaus
> --
> Klaus Major
> http://www.major-k.de
> kl...@major-k.de
>
>
> ___
> 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
>
-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
___
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

Re: Dropbox help

[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/
> 
>   

yes, thanks a lot!

> -
> Andy Piddock 

Best

Klaus

--
Klaus Major
http://www.major-k.de
kl...@major-k.de


___
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

Re: Dropbox help

[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. 

TinyIDE  a Free alternative minimalist IDE Plugin for LiveCode 


Script editor Themer for LC http://2108.co.uk  

PointandSee is a FREE simple but full featured under cursor colour picker / 
finder.
http://www.pointandsee.co.uk  - made with LiveCode
--
Sent from: 
http://runtime-revolution.278305.n4.nabble.com/Revolution-User-f278306.html

___
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

Dropbox help

[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"?
...
put url("binfile:" & path_to_pdf_file_here) into pData
dropboxUpload ?, "name_of_target_file.pdf", "overwrite", "", "", pData
...

As you see, i have no idea so far, any help much appreciated! :-)


Best

Klaus
--
Klaus Major
http://www.major-k.de
kl...@major-k.de


___
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

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

[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 users to research and experiment in
the hope of arriving at the above block of code?


Indeed - the copy command should.

The fact the above can now be written in LiveCode Script means it is 
much easier to work out how to make the copy command 'do the right 
thing'.


Indeed, it wouldn't be too much of a stretch to seriously consider 
implementing most clipboard functionality in script - based around the 
raw clipboard support we have (the clipboardData / fullClipboardData are 
both implemented in terms of the raw clipboard in the engine).


The main missing piece at the moment is the ability to bind the syntax 
to said script handlers, rather than internal C++ engine methods.


Warmest Regards,

Mark.

--
Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
LiveCode: Everyone can create apps

___
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

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

[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.

Changing the tags is probably a good thing to do in the engine code.  
I'm

not so sure about the spaces though.


We can't change the tags for 'htmlText' - i.e. LiveCode's html-like 
styled text representation as many people process it by looking for 'p' 
tags. However, we could add a 'real' HTML converter for the clipboard 
which could use 'div'.


I wonder if the space issue is solved by using an xml:space="preserve" 
attribute?


Warmest Regards,

Mark.

--
Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
LiveCode: Everyone can create apps

___
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

Re: Naive Question time again

[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 PM, Richmond Mathewson via use-livecode wrote:


When a new version (dp, rc, stable) of LiveCode is released how much of
the
change from the previous version resides in the engine and how much in
the IDE
(i.e. the collection of stacks starting with rev associated with the
engine?


That info is in the Release Notes, bugs and additions to the engine and
IDE are listed in separate sections.

--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.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


___
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



___
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