Skip to main content
news

Re: spreadsheet ergonomics

owl
SubjectRe: spreadsheet ergonomics
Fromowl
Date04/02/2017 06:45 (04/02/2017 04:45)
Message-ID<abc90z8.3ahie@rooftop.invalid>
Client
Newsgroupscomp.os.linux.advocacy
FollowsSnit
FollowupsSnit (1h & 48m) > 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,

xterm -into ...

how you tied them together

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

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

https://vid.me/FU0X

...

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

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)"?

...

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

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

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

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.

X11 forwarding lets people easily access and edit stuff remotely.

...

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

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.

Snit (1h & 48m) > owl