• wischi
    link
    fedilink
    arrow-up
    12
    ·
    2 days ago

    Does that get translated if someone else with a different language opens that file?

    • bleistift2@sopuli.xyz
      link
      fedilink
      English
      arrow-up
      8
      ·
      2 days ago

      The best part is that if your version of Excel is German, you can’t write =IF(). You have to use =FALLS().

      It’s always fun to google a function and then the translation.

      • wischi
        link
        fedilink
        arrow-up
        8
        ·
        2 days ago

        I’m pretty sure it’s not FALLS() but WENN(), at least the last time I used Excel.

        • bleistift2@sopuli.xyz
          link
          fedilink
          English
          arrow-up
          1
          ·
          2 days ago

          Could be. I try to avoid Excel. And I believe “wenn” is a wrong translation, whether the function has that name or not.

    • MedievalPresent@discuss.tchncs.de
      link
      fedilink
      arrow-up
      5
      ·
      2 days ago

      Internally Excel saves it in English (or some internal code) and translates it when opened.

      My company switched from Excel-Interops, where you had to send the German function name to Excel. Now we write .xlsx files directly and have to send the English function name. But when opened it displays all functions in German (or whatever localization Excel is set to).