1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
/* global describe it cy require afterEach beforeEach */
var helper = require('../../common/helper');
var calcHelper = require('../../common/calc_helper');
var desktopHelper = require('../../common/desktop_helper');
describe(['tagdesktop'], 'Row Column Operation', function() {
var testFileName = 'row_column_operation.ods';
beforeEach(function() {
helper.beforeAll(testFileName, 'calc');
desktopHelper.switchUIToNotebookbar();
calcHelper.selectEntireSheet();
calcHelper.assertDataClipboardTable(['Hello','Hi','World','Bye']);
calcHelper.clickOnFirstCell(true,false);
cy.cGet('#toolbar-up .w2ui-scroll-right').click();
});
afterEach(function() {
helper.afterAll(testFileName, this.currentTest.state);
});
it('Insert/Delete row' , function() {
//Insert row above
cy.cGet('#home-insert-columns-before-button').click();
calcHelper.selectEntireSheet();
//calcHelper.assertDataClipboardTable(['','','Hello','Hi','World','Bye']);
//delete row
calcHelper.clickOnFirstCell(true, false);
cy.cGet('#home-delete-rows-button').click();
calcHelper.selectEntireSheet();
//calcHelper.assertDataClipboardTable(['Hello','Hi','World','Bye']);
//insert row below
calcHelper.clickOnFirstCell(true, false);
cy.cGet('#home-insert-rows-after-button').click();
calcHelper.selectEntireSheet();
//calcHelper.assertDataClipboardTable(['Hello','Hi','','','World','Bye']);
});
it.only('Insert/Delete Column', function() {
//insert column before
cy.cGet('#home-insert-columns-before-button').click();
calcHelper.selectEntireSheet();
//calcHelper.assertDataClipboardTable(['','Hello','Hi','','World','Bye']);
calcHelper.clickOnFirstCell(true, false);
//delete column
cy.cGet('#home-delete-columns-button').click();
calcHelper.selectEntireSheet();
cy.wait(500);
//calcHelper.assertDataClipboardTable(['Hello','Hi','World','Bye']);
calcHelper.clickOnFirstCell(true,false);
//insert column after
cy.cGet('#home-insert-columns-after-button').click();
calcHelper.selectEntireSheet();
//calcHelper.assertDataClipboardTable(['Hello','','Hi','World','','Bye']);
});
});
|