Examples of CTSheetProtection

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetProtection

1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
     * @param password to set for protection. Pass <code>null</code> to remove protection
     */
    public void protectSheet(String password) {
         
      if(password != null) {
        CTSheetProtection sheetProtection = worksheet.addNewSheetProtection();
        sheetProtection.xsetPassword(stringToExcelPassword(password));
        sheetProtection.setSheet(true);
        sheetProtection.setScenarios(true);
        sheetProtection.setObjects(true);
      } else {
        worksheet.unsetSheetProtection();
      }
    }
View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetProtection

1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
     * @param password to set for protection. Pass <code>null</code> to remove protection
     */
    public void protectSheet(String password) {

      if(password != null) {
        CTSheetProtection sheetProtection = worksheet.addNewSheetProtection();
        sheetProtection.xsetPassword(stringToExcelPassword(password));
        sheetProtection.setSheet(true);
        sheetProtection.setScenarios(true);
        sheetProtection.setObjects(true);
      } else {
        worksheet.unsetSheetProtection();
      }
    }
View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetProtection

1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
    @Test
    public void protectSheet_lowlevel() {
        XSSFWorkbook wb = new XSSFWorkbook();
        XSSFSheet sheet = wb.createSheet();
        CTSheetProtection pr = sheet.getCTWorksheet().getSheetProtection();
        assertNull("CTSheetProtection should be null by default", pr);
        String password = "Test";
        sheet.protectSheet(password);
        pr = sheet.getCTWorksheet().getSheetProtection();
        assertNotNull("CTSheetProtection should be not null", pr);
        assertTrue("sheet protection should be on", pr.isSetSheet());
        assertTrue("object protection should be on", pr.isSetObjects());
        assertTrue("scenario protection should be on", pr.isSetScenarios());
        String hash = String.valueOf(HexDump.shortToHex(PasswordRecord.hashPassword(password))).substring(2);
        assertEquals("well known value for top secret hash should be "+ hash, hash, pr.xgetPassword().getStringValue());

        sheet.protectSheet(null);
        assertNull("protectSheet(null) should unset CTSheetProtection", sheet.getCTWorksheet().getSheetProtection());
    }
View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetProtection

1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
    @Test
    public void protectSheet_lowlevel() {
        XSSFWorkbook wb = new XSSFWorkbook();
        XSSFSheet sheet = wb.createSheet();
        CTSheetProtection pr = sheet.getCTWorksheet().getSheetProtection();
        assertNull("CTSheetProtection should be null by default", pr);
        String password = "Test";
        sheet.protectSheet(password);
        pr = sheet.getCTWorksheet().getSheetProtection();
        assertNotNull("CTSheetProtection should be not null", pr);
        assertTrue("sheet protection should be on", pr.isSetSheet());
        assertTrue("object protection should be on", pr.isSetObjects());
        assertTrue("scenario protection should be on", pr.isSetScenarios());
        String hash = String.valueOf(HexDump.shortToHex(PasswordRecord.hashPassword(password))).substring(2);
        assertEquals("well known value for top secret hash should be "+ hash, hash, pr.xgetPassword().getStringValue());

        sheet.protectSheet(null);
        assertNull("protectSheet(null) should unset CTSheetProtection", sheet.getCTWorksheet().getSheetProtection());
    }
View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetProtection

1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
     * @param password to set for protection. Pass <code>null</code> to remove protection
     */
    public void protectSheet(String password) {
         
      if(password != null) {
        CTSheetProtection sheetProtection = worksheet.addNewSheetProtection();
        sheetProtection.xsetPassword(stringToExcelPassword(password));
        sheetProtection.setSheet(true);
        sheetProtection.setScenarios(true);
        sheetProtection.setObjects(true);
      } else {
        worksheet.unsetSheetProtection();
      }
    }
View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetProtection

1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
     */
    @Override
    public void protectSheet(String password) {

        if(password != null) {
            CTSheetProtection sheetProtection = worksheet.addNewSheetProtection();
            sheetProtection.xsetPassword(stringToExcelPassword(password));
            sheetProtection.setSheet(true);
            sheetProtection.setScenarios(true);
            sheetProtection.setObjects(true);
        } else {
            worksheet.unsetSheetProtection();
        }
    }
View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetProtection

1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
    @Test
    public void protectSheet_lowlevel() {
        XSSFWorkbook wb = new XSSFWorkbook();
        XSSFSheet sheet = wb.createSheet();
        CTSheetProtection pr = sheet.getCTWorksheet().getSheetProtection();
        assertNull("CTSheetProtection should be null by default", pr);
        String password = "Test";
        sheet.protectSheet(password);
        pr = sheet.getCTWorksheet().getSheetProtection();
        assertNotNull("CTSheetProtection should be not null", pr);
        assertTrue("sheet protection should be on", pr.isSetSheet());
        assertTrue("object protection should be on", pr.isSetObjects());
        assertTrue("scenario protection should be on", pr.isSetScenarios());
        int hashVal = CryptoFunctions.createXorVerifier1(password);
        int actualVal = Integer.parseInt(pr.xgetPassword().getStringValue(),16);
        assertEquals("well known value for top secret hash should match", hashVal, actualVal);

        sheet.protectSheet(null);
        assertNull("protectSheet(null) should unset CTSheetProtection", sheet.getCTWorksheet().getSheetProtection());
    }
View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetProtection

1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
     * @param password to set for protection. Pass <code>null</code> to remove protection
     */
    @Override
    public void protectSheet(String password) {
        if (password != null) {
            CTSheetProtection sheetProtection = safeGetProtectionField();
            setSheetPassword(password, null); // defaults to xor password
            sheetProtection.setSheet(true);
            sheetProtection.setScenarios(true);
            sheetProtection.setObjects(true);
        } else {
            worksheet.unsetSheetProtection();
        }
    }
View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetProtection

1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
     * @param password to set for protection. Pass <code>null</code> to remove protection
     */
    public void protectSheet(String password) {
         
      if(password != null) {
        CTSheetProtection sheetProtection = worksheet.addNewSheetProtection();
        sheetProtection.xsetPassword(stringToExcelPassword(password));
        sheetProtection.setSheet(true);
        sheetProtection.setScenarios(true);
        sheetProtection.setObjects(true);
      } else {
        worksheet.unsetSheetProtection();
      }
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.