XSSF Drop Down List Not Supporting MSExcell and Kingsoft Spreadsheet

Asked Oct 05 '16 at 15:06

Active Oct 05 '16 at 15:22

Viewed 270 times

XSSFDataValidationHelper validationHelper = new XSSFDataValidationHelper(firstSheet);
CellRangeAddressList addressList = new CellRangeAddressList(1, 1, 4, 4);
XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint) validationHelper.createExplicitListConstraint(getAllNames()); 
DataValidation dataValidation = validationHelper.createValidation(dvConstraint, addressList);
dataValidation.setSuppressDropDownArrow(true);
dataValidation.setShowErrorBox(true);

Above code for drop down list working only in Libre Office Spread Sheet. Its not working in MS Ex-cell and King soft Spread Sheet. I researched in lots of blogs and Apache POI I didn't find any solution for that. If you guys solved this issue before please help me

edited Oct 05 '16 at 15:22

asked Oct 05 '16 at 15:06

Ramesh Kumar

Have you looked at https://poi.apache.org/spreadsheet/quick-guide.html#xssf.usermodel+%28.xlsx+format%29 Did you remember to add the data validation to the sheet? – IceArdor Oct 09 '16 at 23:39
yes i did but its not working – Ramesh Kumar Oct 10 '16 at 09:22
I am facing the same issue. Have you found any solution for the same? – Bhavesh Patadiya May 07 '18 at 10:24
i already done this solution long ill post it – Ramesh Kumar May 05 '19 at 07:52

XSSF Drop Down List Not Supporting MSExcell and Kingsoft Spreadsheet

0 Answers0