Science Memes

11453 readers

880 users here now

Welcome to c/science_memes @ Mander.xyz!

A place for majestic STEMLORD peacocking, as well as memes about the realities of working in a lab.

Rules

Don't throw mud. Behave like an intellectual and remember the human.
Keep it rooted (on topic).
No spam.
Infographics welcome, get schooled.

This is a science community. We use the Dawkins definition of meme.

Research Committee

[email protected]

Other Mander Communities

Science and Research

Biology and Life Sciences

Physical Sciences

Humanities and Social Sciences

Practical and Applied Sciences

Memes

Miscellaneous

founded 2 years ago

MODERATORS

[email protected]

967

LPT Do it. (mander.xyz)

submitted 7 months ago by [email protected] to c/[email protected]

176 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 19 points 7 months ago (1 children)

If you are, like I once was, the poor fool who has to maintain a bunch of VBA macros... Extract them into files and source control those. Make a script to extract them and to put them back, and use git-lfs for the actual workbook if you need a template workbook.

Now pardon me, I need to add this to the agenda for my next therapy.

[–] petersr 8 points 7 months ago (1 children)

I will join that therapy session. This is pretty much what we did, except LFS, since it was "a requirement" to also track what they layouting of the Excel file was like.

And even extracting and inserting the code was not stable. Excel will arbitrarily change the casing of ".path" to ".Path" for no reason and add and remove whitespace between functions as it see fit. It was such a pain. We also had a hard time handling unicode strings for instance containing a degree sign. And the list goes on.

[–] [email protected] 3 points 7 months ago (1 children)

Perhaps M$ does that specifically to make it hard to work with their formats? That way, tools like libre office stay not 100% compatible, preserving their market share.

[–] petersr 1 points 7 months ago

I hear ya. But to be honest, what they are doing here is fine, and doesn't seem malicious. There is an Open Document specification and they stick to it, but the spec doesn't enforce everything. For instance for the ordering of certain elements on the page, I bet you they store store those elements in memory in an efficient data structure where ordering doesn't matter, so when writing out the memory to disk, the easiest for them to do is just write it out in what order it appears in their data structure.

But there are probably other cases where they are not so innocent.