Google| Subject | Re: spreadsheet ergonomics |
| From | Snit |
| Date | 04/01/2017 18:50 (04/01/2017 09:50) |
| Message-ID | <D505284A.99338%usenet@gallopinginsanity.com> |
| Client | |
| Newsgroups | comp.os.linux.advocacy |
| Follows | owl |
| Followups | owl (11h & 55m) > Snit |
On 4/1/17, 2:23 AM, in article ab9b03.gawe@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:
...
Hint: show the whole process... how you embedded the windows, how you tied them together, etc. Hey, let us each show that with four tables, all tied together and having simple equations flow through them.owlowlSnit
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?
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.
Now I *know* it would be trivial to just have one table do that simple math. Obviously. If I wanted to make this more real-world I would have us replicate the magic system tables I have shown you (even there the math is trivial but there is a reason for multiple tables). But that would take more time -- this is just about the concept of having related tables and, in this case, a simple graph.
To add to the challenge let us have it so the last two tables are on a different tab... but the graph stays with the first two tables.
Here, after I wrote the rest of this post I decided to just do it... not have you do it first or whatever. You can see I start with showing you the file I shared with you online:
<https://youtu.be/YfvQb8cxTBg>
I also do some fiddling with the size and even style of the chart to, I guess, make it look prettier? No real use other than to show it. I do NO other editing of the look of the table or anything like that (we can compare those things later if we like). I do not even have a title or legend on the chart (though you can see on the side it would be just a couple click to get those).
So you can see the final product (and even modify it if you want):
<https://www.icloud.com/numbers/0m6a5IKo-pJFgG8dY32KU-f-A#Owl2>
Pretty sure you do not need an iCloud account to work with that.
Of course... and they are in windows which are also containers (and they are in sheets and tabs, both of which are containers).Snitowl
Oh, Apple calls them "tables"... because they are, you know, tables. :)
The table is in a container.
Fair enough... but that is to be expected with odd work-arounds, even cool ones.owlThat'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.Snit
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.
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.owlPrinted 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.
LOL! I am speaking of just letting people easily access and even edit the stuff online. Here:Snitowl
or even sharing it online
Ever heard of X11 forwarding? It works great.
<https://www.icloud.com/numbers/0UHGZUxdd85R698KTKmddNd5w#For%5FOwl>
Again, I do not think you need an iCloud account to look at it or edit it... not even to add tables (right now there is only one table and one chart). Also notice I have it hooked to actual stock prices ... just a standard template but I figured that would add some interest.
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).Snitowl
(though I think someone needs to have an icloud.com account to use it).SnitAgain, 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?
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.
And easy (and also why I included adding new sheets in the above)... but lacking in many features / capabilities any "real" number cruncher would need. It definitely is designed for light duty!Snitowl
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.
Numbers and sc are made for very different purposes... not trying to say Numbers can do all sc can do, just showing some of the reasons why sc might not be the best tool for all jobs (though if it works for you, cool).
-- 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.
03/31/2017-
-
-
