We use this so users can attach invoices and other documents they've received through mail to orders in our application. Users typically run Outlook on their laptop/PC, but our application as a published application.
We rely on Excel exposing the data in an XML format on the clipboard to reliably import data from Excel. Same for Open/LibreOffice. Without it it's impossible to handle cells which contain both the quote character and newlines, due to the way Excel formats plaintext.
We don't want to import the whole file, because the users typically only need to import parts of the spreadsheet. This saves us from writing a complex UI to select the data to import.
And FWIW, I've used that with >100k rows of data.
home PC ->
RDP to work laptop at home ->
VNC to work network ->
RDP to work desktop ->
RDP to other VMs and PCs at work
I can copy text or a file or a screen shot at any level and paste at any other level. Pretty amazing.Insanely well engineered. It can perform miracles of computing. It damn well has to.
> I can take a screenshot of my Firefox with "PrtScn" button (moving a bitmap of the page into the Clipboard), paste it into Microsoft Paint, edit it a bit, and then copy/paste that into my Discord chat screen for commentary.
All without you worrying about supported image formats or color space encodings! It is insane! Copy from Firefox and then paste into a program that expects 16bit color and it'll probably work. The clipboard stores data in so many duplicate formats and can convert between so many formats, it is nuts.
This idea has a lot of legs IMO.
It was one of the easiest-to-use calculators I've ever seen. Just enter your webpage to play the game, Ctrl-A (select-all), Ctrl-C (copy), and bam, the Utopia-program would instantly analyze your kingdom and provide advice.
Just all off of the HTML-copy that Clipboard supports.
------------
Windows developers "know" the clipboard is one of the most important inter-process communication structures of the entire system, and have known for years. Its probably one of the Win32 API's biggest advantages, no joke.
The shear amount of creative solutions I've seen from clipboard manipulations is outstanding.
It turns out, more and more applications are locking the clipboard and holding onto the lock inappropriately. Enough that there's a particular telemetry watcher for this condition for MSFT to get an idea on who the guilty parties are.
Everyone has had it happen - I notice it when colleagues are in a rush and send me something they didn't mean to send (because their clipboard didn't update). I don't know who the guilty parties are (since that telemetry is encrypted, and can't be inspected), but I sure hope someone is knocking down some doors to address the problem.
I configured my clipboard manager to make a crinkly paper noise when an app copies, so at least I have some feedback when it fails.
But you have found that it helps?
I am sure Raymond Chen knows. Looks like comments are allowed on his blog too!
### Starting Party
#
# Cariel Roame
# - Tome of Light 4
# Xyrella
# - Robes of Purity 2
# Rokara
# - Helm of Inspiration 1
# Murky
# - Time to Krill 3
# Millhouse Manastorm
# - Arcane Powder 1
# Deathwing
# - Heart of Unliving 3
#
CO+cmQQSDlN0YXJ0aW5nIFBhcnR5GAEiRQoJCBIQiwEYICAACgkIExDKARgjIAAKCQgLEIgBGAsgAAoLCLgCEOMCGLIEIAAKCAgOEB8YFCAACgsIqgIQygIYkgQgACgA
#
# To use this deck, copy it to your clipboard and create a new deck in HearthstoneIf it's a regular win32 app, then it has access to all your filesystem (except UAC bits), can read and post keystrokes to other windows, and indeed can just straight up inject code into other processes.
Is protected folder access an on-by-default thing, or is it only certain folders?
Quick googling makes me think my plan might trigger windows defender for an exemption request. Hm That's a drag, but understandable I suppose?
But honestly, I've had to whitelist Microsoft's own Windows utilities from CFA in its earlier days, so don't fret about it.
Thank you for the info.
The basic APIs were there from the beginning in Windows 1.0, including multiple clipboard formats, application specific formats, and the ability to register for clipboard changes. More standard formats have been added over the years, but it still supports some ancient formats, like Software Arts' Data Interchange Format.
https://www.os2museum.com/wp/windows-history/windows-library...
Way back in the 90s, it was possible to put any (+) document inside any sufficiently aware app or document with OLE ("object linking and embedding")
The (+) indicates that there were a lot of terms and conditions applying to this, but you could actually just put an excel spreadsheet in a word document, and it would run a small copy of excel inside word. This is why the original word save format is so horrendous - it's serialized binary objects.
Cool idea though!
I'm not sure why it would be impressive or unusual. The ability to store arbitrary data on the clipboard with metadata that describes what data it is, such as an image file, or an audio file, is very old.
Except its no where near as smooth or universal as in Windows. In Linux, you have to worry about KDE programs vs GNOME programs having different clipboards, for example.
Its also why compatible suites of programs (ie: Adobe) can be so useful when those custom formats come into play. Adobe can copy/paste layers from Photoshop and send them over to other programs. If the photoshop layer isn't understood, it seems to become a Bitmap, which works when I'm on a VBulletin forum over in Firefox land.
---------
Copy/paste works on files / file-managers, images, text, HTML. Yes, any OS could do the same thing, but they largely don't in my experience.
I am no sure where you get this idea. The clipboard is an X11 shared resource and any program taking control of it removes what any other had on it before.
> Its also why compatible suites of programs (ie: Adobe) can be so useful when those custom formats come into play. Adobe can copy/paste layers from Photoshop and send them over to other programs. If the photoshop layer isn't understood, it seems to become a Bitmap, which works when I'm on a VBulletin forum over in Firefox land.
The same exists on X11, programs can define custom metadata and define a hierarchy of different metadata and associated data on the clipboard and any application can decide for itself which formats it understands and which it does not.
I've personally built software that puts images on clipboards, and falls back with uris to that image if direct images not be supported by whatever reads it.
I don't worry about this on linux because it's not the case.
I suppose if I were on windows I would have to worry about legacy programs that only understand UCS-2 not being able to talk to modern programs that only understand UTF-8.
>Its also why compatible suites of programs (ie: Adobe) can be so useful when those custom formats come into play. Adobe can copy/paste layers from Photoshop and send them over to other programs. If the photoshop layer isn't understood, it seems to become a Bitmap, which works when I'm on a VBulletin forum over in Firefox land.
I'm able to paste images from GIMP, Krita, and Thunar into forums just fine.
Selecting text and middle clicking is so much faster than ctrl+c, ctrl+v. Having the two separate, allows you to essentially copy two separate things at once, and paste them separately, which is great for filling out forms.
Also, KDE provides an absolute gem of a clipboard manager, which stores all recent copies in to a list, from which entries can be browsed in order to recopy some text that you may have copied a while ago. IDK where you got the idea that Gnome apps have a different clipboard, as I have never experienced that. Maybe that is an old thing? Definitely not how it is now, thats for sure.
Copy/paste works on files / file-managers, images, text and HTML. This is not a Windows only experience. In fact, the clipboard manager even has little file icons, and image previews, for copied objects.
Just for completeness & correctness: that's an X11 feature, not related to KDE, and predates KDE by several years. I can't easily find the history of it, but this Keith Packard paper[0] on it is dated 1990 so it's necessarily older than that…
[0] http://keithp.com/~keithp/talks/selection.ps
(pg. 5, "4.1. Selection names" - PRIMARY, SECONDARY, CLIPBOARD. I don't think SECONDARY is used much these days.)
In windows 10 and up, win + v to see (and the first time, enable) the clipboard history selector
Note that KDE has had it pre Windows 10 though.
But even if old, it's still notable that such an old concept/technology works so well, and there are few newer inter-process communication methods that work as reliably or with as good UX!
Who invented the "clipboard", Xerox PARC? No, wikipedia just credits two individuals, Pentti Kanerva and Larry Tesler .
https://support.apple.com/guide/mac-help/copy-and-paste-betw...
For example, copying from Excel can output:
- to a table (when copied into word)
- to rich text when copied into Wordpad
- to plain text when copied into Notepad
- and even an image when copied into Paint.
All without having to select the desired type at the source.
Another under-appreciated Windows feature is how they implement drag-and-drop apps. When you drag a file into an app icon, it just stuffs the file path into the command line arguments and runs the app. In contrast, though MacOS introduced drag-and-drop, actually implementing it in System 7 was a huge complex chore.
It does instant rectangular selection, then pops up a simple editor which you can then copy/paste anywhere you'd like.
I have Win+Shift+S bound to a mouse chord, as well as copy and paste, so I can actually paste an arbitrary rectangle of my screen without touching the keyboard.
If I used arch or some other power user linux, I suspect I would have to jump through quite a few hoops to get this experience setup as nicely. But as someone who daily drives both a linux distribution and a windows distribution, I see no notable differences in clipboard functionality.
Something similar is available in the more modern Windows 'snipping tool' feature (win-shift-s) but without the tablet magic.
I can take a screenshot of my Firefox with "PrtScn" button (moving a bitmap of the page into the Clipboard), paste it into Microsoft Paint, edit it a bit, and then copy/paste that into my Discord chat screen for commentary.
--------
Yes, Linux / *Nix users have pipes and great text processing tools. Yes, Powershell has interesting objects that can be passed round. But practically speaking? Most of my "inter-process communications" is over this silly "Clipboard" Windows has, and it works way better than it probably should.