+1Hi Ignitors,
First time poster, long time listener 😀
So I’m trying to get an idea of what this warning ('Validation root cell outside of sheet, ignoring') actually means especially the part ‘outside of sheet’? The cell it refers to that contains the validation does seem to be in the sheet.
Also is there a list of warnings and errors that might be generated with definitions / actions available?
Thank you
Best answer by Simon Tam
Hi PeteE,
Thanks for the question! In short it means an Excel Data Validation has been setup beyond the defined bounds of the worksheet. Spark will not be able to process any of the validation rules defined in that particular cell.
In Excel each worksheet has what’s called a “used range”. You can find the boundary of the used range of a worksheet by clicking on cell A1 and then pressing Ctrl+End. The used range extends from cell A1 all the way to that cell. If the validations are not included in this range then they would not be processed properly by Spark.
To avoid this message, make sure that cells that contain Data Validation are within the used range. The used range of a worksheet can be extended by adding additional content further right or down on the workbook.
We are trying to improve the documentation and messaging of errors in Spark and Gitbook. Keep a lookout for improvements coming down the line!
Simon
+2Hi PeteE,
Thanks for the question! In short it means an Excel Data Validation has been setup beyond the defined bounds of the worksheet. Spark will not be able to process any of the validation rules defined in that particular cell.
In Excel each worksheet has what’s called a “used range”. You can find the boundary of the used range of a worksheet by clicking on cell A1 and then pressing Ctrl+End. The used range extends from cell A1 all the way to that cell. If the validations are not included in this range then they would not be processed properly by Spark.
To avoid this message, make sure that cells that contain Data Validation are within the used range. The used range of a worksheet can be extended by adding additional content further right or down on the workbook.
We are trying to improve the documentation and messaging of errors in Spark and Gitbook. Keep a lookout for improvements coming down the line!
Simon
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
