Win a copy of Rust Web Development this week in the Other Languages forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Junilu Lacar
  • Rob Spoor
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Jesse Silverman
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Frits Walraven

JXL: unwanted datavalidation list dropdown at 0,0

 
Greenhorn
Posts: 11
jQuery Eclipse IDE Firefox Browser
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 11
jQuery Eclipse IDE Firefox Browser
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Help guys...
I am not being able to trace it... Please suggest something..
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic