News for hackers. Stuff that matters.
Re:Excel never dies (2021) by jerry1979 on Thursday August 04, 2022 @06:13PM (#32348977)
>I was horrified to find that even with the supporting scripting capabilities, the entire paradigm revolves around knowing the shape of your data in advance.

Just record yourself finding the bottom of the data set (Ctrl + down arrow), then take a moment to make the code work in relative terms instead of absolute terms.

Re:Excel never dies (2021) by adepressedthrow on Thursday August 04, 2022 @06:51PM (#32349321)
What do you mean by this? What am I "recording" as the bottom of the data set?

My point was that it is very hard to have a dynamic number of rows feed a proportionate dynamic number of rows. Scripting makes it much simpler, but at least with Google Sheet's scripting, the API seemed pretty lacking for that processing (in the very least, it's very slow, since it's running as a very constrained shared resource).

Re:Excel never dies (2021) by spywaregorilla on Thursday August 04, 2022 @08:43PM (#32350160)
Excel let's you create macros by hitting "record" and then doing the operations yourself. It'll generate the code to replicate the impact of your inputs.