Documentation/Calc Functions/JIS
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
JIS
Category:
Text
Summary:
Converts half-width to full-width for ASCII and katakana characters. JIS is the complementary function to ASC.
Syntax:
JIS(Text)
Returns:
Returns a text string that comprises the converted characters.
Arguments:
Text is a string (in quotation marks) or a number, or a reference to a cell containing one of those types, that contains the characters to be converted.
Additional details:
JIS is an acronym for Japanese Industrial Standards.
Conversion is carried out for half-width ASCII and katakana characters, with some characters being converted in a special way (for more information on this, visit the JIS and ASC functions page located in another part of this wiki). Other characters are copied from the input string to the result string with no change.
Examples:
| Formula | Description | Returns |
|---|---|---|
| =JIS("LibreOffice") where the characters comprising this argument are all half-width. | Here the function converts all characters in the input string to their full-width equivalents and returns the string "ＬｉｂｒｅＯｆｆｉｃｅ". | ＬｉｂｒｅＯｆｆｉｃｅ |
| =JIS(234.56) | Here the function converts the characters of the input number to text, returning ２３４．５６ as a string of full-width characters. | ２３４．５６ |
| =JIS(F1) where cell F1 contains the text "Ｃａｌｃ" in full-width characters. | Here the function carries out no conversion because the input string contains no half-width characters. The word "Ｃａｌｃ" is returned as a string. | Ｃａｌｃ |
| =JIS("ｼ") | Here the function converts a half-width katakana character (Unicode U+FF7C) to its full-width equivalent, returning ジ (Unicode U+30B8) as a string. | ジ |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
JIS