wood burning stoves 2.0*
The moose likes Other Open Source Projects and the fly likes JXL: unwanted datavalidation list dropdown at 0,0 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "JXL: unwanted datavalidation list dropdown at 0,0" Watch "JXL: unwanted datavalidation list dropdown at 0,0" New topic
Author

JXL: unwanted datavalidation list dropdown at 0,0

Nikhil Wanpal
Greenhorn

Joined: Apr 16, 2010
Posts: 11

Hi all,
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..?

Please advice...
Nikhil Wanpal
Greenhorn

Joined: Apr 16, 2010
Posts: 11

Help guys...
I am not being able to trace it... Please suggest something..
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: JXL: unwanted datavalidation list dropdown at 0,0
 
Similar Threads
Using JDBC to insert into MS Excel file
Java POI
finding the empty cell using jxl
jxl getworkbook method hangs for corrupted file
Using JXL - Error encountered