Google| Subject | Re: spreadsheet ergonomics |
| From | Snit |
| Date | 04/03/2017 04:24 (04/02/2017 19:24) |
| Message-ID | <D507005D.9C637%usenet@gallopinginsanity.com> |
| Client | |
| Newsgroups | comp.os.linux.advocacy |
| Follows | owl |
| Followups | owl (1h & 48m) > Snit |
On 4/2/17, 6:46 PM, in article hvjjz003.gah@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:
owlI 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. If you goof and make a circle it tells you immediately (does yours even do that).
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.
<https://youtu.be/wiRBQDhanC0>
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.
...
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).owlAll of that can be scripted so it is transparent. What do you think is happening behind the scenes within a docx file?Snit
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.
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).
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. :)Snitowl
You 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.
So Numbers has no learning curve. Why were you having to "help" those kids again?
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.owlSnitSnitowl
But, 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.
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.
...
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. :)owlSnitSnitowl
Right... all sorts of scripting and working with multiple files. That is what I am talking about.
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.
-- Personal attacks from those who troll show their own insecurity. They cannot use reason to show the message to be wrong so they try to feel somehow superior by attacking the messenger.
They cling to their attacks and ignore the message time and time again.
<https://youtu.be/H4NW-Cqh308>
03/31/2017-
-
-
