numberFormatIndex property

@override int numberFormatIndex

Gets/sets cell numberFormat index.

final Workbook workbook = Workbook();
final Worksheet sheet = workbook.worksheets[0];
final Style style = workbook.styles.add('style');
// set number format.
style.numberFormat = '_(\$* #,##0_)';
final Range range1 = sheet.getRangeByIndex(3, 4);
range1.number = 10;
range1.cellStyle = style;
// Check number format index.
print(workbook.styles[1].numberFormatIndex);
final List<int> bytes = workbook.saveAsStream();
File('CellStyle.xlsx').writeAsBytes(bytes);
workbook.dispose();

Implementation

@override
int get numberFormatIndex {
  int numberFormatIndexStyle = 0;
  bool first = true;

  final int last = _arrRanges.length;
  for (int index = 0; index < last; index++) {
    final Range range = _arrRanges[index];

    if (first) {
      numberFormatIndexStyle = range.cellStyle.numberFormatIndex;
      first = false;
    } else if (range.cellStyle.numberFormatIndex != numberFormatIndexStyle) {
      return 0;
    }
  }
  return numberFormatIndexStyle;
}

@override void numberFormatIndex=(int value)

Gets/sets cell numberFormat index.

final Workbook workbook = Workbook();
final Worksheet sheet = workbook.worksheets[0];
final Style style = workbook.styles.add('style');
// set number format.
style.numberFormat = '_(\$* #,##0_)';
final Range range1 = sheet.getRangeByIndex(3, 4);
range1.number = 10;
range1.cellStyle = style;
// Check number format index.
print(workbook.styles[1].numberFormatIndex);
final List<int> bytes = workbook.saveAsStream();
File('CellStyle.xlsx').writeAsBytes(bytes);
workbook.dispose();

Implementation

@override
set numberFormatIndex(int value) {
  final int last = _arrRanges.length;
  for (int index = 0; index < last; index++) {
    final Range range = _arrRanges[index];
    range.cellStyle.numberFormatIndex = value;
  }
}