Skip to main content
news

Re: spreadsheet ergonomics

Snit
Google Google
SubjectRe: spreadsheet ergonomics
FromSnit
Date04/06/2017 18:59 (04/06/2017 09:59)
Message-ID<D50BC1EF.9D0EC%usenet@gallopinginsanity.com>
Client
Newsgroupscomp.os.linux.advocacy
Followsowl
Followupsowl (57m) > Snit
On 4/6/17, 5:38 AM, in article ahcjz93.g88b@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:

owl
DFS <nospam@dfs.com>wrote:

DFS
On 4/5/2017 10:01 PM, DFS wrote:

ActiveCell.FormulaR1C1 = "=SUM(R[-10]C:R[-1]C)"

Whoops. Make that "=SUM(R[-9]C:R[-1]C)"

http://imgur.com/a/NHHS7

owl
Is there not a way to feed it a count instead of just seeing how many it can create in 15 seconds?

Just for the fun of it I looked up a script for creating and populating a table in Numbers: <https://iworkautomation.com/numbers/table-populate.html>

I ran the first script on the page, unedited. It does not do what yours does but I think it makes the point. While there are certainly ways to speed the script up, such as not having it create random numbers, not watching the results as it runs, not aligning the data, etc., I think we can safely say both sc and Excel kick Number's ass on this one. :)

<https://youtu.be/l43rtWFrq38>

Impressive, eh?

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

<https://youtu.be/H4NW-Cqh308>

Google
owl (57m) > Snit