DocumentServer-v-9.2.0/sdkjs/tests/cell/spreadsheet-calculation/SheetViewTests.js

/*
 * (c) Copyright Ascensio System SIA 2010-2024
 *
 * This program is a free software product. You can redistribute it and/or
 * modify it under the terms of the GNU Affero General Public License (AGPL)
 * version 3 as published by the Free Software Foundation. In accordance with
 * Section 7(a) of the GNU AGPL its Section 15 shall be amended to the effect
 * that Ascensio System SIA expressly excludes the warranty of non-infringement
 * of any third-party rights.
 *
 * This program is distributed WITHOUT ANY WARRANTY; without even the implied
 * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR  PURPOSE. For
 * details, see the GNU AGPL at: http://www.gnu.org/licenses/agpl-3.0.html
 *
 * You can contact Ascensio System SIA at 20A-6 Ernesta Birznieka-Upish
 * street, Riga, Latvia, EU, LV-1050.
 *
 * The  interactive user interfaces in modified source and object code versions
 * of the Program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU AGPL version 3.
 *
 * Pursuant to Section 7(b) of the License you must retain the original Product
 * logo when distributing the program. Pursuant to Section 7(e) we decline to
 * grant you any rights under trademark law for use of our trademarks.
 *
 * All the Product's GUI elements, including illustrations and icon sets, as
 * well as technical writing content are licensed under the terms of the
 * Creative Commons Attribution-ShareAlike 4.0 International. See the License
 * terms at http://creativecommons.org/licenses/by-sa/4.0/legalcode
 *
 */
QUnit.config.autostart = false;
$(function() {


	Asc.spreadsheet_api.prototype._init = function() {
		this._loadModules();
	};
	Asc.spreadsheet_api.prototype.asyncImagesDocumentEndLoaded = function() {
	};
	Asc.spreadsheet_api.prototype.onEndLoadFile = function(fonts, callback) {
		openDocument();
	};
	Asc.spreadsheet_api.prototype._onEndLoadSdk = function () {
		AscCommon.baseEditorsApi.prototype._onEndLoadSdk.call(this);
	};
	AscCommonExcel.WorkbookView.prototype._onWSSelectionChanged = function() {
	};
	AscCommonExcel.WorkbookView.prototype.showWorksheet = function() {
	};
	AscCommonExcel.WorkbookView.prototype.changeZoom = function() {
	};
	AscCommonExcel.WorkbookView.prototype.recalculateDrawingObjects = function() {
	};
	AscCommonExcel.WorksheetView.prototype.updateRanges = function() {
	};
	AscCommonExcel.WorksheetView.prototype._autoFitColumnsWidth = function() {
	};
	AscCommonExcel.WorksheetView.prototype.setSelection = function() {
	};
	AscCommonExcel.WorksheetView.prototype.draw = function() {
	};
	AscCommonExcel.WorksheetView.prototype._prepareDrawingObjects = function() {
		this.objectRender = new AscFormat.DrawingObjects();
	};
	Asc.spreadsheet_api.prototype.initGlobalObjects = function(wbModel) {
		AscCommonExcel.g_DefNameWorksheet = new AscCommonExcel.Worksheet(wbModel, -1);
		AscCommonExcel.g_oUndoRedoWorksheet = new AscCommonExcel.UndoRedoWoorksheet(wbModel);
	};
	AscCommon.baseEditorsApi.prototype._onEndLoadSdk = function() {
		AscFonts.g_fontApplication.Init();

		this.FontLoader  = AscCommon.g_font_loader;
		this.ImageLoader = AscCommon.g_image_loader;
		this.FontLoader.put_Api(this);
		this.ImageLoader.put_Api(this);
	};


	Asc.spreadsheet_api.prototype.fAfterLoad = function(fonts, callback) {
		api.initCollaborativeEditing({});
		api.wb = new AscCommonExcel.WorkbookView(api.wbModel, api.controller, api.handlers, api.HtmlElement,
			api.topLineEditorElement, api, api.collaborativeEditing, api.fontRenderingMode);
		wb = api.wbModel;
		wb.handlers = new AscCommonExcel.asc_CHandlersList();
		wb.handlers.add("getSelectionState", function() {
			return null;
		});
		wsView = api.wb.getWorksheet();
		ws = api.wbModel.aWorksheets[0];

		startTests();
	};


	var api = new Asc.spreadsheet_api({
		'id-view': 'editor_sdk'
	});
	api.FontLoader = {
		LoadDocumentFonts: function () {
		}
	};

	function openDocument(){
		AscCommon.g_oTableId.init();
		api._onEndLoadSdk();
		api.isOpenOOXInBrowser = false;
		api.OpenDocumentFromBin(null, AscCommon.getEmpty());
	}

	api.HtmlElement = document.createElement("div");
	var curElem = document.getElementById("editor_sdk");
	curElem.appendChild(api.HtmlElement);
	window["Asc"]["editor"] = api;

	function updateView () {
		wsView._cleanCache(new Asc.Range(0, 0, wsView.cols.length - 1, wsView.rows.length - 1));
		wsView.changeWorksheet("update", {reinitRanges: true});
	}

	function checkUndoRedo(fBefore, fAfter, desc) {
		fAfter("after_action: " + desc);
		AscCommon.History.Undo();
		updateView();
		fBefore("after_undo: " + desc);
		AscCommon.History.Redo();
		updateView();
		fAfter("after_redo: " + desc);
	}

	let wb, wsView, ws;
	function testShowFormulasOption() {
		QUnit.test("Test: show formulas option ", function(assert ) {

			let testData = [
				["=1+1", "test1"],
				["=2+1", "test2"],
				["=3+1", "test3"],
				["=4+1", "test4"],
				["=5+1", "test5"],
				["=6+1", "test6"]
			];

			let range = ws.getRange4(0, 0);
			range.fillData(testData);
			updateView();

			//action
			api.asc_setShowFormulas(true);

			checkUndoRedo(function (_desc) {
				assert.strictEqual(!!api.asc_getShowFormulas(), false, _desc);
			}, function (_desc) {
				assert.strictEqual(!!api.asc_getShowFormulas(), true, _desc);
			}, "_check show formulas flag");


			let defaultColumnWidth = Asc.round(64 * wsView.getRetinaPixelRatio());
			checkUndoRedo(function (_desc) {
				assert.strictEqual(wsView.getColumnWidth(0), defaultColumnWidth, _desc + "_column_0_width_");
				assert.strictEqual(wsView.getColumnWidth(1), defaultColumnWidth, _desc + "_column_1_width_");

			}, function (_desc) {
				assert.strictEqual(wsView.getColumnWidth(0), defaultColumnWidth * 2, _desc + "_column_0_width_");
				assert.strictEqual(wsView.getColumnWidth(1), defaultColumnWidth * 2, _desc + "_column_1_width_");

			}, "_check columns width");

			assert.strictEqual(wsView._getCellTextCache(0,0).cellHA, AscCommon.align_Left, "align_horizonal_0_0");
			assert.strictEqual(wsView._getCellTextCache(1,0).cellHA, AscCommon.align_Left, "align_horizonal_1_0");
			assert.strictEqual(wsView._getCellTextCache(0,1).cellHA, AscCommon.align_Left, "align_horizonal_0_1");
			assert.strictEqual(wsView._getCellTextCache(1,1).cellHA, AscCommon.align_Left, "align_horizonal_1_1");
			assert.strictEqual(wsView._getCellTextCache(0,2).cellHA, AscCommon.align_Left, "align_horizonal_0_2");
			assert.strictEqual(wsView._getCellTextCache(1,2).cellHA, AscCommon.align_Left, "align_horizonal_1_2");
		});
	}

	QUnit.module("Sheet view");

	function startTests() {
		QUnit.start();
		testShowFormulasOption();
	}

});