Sheet Mode / Features Overview / Format
In This Topic
    In This Topic

    Setting Format

    To set the format for each column, move to the target column and click on Format in the Home tab of the ribbon area.

    The advanced setting screen appears. In the following three tabs, you can set the format the same way you would in Excel.

    Format tab

    Font tab

    Alignment tab

    • The format you set isn't effective while entering data in a cell.
      For example, if you set the format displaying "Oct 20, 2017" in a date field, the date is displayed as "2017-10-20" while entering it, and "Oct 20, 2017" is displayed after the entry is confirmed.
    • The settings in krewSheet aren't valid on the record editing screen of Kintone.
    • The first Japanese year is displayed as the "first" year with krewSheet. By using the user-defined formatting, the first Reiwa year can be displayed as "1." (e.g., R1/5/1) [<43586]ge/M/d;[<43831]g"1"/M/d;ge/M/d
    • Regarding the format of days such as "ddd" or "aaa," its display will change on krewSheet according to the language setting of the Kintone account (English: Wed, Japanese: 水). If you don't want to change the display according to the Kintone language setting, add locale ID to make it something like "[$-ja-JP]m/d(aaa)."

    Formattable Field Type

    Depending on the field type, the format might or might not be effective. The details are described below.

    Format Priority

    If you set the format in both the krewSheet settings and the Kintone form settings, the format setting in krewSheet has priority. To enable the format setting in Kintone, clear the one in krewSheet.

    Format setting screen in kintone

    Clearing Format

    To initialize the format of any selected column, move to the target column and click on Clear in the Home tab.

    To clear font effects (Bold, Italic, Underline, Strikethrough) in conditional formatting, click Clear on the Font tab of the Column Setting dialog.