I'm using the POI 3.6-XSSF API to write Excel 2007 documents, and i'm having trouble getting specific user edit actions of a given sheet to lock (i.e. lockDeleteRows). The API says that you need to call enableLocking() on the sheet but when I do that it locks everything and ignores my specific locking settings (example below). When I don't call it nothing is locked.
It seems this should work given the fact that specific methods are provided to give one this granular locking control at a sheet level. So how can I lock specific user edit actions of a workbook/worksheet using this API?
XSSFWorkbook wb = new XSSFWorkbook();
XSSFSheet sheet = wb.createSheet("Sheet1");
XSSFCell cell;
XSSFRow row = sheet.createRow(0);
cell = row.createCell(0, XSSFCell.CELL_TYPE_STRING); cell.setCellValue("Sku");
cell = row.createCell(1, XSSFCell.CELL_TYPE_STRING); cell.setCellValue("Category");
cell = row.createCell(2, XSSFCell.CELL_TYPE_STRING); cell.setCellValue("SubCategory");
cell = row.createCell(3, XSSFCell.CELL_TYPE_STRING); cell.setCellValue("Name");
cell = row.createCell(4, XSSFCell.CELL_TYPE_STRING); cell.setCellValue("DATE_ADDED");
cell = row.createCell(5, XSSFCell.CELL_TYPE_STRING); cell.setCellValue("SEO_DESCRIPTION");
row = sheet.createRow(1);
cell = row.createCell(0, XSSFCell.CELL_TYPE_STRING); cell.setCellValue("4bd2c24571534e098589");
cell = row.createCell(1, XSSFCell.CELL_TYPE_STRING); cell.setCellValue("CLUBS");
cell = row.createCell(2, XSSFCell.CELL_TYPE_STRING); cell.setCellValue("DRIVERS");
cell = row.createCell(3, XSSFCell.CELL_TYPE_STRING); cell.setCellValue("1112222 -- ASFASDF");
cell = row.createCell(4, XSSFCell.CELL_TYPE_STRING); cell.setCellValue(new Date());
cell = row.createCell(5, XSSFCell.CELL_TYPE_STRING); cell.setCellValue("asdfhavsdvf absdfhvbashdv asvdfhavsfasdf");
sheet.lockDeleteColumns();
sheet.lockInsertColumns();
sheet.lockDeleteRows();
sheet.enableLocking(); // why does this call ignore the last 3 lock settings i just set???????????
OutputStream out;
try {
out = new FileOutputStream("c:\\temp\\TestWB.xlsx", false);
wb.write(out);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}