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 <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 310000 > https://matthiasrebbe.eu <https://matthiasrebbe.eu/> > >> Am 16.01.2018 um 19:10 schrieb Ben Rubinstein via use-livecode >> <use-livecode@lists.runrev.com <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 <mailto: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
