Build your own AI office with Univer Office SDK. Bring editing, calculation, collaboration, and file processing into your product for people and AI agents. Built on an extensible open-source core.
TypeScript boardcollaborationdocdocxexceloffce365officepdfpptpptxpresentationsdksheetslidesspreadsheetuniverwordwordprocessorworkspacexlsx
/**
* Copyright 2023-present DreamNum Co., Ltd.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
import type { ArrayValueObject } from '../../../engine/value-object/array-value-object';
import type { BaseValueObject } from '../../../engine/value-object/base-value-object';
import { NumberValueObject } from '../../../engine/value-object/primitive-object';
import { BaseFunction } from '../../base-function';
export class Sum extends BaseFunction {
override minParams = 1;
override maxParams = 255;
override calculate(...variants: BaseValueObject[]) {
let accumulatorAll: BaseValueObject = NumberValueObject.create(0);
for (let i = 0; i < variants.length; i++) {
let variant = variants[i];
variant = this._legacyImplicitDerivedArray(variant);
if (variant.isString()) {
variant = variant.convertToNumberObjectValue();
}
if (variant.isError()) {
return variant;
}
if (variant.isArray()) {
variant = variant.sum();
}
if (variant.isError()) {
return variant;
}
accumulatorAll = accumulatorAll.plus(variant);
if (accumulatorAll.isError()) {
return accumulatorAll;
}
}
return accumulatorAll;
}
private _legacyImplicitDerivedArray(variant: BaseValueObject): BaseValueObject {
if (!variant.isArray()) {
return variant;
}
const array = variant as ArrayValueObject;
if (array.usesInvertedIndexCache() || !array.usesLegacyImplicitForAggregate()) {
return variant;
}
const startRow = array.getCurrentRow();
const startColumn = array.getCurrentColumn();
if (startRow < 0 || startColumn < 0) {
return variant;
}
const rowCount = array.getRowCount();
const columnCount = array.getColumnCount();
let rowIndex = -1;
let columnIndex = -1;
if (rowCount === 1) {
rowIndex = 0;
columnIndex = this.column - startColumn;
} else if (columnCount === 1) {
rowIndex = this.row - startRow;
columnIndex = 0;
} else {
rowIndex = this.row - startRow;
columnIndex = this.column - startColumn;
}
if (rowIndex < 0 || rowIndex >= rowCount || columnIndex < 0 || columnIndex >= columnCount) {
return variant;
}
return array.get(rowIndex, columnIndex) as BaseValueObject || variant;
}
}