Commit8fb94e9

authored

Merge pull request#728 from LesterLyu/fix-worksheet-state

Read worksheet hidden state

2 parents2b747cd +eb8814d commit8fb94e9Copy full SHA for 8fb94e9

File tree

+24

-1

lines changed

+24

-1

lines changed

Lines changed: 0 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -238,7 +238,6 @@ var worksheet = workbook.getWorksheet(1);`
`238`	`238`
`239`	`239`	```javascript
`240`	`240`	`// make worksheet visible`
`241`		`-worksheet.state='show';`
`242`	`241`	`worksheet.state='visible';`
`243`	`242`
`244`	`243`	`// make worksheet hidden`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -193,10 +193,12 @@ Workbook.prototype = {`
`193`	`193`	`varid=worksheetModel.id;`
`194`	`194`	`varname=worksheetModel.name;`
`195`	`195`	`varorderNo=value.sheets.findIndex(ws=>ws.id===id);`
	`196`	`+varstate=worksheetModel.state;`
`196`	`197`	`varworksheet=this._worksheets[id]=newWorksheet({`
`197`	`198`	`id:id,`
`198`	`199`	`name:name,`
`199`	`200`	`orderNo,`
	`201`	`+ state,`
`200`	`202`	`workbook:this`
`201`	`203`	`});`
`202`	`204`

9.65 KB

Binary file not shown.

Lines changed: 22 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,22 @@`
	`1`	`+'use strict';`
	`2`	`+`
	`3`	`+varchai=require('chai');`
	`4`	`+`
	`5`	`+varverquire=require('../../utils/verquire');`
	`6`	`+`
	`7`	`+varExcel=verquire('excel');`
	`8`	`+`
	`9`	`+varexpect=chai.expect;`
	`10`	`+`
	`11`	`+describe('github issues',function(){`
	`12`	`+it('pull request 728 - Read worksheet hidden state',function(){`
	`13`	`+varwb=newExcel.Workbook();`
	`14`	`+returnwb.xlsx.readFile('./spec/integration/data/test-pr-728.xlsx')`
	`15`	`+.then(function(){`
	`16`	`+varexpected={1:'visible',2:'hidden',3:'visible'};`
	`17`	`+wb.eachSheet(function(ws,sheetId){`
	`18`	`+expect(ws.state).to.equal(expected[sheetId]);`
	`19`	`+});`
	`20`	`+});`
	`21`	`+});`
	`22`	`+});`

Comments

(0)