Documentation/Calc Functions/JIS

    From The Document Foundation Wiki
    Other languages:

    Function name:





    Converts half-width to full-width for ASCII and katakana characters. JIS is the complementary function to ASC.




    Returns a text string that comprises the converted characters.


    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.


    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 "LibreOffice". LibreOffice
    =JIS(234.56) Here the function converts the characters of the input number to text, returning 234.56 as a string of full-width characters. 234.56
    =JIS(F1) where cell F1 contains the text "Calc" in full-width characters. Here the function carries out no conversion because the input string contains no half-width characters. The word "Calc" is returned as a string. Calc
    =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:

    Section 6.20.11, part 2

    Related (or similar) Excel functions: