Calc/Features/JIS and ASC functions

From Apache OpenOffice Wiki
< Calc‎ | Features
Jump to: navigation, search

JIS and ASC Spreadsheet Functions

Specification Status
Author Eike Rathke
Last Change 2007-07-25
Status Standard, implemented in CWS dr54, updated in CWS calc43

Abstract

The ASC function converts full-width to half-width ASCII and katakana characters.

The JIS function converts half-width to full-width ASCII and katakana characters.

Both functions are needed for interoperability with Japanese localized Microsoft Excel versions.

References

Reference Document Check Location (URL)
Specification Process Entry Check passed n/a
Product Requirement, RFE, Issue ID (required) available i70213
Product Concept Document not available
Test case specification (required) available .xls document attached to i70213
IDL Specification not available
Software Specification Rules n/a n/a
Other, e.g. references to related specs n/a

Contacts

Role Name E-Mail Address
Developer Eike Rathke <er@openoffice.org>
Quality Assurance Frank Stecher <fst@openoffice.org>
Documentation Uwe Fischer <ufi@openoffice.org>
User Experience n/a n/a

Acronyms and Abbreviations

Acronym / Abbreviation Definition
ASCII American Standard Code for Information Interchange
JIS Japanese Industrial Standard

Detailed Specification

JIS

Summary: Converts half-width to full-width ASCII and katakana characters.

Syntax: JIS( Text T )

Returns: Text

Constraints: None

Semantics: Conversion is done for half-width ASCII and katakana characters, some characters are converted in a special way, see table below. Other characters are simply copied from T to the result. This is the complementary function to ASC.

A followed by means that there are two consecutive characters to convert from.

From Unicode Character (c)

To Unicode Character

Comment

0x0022

0x201d

QUOTATION MARK => RIGHT DOUBLE QUOTATION MARK
This is an exception to the ASCII range that follows below.

0x005c

0xffe5

REVERSE SOLIDUS "\" => FULLWIDTH YEN SIGN
(code-page 932 legacy, for details see ASC function)
This is an exception to the ASCII range that follows below.

0x0060

0x2018

GRAVE ACCENT => LEFT SINGLE QUOTATION MARK
This is an exception to the ASCII range that follows below.

0x0027

0x2019

APOSTROPHE => RIGHT SINGLE QUOTATION MARK
This is an exception to the ASCII range that follows below.

0x0021 <= c <= 0x007e

c - 0x0021 + 0xff01

ASCII characters

0xff66

0x30f2

katakana wo

0xff67 <= c <= 0xff6b

(c - 0xff67) * 2 + 0x30a1

katakana small a-o

0xff6c <= c <= 0xff6e

(c - 0xff6c) * 2 + 0x30e3

katakana small ya-yo

0xff6f

0x30c3

katakana small tsu

0xff71 <= c <= 0xff75

(c - 0xff71) * 2 + 0x30a2

katakana a-o

0xff76 <= c <= 0xff81
followed by 0xff9e

(c - 0xff76) * 2 + 0x30ac

katakana ga-dsu

0xff76 <= c <= 0xff81
not followed by 0xff9e

(c - 0xff76) * 2 + 0x30ab

katakana ka-chi

0xff82 <= c <= 0xff84
followed by 0xff9e

(c - 0xff82) * 2 + 0x30c5

katakana du-do

0xff82 <= c <= 0xff84
not followed by 0xff9e

(c - 0xff82) * 2 + 0x30c4

katakana tsu-to

0xff85 <= c <= 0xff89

c - 0xff85 + 0x30ca

katakana na-no

0xff8a <= c <= 0xff8e
followed by 0xff9e

(c - 0xff8a) * 3 + 0x30d0

katakana ba-bo

0xff8a <= c <= 0xff8e
followed by 0xff9f

(c - 0xff8a) * 3 + 0x30d1

katakana pa-po

0xff8a <= c <= 0xff8e
neither followed by 0xff9e nor 0xff9f

(c - 0xff8a) * 3 + 0x30cf

katakana ha-ho

0xff8f <= c <= 0xff93

c - 0xff8f + 0x30de

katakana ma-mo

0xff94 <= c <= 0xff96

(c - 0xff94) * 2 + 0x30e4

katakana ya-yo

0xff97 <= c <= 0xff9b

c - 0xff97 + 0x30e9

katakana ra-ro

0xff9c

0x30ef

katakana wa

0xff9d

0x30f3

katakana nn

0xff9e

0x309b

HALFWIDTH KATAKANA VOICED SOUND MARK => FULLWIDTH

0xff9f

0x309c

HALFWIDTH KATAKANA SEMI-VOICED SOUND MARK => FULLWIDTH

0xff70

0x30fc

HALFWIDTH KATAKANA-HIRAGANA PROLONGED SOUND MARK => FULLWIDTH

0xff61

0x3002

HALFWIDTH IDEOGRAPHIC FULL STOP => FULLWIDTH

0xff62

0x300c

HALFWIDTH LEFT CORNER BRACKET => FULLWIDTH

0xff63

0x300d

HALFWIDTH RIGHT CORNER BRACKET => FULLWIDTH

0xff64

0x3001

HALFWIDTH IDEOGRAPHIC COMMA => FULLWIDTH

0xff65

0x30fb

HALFWIDTH KATAKANA MIDDLE DOT => FULLWIDTH

ASC

Summary: Converts full-width to half-width ASCII and katakana characters.

Syntax: ASC( Text T )

Returns: Text

Constraints: None

Semantics: Conversion is done for full-width ASCII and katakana characters, some characters are converted in a special way, see table below. Other characters are simply copied from T to the result. This is the complementary function to JIS.

The percent sign % in the conversion table below denotes the modulo operation. A followed by means that a character is converted to two consecutive characters.

From Unicode Character (c)

To Unicode Character

Comment

0x30a1 <= c <= 0x30aa
if c%2==0

(c - 0x30a2) / 2 + 0xff71

katakana a-o

0x30a1 <= c <= 0x30aa
if c%2==1

(c - 0x30a1) / 2 + 0xff67

katakana small a-o

0x30ab <= c <= 0x30c2
if c%2==1

(c - 0x30ab) / 2 + 0xff76

katakana ka-chi

0x30ab <= c <= 0x30c2
if c%2==0

(c - 0x30ac) / 2 + 0xff76
followed by 0xff9e

katakana ga-dhi

0x30c3

0xff6f

katakana small tsu

0x30c4 <= c <= 0x30c9
if c%2==0

(c - 0x30c4) / 2 + 0xff82

katakana tsu-to

0x30c4 <= c <= 0x30c9
if c%2==1

(c - 0x30c5) / 2 + 0xff82
followed by 0xff9e

katakana du-do

0x30ca <= c <= 0x30ce

c - 0x30ca + 0xff85

katakana na-no

0x30cf <= c <= 0x30dd
if c%3==0

(c - 0x30cf) / 3 + 0xff8a

katakana ha-ho

0x30cf <= c <= 0x30dd
if c%3==1

(c - 0x30d0) / 3 + 0xff8a
followed by 0xff9e

katakana ba-bo

0x30cf <= c <= 0x30dd
if c%3==2

(c - 0x30d1) / 3 + 0xff8a
followed by 0xff9f

katakana pa-po

0x30de <= c <= 0x30e2

c - 0x30de + 0xff8f

katakana ma-mo

0x30e3 <= c <= 0x30e8
if c%2==0

(c - 0x30e4) / 2 + 0xff94)

katakana ya-yo

0x30e3 <= c <= 0x30e8
if c%2==1

(c - 0x30e3) / 2 + 0xff6c

katakana small ya-yo

0x30e9 <= c <= 0x30ed

c - 0x30e9 + 0xff97

katakana ra-ro

0x30ef

0xff9c

katakana wa

0x30f2

0xff66

katakana wo

0x30f3

0xff9d

katakana nn

0xff01 <= c <= 0xff5e

c - 0xff01 + 0x0021

ASCII characters

0x2015

0xff70

HORIZONTAL BAR => HALFWIDTH KATAKANA-HIRAGANA PROLONGED SOUND MARK

0x2018

0x0060

LEFT SINGLE QUOTATION MARK => GRAVE ACCENT

0x2019

0x0027

RIGHT SINGLE QUOTATION MARK => APOSTROPHE

0x201d

0x0022

RIGHT DOUBLE QUOTATION MARK => QUOTATION MARK

0x3001

0xff64

IDEOGRAPHIC COMMA

0x3002

0xff61

IDEOGRAPHIC FULL STOP

0x300c

0xff62

LEFT CORNER BRACKET

0x300d

0xff63

RIGHT CORNER BRACKET

0x309b

0xff9e

KATAKANA-HIRAGANA VOICED SOUND MARK

0x309c

0xff9f

KATAKANA-HIRAGANA SEMI-VOICED SOUND MARK

0x30fb

0xff65

KATAKANA MIDDLE DOT

0x30fc

0xff70

KATAKANA-HIRAGANA PROLONGED SOUND MARK

0xffe5

0x005c

FULLWIDTH YEN SIGN => REVERSE SOLIDUS "\"

The REVERSE SOLIDUS "\" (aka backslash) is a specialty that gets displayed as a Yen sign with some Japanese fonts, which is a legacy of code-page 932, see
http://www.microsoft.com/globaldev/DrIntl/columns/019/default.mspx#EED
http://www.microsoft.com/globaldev/reference/dbcs/932.htm

related references

For references regarding halfwidth and fullwidth characters see
http://www.unicode.org/reports/tr11/
http://www.unicode.org/charts/charindex2.html#H
http://www.unicode.org/charts/charindex2.html#F

For information about the mapping of JIS X 0201 and JIS X 0208 to Unicode characters see
http://www.unicode.org/Public/MAPPINGS/OBSOLETE/EASTASIA/JIS/JIS0201.TXT
http://www.unicode.org/Public/MAPPINGS/OBSOLETE/EASTASIA/JIS/JIS0208.TXT


Migration

No migration, previous versions of OOo didn't have JIS and ASC functions.

Configuration

No configuration involved.

File Format

No file format changes.

Open Issues

None.

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Calc/Features/JIS_and_ASC_functions&oldid=40296"
Personal tools