Skip to main content
news

Re: spreadsheet ergonomics

Snit
SubjectRe: spreadsheet ergonomics
FromSnit
Date04/02/2017 08:34 (04/01/2017 23:34)
Message-ID<D505E97C.99441%usenet@gallopinginsanity.com>
Client
Newsgroupscomp.os.linux.advocacy
Followsowl
Followupsowl (2h & 24m) > Snit

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

owl
Snit <usenet@gallopinginsanity.com>wrote:

Snit
On 4/1/17, 2:23 AM, in article ab9b03.gawe@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:

...

owl
Nothing bizarre about it at all. It's not much different from your embedded tables, which are also in frames (or whatever Apple calls the containers).

https://vid.me/Al6B

Snit
A cool, weird, and somewhat bizarre work around.

owl
What is weird or bizarre about it?

Snit
Hint: show the whole process... how you embedded the windows,

owl
xterm -into ...

Snit
how you tied them together

owl
In the main sheet:

let <cell>= @ston(@ext("sc -W<range><file>2>/dev/null",0))

along with:

1-sec looping of an update script with xdotool type --window <windowid>"@"

Ok, the looping in the background is clearly kludgy.

Snit
, etc. Hey, let us each show that with four tables, all tied together and having simple equations flow through them.

For consistency sake and to make things easy:

Table 1: numbers 1-20 Table 2: add 3 to each number Table 3: multiple the results by 3 Table 4: subtract 9 from each number

Then have a graph showing the data from table 4.

owl
https://vid.me/FU0X

You clearly have that scripted before recording. I started a new file and did everything on screen. Even shared it so you can easily play with it online... add vulgar images or whatever you wanted to do. :)

Did you bother to click my link and look at it at all?

...

Snit
Oh, Apple calls them "tables"... because they are, you know, tables. :)

owl
The table is in a container.

Snit
Of course... and they are in windows which are also containers (and they are in sheets and tabs, both of which are containers).

owl
Then why did you say "Apple calls them 'tables' because they are tables" in response to my saying that "the tables are are also in frames (or whatever Apple calls them)"?

Because Apple calls them tables.

The tables are in other containers (tabs, windows, etc.) but the tables are just tables. And the tables have rows and columns and cells.

...

Printed docs are static anyway, so it doesn't matter how you get to the result. Documents shared for editing can just share the whole process if necessary.

Snit
As opposed to sharing a file

owl
A tarball is a file.

Snit
Which contains a bunch of files (at least in this case) and they are not in any way treated as a single file once they are in a usable format.

owl
The files might be accessed through a single script, which might be tied to a hotkey or launcher.

I am talking about just sending a spreadsheet to someone and letting them use it. If it is multiple files in the background (say in a zipped format) that is fine -- as long as the end user can just open it and use it.

Documents do not need to be in single files. Are not docx files themselves just compressed archives of multiple files?

I believe so. Same with the files Numbers use (you can even open the "package" contents and look at it if you care to... but most users have no such need ever).

Snit
or even sharing it online

owl
Ever heard of X11 forwarding? It works great.

Snit
LOL! I am speaking of just letting people easily access and even edit the stuff online.

owl
X11 forwarding lets people easily access and edit stuff remotely.

Would love to work with your shared content... just post a link like I did. In case you lost my link (looks like it was snipped) here it is:

<https://www.icloud.com/numbers/0m6a5IKo-pJFgG8dY32KU-f-A#Owl2>

Should work on pretty much any modern browser. If you have macOS or iOS you can even open it in a local copy of Numbers. The fact you need one of the Apple OSs, though, is a pretty big weakness.

Seriously, though, play with it for a bit and see how easy it is... even if the online version offers less than the desktop version. And keep in mind the focus of the tool is NOT on heavy duty calculations. If you want to have fun, try creating a table with a few thousand rows and columns. Not sure it will even let you (likely not) but if it does I am sure it will be slow. Even the desktop one would be. And I think the online version lacks some functions... but even it has fewer than Excel (and, I am sure, sc).

Again, NOT pushing Numbers as the be-all and end-all of spreadsheets or putting sc down... just noting it does many of the things it is designed for better (in my view). And if you disagree, so be it.

One big strength of sc is you can use it on any UNIX or Unix-like OS or even other ones.

...

Snit
Again, though, nothing wrong with sc and while Numbers does plenty it does not, sc is a MUCH more powerful tool for "real" number crunching (as is even Excel).

owl
Why do you say that?

Snit
Numbers does not handle very large tables, lacks some functions and formatting, does not allow to lock specific ranges or cells as Excel does (do not know if sc does that but I would not be surprised if it did not),

owl
It does.

Snit
With password protection? If so that is news to me (though I am sure there is a LOT it can do which I am unaware of... remember, have not touched it since the '90s and even then only briefly).

owl
It offers cell and range locking, but not password protection. I believe that password protection of documents is typically implemented weakly anyway. Besides, I don't see the benefit in password-protecting the locking of cell ranges anyway, unless you just want to protect a particular copy of a document, which can be done with system perms.

It would have come in handy even with the spell tool that the kids I was working with posted... they only wanted people to be able to edit specific cells of specific tables (and even then only with specific values).

You can do that with Excel (though you cannot have more than one table per sheet). I would have to double check but I am pretty sure you can do the same thing with LO Calc... if I remember correctly there were some limitations compared to Excel but I cannot recall what they were. Could be wrong (or it could be outdated).

-- 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://www.facebook.com/WOMENSRIGHTSNEWS/videos/1456735851015867/

owl (2h & 24m) > Snit