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 { LocaleType } from '@univerjs/core';
import { currencySymbols, excelDateTimeSerial, getNumfmtLocaleTag, numfmt } from '@univerjs/core';
import { getDateFormatPatterns } from '../base/const/date-format';
import { CURRENCYFORMAT, DATEFMTLISG, NUMBERFORMAT } from '../base/const/formatdetail';
export const getCurrencyOptions = () => currencySymbols.map((item) => ({ label: item, value: item }));
export const getCurrencyFormatOptions = (suffix: string) =>
CURRENCYFORMAT.map((item) => ({
label: item.label(suffix),
value: item.suffix(suffix),
color: item.color,
}));
const DATE_FORMAT_PREVIEW_VALUE = excelDateTimeSerial(new Date(Date.UTC(1930, 7, 5, 13, 30, 30)));
export const getDateFormatOptions = (locale?: LocaleType, currentPattern?: string) => {
if (locale === undefined) {
return DATEFMTLISG.map((item) => ({ label: item.label, value: item.suffix }));
}
const numfmtLocale = getNumfmtLocaleTag(locale);
const patterns = getDateFormatPatterns(locale);
if (currentPattern && !patterns.includes(currentPattern)) {
patterns.unshift(currentPattern);
}
return patterns.map((pattern) => ({
label: numfmt.format(pattern, DATE_FORMAT_PREVIEW_VALUE, { locale: numfmtLocale }),
value: pattern,
}));
};
export const getNumberFormatOptions = () =>
NUMBERFORMAT.map((item) => ({ label: item.label, value: item.suffix, color: item.color }));