Skip to main content
news

Re: spreadsheet ergonomics

owl
SubjectRe: spreadsheet ergonomics
Fromowl
Date04/04/2017 22:41 (04/04/2017 20:41)
Message-ID<abz89z03.gvhy@rooftop.invalid>
Client
Newsgroupscomp.os.linux.advocacy
FollowsSnit
FollowupsSnit (14m) > owl

Snit <usenet@gallopinginsanity.com>wrote:

Snit
On 4/3/17, 10:01 PM, in article abzc003.agu@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:

...

owl
I already showed connecting remotely from a VM to the host and having the app windows display on the VM.

Snit
Hey, I shared mine in a way where you can just click a link. I likely will set yours up in the next day or two, but why not just give me easy access like I gave you?

Seems you won't / can't.

Again, just easy access -- no passwords or anything, just a simple link, even if not 100% fully functional enough to get the basics. And allows me to just download a file and double click (assuming I am on desktop Linux and have a common program that generally comes with the OS).

I guess this is what you want (it may show up as an attachment depending on your newsreader):

begin 644 owlapp.tar.gz M'XL(")0!Y%@``V]W;&%P<"YT87(`[9A=;]HP%(:YSJ\X2ZL5U`'^2$C5J5/I M+K;[39HF]<8D)D08&SG.`+7][W-*&+"6,54+;34_0EAQ<LZ)L-YS7J%F@DVG MW4:=($L4AN6*HQ!MKBL:F*+(/D1ZD=W'&-&H`6&M;U51Y(9I@`:32O[IN7WW M7REJ>?XI&^%.'M=3HSS@7A#L/'_:"];G'_3L^1."@P:@>EYGF__\_(_@ZRC+ M(6&&P3`3'&8LAY1+KIGA"0P68$8<ODPU9TD^XMS`1R;B0C"C=,<[@N^J`"8F M*C<0<VU8)L4"\I$J1")/#/`D,Y"9CN?E-E06$ZZS&/C<#`L)L6:QR92$"\`0 M*Z'T\IMK[2TOL;UU.1`L'K^_7'`AU,P;COD"J-WW;:Z4P[5_V^D6R;7O>\*6 MZ),R)"\FS3XZ[^.6)U0\MKM>JHR"/K(?[[E_\Y=$I?\BJ;'&OOZ>[32?Q!$ M)"S[/XTBI_]#</2F.\AD=\#RD3?+9*)F64(OCIMS>Y')H8*VT9Q#6RMEX#;5 M?`J?^I\IW++9&$YNICJ3!H[QW4G+FR=68DJ`64QM0'N9#8YO?J6]`__2]YS\ M7A*5_DL1&#Z9UU)CG_XI"E?S'U-:^C_2(\3I_Q!LZG]NN)Y8P6?&^@"K<@SM ME*L)-WH!9VA.@E.,T"F"-@<_CZ&S<HT^O'T02QZ-[:'M:+(CFCZ(/K/1]+=H M6D6[CO)TUOZ?/*/_)QO^/UCZ?^ST?PA>C_^/%TPZ]_^OV9[_]=38._\#NI[_ MN/3_)*#._Q^$S?D_L9)OEY,XDTQ8![]I!/[>">S,0A[/LLL3[,Q#'^9Q[N"I MK.<_?;;YW\-K_8?AO?\GR/W_=Q!>S_Q/->>RVK?3_0I!L+K"YU<80NL`AB8W M.I-I.>JM1RB[TM(87*%[8V"4;%[:ZLVR2[2_,7+.R+I[`?G03?B/KBR$\-^A M5FLK(ZXRDBHCWI.1/)ZQ-"0#5*VX,B;$&1.'P^%P.!P.A\/A<-3*3_W[,Q$` #*``` ` end

In the owlapp directory, there are two startup scripts: startem and startemx. startem uses mate-terminal; startemx uses xterm and requires that the GAH3 xterm window have "Allow SendEvents" checked. Type numbers in one of the others. Then type "P<enter>" to write the file. Then hit <F3>and GAH3 will update.

...

Above you speak of Numbers needing macOS (which is not quite true but close enough). Sure, that is a deal breaker for many situations. I openly admit to the weaknesses of the solutions I talk about. I am honest.

owl
LOL.

Snit
What weaknesses do you think I try to hide?

None you can think of. OK.

I'm laughing at the honesty part.

One thing I find interesting about Linux "advocates" is how hard it is for them to speak of the weaknesses of their solutions... even such obvious things as lacking the ability to have multiple tables on one sheet in a way pretty much any user can easily create.

owl
Granny would not be able to do it with Numbers.

Snit
My intro classes often have many grandmothers (though I have not taught that class in a few semesters). Most of the students, though, are seniors. I have taught it for Mac and Windows.

I do not focus much on spreadsheets but we do a little... I get them to the point where they are given a small bag of M&Ms and they make a simple spreadsheet and chart based on it. In some classes they then combine the data -- depending on their skills and interests.

In a class for people with learning disabilities and head trauma and the like I took them further than that (again have taught that for Mac and Windows). Also true of a class for vets, though I have only taught that on Windows.

Interesting you had no comment on this... did you not expect general users, even handicapped ones, to be able to do the types of things I am talking about? They can (though my classes were before the online tools were what they are now and I did not use them).

I find it interesting that using Numbers requires taking a class. So much for ease of use.

owl
You have biased assumptions based on your personal experience with and preference for Mack.

Snit
Keep in mind I also teach on Windows... and use Linux (though not as much as I have in the past). But if you have specific examples of bias you wish to address, even though off topic here, I am open to it. I think we all have our biases. I am open to hearing about mine (does not mean I will agree with you, but I will listen).

I am sincere with this... what do you think I am biased. Be specific.

The sentence was self-explanatory.

And even with those other programs to tie into sc and support your scripts, as far as I know nothing comes close to what I have shown you. Your solution surely does not.

owl
No looping updates required. https://vid.me/txC9

Snit
The flickering of the "running external function" and other flashing messages and the inability to directly manipulate the data would be annoying for me, but if it works for you, great.

owl
Did you watch it? I told you there is no more looping update to cause "flickering" and interfere with editing. Updates are done with magic dust now.

Snit
At 0:04:11 I see "Running external function..." in GAH3. Are you saying you do not even see it? Repeats at 0:21:17 and 0:51:00.

owl
The cells in GAH3 get updated, but there is no loop. You see that text when an update occurs.

Snit
I said nothing of any loop.

You made your comment in response to my statement "No looping updates required" and mentioned an inability to directly manipulate the data, which is false..

I noted that it flashes a message. And it does. I gave specific timestamps where it happens in your video.

So? That's sc's message bar. It cannot be disabled.

If your screen recording software is not showing all frames might even be others it missed. Or I could have missed some.

There is also flashing text talking about how gah1.sc is being written to, etc.

owl
It's not in a loop.

Snit
Nobody said the flashing of "Running external function..." was from any loop. But it still happens.

So?

Care to show setting that up, from scratch, as I did with my multiple table solution?

owl
Why?

Snit
So we can compare how easy each solution is, of course.

owl
People don't make spreadsheets just to enjoy the process of making them.

Snit
Right! That is why it is important it is easy to do! They want to focus on the end product, not the process of creation.

owl
So why do you want to focus on the process of creation?

Snit
So we can see how they are created, of course. That is how we can understand how much effort goes into making something like this. Not looking up your exact wording, but even you noted people tend to care about using the tools, not setting them up. If there is a lot of setup that is a big disadvantage compared to a tool where there is little.

With Numbers you have seen it -- just plop the tables in and go. Sure, you have to pick the type of table (or modify others) but you can easily create new ones from old, etc.

All things a "grandmother" can do.

Not without taking a class, apparently.

If what you are doing is a far more complex process than that is a pretty big weakness for the exact reason you state.

owl
No, it's not complex. Just a matter of typing a few lines.

Snit
But you will not show the full creation process, as I did.

Why do you want to see me typing in vim?

Snit (14m) > owl