You Suck at Excel with Joel Spolsky (2015) [video]

Re:You Suck at Excel with Joel Spolsky (2015) [video] by Kurtz79 on Thursday September 08, 2016 @07:25AM (#12452004)

"Also, a curse on Microsoft for localizing Excel formulas - what where they thinking ?"

+1. It's like programming in Java or C and all the keyworks (if, interface, etc...) were changed to the local language.

Madness.

[ Parent | on HN ]

Re:You Suck at Excel with Joel Spolsky (2015) [video] by Tomte on Thursday September 08, 2016 @08:35AM (#12452382)

MS actually did that with Visual Basic for Applications in Excel 95.

Umlaute in keywords, yay!

Example stolen from Wikipedia:

  Prüfe Fall wd
    Fall 1
      ' Auf Sonntag wird Datum vom letzten Freitag zurückgegeben
      VorherigerGeschaeftstag = dt - 2
    Fall 2
      ' Auf Montag wird Datum vom letzten Freitag zurückgegeben
      VorherigerGeschaeftstag = dt - 3
    Fall Sonst
      ' Andere Tage: vorheriges Datum wird zurückgegeben
      VorherigerGeschaeftstag = dt - 1
  Ende Prüfe

[ Parent | on HN ]

Re:You Suck at Excel with Joel Spolsky (2015) [video] by yessql on Thursday September 08, 2016 @12:26PM (#12454469)

Ugh, I did some VBA in Germany around 2000. So crazy that keywords were in German (and command and periods have different meanings in numbers). Totally unportable code.

[ Parent | on HN ]

Re:You Suck at Excel with Joel Spolsky (2015) [video] by brians on Thursday September 08, 2016 @08:16AM (#12452249)

That was a thing, for a while: ALGOL, COBOL, a few others had alternate keyword sets for non-English languages.

[ Parent | on HN ]

Re:You Suck at Excel with Joel Spolsky (2015) [video] by skocznymroczny on Thursday September 08, 2016 @09:14AM (#12452635)

I saw a "translation for C", which was a header that #defined the keywords to their local language equivalents

[ Parent | on HN ]