Subject | Re: spreadsheet ergonomics |
From | owl |
Date | 04/03/2017 06:12 (04/03/2017 04:12) |
Message-ID | <z9b003gaew.hy@rooftop.invalid> |
Client | |
Newsgroups | comp.os.linux.advocacy |
Follows | Snit |
Followups | owl (40m) Snit (13h & 40m) > owl |
SnitYou don't have to turn it on at all. That's just to have the data in one table update automatically from changes in another table. If you don't need that, the just move your mouse to the target table and type "@" or enter some data into any cell. The external data will then be automatically calculated.
On 4/2/17, 6:46 PM, in article hvjjz003.gah@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:owlSnit
Snit <usenet@gallopinginsanity.com>wrote:Snitowl
On 4/2/17, 5:14 PM, in article ykahvj003ta.yr@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:
...SnitowlSnitOk, the looping in the background is clearly kludgy.owl
It's not a kludge. It's the way it works.
Except as you note, it does not auto-update without you writing such scripts and then you see flashing on the screen.
The "flashing" is not an artifact, but a message notifying you that it's running an external script. I'm not sure that you can turn that off.
Right... it is flashing and jumping up and down screaming for attention even when you are NOT updating data. That is worse than the damned Mac dock icons which can jump up and down.SnitCan you even go from table to table and modify them without starting and stopping scripts?owl
Yes. You can click the menu on the xterm and uncheck "Allow SendEvents" when you need to edit the sheet. Then turn them back on when you're done.
But you do not consider this to be a kludgy work-around?
No, that's setting it back to default mode, which has "Allow SendEvents" turned off.
I mean turning it on and off just to work with tables.
I mean, really, tables should just have the data flow. For older spreadsheets, like back in the Apple IIe days, you had to say update -- but now it just happens.It does update automatically, if you're *in* that sheet. And remember, this is something that you said is not even possible with Numbers -- updating a sheet with data from a completely separate file.
If you goof and make a circle it tells you immediately (does yours even do that).Huh? What do you mean by "a circle"?
<https://youtu.be/wiRBQDhanC0>I might be able do that, depending on the video player.
Will show other info on other errors. You can see the results of that on the shared copy... no added work from me.
I will say I tried it online and while you can enter formulas you cannot do it with point and click with kinda sucks. That makes it MUCH easier to do.
You also cannot play embedded videos. OK, sure, that is an odd thing to do with a spreadsheet but they do play on the desktop version.
...You will need to make it executable:SnitowlowlSnit
All of that can be scripted so it is transparent. What do you think is happening behind the scenes within a docx file?
The point is one you have to script and set up and have as multiple files and assume a pretty high level of knowledge on the part of the recipient and an even higher level of knowledge from the developer... NONE of it dealing with actually just putting numbers and formulas and charts into a spreadsheet.
You said you didn't care what is happening behind the scenes -- just the presentation.
Right... I care about what the user has to do. I do not care if it is REALLY saved in one file or 100 as long as to the users working with it the data is in one APPARENT file (and even then if there is something just as simple I would be fine with that).
The point is to focus on the task (working with a simple spreadsheet) and not on scripting and fiddling and other stuff. AGAIN, not that there are not absolutely times when such things can offer benefits... but when the the work is just the spreadsheet you should not have to do stuff outside of that (again, not counting basics you need to do to do pretty much ANYTHING on a computer).SnitYou have to fiddle with a bunch of externals and not just focus on the work. What I am showing you is focusing on (pretty much) just the work. It is true the person needs to know the basics of how to turn their computer on, use a mouse and keyboard (or use the either one to emulate the other, basically), etc. But all very basic things.owl
So Numbers has no learning curve. Why were you having to "help" those kids again?
It has a much lower learning curve than what you are describing. Most of this they figured out on their own. I did show them some examples and answer some questions along the way... but even those were focused on the direct tasks (building the spreadsheet... they did not think of the idea of having blue being a sign of what SHOULD be edited (but they figured out how to do it on their own), they were a bit confused with the options for sharing online (and those have since changed to be easier), and they wanted help annotating a related PDF of a recipe. Oh. Wait. Not that last part... just seeing if you were still reading. :)SnitowlSnitBut, as I have said, with Numbers you need an Apple made OS (the program comes with it, I think). So that is a pretty big hurdle to jump.owl
Really comes down to from the user perspective is it one item they are dealing with or multiple?
As I said, it can be made to appear to be a single item.
Can you show this single item? I will happily double click it on a Linux VM and we shall see if it is as easy as the simple URL I provided you (which you can use to download the file, too).
I'll put something together.
Also, with yours, will I need to give it special permissions?
If so, well, fine to do in a VM but I would not do it on a system I cared about. Heck, look at your attempt to rename an open file... yes, *I* knew it was going to lead to disaster but most people would have no clue and there are lots of things you could add -- on purpose or not -- which I would not know would lead to disaster.LOL
...Picture this as the application that the user runs to make the file. In this case it's just operating on one that's already built, but the principal is the same.SnitowlSnitRight... all sorts of scripting and working with multiple files. That is what I am talking about.owl
You have a primitive view of what scripting can do.
Could be... but how do you think that is relevant? Keep in mind I am talking about how these things are done -- focusing on the tool itself (the spreadsheet) or focusing on all sorts of external things such as scripts and working with multiple files, etc.
The user needn't notice that it's multiple files.
Even the user making it?
If so that is very different than what I am picturing. Even for the end user I think they likely would if you did not have embedded xterms in other windows and the like. Which, sure, you can do. Maybe we found a reason for it ... to get around limitations of sc. :)Let me know when Numbers can handle a similar task of linking separate files with automatic updates.