pasting comma or space separated values into a list

[sdnjack]

Using CEmu in the classroom, is there any way to quickly "paste" a list of numbers into L1? I believe WabbitEmu has this feature, and it's really handy, but I like your interface better. Pasting directly from MSExcel or Google Sheets would be fantastic, too.

[adriweb]

Sounds similar to your issue 4 years ago here: #388 ?
In which case, there hasn't been any work on this feature I guess.

It wouldn't be so hard to use the already-built-in tivars_lib_cpp code to convert the clipboard data to L1 and transfer that though. Maybe I can try it later today :)

[sdnjack]

Huh. I did not remember posting that, but I am not really surprised - It's a feature I use a lot with Wabbit. I don't know what tivars_lib_cpp is - I'm just a math teacher, not a programmer. Thanks for responding, adriweb.

[adriweb]

This has now been implemented, in the variables dock, at its top right, you'll find a button to send the clipboard content to L1.
If the content is empty or otherwise not a list, it will let you know.
It expects the list to be comma-separated real numbers, optionally with the whole thing between curly brackets.

For instance, {9, 0, .5, -6e-8} is fine (the e-8 part being 6*10^-8).

You can find a test build of CEmu here: https://github.com/CE-Programming/CEmu/releases/nightly

[adriweb]

Ah and there's a keyboard shortcut for it: Ctrl-Shift-L (or Cmd-Shift-L on macOS)

[sdnjack]

Wow. Really helpful. If I want to paste directly from Excel, I have to massage my list a bit with =CONCAT(TEXT(C1,"0.0"),","), except for the last item, which can't have a comma. It's doable, but still a bit clumsy. Looks like Google sheets does the same thing. If you're looking for something to do on a rainy day, I'd love it if I could just select a list in Excel, hit Ctrl-C, switch to CEmu, then Ctrl-Shift-L.

Thanks again!

[adriweb]

Ah well that's easy enough. I just made it so it will internally remove trailing commas if present.
Also improved how it handled the temporary file during the conversion, as it may not have always been a writable path.

Anyway, the build should be available in a few minutes from the same link.