Skip to main content
news

Re: spreadsheet ergonomics

Snit
SubjectRe: spreadsheet ergonomics
FromSnit
Date04/05/2017 06:32 (04/04/2017 21:32)
Message-ID<D509C17D.9CDA6%usenet@gallopinginsanity.com>
Client
Newsgroupscomp.os.linux.advocacy
Followsowl
Followupsowl (50m) > Snit

On 4/4/17, 8:59 PM, in article i88vz003.pvh4e2@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:

...

owl
How long does it take in Numbers to create a sheet with 52000 tables with locked formulas and labels (A-Z with 2000 tables in each column, each table with a label{#} at the top, and a sum the bottom, summing 10 rows)? And how long does it take to navigate to a specific such table?

2.57 seconds here with sc.

Snit
I assume you are sending it instructions with some script... but even if I did that I am SURE Numbers would take much longer. That is the type task Numbers sucks at -- no argument here. And I also realize that there are many instances where people DO want spreadsheets similar to what you speak of to deal with large amounts of data and number crunching.

owl
Well, try it and let's see the results.

Can I see your solution with "a sheet" with "52000 tables" on it?

...

Emphasis on style instead of substance.

Snit
You tend to label things which benefit usability as "fluff" or just "style" when they, often, are key to how tools are used.

owl
To Mack, everything is a flyer.

Not sure what you mean here.

Snit
...

LOL! Yeah, no assuming you have enough common sense to figure out people do not want to lose data. Repeatedly.

owl
Where is the "common sense" in renaming an open file?

Snit
Has already been discussed MANY times with me giving specific examples of when I have done so. Just off the top of my head:

* Downloaded a video and opened it... then realized it is was in the place I store it nor with the name (or label) I prefer. No reason to close it just to rename and move it (and add a label)!

* Opened files named "[Whatever] - New" and "[Whatever]" and, as I worked with them, realize I had related files with a different naming scheme... and saved in different folders. So renamed them to "[Whatever]" and "[Whatever] - OLD" and also moved them to their correct folders.

owl
None of that represents "common sense."

Snit
So it makes more sense to close the files, rename them, move them, and then open them? Heck, even if you do it that way it is STILL easier on macOS -- you can (for most programs) just use the recent items lists!

So even doing that rather non-intuitive, inefficient, workaround for a lack of a simple ability to rename and move files without closing them Linux still does not do a very good job.

owl
Nobody even cares to do that.

Well, Linux "advocates" will never admit to the advantage because Linux does not have it. Sure.

Mack is only a small percentage of computers, and it's the only one that does that insanity.

See: as with many "advocates" you put down features and choices Linux lack. So be it... I prefer choice. You do not. No reason to argue over different tastes.

Snit
Why in situations such as that, as well as any other similar one, would you want to HAVE to close the file just to rename it or move it. That is a pretty big limitation!

owl
"Save As..."

Snit
That creates a copy.

owl
So?

It is a huge moving of goal posts from renaming a file. I mean, really, if I want to rename and move a video I am watching why would I copy it?

And I believe I read something about people complaining about not having a "Save As..." and so they put it back, along with a "Duplicate" choice. The Apple crew is just a bunch of clods.

Snit
I think it is good to have both available -- they do different things and both are of value!

owl
So "duplicate" deletes the original?

Ah, another place you are lacking in common sense -- of course it does not. That is not what the word "duplicate" means and nobody suggested it should or would do such a thing.

Hint: duplicate serves to DUPLICATE the file. Works much like the duplicate command in the Finder, really (though not quite exact).

Snit
Right... your solution for one program, not built in and never explained, and with the video with bizarre zooming (curious why you did that... does not really hurt it but just weird).

owl
It may remain a mystery. I keep some magic to myself.

Snit
Meaning faked or, more likely, some significant weaknesses you will not share. OK.

owl
It's not faked. It's very real. And by the way that "bizarre zooming" is xmag, which has been around since the dawn of time. I'm surpised you didn't recognize it. My window manager doesn't support zooming, so I use xmag.

I did not know the program but I saw what you did. Just bizarre zooming. Why not just, well, zoom in and show what you want to show? Do it in post production so you can stay focused on the topic.

Snit
But it shows your thinking in terms of one program

owl
Once again you try to move the goal posts. Your specification was for doing it LibreOffice.

Snit
The idea is to have it be, largely, system wide. And I have noted where the macOS environment, while doing a better job at it, is far from perfect.

owl
That's the idea *now*.

Whose idea and when was it different? Seems you are just confused.

Snit
and not the system... while showing something I did not expect you to so, sure, well done. Curious why you never shared it... I suspect you had different instances of LO or other weaknesses.

owl
Nope.

Snit
If there was not a significant weakness you would happily share it. Not going to play guessing games to try to figure out what, but clearly there is.

owl
Wouldn't want you to get a virus.

What a cold thing to say. :)

Snit
If nothing else you cannot just drag and drop from your file browser.

owl
My browser?

Snit
<https://en.wikipedia.org/wiki/File_manager> ----- A file manager or file browser is a computer program that provides a user interface to manage files and folders. The most common operations performed on files or groups of files include creating, opening (e.g. viewing, playing, editing or printing), renaming, moving or copying, deleting and searching for files, as well as modifying file attributes, properties and file permissions. Folders and files may be displayed in a hierarchical tree based on their directory structure. Some file managers contain features inspired by web browsers, including forward and back navigational buttons. -----

This is a common way of moving and renaming files. And, of course, with Linux if you do that without closing a file first you are far more likely to run into problems.

owl
Nope.

Sure you are... heck, when you tried your created a solution that lead to a huge risk of lost data. Then blamed ME for not telling you that such a solution should, well, not be a huge risk to losing data.

Maybe you just have no data you care about.

It is your responsibility to detail everything you expect from a solution.

Snit
The assumption of basic common sense is included in everything I say.

owl
A written specification represents the totality of the requirments.

Snit
So you do not assume and take into consideration common sense with your work. Fair enough. That is just one other way we look at things differently. For me common sense and thinking in terms of risks is important and just comes naturally. For you that is not the case.

owl
You wrote the specification. It's your FAIL. I can't help it if you are unable to put a coherent request to paper.

Snit
As I said, I made the assumption of common sense from you... and, yes, clearly that was my failure.

owl
Nope. You just fucked up your specification. Simple as that.

Already agreed I made the mistake of assuming you would use common sense. Not sure why you want to keep focusing on that.

-- 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>

owl (50m) > Snit