Skip to main content
news

Re: spreadsheet ergonomics

Snit
SubjectRe: spreadsheet ergonomics
FromSnit
Date04/04/2017 18:29 (04/04/2017 09:29)
Message-ID<D509180F.9CA33%usenet@gallopinginsanity.com>
Client
Newsgroupscomp.os.linux.advocacy
Followsowl
Followupsowl (4h & 19m) > Snit

On 4/3/17, 9:45 PM, in article zb3ugoa00.aulu@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:

...

owl
You haven't shown any benefit to that.

Snit
Sure I have... it allows you to group logically separate concepts into separate tables on the same sheet, it allows you to have data where columns do not line up, etc. I focused on this in the video on the magic spell calculation.

owl
And I do all of that using separate windows, possibly embedded into a single window.

So show it... including the creation process. THAT will show the benefits you are missing... the ease of use.

Snit
On the other side, I do not believe you have offered any benefits to denying such choice.

owl
I don't deny such choice. I provide it.

So show it.

Snit
Keep in mind nothing in Numbers forces you to do it this way.

owl
I can freeze ranges and view distant cells, or I can jump to a distant table with

g "table3"

That jump could also be tied to a function key, so that hitting f3 would take me there.

Snit
What is the benefit to combining them? And what about different widths? I talk about that some here:

<https://youtu.be/VzVKlou6byU>

Here is the video I spoke of which talks about some of the benefits you say I have not shown.

owl
Mine does all of that.

So show it.

...

I can live with a 22-million cell limit.

Snit
I have not suggested the point of multiple tables in one sheet has anything to do with bypassing a limit of cells per table.

owl
You have implied that you want everything visible at a glance.

For the spell-cost example, sure.

That limits your cell use to however many cells can appear in the window, whether that's a sheet or a group of tables arranged in the window. So why even have more than about 1000 cells in a sheet if you're never going to use them? All that capacity is going to waste with your appoach.

That spreadsheet does not have more than 1000 cells. It has 247, though some of those are merged, so if you count the merged cells as just single cells it has fewer than that.

But why limit the tool to this one task? This again shows you thinking in terms of computers as single-task tools: the value of the tools is they can be used for many things (though different tools will be better for different uses).

Time and time again we see you thinking in terms of programs and tools being used ONLY for one task. And time and time again we see me thinking in terms of broader usage.

At the same time, you see the little pieces and how to combine them and do a great job with that, so you can handle a very wide range of single tasks, even if in a cumbersome way, where I would likely be more limited on the tasks I can do BUT those I do I generally do in an easier way.

It is just an interesting observation about how we see tech (and I am sure there are exceptions to these broad generalizations).

...

The risk is huge. It is closed-source.

Snit
What harm would you expect me to have run into. Anyone? By all means point to it.

owl
Malware.

Just one example:

https://support.apple.com/en-us/HT205373 <quote> Keynote, Pages, and Numbers Available for: OS X Yosemite v10.10.4 or later, iOS 8.4 or later Impact: Opening a maliciously crafted document may lead to unexpected application termination or arbitrary code execution </quote>

There are security holes for any software, or at least any complex software. Sure. But that is for Numbers 3.6 on iOS and I am using Numbers 4.1 on macOS (and using the online version). In other words, that is not even relevant to the OSs or versions I am using!

Snit
With YOUR suggestion, with an open source tool, we saw the hazard: an unknowing person could have lost data. Twice.

owl
We saw you move the goalposts beyond the specifications.

Yeah, I merely noted I wanted an open file to be renamed, I did not note I wanted this done in a way that would not lose data in that file and others. This, of course, would be simply assumed by any reasonable person... but you did not. It is quite telling as to how you see technology... almost as if you want to think like a computer and not assume basic knowledge and only go with what the "programmer" tells you. I mean, really, the concept that the task should NOT lead to repeated data loss in multiple files is NOT a specification that should have to be stated. It would be insane to try to list EVERY single simple assumption like 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 (4h & 19m) > Snit