Skip to main content
news

Re: spreadsheet ergonomics

owl
SubjectRe: spreadsheet ergonomics
Fromowl
Date2017-04-01 07:22 (2017-04-01 05:22)
Message-ID<00b90q.ah33@rooftop.invalid>
Client
Newsgroupscomp.os.linux.advocacy
FollowsSnit
FollowupsSnit (28m) > owl
DFS (10h & 25m) > owl

Snit <usenet@gallopinginsanity.com>wrote:

Snit
On 3/31/17, 4:19 PM, in article ablaico3.ss@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:

owl
Snit <usenet@gallopinginsanity.com>wrote:

Snit
On 3/31/17, 4:48 AM, in article ab003g.hi4@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:

owl
https://vid.me/UgNo Spread your work out how you want it with sc. There are two views of the main sheet (green), and two sets (yellow and blue) of other sheets. Data enterened into any of the auxilliary sheets gets totaled and sent to the main sheet.

Snit
Right... you can have related tables, but you can only have one table per window, right? You cannot, for example, have someone open a page and get something like this (hmmm, though I had an old video of this... maybe not, so made a new one):

<https://youtu.be/V2bRLDuaVOk>

owl
We've been over the embedding of windows in X11. xterm has it as an option, and xdotool allows it for most any window. Of course, this is window embedding, not document embedding, but you can simulate document embedding by using a frame and sizing/positioning the embedded window to the frame, then having text appear to wrap around the embedded window by wrapping around the frame.

Snit
Right, you can do some rather extreme and bizarre work arounds to get similar end results... sort of.

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

That's the main.sc sheet from earlier, now embedded in a scribus window, and taking data from the other sheets. Editing the other sheets shows those updates in the scribus sc window. Both local and remote editing demonstrated.

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.

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?

Snit (28m) > owl
DFS (10h & 25m) > owl