Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: spreadsheet ergonomics

Show all headers | View raw

Snit <usenet@gallopinginsanity.com> wrote:
> 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.
> 

What is weird or bizarre about it?


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

The table is in a container. 


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

I wish there was more documentation.  Or at least more users
sharing their experiences online.  Figuring out how to do things
with sc involves a great deal of trial and error.


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

A tarball is a file.

> or even sharing it online

Ever heard of X11 forwarding?  It works great.

> (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),

It does.

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

Pretty.

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 14:17 -0700
                Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-03 21:24 +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 Snit <usenet@gallopinginsanity.com> - 2017-04-03 14:16 -0700
          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 Marek Novotny <marek.novotny@marspolar.com> - 2017-04-03 16:14 -0500
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-03 14:18 -0700
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-03 14:26 -0700
                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