Subject | Re: spreadsheet ergonomics |
From | owl |
Date | 04/03/2017 22:54 (04/03/2017 20:54) |
Message-ID | <bajz8v94.ab8@rooftop.invalid> |
Client | |
Newsgroups | comp.os.linux.advocacy |
Follows | Snit |
Followups | Snit (21m) > owl |
SnitWhat does "finalize" mean? Clarify what all keystrokes or mouse clicks are necessary for all linked tables to update.
On 4/3/17, 12:38 PM, in article hjguc8892a.a@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:owlSnit
Snit <usenet@gallopinginsanity.com>wrote:Snitowl
On 4/2/17, 9:12 PM, in article z9b003gaew.hy@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:
...
now.
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:That might be a virus for all I know.
<https://www.icloud.com/numbers/040IoTN2lqc4MhnA0sNpm6zpg#Kids_RPG_Rules_-_M agic_System>OR <https://goo.gl/vOFudM>
Because it doesn't need to be separated.SnitowlowlSnit
Numbers -- updating a sheet with data from a completely separate file.
Well, this whole thing is a work around to try to emulate what Numbers does easily... have multiple tables all on one sheet
And the question is why are you doing that anyway when you can just use different sections of one sheet for the work?
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.Who cares about that? About 1/2 of 1 percent of the population. Your way is like have a 200 acre farm and never leaving the front porch.
So leave perms at 644 and source it.SnitThink 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?owl
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.
Would you use that same security protocol with a Numbers file?
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).I thought you stipulated an untrusted source. You did specify that you did not really know what the file did. So would you run a Numbers spreadsheet from an untrusted source?owlSnit
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.
It is running a spreadsheet. And it is from a known, trusted source.