Groups > comp.os.linux.advocacy > #405312

Re: spreadsheet ergonomics

From	Snit <usenet@gallopinginsanity.com>
Newsgroups	comp.os.linux.advocacy
Subject	Re: spreadsheet ergonomics
Date	2017-03-31 22:50 -0700
Message-ID	<D5048DC1.992DC%usenet@gallopinginsanity.com> (permalink)
References	<ab003g.hi4@rooftop.invalid> <D503FAB8.99172%usenet@gallopinginsanity.com> <ablaico3.ss@rooftop.invalid> <D504599B.99241%usenet@gallopinginsanity.com> <00b90q.ah33@rooftop.invalid>

Show all headers | View raw

On 3/31/17, 10:22 PM, in article 00b90q.ah33@rooftop.invalid, "owl"
<owl@rooftop.invalid> wrote:

> Snit <usenet@gallopinginsanity.com> wrote:
>> On 3/31/17, 4:19 PM, in article ablaico3.ss@rooftop.invalid, "owl"
>> <owl@rooftop.invalid> wrote:
>> 
>>> Snit <usenet@gallopinginsanity.com> wrote:
>>>> On 3/31/17, 4:48 AM, in article ab003g.hi4@rooftop.invalid, "owl"
>>>> <owl@rooftop.invalid> wrote:
>>>> 
>>>>> 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.
>>>>> 
>>>> 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>
>>> 
>>> 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.
>> 
>> 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

A cool, weird, and somewhat bizarre work around.

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

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

It is pretty cool how even in different files they can be connected.

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

As opposed to sharing a file or even sharing it online (though I think
someone needs to have an icloud.com account to use it).

>> 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),
has less robust import tools, etc. It does have some pretty cool other
features, and what it does it does (mostly) well, but it simply is not as
complete of a solution. I can show you some of the oddities I have seen with
referencing cells from other "sheets" from the same document... still works
but has some graphical oddities.

Started to make a video showing some of what I mean... got interrupted by my
9 year old coming to my office to ask me about other stuff... talked to her
as I finished the video and then helped her as it was uploading. Did not
even bother to redo the video so lot so me just fiddling around but it is
only 2:16

    <https://youtu.be/pVA0efp0gb8>

Shows me using a real, but very simple, spreadsheet I had open then using a
template then one from scratch where I have one table reference another. Do
not show different sheets in the same file but that works much as it does in
MS Office and LibreOffice.

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

Back to comp.os.linux.advocacy | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-03-31 11:48 +0000
  Re: spreadsheet ergonomics chrisv <chrisv@nospam.invalid> - 2017-03-31 09:20 -0500
    Re: spreadsheet ergonomics chrisv <chrisv@nospam.invalid> - 2017-03-31 10:07 -0500
  Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-03-31 12:23 -0700
    Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-03-31 23:19 +0000
      Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-03-31 19:08 -0700
        Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-01 05:22 +0000
          Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-03-31 22:50 -0700
            Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-01 09:23 +0000
              Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-01 09:50 -0700
                Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-02 04:45 +0000
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-01 23:34 -0700
                Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-02 08:58 +0000
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-02 08:59 -0700
                Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-03 00:14 +0000
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-02 17:33 -0700
                Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-03 01:46 +0000
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-02 19:24 -0700
                Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-03 04:53 +0000
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-03 10:20 -0700
                Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-03 19:40 +0000
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-03 10:53 -0700
                Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-03 19:38 +0000
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-03 13:01 -0700
                Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-03 20:54 +0000
          Re: spreadsheet ergonomics DFS <nospam@dfs.com> - 2017-04-01 11:47 -0400
            Re: spreadsheet ergonomics Marek Novotny <marek.novotny@marspolar.com> - 2017-04-01 11:21 -0500
              Re: spreadsheet ergonomics DFS <nospam@dfs.com> - 2017-04-02 10:44 -0400
                Re: spreadsheet ergonomics Marek Novotny <marek.novotny@marspolar.com> - 2017-04-02 15:02 -0500
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-02 13:35 -0700
                Re: spreadsheet ergonomics Marek Novotny <marek.novotny@marspolar.com> - 2017-04-02 15:39 -0500
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-02 13:52 -0700
                Re: spreadsheet ergonomics Sandman <mr@sandman.net> - 2017-04-03 07:49 +0000
                Re: spreadsheet ergonomics William Poaster <wp@dev.null> - 2017-04-02 22:42 +0100
                Re: spreadsheet ergonomics Joe <Negrojoe@cottonpickers.edu> - 2017-04-02 21:57 +0000
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-02 15:46 -0700
                Re: spreadsheet ergonomics Joe <Negrojoe@cottonpickers.edu> - 2017-04-02 23:00 +0000
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-02 16:10 -0700
                Re: spreadsheet ergonomics Peter Köhlmann <peter-koehlmann@t-online.de> - 2017-04-03 01:24 +0200
                Re: spreadsheet ergonomics flatfish+++ <flatfish@cutey.com> - 2017-04-02 19:31 -0400
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-02 16:40 -0700
                Snit digest 386 / 2017-04-03 Sandman <mr@sandman.net> - 2017-04-03 07:56 +0000
                Re: spreadsheet ergonomics Peter Köhlmann <peter-koehlmann@t-online.de> - 2017-04-03 09:47 +0200
                Re: spreadsheet ergonomics flatfish+++ <flatfish@cutey.com> - 2017-04-03 12:17 -0400
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-03 10:57 -0700
                Re: spreadsheet ergonomics Steve Carroll <fretwizzer@gmail.com> - 2017-04-03 11:34 -0700
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-02 16:34 -0700
                Re: spreadsheet ergonomics Marek Novotny <marek.novotny@marspolar.com> - 2017-04-02 19:49 -0500
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-02 18:00 -0700
                Re: spreadsheet ergonomics Marek Novotny <marek.novotny@marspolar.com> - 2017-04-02 21:36 -0500
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-02 19:45 -0700
                Re: spreadsheet ergonomics Sandman <mr@sandman.net> - 2017-04-03 08:09 +0000
                Re: spreadsheet ergonomics Marek Novotny <marek.novotny@marspolar.com> - 2017-04-03 10:43 -0500
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-03 11:05 -0700
                Re: spreadsheet ergonomics Sandman <mr@sandman.net> - 2017-04-03 21:08 +0000
                Re: spreadsheet ergonomics Sandman <mr@sandman.net> - 2017-04-03 08:02 +0000
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-03 11:48 -0700
            Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-01 09:56 -0700
              Re: spreadsheet ergonomics Steve Carroll <fretwizzer@gmail.com> - 2017-04-01 10:12 -0700
            Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-02 05:01 +0000
  Re: spreadsheet ergonomics Chris Ahlstrom <OFeem1987@teleworm.us> - 2017-04-01 04:53 -0400
    Re: spreadsheet ergonomics Marek Novotny <marek.novotny@marspolar.com> - 2017-04-01 08:30 -0500
    Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-02 05:00 +0000
      Re: spreadsheet ergonomics Chris Ahlstrom <OFeem1987@teleworm.us> - 2017-04-02 09:01 -0400
        Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-02 20:41 +0000
          Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-02 13:57 -0700
            Re: spreadsheet ergonomics Joe <Negrojoe@cottonpickers.edu> - 2017-04-02 21:10 +0000
              Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-02 14:22 -0700

csiph-web