gc.spread.sheets.angular.11.2.2.js 35 KB

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