This is regarding jxl. I am while writing to the file I am creating a data-validation list for a column, to ease the user inputs to the excel sheet.. But the drop down for the data-validation gets displayed at the location 0,0. Even if it is not set to be there.. the cell features of that cell are perfectly fine, tried to read such excel back, but it dint have a data validation list..
Also, I executed my code in debug mode, found out that this drop down gets displayed only after the 2nd row with data-validation being added to the sheet.. for the first row, it is not there...
The weirdest part is, this drop down, when clicked, does not show the list.. but if select a cell with the data-validation list, and then click the drop down arrow in the 0,0 cell, it opens the list! changing the values there changes the value in the selected cell..!!
Anybody having any idea why this could be happening..? has it got anything to do with me using office07 to open that file..?