Copying a calculated cell from Numbers into Pages - two workarounds and Apple's Copy Snapshot answer

You can't copy a Numbers calculated cell, like one formed by concatenating strings in other cells, into Pages. The formula is pasted instead, typically with an error icon (absent references). It's apparently been a problem for all eternity, though I just ran into it recently.

What about Cmd-Opt-Shift-V?

This pastes without table formatting but Numbers will still put the formulae on the clipboard and the paste will show broken references. Unless you use the Copy Snapshot feature below, then it does nothing.

There are three workarounds I've learned:

Simple

Paste into something like Notes.app or TextEdit.app or pretty much anything but Pages. Then copy/paste that into Pages.

Better

If you create a Sheet that directly references a calculated cell you will be able to paste that into Pages. Numbers doesn't hunt for the formulae, it just puts the calculated cell value on the clipboard. (Thanks Ben O'Matic for the tip!)

Best - Apple actually fixed this

If you choose "Copy Snapshot" in Numbers (it's up on the File menu you and I never look at) it will copy the values, not the formulae. It will paste as a table in Numbers. There's actually documentation of this, but the AIs and Google couldn't find it -- until I figured it out. (How did I figure it out? I realized what Apple needed to do and then it occurred to me that maybe they had done it.)

What should Apple do?

I only found "Copy Snapshot" after I wondered how Apple could fix this. So it could be a bit easier to discover. Something like:

1. Make the "Copy Snapshot" behavior the default Copy behavior and fix the Cmd-Opt-Shift-V shortcut.
2. Make the current behavior a separate item (opt-copy?) called something like "Copy Dynamic".