/** * DevExtreme (exporter/excel_format_converter.js) * Version: 19.1.16 * Build date: Tue Oct 18 2022 * * Copyright (c) 2012 - 2022 Developer Express Inc. ALL RIGHTS RESERVED * Read about DevExtreme licensing here: https://js.devexpress.com/Licensing/ */ "use strict"; var _string = require("../core/utils/string"); var _string2 = _interopRequireDefault(_string); var _number = require("../localization/number"); var _number2 = _interopRequireDefault(_number); var _date = require("../localization/date"); var _date2 = _interopRequireDefault(_date); var _type = require("../core/utils/type"); var _date3 = require("../localization/ldml/date.format"); var _language_codes = require("../localization/language_codes"); require("../localization/currency"); function _interopRequireDefault(obj) { return obj && obj.__esModule ? obj : { "default": obj } } var ARABIC_ZERO_CODE = 1632; var DEFINED_NUMBER_FORMTATS = { thousands: "#,##0{0},"K"", millions: "#,##0{0},,"M"", billions: "#,##0{0},,,"B"", trillions: "#,##0{0},,,,"T"", percent: "0{0}%", decimal: "#{0}", fixedpoint: "#,##0{0}", exponential: "0{0}E+00", currency: " " }; var PERIOD_REGEXP = /a+/g; var DAY_REGEXP = /E/g; var DO_REGEXP = /dE+/g; var STANDALONE_MONTH_REGEXP = /L/g; var HOUR_REGEXP = /h/g; var SLASH_REGEXP = /\//g; var SQUARE_OPEN_BRACKET_REGEXP = /\[/g; var SQUARE_CLOSE_BRACKET_REGEXP = /]/g; var ANY_REGEXP = /./g; var excelFormatConverter = module.exports = { _applyPrecision: function(format, precision) { var result; var i; if (precision > 0) { result = "decimal" !== format ? "." : ""; for (i = 0; i < precision; i++) { result += "0" } return result } return "" }, _hasArabicDigits: function(text) { var code; for (var i = 0; i < text.length; i++) { code = text.charCodeAt(i); if (code >= ARABIC_ZERO_CODE && code < ARABIC_ZERO_CODE + 10) { return true } } return false }, _convertDateFormatToOpenXml: function(format) { return format.replace(SLASH_REGEXP, "\\/").split("'").map(function(datePart, index) { if (index % 2 === 0) { return datePart.replace(PERIOD_REGEXP, "AM/PM").replace(DO_REGEXP, "d").replace(DAY_REGEXP, "d").replace(STANDALONE_MONTH_REGEXP, "M").replace(HOUR_REGEXP, "H").replace(SQUARE_OPEN_BRACKET_REGEXP, "\\[").replace(SQUARE_CLOSE_BRACKET_REGEXP, "\\]") } if (datePart) { return datePart.replace(ANY_REGEXP, "\\$&") } return "'" }).join("") }, _convertDateFormat: function(format) { var formattedValue = (_date2.default.format(new Date(2009, 8, 8, 6, 5, 4), format) || "").toString(); var result = (0, _date3.getFormat)(function(value) { return _date2.default.format(value, format) }); if (result) { result = this._convertDateFormatToOpenXml(result); result = this._getLanguageInfo(formattedValue) + result } return result }, _getLanguageInfo: function(defaultPattern) { var languageID = (0, _language_codes.getLanguageId)(); var languageIDStr = languageID ? languageID.toString(16) : ""; var languageInfo = ""; if (this._hasArabicDigits(defaultPattern)) { while (languageIDStr.length < 3) { languageIDStr = "0" + languageIDStr } languageInfo = "[$-2010" + languageIDStr + "]" } else { if (languageIDStr) { languageInfo = "[$-" + languageIDStr + "]" } } return languageInfo }, _convertNumberFormat: function(format, precision, currency) { var result; var excelFormat; if ("currency" === format) { excelFormat = _number2.default.getOpenXmlCurrencyFormat(currency) } else { excelFormat = DEFINED_NUMBER_FORMTATS[format.toLowerCase()] } if (excelFormat) { result = _string2.default.format(excelFormat, this._applyPrecision(format, precision)) } return result }, convertFormat: function(format, precision, type, currency) { if ((0, _type.isDefined)(format)) { if ("date" === type) { return excelFormatConverter._convertDateFormat(format) } else { if ((0, _type.isString)(format) && DEFINED_NUMBER_FORMTATS[format.toLowerCase()]) { return excelFormatConverter._convertNumberFormat(format, precision, currency) } } } } };