gc.spread.sheets.angular.13.1.0.js 38 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044
  1. "use strict";
  2. /*!
  3. *
  4. * SpreadJS Wrapper Components for Angular 0.0.0
  5. *
  6. * Copyright(c) GrapeCity, Inc. All rights reserved.
  7. *
  8. * Licensed under the SpreadJS Commercial License.
  9. * us.sales@grapecity.com
  10. * http://www.grapecity.com/licensing/grapecity/
  11. *
  12. */
  13. var __decorate = (this && this.__decorate) || function (decorators, target, key, desc) {
  14. var c = arguments.length, r = c < 3 ? target : desc === null ? desc = Object.getOwnPropertyDescriptor(target, key) : desc, d;
  15. if (typeof Reflect === "object" && typeof Reflect.decorate === "function") r = Reflect.decorate(decorators, target, key, desc);
  16. else for (var i = decorators.length - 1; i >= 0; i--) if (d = decorators[i]) r = (c < 3 ? d(r) : c > 3 ? d(target, key, r) : d(target, key)) || r;
  17. return c > 3 && r && Object.defineProperty(target, key, r), r;
  18. };
  19. var __metadata = (this && this.__metadata) || function (k, v) {
  20. if (typeof Reflect === "object" && typeof Reflect.metadata === "function") return Reflect.metadata(k, v);
  21. };
  22. var __param = (this && this.__param) || function (paramIndex, decorator) {
  23. return function (target, key) { decorator(target, key, paramIndex); }
  24. };
  25. Object.defineProperty(exports, "__esModule", { value: true });
  26. var core_1 = require("@angular/core");
  27. var common_1 = require("@angular/common");
  28. var ColumnComponent = (function () {
  29. function ColumnComponent() {
  30. this.changes = {};
  31. }
  32. ColumnComponent.prototype.onAttached = function (sheet, index) {
  33. this.sheet = sheet;
  34. this.index = index;
  35. this.onColumnChanged();
  36. };
  37. ColumnComponent.prototype.onColumnChanged = function () {
  38. if (this.sheet) {
  39. var sheet = this.sheet;
  40. sheet.suspendPaint();
  41. sheet.suspendEvent();
  42. var changes = this.changes;
  43. for (var changeName in changes) {
  44. var newValue = changes[changeName].currentValue;
  45. if (newValue === null || newValue === void 0) {
  46. continue;
  47. }
  48. switch (changeName) {
  49. case 'width':
  50. newValue = parseInt(newValue, 10);
  51. sheet.setColumnWidth(this.index, newValue);
  52. break;
  53. case 'visible':
  54. sheet.setColumnVisible(this.index, newValue);
  55. break;
  56. case 'resizable':
  57. sheet.setColumnResizable(this.index, newValue);
  58. break;
  59. case 'autoFit':
  60. if (newValue) {
  61. sheet.autoFitColumn(this.index);
  62. }
  63. break;
  64. case 'style':
  65. sheet.setStyle(-1, this.index, newValue);
  66. break;
  67. case 'headerStyle':
  68. sheet.setStyle(-1, this.index, newValue, GC.Spread.Sheets.SheetArea.colHeader);
  69. break;
  70. case 'cellType':
  71. sheet.setCellType(-1, this.index, newValue);
  72. break;
  73. case 'formatter':
  74. sheet.setFormatter(-1, this.index, newValue, GC.Spread.Sheets.SheetArea.viewport);
  75. break;
  76. }
  77. }
  78. sheet.resumeEvent();
  79. sheet.resumePaint();
  80. }
  81. };
  82. ColumnComponent.prototype.ngOnChanges = function (changes) {
  83. this.changes = {};
  84. var changesCache = this.changes;
  85. for (var changeName in changes) {
  86. changesCache[changeName] = changes[changeName];
  87. }
  88. this.onColumnChanged();
  89. };
  90. return ColumnComponent;
  91. }());
  92. __decorate([
  93. core_1.Input(),
  94. __metadata("design:type", Number)
  95. ], ColumnComponent.prototype, "width", void 0);
  96. __decorate([
  97. core_1.Input(),
  98. __metadata("design:type", String)
  99. ], ColumnComponent.prototype, "dataField", void 0);
  100. __decorate([
  101. core_1.Input(),
  102. __metadata("design:type", String)
  103. ], ColumnComponent.prototype, "headerText", void 0);
  104. __decorate([
  105. core_1.Input(),
  106. __metadata("design:type", Boolean)
  107. ], ColumnComponent.prototype, "visible", void 0);
  108. __decorate([
  109. core_1.Input(),
  110. __metadata("design:type", Boolean)
  111. ], ColumnComponent.prototype, "resizable", void 0);
  112. __decorate([
  113. core_1.Input(),
  114. __metadata("design:type", Boolean)
  115. ], ColumnComponent.prototype, "autoFit", void 0);
  116. __decorate([
  117. core_1.Input(),
  118. __metadata("design:type", GC.Spread.Sheets.Style)
  119. ], ColumnComponent.prototype, "style", void 0);
  120. __decorate([
  121. core_1.Input(),
  122. __metadata("design:type", GC.Spread.Sheets.CellTypes.Base)
  123. ], ColumnComponent.prototype, "cellType", void 0);
  124. __decorate([
  125. core_1.Input(),
  126. __metadata("design:type", GC.Spread.Sheets.Style)
  127. ], ColumnComponent.prototype, "headerStyle", void 0);
  128. __decorate([
  129. core_1.Input(),
  130. __metadata("design:type", Object)
  131. ], ColumnComponent.prototype, "formatter", void 0);
  132. ColumnComponent = __decorate([
  133. core_1.Component({
  134. selector: 'gc-column',
  135. template: "\n <ng-content></ng-content>\n "
  136. })
  137. ], ColumnComponent);
  138. exports.ColumnComponent = ColumnComponent;
  139. var WorksheetComponent = (function () {
  140. function WorksheetComponent() {
  141. this.sheet = new GC.Spread.Sheets.Worksheet('');
  142. }
  143. WorksheetComponent.prototype.onAttached = function () {
  144. var _this = this;
  145. var sheet = this.sheet;
  146. var columns = this.columns;
  147. sheet.suspendPaint();
  148. sheet.suspendEvent();
  149. if (this.dataSource) {
  150. sheet.setDataSource(this.dataSource);
  151. columns.forEach(function (columnComponent, index) {
  152. if (columnComponent.dataField) {
  153. sheet.bindColumn(index, {
  154. name: columnComponent.dataField,
  155. displayName: columnComponent.headerText
  156. });
  157. }
  158. });
  159. }
  160. if (columns.length > 0) {
  161. sheet.setColumnCount(columns.length);
  162. columns.forEach(function (columnComponent, index) {
  163. columnComponent.onAttached(_this.sheet, index);
  164. });
  165. }
  166. sheet.resumeEvent();
  167. sheet.resumePaint();
  168. };
  169. WorksheetComponent.prototype.getSheet = function () {
  170. return this.sheet;
  171. };
  172. WorksheetComponent.prototype.ngOnChanges = function (changes) {
  173. var sheet = this.sheet;
  174. sheet.suspendPaint();
  175. sheet.suspendEvent();
  176. for (var changeName in changes) {
  177. var newValue = changes[changeName].currentValue;
  178. if (newValue === null || newValue === void 0) {
  179. continue;
  180. }
  181. switch (changeName) {
  182. case 'rowCount':
  183. sheet.setRowCount(newValue);
  184. break;
  185. case 'colCount':
  186. sheet.setColumnCount(newValue);
  187. break;
  188. case 'name':
  189. sheet.name(newValue);
  190. break;
  191. case 'frozenColumnCount':
  192. sheet.frozenColumnCount(newValue);
  193. break;
  194. case 'frozenRowCount':
  195. sheet.frozenRowCount(newValue);
  196. break;
  197. case 'frozenTrailingRowCount':
  198. sheet.frozenTrailingRowCount(newValue);
  199. break;
  200. case 'frozenTrailingColumnCount':
  201. sheet.frozenTrailingColumnCount(newValue);
  202. break;
  203. case 'selectionPolicy':
  204. sheet.selectionPolicy(newValue);
  205. break;
  206. case 'selectionUnit':
  207. sheet.selectionUnit(newValue);
  208. break;
  209. case 'zoom':
  210. sheet.zoom(newValue);
  211. break;
  212. case 'currentTheme':
  213. sheet.currentTheme(newValue);
  214. break;
  215. case 'defaultStyle':
  216. sheet.setDefaultStyle(newValue);
  217. break;
  218. case 'rowOutlineInfo':
  219. newValue.forEach(function (item) {
  220. sheet.rowOutlines.group(item.index, item.count);
  221. });
  222. sheet.repaint();
  223. break;
  224. case 'columnOutlineInfo':
  225. newValue.forEach(function (item) {
  226. sheet.columnOutlines.group(item.index, item.count);
  227. });
  228. sheet.repaint();
  229. break;
  230. case 'showRowOutline':
  231. sheet.showRowOutline(newValue);
  232. break;
  233. case 'showColumnOutline':
  234. sheet.showColumnOutline(newValue);
  235. break;
  236. case 'dataSource':
  237. sheet.setDataSource(newValue);
  238. break;
  239. case 'autoGenerateColumns':
  240. sheet[changeName] = newValue;
  241. default:
  242. sheet.options[changeName] = newValue;
  243. }
  244. }
  245. sheet.resumeEvent();
  246. sheet.resumePaint();
  247. };
  248. WorksheetComponent.prototype.ngAfterViewInit = function () {
  249. var _this = this;
  250. this.columns.changes.subscribe(function () { _this.onAttached(); });
  251. };
  252. WorksheetComponent.prototype.ngOnDestroy = function () {
  253. var sheet = this.sheet;
  254. var spread = sheet ? sheet.getParent() : null;
  255. if (spread) {
  256. var sheetIndex = spread.getSheetIndex(sheet.name());
  257. if (sheetIndex !== void 0) {
  258. spread.removeSheet(sheetIndex);
  259. }
  260. }
  261. };
  262. return WorksheetComponent;
  263. }());
  264. __decorate([
  265. core_1.ContentChildren(ColumnComponent),
  266. __metadata("design:type", core_1.QueryList)
  267. ], WorksheetComponent.prototype, "columns", void 0);
  268. __decorate([
  269. core_1.Input(),
  270. __metadata("design:type", Number)
  271. ], WorksheetComponent.prototype, "rowCount", void 0);
  272. __decorate([
  273. core_1.Input(),
  274. __metadata("design:type", Number)
  275. ], WorksheetComponent.prototype, "colCount", void 0);
  276. __decorate([
  277. core_1.Input(),
  278. __metadata("design:type", Object)
  279. ], WorksheetComponent.prototype, "dataSource", void 0);
  280. __decorate([
  281. core_1.Input(),
  282. __metadata("design:type", String)
  283. ], WorksheetComponent.prototype, "name", void 0);
  284. __decorate([
  285. core_1.Input(),
  286. __metadata("design:type", Number)
  287. ], WorksheetComponent.prototype, "frozenColumnCount", void 0);
  288. __decorate([
  289. core_1.Input(),
  290. __metadata("design:type", Number)
  291. ], WorksheetComponent.prototype, "frozenRowCount", void 0);
  292. __decorate([
  293. core_1.Input(),
  294. __metadata("design:type", Number)
  295. ], WorksheetComponent.prototype, "frozenTrailingRowCount", void 0);
  296. __decorate([
  297. core_1.Input(),
  298. __metadata("design:type", Number)
  299. ], WorksheetComponent.prototype, "frozenTrailingColumnCount", void 0);
  300. __decorate([
  301. core_1.Input(),
  302. __metadata("design:type", Boolean)
  303. ], WorksheetComponent.prototype, "allowCellOverflow", void 0);
  304. __decorate([
  305. core_1.Input(),
  306. __metadata("design:type", String)
  307. ], WorksheetComponent.prototype, "frozenlineColor", void 0);
  308. __decorate([
  309. core_1.Input(),
  310. __metadata("design:type", String)
  311. ], WorksheetComponent.prototype, "sheetTabColor", void 0);
  312. __decorate([
  313. core_1.Input(),
  314. __metadata("design:type", Number)
  315. ], WorksheetComponent.prototype, "selectionPolicy", void 0);
  316. __decorate([
  317. core_1.Input(),
  318. __metadata("design:type", Number)
  319. ], WorksheetComponent.prototype, "selectionUnit", void 0);
  320. __decorate([
  321. core_1.Input(),
  322. __metadata("design:type", Number)
  323. ], WorksheetComponent.prototype, "zoom", void 0);
  324. __decorate([
  325. core_1.Input(),
  326. __metadata("design:type", String)
  327. ], WorksheetComponent.prototype, "currentTheme", void 0);
  328. __decorate([
  329. core_1.Input(),
  330. __metadata("design:type", Number)
  331. ], WorksheetComponent.prototype, "clipBoardOptions", void 0);
  332. __decorate([
  333. core_1.Input(),
  334. __metadata("design:type", Boolean)
  335. ], WorksheetComponent.prototype, "rowHeaderVisible", void 0);
  336. __decorate([
  337. core_1.Input(),
  338. __metadata("design:type", Boolean)
  339. ], WorksheetComponent.prototype, "colHeaderVisible", void 0);
  340. __decorate([
  341. core_1.Input(),
  342. __metadata("design:type", Number)
  343. ], WorksheetComponent.prototype, "rowHeaderAutoText", void 0);
  344. __decorate([
  345. core_1.Input(),
  346. __metadata("design:type", Number)
  347. ], WorksheetComponent.prototype, "colHeaderAutoText", void 0);
  348. __decorate([
  349. core_1.Input(),
  350. __metadata("design:type", Number)
  351. ], WorksheetComponent.prototype, "rowHeaderAutoTextIndex", void 0);
  352. __decorate([
  353. core_1.Input(),
  354. __metadata("design:type", Number)
  355. ], WorksheetComponent.prototype, "colHeaderAutoTextIndex", void 0);
  356. __decorate([
  357. core_1.Input(),
  358. __metadata("design:type", Boolean)
  359. ], WorksheetComponent.prototype, "isProtected", void 0);
  360. __decorate([
  361. core_1.Input(),
  362. __metadata("design:type", Boolean)
  363. ], WorksheetComponent.prototype, "showRowOutline", void 0);
  364. __decorate([
  365. core_1.Input(),
  366. __metadata("design:type", Boolean)
  367. ], WorksheetComponent.prototype, "showColumnOutline", void 0);
  368. __decorate([
  369. core_1.Input(),
  370. __metadata("design:type", String)
  371. ], WorksheetComponent.prototype, "selectionBackColor", void 0);
  372. __decorate([
  373. core_1.Input(),
  374. __metadata("design:type", String)
  375. ], WorksheetComponent.prototype, "selectionBorderColor", void 0);
  376. __decorate([
  377. core_1.Input(),
  378. __metadata("design:type", GC.Spread.Sheets.Style)
  379. ], WorksheetComponent.prototype, "defaultStyle", void 0);
  380. __decorate([
  381. core_1.Input(),
  382. __metadata("design:type", Array)
  383. ], WorksheetComponent.prototype, "rowOutlineInfo", void 0);
  384. __decorate([
  385. core_1.Input(),
  386. __metadata("design:type", Array)
  387. ], WorksheetComponent.prototype, "columnOutlineInfo", void 0);
  388. __decorate([
  389. core_1.Input(),
  390. __metadata("design:type", Boolean)
  391. ], WorksheetComponent.prototype, "autoGenerateColumns", void 0);
  392. WorksheetComponent = __decorate([
  393. core_1.Component({
  394. selector: 'gc-worksheet',
  395. template: "\n <ng-content></ng-content>\n "
  396. }),
  397. __metadata("design:paramtypes", [])
  398. ], WorksheetComponent);
  399. exports.WorksheetComponent = WorksheetComponent;
  400. var SpreadSheetsComponent = (function () {
  401. function SpreadSheetsComponent(elRef) {
  402. this.style = {
  403. width: '800px',
  404. height: '600px'
  405. };
  406. this.workbookInitialized = new core_1.EventEmitter();
  407. this.validationError = new core_1.EventEmitter();
  408. this.cellClick = new core_1.EventEmitter();
  409. this.cellDoubleClick = new core_1.EventEmitter();
  410. this.enterCell = new core_1.EventEmitter();
  411. this.leaveCell = new core_1.EventEmitter();
  412. this.valueChanged = new core_1.EventEmitter();
  413. this.topRowChanged = new core_1.EventEmitter();
  414. this.leftColumnChanged = new core_1.EventEmitter();
  415. this.invalidOperation = new core_1.EventEmitter();
  416. this.rangeFiltering = new core_1.EventEmitter();
  417. this.rangeFiltered = new core_1.EventEmitter();
  418. this.tableFiltering = new core_1.EventEmitter();
  419. this.tableFiltered = new core_1.EventEmitter();
  420. this.rangeSorting = new core_1.EventEmitter();
  421. this.rangeSorted = new core_1.EventEmitter();
  422. this.clipboardChanging = new core_1.EventEmitter();
  423. this.clipboardChanged = new core_1.EventEmitter();
  424. this.clipboardPasting = new core_1.EventEmitter();
  425. this.clipboardPasted = new core_1.EventEmitter();
  426. this.columnWidthChanging = new core_1.EventEmitter();
  427. this.columnWidthChanged = new core_1.EventEmitter();
  428. this.rowHeightChanging = new core_1.EventEmitter();
  429. this.rowHeightChanged = new core_1.EventEmitter();
  430. this.dragDropBlock = new core_1.EventEmitter();
  431. this.dragDropBlockCompleted = new core_1.EventEmitter();
  432. this.dragFillBlock = new core_1.EventEmitter();
  433. this.dragFillBlockCompleted = new core_1.EventEmitter();
  434. this.editStarting = new core_1.EventEmitter();
  435. this.editChange = new core_1.EventEmitter();
  436. this.editEnding = new core_1.EventEmitter();
  437. this.editEnd = new core_1.EventEmitter();
  438. this.editEnded = new core_1.EventEmitter();
  439. this.rangeGroupStateChanging = new core_1.EventEmitter();
  440. this.rangeGroupStateChanged = new core_1.EventEmitter();
  441. this.selectionChanging = new core_1.EventEmitter();
  442. this.selectionChanged = new core_1.EventEmitter();
  443. this.sheetTabClick = new core_1.EventEmitter();
  444. this.sheetTabDoubleClick = new core_1.EventEmitter();
  445. this.sheetNameChanging = new core_1.EventEmitter();
  446. this.sheetNameChanged = new core_1.EventEmitter();
  447. this.userZooming = new core_1.EventEmitter();
  448. this.userFormulaEntered = new core_1.EventEmitter();
  449. this.cellChanged = new core_1.EventEmitter();
  450. this.columnChanged = new core_1.EventEmitter();
  451. this.rowChanged = new core_1.EventEmitter();
  452. this.activeSheetChanging = new core_1.EventEmitter();
  453. this.activeSheetChanged = new core_1.EventEmitter();
  454. this.sparklineChanged = new core_1.EventEmitter();
  455. this.rangeChanged = new core_1.EventEmitter();
  456. this.buttonClicked = new core_1.EventEmitter();
  457. this.editorStatusChanged = new core_1.EventEmitter();
  458. this.floatingObjectChanged = new core_1.EventEmitter();
  459. this.floatingObjectSelectionChanged = new core_1.EventEmitter();
  460. this.pictureChanged = new core_1.EventEmitter();
  461. this.floatingObjectRemoving = new core_1.EventEmitter();
  462. this.floatingObjectRemoved = new core_1.EventEmitter();
  463. this.pictureSelectionChanged = new core_1.EventEmitter();
  464. this.floatingObjectLoaded = new core_1.EventEmitter();
  465. this.touchToolStripOpening = new core_1.EventEmitter();
  466. this.commentChanged = new core_1.EventEmitter();
  467. this.commentRemoving = new core_1.EventEmitter();
  468. this.commentRemoved = new core_1.EventEmitter();
  469. this.slicerChanged = new core_1.EventEmitter();
  470. this.elRef = elRef;
  471. }
  472. SpreadSheetsComponent.prototype.ngAfterViewInit = function () {
  473. var _this = this;
  474. var elRef = this.elRef;
  475. var dom = elRef.nativeElement;
  476. var hostElement = dom.querySelector('div');
  477. this.spread = new GC.Spread.Sheets.Workbook(hostElement, { sheetCount: 0 });
  478. this.setSpreadOptions();
  479. this.initSheets();
  480. this.sheets.changes.subscribe(function (changes) {
  481. _this.onSheetsChanged(changes);
  482. });
  483. this.bindCustomEvent(this.spread);
  484. this.workbookInitialized.emit({ spread: this.spread });
  485. };
  486. SpreadSheetsComponent.prototype.onSheetsChanged = function (sheetComponents) {
  487. var spread = this.spread;
  488. spread.suspendPaint();
  489. if (sheetComponents) {
  490. sheetComponents.forEach(function (sheetComponent, index) {
  491. var sheet = sheetComponent.getSheet();
  492. if (sheet && !sheet.getParent()) {
  493. spread.addSheet(index, sheetComponent.getSheet());
  494. sheetComponent.onAttached();
  495. }
  496. });
  497. }
  498. spread.resumePaint();
  499. };
  500. SpreadSheetsComponent.prototype.initSheets = function () {
  501. var sheets = this.sheets;
  502. var spread = this.spread;
  503. spread.clearSheets();
  504. sheets.forEach(function (sheetComponent, index) {
  505. spread.addSheet(index, sheetComponent.getSheet());
  506. sheetComponent.onAttached();
  507. });
  508. if (sheets.length === 0) {
  509. spread.addSheet(0, new GC.Spread.Sheets.Worksheet(''));
  510. }
  511. };
  512. SpreadSheetsComponent.prototype.bindCustomEvent = function (spread) {
  513. var _this = this;
  514. var customEventNameSpace = '.ng';
  515. var events = ['ValidationError', 'CellClick', 'CellDoubleClick', 'EnterCell',
  516. 'LeaveCell', 'ValueChanged', 'TopRowChanged', 'LeftColumnChanged',
  517. 'InvalidOperation', 'RangeFiltering', 'RangeFiltered', 'TableFiltering',
  518. 'TableFiltered', 'RangeSorting', 'RangeSorted', 'ClipboardChanging',
  519. 'ClipboardChanged', 'ClipboardPasting', 'ClipboardPasted', 'ColumnWidthChanging',
  520. 'ColumnWidthChanged', 'RowHeightChanging', 'RowHeightChanged', 'DragDropBlock',
  521. 'DragDropBlockCompleted', 'DragFillBlock', 'DragFillBlockCompleted', 'EditStarting',
  522. 'EditChange', 'EditEnding', 'EditEnd', 'EditEnded', 'RangeGroupStateChanging',
  523. 'RangeGroupStateChanged', 'SelectionChanging', 'SelectionChanged', 'SheetTabClick',
  524. 'SheetTabDoubleClick', 'SheetNameChanging', 'SheetNameChanged',
  525. 'UserZooming', 'UserFormulaEntered', 'CellChanged', 'ColumnChanged',
  526. 'RowChanged', 'ActiveSheetChanging', 'ActiveSheetChanged',
  527. 'SparklineChanged',
  528. 'RangeChanged', 'ButtonClicked', 'EditorStatusChanged',
  529. 'FloatingObjectChanged', 'FloatingObjectSelectionChanged', 'PictureChanged',
  530. 'FloatingObjectRemoving', 'FloatingObjectRemoved', 'PictureSelectionChanged',
  531. 'FloatingObjectLoaded', 'TouchToolStripOpening', 'CommentChanged', 'CommentRemoving', 'CommentRemoved', 'SlicerChanged'];
  532. events.forEach(function (event) {
  533. spread.bind(event + customEventNameSpace, function (event, data) {
  534. var eventType = event.type;
  535. var camelCaseEvent = eventType[0].toLowerCase() + eventType.substr(1);
  536. _this[camelCaseEvent].emit(data);
  537. });
  538. });
  539. };
  540. SpreadSheetsComponent.prototype.setSpreadOptions = function () {
  541. var spread = this.spread;
  542. if (!this.spread) {
  543. return;
  544. }
  545. spread.suspendEvent();
  546. spread.suspendPaint();
  547. var options = this.spreadOptions;
  548. options && options.forEach(function (option) {
  549. if (option.name === 'name') {
  550. spread.name = option.value;
  551. }
  552. else {
  553. spread.options[option.name] = option.value;
  554. }
  555. });
  556. spread.resumePaint();
  557. spread.resumeEvent();
  558. };
  559. SpreadSheetsComponent.prototype.ngOnChanges = function (changes) {
  560. var options = [];
  561. for (var changeName in changes) {
  562. var newValue = changes[changeName].currentValue;
  563. if (newValue !== null && newValue !== void 0) {
  564. switch (changeName) {
  565. case 'hostStyle':
  566. this.style = newValue;
  567. break;
  568. case 'hostClass':
  569. break;
  570. default:
  571. options.push({ name: changeName, value: newValue });
  572. }
  573. }
  574. }
  575. this.spreadOptions = options;
  576. this.setSpreadOptions();
  577. };
  578. SpreadSheetsComponent.prototype.ngOnDestroy = function () {
  579. this.spread.destroy();
  580. };
  581. return SpreadSheetsComponent;
  582. }());
  583. __decorate([
  584. core_1.Input(),
  585. __metadata("design:type", Boolean)
  586. ], SpreadSheetsComponent.prototype, "allowUserResize", void 0);
  587. __decorate([
  588. core_1.Input(),
  589. __metadata("design:type", Boolean)
  590. ], SpreadSheetsComponent.prototype, "allowUserZoom", void 0);
  591. __decorate([
  592. core_1.Input(),
  593. __metadata("design:type", Boolean)
  594. ], SpreadSheetsComponent.prototype, "allowUserEditFormula", void 0);
  595. __decorate([
  596. core_1.Input(),
  597. __metadata("design:type", Boolean)
  598. ], SpreadSheetsComponent.prototype, "allowUserDragFill", void 0);
  599. __decorate([
  600. core_1.Input(),
  601. __metadata("design:type", Boolean)
  602. ], SpreadSheetsComponent.prototype, "allowUserDragDrop", void 0);
  603. __decorate([
  604. core_1.Input(),
  605. __metadata("design:type", Boolean)
  606. ], SpreadSheetsComponent.prototype, "allowUserDragMerge", void 0);
  607. __decorate([
  608. core_1.Input(),
  609. __metadata("design:type", Boolean)
  610. ], SpreadSheetsComponent.prototype, "allowUndo", void 0);
  611. __decorate([
  612. core_1.Input(),
  613. __metadata("design:type", Boolean)
  614. ], SpreadSheetsComponent.prototype, "allowSheetReorder", void 0);
  615. __decorate([
  616. core_1.Input(),
  617. __metadata("design:type", Boolean)
  618. ], SpreadSheetsComponent.prototype, "allowContextMenu", void 0);
  619. __decorate([
  620. core_1.Input(),
  621. __metadata("design:type", Boolean)
  622. ], SpreadSheetsComponent.prototype, "allowUserDeselect", void 0);
  623. __decorate([
  624. core_1.Input(),
  625. __metadata("design:type", Boolean)
  626. ], SpreadSheetsComponent.prototype, "allowCopyPasteExcelStyle", void 0);
  627. __decorate([
  628. core_1.Input(),
  629. __metadata("design:type", Boolean)
  630. ], SpreadSheetsComponent.prototype, "allowExtendPasteRange", void 0);
  631. __decorate([
  632. core_1.Input(),
  633. __metadata("design:type", Boolean)
  634. ], SpreadSheetsComponent.prototype, "cutCopyIndicatorVisible", void 0);
  635. __decorate([
  636. core_1.Input(),
  637. __metadata("design:type", String)
  638. ], SpreadSheetsComponent.prototype, "cutCopyIndicatorBorderColor", void 0);
  639. __decorate([
  640. core_1.Input(),
  641. __metadata("design:type", Number)
  642. ], SpreadSheetsComponent.prototype, "copyPasteHeaderOptions", void 0);
  643. __decorate([
  644. core_1.Input(),
  645. __metadata("design:type", Number)
  646. ], SpreadSheetsComponent.prototype, "defaultDragFillType", void 0);
  647. __decorate([
  648. core_1.Input(),
  649. __metadata("design:type", Boolean)
  650. ], SpreadSheetsComponent.prototype, "enableFormulaTextbox", void 0);
  651. __decorate([
  652. core_1.Input(),
  653. __metadata("design:type", Boolean)
  654. ], SpreadSheetsComponent.prototype, "highlightInvalidData", void 0);
  655. __decorate([
  656. core_1.Input(),
  657. __metadata("design:type", Boolean)
  658. ], SpreadSheetsComponent.prototype, "newTabVisible", void 0);
  659. __decorate([
  660. core_1.Input(),
  661. __metadata("design:type", Boolean)
  662. ], SpreadSheetsComponent.prototype, "tabStripVisible", void 0);
  663. __decorate([
  664. core_1.Input(),
  665. __metadata("design:type", Boolean)
  666. ], SpreadSheetsComponent.prototype, "tabEditable", void 0);
  667. __decorate([
  668. core_1.Input(),
  669. __metadata("design:type", Number)
  670. ], SpreadSheetsComponent.prototype, "tabStripRatio", void 0);
  671. __decorate([
  672. core_1.Input(),
  673. __metadata("design:type", Boolean)
  674. ], SpreadSheetsComponent.prototype, "tabNavigationVisible", void 0);
  675. __decorate([
  676. core_1.Input(),
  677. __metadata("design:type", Number)
  678. ], SpreadSheetsComponent.prototype, "autoFitType", void 0);
  679. __decorate([
  680. core_1.Input(),
  681. __metadata("design:type", Number)
  682. ], SpreadSheetsComponent.prototype, "referenceStyle", void 0);
  683. __decorate([
  684. core_1.Input(),
  685. __metadata("design:type", String)
  686. ], SpreadSheetsComponent.prototype, "backColor", void 0);
  687. __decorate([
  688. core_1.Input(),
  689. __metadata("design:type", String)
  690. ], SpreadSheetsComponent.prototype, "grayAreaBackColor", void 0);
  691. __decorate([
  692. core_1.Input(),
  693. __metadata("design:type", Number)
  694. ], SpreadSheetsComponent.prototype, "resizeZeroIndicator", void 0);
  695. __decorate([
  696. core_1.Input(),
  697. __metadata("design:type", Boolean)
  698. ], SpreadSheetsComponent.prototype, "showVerticalScrollbar", void 0);
  699. __decorate([
  700. core_1.Input(),
  701. __metadata("design:type", Boolean)
  702. ], SpreadSheetsComponent.prototype, "showHorizontalScrollbar", void 0);
  703. __decorate([
  704. core_1.Input(),
  705. __metadata("design:type", Boolean)
  706. ], SpreadSheetsComponent.prototype, "scrollbarMaxAlign", void 0);
  707. __decorate([
  708. core_1.Input(),
  709. __metadata("design:type", Boolean)
  710. ], SpreadSheetsComponent.prototype, "scrollIgnoreHidden", void 0);
  711. __decorate([
  712. core_1.Input(),
  713. __metadata("design:type", Object)
  714. ], SpreadSheetsComponent.prototype, "hostStyle", void 0);
  715. __decorate([
  716. core_1.Input(),
  717. __metadata("design:type", String)
  718. ], SpreadSheetsComponent.prototype, "hostClass", void 0);
  719. __decorate([
  720. core_1.Input(),
  721. __metadata("design:type", Boolean)
  722. ], SpreadSheetsComponent.prototype, "hideSelection", void 0);
  723. __decorate([
  724. core_1.Input(),
  725. __metadata("design:type", String)
  726. ], SpreadSheetsComponent.prototype, "name", void 0);
  727. __decorate([
  728. core_1.Input(),
  729. __metadata("design:type", String)
  730. ], SpreadSheetsComponent.prototype, "backgroundImage", void 0);
  731. __decorate([
  732. core_1.Input(),
  733. __metadata("design:type", Number)
  734. ], SpreadSheetsComponent.prototype, "backgroundImageLayout", void 0);
  735. __decorate([
  736. core_1.Input(),
  737. __metadata("design:type", Number)
  738. ], SpreadSheetsComponent.prototype, "showScrollTip", void 0);
  739. __decorate([
  740. core_1.Input(),
  741. __metadata("design:type", Number)
  742. ], SpreadSheetsComponent.prototype, "showResizeTip", void 0);
  743. __decorate([
  744. core_1.Input(),
  745. __metadata("design:type", Boolean)
  746. ], SpreadSheetsComponent.prototype, "showDragDropTip", void 0);
  747. __decorate([
  748. core_1.Input(),
  749. __metadata("design:type", Boolean)
  750. ], SpreadSheetsComponent.prototype, "showDragFillTip", void 0);
  751. __decorate([
  752. core_1.Input(),
  753. __metadata("design:type", Boolean)
  754. ], SpreadSheetsComponent.prototype, "showDragFillSmartTag", void 0);
  755. __decorate([
  756. core_1.Input(),
  757. __metadata("design:type", Boolean)
  758. ], SpreadSheetsComponent.prototype, "scrollbarShowMax", void 0);
  759. __decorate([
  760. core_1.Input(),
  761. __metadata("design:type", Boolean)
  762. ], SpreadSheetsComponent.prototype, "useTouchLayout", void 0);
  763. __decorate([
  764. core_1.Output(),
  765. __metadata("design:type", Object)
  766. ], SpreadSheetsComponent.prototype, "workbookInitialized", void 0);
  767. __decorate([
  768. core_1.Output(),
  769. __metadata("design:type", Object)
  770. ], SpreadSheetsComponent.prototype, "validationError", void 0);
  771. __decorate([
  772. core_1.Output(),
  773. __metadata("design:type", Object)
  774. ], SpreadSheetsComponent.prototype, "cellClick", void 0);
  775. __decorate([
  776. core_1.Output(),
  777. __metadata("design:type", Object)
  778. ], SpreadSheetsComponent.prototype, "cellDoubleClick", void 0);
  779. __decorate([
  780. core_1.Output(),
  781. __metadata("design:type", Object)
  782. ], SpreadSheetsComponent.prototype, "enterCell", void 0);
  783. __decorate([
  784. core_1.Output(),
  785. __metadata("design:type", Object)
  786. ], SpreadSheetsComponent.prototype, "leaveCell", void 0);
  787. __decorate([
  788. core_1.Output(),
  789. __metadata("design:type", Object)
  790. ], SpreadSheetsComponent.prototype, "valueChanged", void 0);
  791. __decorate([
  792. core_1.Output(),
  793. __metadata("design:type", Object)
  794. ], SpreadSheetsComponent.prototype, "topRowChanged", void 0);
  795. __decorate([
  796. core_1.Output(),
  797. __metadata("design:type", Object)
  798. ], SpreadSheetsComponent.prototype, "leftColumnChanged", void 0);
  799. __decorate([
  800. core_1.Output(),
  801. __metadata("design:type", Object)
  802. ], SpreadSheetsComponent.prototype, "invalidOperation", void 0);
  803. __decorate([
  804. core_1.Output(),
  805. __metadata("design:type", Object)
  806. ], SpreadSheetsComponent.prototype, "rangeFiltering", void 0);
  807. __decorate([
  808. core_1.Output(),
  809. __metadata("design:type", Object)
  810. ], SpreadSheetsComponent.prototype, "rangeFiltered", void 0);
  811. __decorate([
  812. core_1.Output(),
  813. __metadata("design:type", Object)
  814. ], SpreadSheetsComponent.prototype, "tableFiltering", void 0);
  815. __decorate([
  816. core_1.Output(),
  817. __metadata("design:type", Object)
  818. ], SpreadSheetsComponent.prototype, "tableFiltered", void 0);
  819. __decorate([
  820. core_1.Output(),
  821. __metadata("design:type", Object)
  822. ], SpreadSheetsComponent.prototype, "rangeSorting", void 0);
  823. __decorate([
  824. core_1.Output(),
  825. __metadata("design:type", Object)
  826. ], SpreadSheetsComponent.prototype, "rangeSorted", void 0);
  827. __decorate([
  828. core_1.Output(),
  829. __metadata("design:type", Object)
  830. ], SpreadSheetsComponent.prototype, "clipboardChanging", void 0);
  831. __decorate([
  832. core_1.Output(),
  833. __metadata("design:type", Object)
  834. ], SpreadSheetsComponent.prototype, "clipboardChanged", void 0);
  835. __decorate([
  836. core_1.Output(),
  837. __metadata("design:type", Object)
  838. ], SpreadSheetsComponent.prototype, "clipboardPasting", void 0);
  839. __decorate([
  840. core_1.Output(),
  841. __metadata("design:type", Object)
  842. ], SpreadSheetsComponent.prototype, "clipboardPasted", void 0);
  843. __decorate([
  844. core_1.Output(),
  845. __metadata("design:type", Object)
  846. ], SpreadSheetsComponent.prototype, "columnWidthChanging", void 0);
  847. __decorate([
  848. core_1.Output(),
  849. __metadata("design:type", Object)
  850. ], SpreadSheetsComponent.prototype, "columnWidthChanged", void 0);
  851. __decorate([
  852. core_1.Output(),
  853. __metadata("design:type", Object)
  854. ], SpreadSheetsComponent.prototype, "rowHeightChanging", void 0);
  855. __decorate([
  856. core_1.Output(),
  857. __metadata("design:type", Object)
  858. ], SpreadSheetsComponent.prototype, "rowHeightChanged", void 0);
  859. __decorate([
  860. core_1.Output(),
  861. __metadata("design:type", Object)
  862. ], SpreadSheetsComponent.prototype, "dragDropBlock", void 0);
  863. __decorate([
  864. core_1.Output(),
  865. __metadata("design:type", Object)
  866. ], SpreadSheetsComponent.prototype, "dragDropBlockCompleted", void 0);
  867. __decorate([
  868. core_1.Output(),
  869. __metadata("design:type", Object)
  870. ], SpreadSheetsComponent.prototype, "dragFillBlock", void 0);
  871. __decorate([
  872. core_1.Output(),
  873. __metadata("design:type", Object)
  874. ], SpreadSheetsComponent.prototype, "dragFillBlockCompleted", void 0);
  875. __decorate([
  876. core_1.Output(),
  877. __metadata("design:type", Object)
  878. ], SpreadSheetsComponent.prototype, "editStarting", void 0);
  879. __decorate([
  880. core_1.Output(),
  881. __metadata("design:type", Object)
  882. ], SpreadSheetsComponent.prototype, "editChange", void 0);
  883. __decorate([
  884. core_1.Output(),
  885. __metadata("design:type", Object)
  886. ], SpreadSheetsComponent.prototype, "editEnding", void 0);
  887. __decorate([
  888. core_1.Output(),
  889. __metadata("design:type", Object)
  890. ], SpreadSheetsComponent.prototype, "editEnd", void 0);
  891. __decorate([
  892. core_1.Output(),
  893. __metadata("design:type", Object)
  894. ], SpreadSheetsComponent.prototype, "editEnded", void 0);
  895. __decorate([
  896. core_1.Output(),
  897. __metadata("design:type", Object)
  898. ], SpreadSheetsComponent.prototype, "rangeGroupStateChanging", void 0);
  899. __decorate([
  900. core_1.Output(),
  901. __metadata("design:type", Object)
  902. ], SpreadSheetsComponent.prototype, "rangeGroupStateChanged", void 0);
  903. __decorate([
  904. core_1.Output(),
  905. __metadata("design:type", Object)
  906. ], SpreadSheetsComponent.prototype, "selectionChanging", void 0);
  907. __decorate([
  908. core_1.Output(),
  909. __metadata("design:type", Object)
  910. ], SpreadSheetsComponent.prototype, "selectionChanged", void 0);
  911. __decorate([
  912. core_1.Output(),
  913. __metadata("design:type", Object)
  914. ], SpreadSheetsComponent.prototype, "sheetTabClick", void 0);
  915. __decorate([
  916. core_1.Output(),
  917. __metadata("design:type", Object)
  918. ], SpreadSheetsComponent.prototype, "sheetTabDoubleClick", void 0);
  919. __decorate([
  920. core_1.Output(),
  921. __metadata("design:type", Object)
  922. ], SpreadSheetsComponent.prototype, "sheetNameChanging", void 0);
  923. __decorate([
  924. core_1.Output(),
  925. __metadata("design:type", Object)
  926. ], SpreadSheetsComponent.prototype, "sheetNameChanged", void 0);
  927. __decorate([
  928. core_1.Output(),
  929. __metadata("design:type", Object)
  930. ], SpreadSheetsComponent.prototype, "userZooming", void 0);
  931. __decorate([
  932. core_1.Output(),
  933. __metadata("design:type", Object)
  934. ], SpreadSheetsComponent.prototype, "userFormulaEntered", void 0);
  935. __decorate([
  936. core_1.Output(),
  937. __metadata("design:type", Object)
  938. ], SpreadSheetsComponent.prototype, "cellChanged", void 0);
  939. __decorate([
  940. core_1.Output(),
  941. __metadata("design:type", Object)
  942. ], SpreadSheetsComponent.prototype, "columnChanged", void 0);
  943. __decorate([
  944. core_1.Output(),
  945. __metadata("design:type", Object)
  946. ], SpreadSheetsComponent.prototype, "rowChanged", void 0);
  947. __decorate([
  948. core_1.Output(),
  949. __metadata("design:type", Object)
  950. ], SpreadSheetsComponent.prototype, "activeSheetChanging", void 0);
  951. __decorate([
  952. core_1.Output(),
  953. __metadata("design:type", Object)
  954. ], SpreadSheetsComponent.prototype, "activeSheetChanged", void 0);
  955. __decorate([
  956. core_1.Output(),
  957. __metadata("design:type", Object)
  958. ], SpreadSheetsComponent.prototype, "sparklineChanged", void 0);
  959. __decorate([
  960. core_1.Output(),
  961. __metadata("design:type", Object)
  962. ], SpreadSheetsComponent.prototype, "rangeChanged", void 0);
  963. __decorate([
  964. core_1.Output(),
  965. __metadata("design:type", Object)
  966. ], SpreadSheetsComponent.prototype, "buttonClicked", void 0);
  967. __decorate([
  968. core_1.Output(),
  969. __metadata("design:type", Object)
  970. ], SpreadSheetsComponent.prototype, "editorStatusChanged", void 0);
  971. __decorate([
  972. core_1.Output(),
  973. __metadata("design:type", Object)
  974. ], SpreadSheetsComponent.prototype, "floatingObjectChanged", void 0);
  975. __decorate([
  976. core_1.Output(),
  977. __metadata("design:type", Object)
  978. ], SpreadSheetsComponent.prototype, "floatingObjectSelectionChanged", void 0);
  979. __decorate([
  980. core_1.Output(),
  981. __metadata("design:type", Object)
  982. ], SpreadSheetsComponent.prototype, "pictureChanged", void 0);
  983. __decorate([
  984. core_1.Output(),
  985. __metadata("design:type", Object)
  986. ], SpreadSheetsComponent.prototype, "floatingObjectRemoving", void 0);
  987. __decorate([
  988. core_1.Output(),
  989. __metadata("design:type", Object)
  990. ], SpreadSheetsComponent.prototype, "floatingObjectRemoved", void 0);
  991. __decorate([
  992. core_1.Output(),
  993. __metadata("design:type", Object)
  994. ], SpreadSheetsComponent.prototype, "pictureSelectionChanged", void 0);
  995. __decorate([
  996. core_1.Output(),
  997. __metadata("design:type", Object)
  998. ], SpreadSheetsComponent.prototype, "floatingObjectLoaded", void 0);
  999. __decorate([
  1000. core_1.Output(),
  1001. __metadata("design:type", Object)
  1002. ], SpreadSheetsComponent.prototype, "touchToolStripOpening", void 0);
  1003. __decorate([
  1004. core_1.Output(),
  1005. __metadata("design:type", Object)
  1006. ], SpreadSheetsComponent.prototype, "commentChanged", void 0);
  1007. __decorate([
  1008. core_1.Output(),
  1009. __metadata("design:type", Object)
  1010. ], SpreadSheetsComponent.prototype, "commentRemoving", void 0);
  1011. __decorate([
  1012. core_1.Output(),
  1013. __metadata("design:type", Object)
  1014. ], SpreadSheetsComponent.prototype, "commentRemoved", void 0);
  1015. __decorate([
  1016. core_1.Output(),
  1017. __metadata("design:type", Object)
  1018. ], SpreadSheetsComponent.prototype, "slicerChanged", void 0);
  1019. __decorate([
  1020. core_1.ContentChildren(WorksheetComponent),
  1021. __metadata("design:type", core_1.QueryList)
  1022. ], SpreadSheetsComponent.prototype, "sheets", void 0);
  1023. SpreadSheetsComponent = __decorate([
  1024. core_1.Component({
  1025. selector: 'gc-spread-sheets',
  1026. template: "\n <div [ngStyle]=\"style\" [ngClass]=\"hostClass\">\n <ng-content></ng-content>\n </div>\n "
  1027. }),
  1028. __param(0, core_1.Inject(core_1.ElementRef)),
  1029. __metadata("design:paramtypes", [core_1.ElementRef])
  1030. ], SpreadSheetsComponent);
  1031. exports.SpreadSheetsComponent = SpreadSheetsComponent;
  1032. var SpreadSheetsModule = (function () {
  1033. function SpreadSheetsModule() {
  1034. }
  1035. return SpreadSheetsModule;
  1036. }());
  1037. SpreadSheetsModule = __decorate([
  1038. core_1.NgModule({
  1039. imports: [common_1.CommonModule],
  1040. declarations: [SpreadSheetsComponent, WorksheetComponent, ColumnComponent],
  1041. exports: [SpreadSheetsComponent, WorksheetComponent, ColumnComponent]
  1042. })
  1043. ], SpreadSheetsModule);
  1044. exports.SpreadSheetsModule = SpreadSheetsModule;