3 ms·
The article also does not mention that not only Excel Formulas are localized, but VBA was localized in Office 95 as well [1]. This is German VBA: Funktion
by nikeee 7y ago
The article also does not mention that not only Excel Formulas are localized, but VBA was localized in Office 95 as well [1].
This is German VBA:
Funktion VorherigerGeschaeftstag(dt Als Datum) Als Datum
Dim wd Als Integer
wd = Wochentag(dt) ' Wochentag liefert 1 für Sonntag, 2 für Montag usw.
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
Ende Funktion
[1] https://de.wikipedia.org/wiki/Visual_Basic_for_Applications#VBA_unter_Office_95 https://de.wikipedia.org/wiki/Visual_Basic_for_Applications#...
- Freak_NL 7y agoThe localisation of Excel goes even further. If I send a normal CSV file (that is, one containing values separated with actual commas and newlines) to an American, their Excel can open it. If I send the same file to a fellow Dutchman, their Excel can't. Excel, for some obscure reason lost in time, decreed that the Dutch do not, in fact, separate their comma-separated values with commas. We use semicolons. No one seems to know why Microsoft thinks we apparently do this. That means that a normal bog-standard CSV file won't work by just double-clicking it or opening it in Excel. That's right: a Dutch comma-separated values file must have semi-colons according to Excel. LibreOffice meanwhile works with anything you throw at it, in any language, of course. It'll just ask you about the separators, defaulting to commas.