hello, have you ever know how is this feature, I use the POI generate Excel, the table has a column is a drop-down box to choose, but at the same time requirements will also be able to input, the question now is: input the Excel spreadsheet will automatically check the validity of the data, which prompts an error, this error has to know how to cancel with code?

CodePudding user response:

You in your project under the global search: HSSFCell
See if there are any where in the cell to check

CodePudding user response:

Is the default you use DataValidation increase drop-down box, try it

SetShowErrorBox (Boolean show); Can set to false,

http://poi.apache.org/apidocs/dev/org/apache/poi/xssf/usermodel/XSSFDataValidation.html#setShowErrorBox-boolean-