Worksheet, workbook and cell-level protection settings (locking, password protection)

[kainhofer]

Functionality

• locked and hidden cell properties are properly loaded by loadWorksheet, retained and written back by saveWorkbook ( child element of the cell styles)
• worksheet protection settings (including fine-grained flags what is allows and what not, as available in Excel's worksheet protection dialog) and password are loaded by loadWorksheet, retained and written back by saveWorkbook ( element of the worksheet)
• workbook protection settings (lock structure and windows) and password are loaded by loadWorksheet, retained and written back by saveWorkbook ( element of the workbook)

New functions to set these protection levels:

• new attributes 'hidden' and 'locked' for the Style class => sets cell-level flags for locked / hidden (will have effect only if worksheet is set to protected)
• protectWorksheet(wb, sheet, protect = TRUE, password = NULL, lock...) to set and remove worksheet protection.
• protectWorkbook(wb, protect = TRUE, password = NULL, lock...) to set and remove workbook protection.
• hashPassword(password) helper function that implements the "old" Excel password hashes until Excel 2013
  • unit tests are provided

This fixes issues #409 and #410

[codecov[bot]]

Codecov Report

Merging #413 into master will increase coverage by <.01%. The diff coverage is 61.4%.

@@            Coverage Diff             @@
##           master     #413      +/-   ##
==========================================
+ Coverage   60.23%   60.23%   +<.01%     
==========================================
  Files          30       30              
  Lines        7031     7142     +111     
==========================================
+ Hits         4235     4302      +67     
- Misses       2796     2840      +44

Impacted Files	Coverage Δ
R/helperFunctions.R	75.56% <100%> (+0.62%)	:arrow_up:
R/StyleClass.R	17.28% <16.66%> (-0.05%)	:arrow_down:
R/worksheet_class.R	73.28% <50%> (-0.37%)	:arrow_down:
R/WorkbookClass.R	55.26% <58.06%> (-0.01%)	:arrow_down:
R/wrappers.R	42.61% <65.38%> (+0.98%)	:arrow_up:
src/load_workbook.cpp	90% <66.66%> (-0.15%)	:arrow_down:
R/loadWorkbook.R	69.56% <75%> (-0.02%)	:arrow_down:

---

Continue to review full report at Codecov.

Legend - Click here to learn more Δ = absolute <relative> (impact), ø = not affected, ? = missing data Powered by Codecov. Last update 025605f...3fc0025. Read the comment docs.