OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: DBCS function and others in section 2.1.3 Large Group


another one:

| TODO: Currently the list above includes functions “hidden” in Excel that
| perhaps should be removed: DBSC, HYPGEOMVERT, MNORMSINV, PHONETIC,

We got a request to support the DBCS (note that it's not DBSC, which
seems to be a typo in our document) function, which in Japanese Excel
versions is named JIS, and the complementary ASC function (despite that
they aren't related to JIS <-> ASCII text encoding conversion, as the
names may suggest). Both seem to be actively used in Japanese
environments. But might also do different things in other
localizations.. See also

As for HYPGEOMVERT: this seems to be a typo/copy&paste error, the
function is called HYPGEOMDIST, hypergeometric distribution, and is not
hidden. HYPGEOMVERT is the German localized function name (Verteilung ==

MNORMSINV is a typo, the function name is NORMSINV instead. Was probably
copied from http://sc.openoffice.org/excelfileformat.pdf ;-)

As for PHONETIC I agree that it isn't too important and most probably
will work for English language only anyway.

USDOLLAR is a bit different. In a German localized Excel version it is
named DM, but of course now doesn't return the old Deutsche Mark as
currency, but the new Euro instead. Actually it depends on the locale
(regional setting) you're working with, I currently get Japanese Yen
because I tried the JIS function before.. This function is quite
nonsense, as it yields different results that when taken seriously are
even different amounts of money when the same document is loaded in
different locales, or even in the same locale after some time has passed
and currency changed..


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]