clipboardNumberFormat

sets a format for correct copy/paste of numbers between SpreadSheet and Excel

Example

clipboardNumberFormat:{
    decimalOptional:true,
    groupSize: 3,
    decimalDelimiter: ",",
    groupDelimiter: " ",
    minusPosition:"after",
    minusSign:"-"
  }

It can contain the following attributes:

• decimalSize - the number of decimal digits in the float number.
• groupSize - the number of digits in a group.
• decimalDelimiter - a char which separates the decimal part in the float number.
• groupDelimiter - a char which separates groups of digits.
• decimalOptional - boolean. If true, allows you not to specify the number of decimal digits in the float number.
• prefix - string. Adds prefix to the formatted number.
• sufix - string. Adds suffix to the formatted number.
• minusPosition - string. The position of a negative sign.
• minusSign - string|array. A sign for a negative number.

Back to top