Is there a way to ignore validation errors using XSSF? Eliminating the green checkmark warnings "Number stored as text" is my ultimate goal. In my circumstance the values should be text because they often have leading zeros, eg 00012345. So I want the value to be text but for the validation checks to ignore those cells. Any ideas are greatly appreciate. And congrats on releasing version 3.6! The comments in XSSF are great.
Tom Carolan
