SpreadJS 15
Formula Reference / Formula Functions / Barcode Functions / BC_EAN13
In This Topic
    BC_EAN13
    In This Topic

    This function returns a data set for representing a EAN13.

    Syntax

    BC_EAN13(value, color, backgroundColor, showLabel, labelPosition, addOn, addOnLabelPosition, fontFamily, fontStyle, fontWeight, fontTextDecoration, fontTextAlign, fontSize, quietZoneLeft, quietZoneRight, quietZoneTop, quietZoneBottom)

    Arguments

    Argument Description
    value  Specifies that the value length must be 12 or 13.
    color  A color that represents the barcode color. The default value is 'rgb(0,0,0)'.
    backgroundColor  A color that represents the barcode background color. The default value is 'rgb(255, 255, 255)'
    showLabel Specifies whether to show label text when the barcode has label.
    labelPosition A value that represents the label position when the label is shown.
    addOn A string that represents the add text of QRCode. Specifies that value length must be 2 or 5.
    addOnLabelPosition The position to add the text when text is shown.
    fontFamily A string that represents the label text fontFamily. The default value is 'sans-serif'.
    fontStyle A string that represents the label text fontStyle. The default value is 'normal'.
    fontWeight A string that represents the label text fontWeight. The default value is 'normal'.
    fontTextDecoration A string that represents the label text fontTextDecoration. The default value is 'none'.
    fontTextAlign A string that represents the label text fontTextAlign. The default value is 'center'.
    fontSize  A string that represents the label text fontSize. The default value is '12px'.
    quietZoneLeft  A value that represents the size of left quiet zone.
    quietZoneRight  A value that represents the size of right quiet zone.
    quietZoneTop  A value that represents the size of top quiet zone.
    quietZoneBottom   A value that represents the size of bottom quiet zone.

    Data Types

    Accepts only twelve numbers as a string to calculate a check digit. Returns barcode sparkline.

    Examples

    sheet.setFormula(3, 3, '=BC_EAN13(C4)');