Re: how to format text for copy-pasting as a spreadsheet table

CTRL-K is the standard keyboard equivalent, but LC does not respond to that. I suppose you can have a frontscript with a rawkeyDown handler that checks for CTRL-K (ascii 107) then put numToChar(11) into the selection. Remember to pass rawKeyDown. BTW I also use this to trap for other keys like

Re: how to format text for copy-pasting as a spreadsheet table

On 2/14/18 7:53 PM, Paul Hibbert via use-livecode wrote: As far as I can see, importing a table (with returns in a cell) info into LiveCode is much trickier, mainly because LiveCode doesn’t appear to support soft returns within a table cell, I don't know if it applies to table cells, but LC

Re: how to format text for copy-pasting as a spreadsheet table

The best place to start is by analysing the clipBoard data, in this case, copy a small table from Pages and then look at the fullClipBoardData[“html”] in LiveCode to see how the table is represented as html. You can then use this as a model to build a table in html and place it on the

Re: how to format text for copy-pasting as a spreadsheet table

Hi, primarely from live code to pages, but also from pages to live code Thanks JJW ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

Re: how to format text for copy-pasting as a spreadsheet table

Could you give a little more info… Do you want to import from Pages into LiveCode or import from LiveCode into Pages? Paul Paul p...@livecode.org Mac OS Sierra 10.12.1 > On Feb 13, 2018, at 3:14 AM, Jean-Jacques Wagner via use-livecode > wrote: > > Hallo, >

Re: how to format text for copy-pasting as a spreadsheet table

Hallo, I did it in pages and its works. I had an other problem with the soft-return, it is to import text with lines in the same cells. Can somebody tell me, how to do this. I tried with several chars, also 16 bits chars and never succeed. Tanks JJW

Re: how to format text for copy-pasting as a spreadsheet table

Paul, thank you! And no offense taken. I work so intermittenly with LC that whenever I take up a new project I feel like a beginner, having to recall things I once knew. I'm very grateful to have this list as a resource. -- Nicolas Cueto On 9 February 2018 at 10:42, Paul Hibbert via

Re: how to format text for copy-pasting as a spreadsheet table

Nicolas, please don’t give up just yet, I don’t think this is too difficult. I’ve posted a sample in the user forum [ http://forums.livecode.com/viewtopic.php?f=7=30584 ] that I think may work for what you describe. The example I tried uses

Re: how to format text for copy-pasting as a spreadsheet table

Correct that my code just enables a paste into a non-plain text app without extra lines (but colors and other formatting is retained). Once the plain text bug fix code is released, an intermediate step will not be needed to clean formatting as long as plain text is what was placed on the

Re: how to format text for copy-pasting as a spreadsheet table

Craig wrote: > I should be able to paste directly into any spreadsheet. One would think it should, but long experience copy-pasting from/to LC confirms "directly" just doesn't work. An intermediary step, such as a text editor app, is always needed. Brian wrote: > If you are talking about

Re: how to format text for copy-pasting as a spreadsheet table

See my code here: https://github.com/bwmilby/lc-misc/blob/master/ClipboardHelper/clipboardhelper.livecodescript "updateClipboardHtmlText" will take the HTMLText on the clipboard (which gives the extra lines) and replace the tags so it doesn't do that. I'm not sure if this will do what you want

Re: how to format text for copy-pasting as a spreadsheet table

You can. You will just get 2 returns instead of the one when you paste it anywhere but in an app that knows how to handle the contents of that clipboard. Bob S > On Feb 8, 2018, at 06:40 , dunbarx via use-livecode > wrote: > > put "cat" & tab & "dog" & tab &

Re: how to format text for copy-pasting as a spreadsheet table

I have code that can bypass step 1 (8.1.9 probably can too since I think that bug fix is in there). If you are talking about getting an actual table, then it is possible but may require some code to pull off. I would need to do some testing to figure out what is on the clipboard after the

Re: how to format text for copy-pasting as a spreadsheet table

Hi. Not sure I understand. If I make a list: put "cat" & tab & "dog" & tab & "eel" & return & "red" & tab & "blue" & tab & "yellow" into myList set the clipBoardData to myList I should be able to paste directly into any spreadsheet. There is a thread that describes an issue pasting into google