clipboardNumberFormat

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

object clipboardNumberFormat;

Example

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

Details

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