Function fillMatrix

packages/office-viewer/src/excel/formula/functions/reference.ts:354–384

(array: number[][] | number[], fill_value?: number)

}

export function fillMatrix(array: number[][] | number[], fill_value?: number) {
  if (!array) {
    throw FormulaError.VALUE;
  }
  let matrix: number[][];
  // 兼容一维数组的情况
  if (isOneDimensionalArray(array)) {
    matrix = [[...(array as number[])]];
  } else {
    matrix = array as number[][];
  }

  matrix.map((arr, i) => {
    arr.map((a, j) => {
      if (!a) {
        matrix[i][j] = 0;
      }
    });
  });

  const longestArrayIndex = matrix.reduce(
    (acc, arr, i) => (arr.length > matrix[acc].length ? i : acc),
    0
  );
  const longestArrayLength = matrix[longestArrayIndex].length;

  return matrix.map(el => [
    ...el,
    ...Array(longestArrayLength - el.length).fill(fill_value ? fill_value : 0)
  ]);
}

export function transpose(matrix: number[][]) {
  if (!matrix) {