Snit
On 4/3/17, 12:38 PM, in article hjguc8892a.a@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:

owl
Snit <usenet@gallopinginsanity.com>wrote:

Snit
On 4/2/17, 9:12 PM, in article z9b003gaew.hy@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:

...

owl
now.

Snit
And then try to type between the updates? And then the updates are not happening in apparent real time, right?

I admit I could be wrong about that... if so I would love to see it.

But all of this setting refresh rates and more is showing what I have been talking about -- it is a kludge to try to do what you can do trivially with other tools (as shown in this video I already posted for you):

<https://youtu.be/V2bRLDuaVOk>

For whatever reason I clicked off of the cells to "finalize" them in the video. Can also hit enter or tab (and other options). No need to even leave the table.

And here is that spreadsheet where you can do what I show right now:

<https://www.icloud.com/numbers/040IoTN2lqc4MhnA0sNpm6zpg#Kids_RPG_Rules_-_M agic_System>OR <https://goo.gl/vOFudM>

owl
Numbers -- updating a sheet with data from a completely separate file.

Snit
Well, this whole thing is a work around to try to emulate what Numbers does easily... have multiple tables all on one sheet

owl
And the question is why are you doing that anyway when you can just use different sections of one sheet for the work?

Snit
Why do it that way when you are not limited to it? Why not have each logical section be its own table?

Makes it easier to update and maintain and move things around anyway... and table rows from one table do not effect the width of other data, etc.

Think of it this way, if you were sent a file by someone and did not really know what it did, would YOU be willing to change its permissions and run it?

I suspect not... at least not anywhere other than in a safe environment where if it wiped out the machine (or VM) it would not matter to you.

owl
Would you use that same security protocol with a Numbers file?

Snit
I would not change its permissions! No need.

So given that I would not have to run it in a safe environment -- it is merely a file and not a program, and there are no macro issues that I know of (as there are with MS Office).

owl
At least this is open-source (even the spreadsheet files themselves are open-source) and you can examine exactly what it does. Who knows what a Numbers file is doing, or even what Numbers is doing, for that matter.

Snit
It is running a spreadsheet. And it is from a known, trusted source.