The Daily WTF: Curious Perversions in Information Technology

LB_ · 2015-11-22 Reply Admin

spn.innerHTML = "";

dkf · 2015-11-25 Reply Admin

Just looking at the definition of arBlank makes me cringe inside.

PWolff · 2015-11-25 Reply Admin

If only the Microsoft guys wouldn't have thought the Range object methods Clear and ClearContents were superfluous after Excel 2000.

gleemonk · 2015-11-25 Reply Admin

This code needs the loving care of an axe.

PWolff · 2015-11-25 Reply Admin

The code is a bit un-enterprisey. Better would be

for (var i=1; i<=50; i++) {
for (var j="A"; j<="N"; j++) {
   arBlank = [
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""],
      ["", "", "", "", "", "", "", "", "", "", "", "", "", ""]
   ];
};};

george_gonzalez · 2015-11-25 Reply Admin

I"m not too hep on VBA and Excel, but I'm guessing this could be done with one line by specifying a range?

LB_ · 2015-11-25 Reply Admin

Did you mean to reply to me? I don't understand if so.

Yamikuronue · 2015-11-26 Reply Admin

Looks like someone's first Node.JS code. Am I right, @accalia? :D

accalia · 2015-11-26 Reply Admin

:mask:

icky icky!

Dreikin · 2015-11-26 Reply Admin

Yamikuronue:
Looks like someone's first Node.JS code.

I'm pretty sure my work on vote isn't that bad! I hope…

Scarlet_Manuka · 2015-11-26 Reply Admin

PWolff:
If only the Microsoft guys wouldn't have thought the Range object methods Clear and ClearContents were superfluous after Excel 2000.

Fortunately my copy of Excel 2007 (I'm at work at the moment) is one of those ones that by a freakish accident somehow still has them. By an incredible coincidence, I'm willing to bet that if I check my home copy of Excel 2016, it will too. I'm just lucky, I guess.

Eldelshell · 2015-11-26 Reply Admin

She probably got bored. I mean, JS + Excel? If it was me you would have found my brains splattered on the ceiling.

PWolff · 2015-11-26 Reply Admin

Sorry, I ran short of irony tags.

PWolff · 2015-11-26 Reply Admin

You're perfectly right.

That's btw my thought when I scanned the methods of the Range class for some meaningful name and found Clear and ClearContents which do exactly as their names suggest. Took me ~ 1/10 of the time to copy-paste compose my code suggestion.

AlexMedia · 2015-11-26 Reply Admin

Eldelshell:
I mean, JS + Excel?

Yes, it's yet another way to do Excel automation apart from VBA, Office Interop and Visual Studio Tools for Office (VSTO). The key difference is that these add-ins can also run in Excel on the Web.

foxyshadis · 2015-11-26 Reply Admin

PWolff:
Sorry, I ran short of irony tags.

Jokes are supposed to be funny.

Try to not trigger Poe's Law, because the default assumption is idiot not troll.

Scarlet_Manuka · 2015-11-27 Reply Admin

PWolff:
Sorry, I ran short of irony tags.

Meh, I was trying to play along, but I don't think it worked all that well. But :barrier: to :postbox: and all that.

2016-12-03 Reply Admin

I really like how they keep setting spn.innerHTML = ""

As if it was going to somehow change while they weren't looking.

Mid-Stream Switch

Leave a comment on “Mid-Stream Switch”