Subject | Re: spreadsheet ergonomics |
From | Snit |
Date | 04/02/2017 08:34 (04/01/2017 23:34) |
Message-ID | <D505E97C.99441%usenet@gallopinginsanity.com> |
Client | |
Newsgroups | comp.os.linux.advocacy |
Follows | owl |
Followups | owl (2h & 24m) > Snit |
owlOk, the looping in the background is clearly kludgy.
Snit <usenet@gallopinginsanity.com>wrote:Snitowl
On 4/1/17, 2:23 AM, in article ab9b03.gawe@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:
...SnitowlowlSnit
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
A cool, weird, and somewhat bizarre work around.
What is weird or bizarre about it?
Hint: show the whole process... how you embedded the windows,
xterm -into ...Snitowl
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>"@"
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. :)Snitowl
, 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
...Because Apple calls them tables.owlSnitSnitowl
Oh, Apple calls them "tables"... because they are, you know, tables. :)
The table is in a container.
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)"?
...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.owlSnitowlPrinted 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
A tarball is a file.
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?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).
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:owlSnitSnitowl
or even sharing it online
Ever heard of X11 forwarding? It works great.
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.
...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).owlSnitowlSnitSnitowl
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).
Why do you say that?
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),
It does.
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.