Droplist Worksheet

[Lorie]

I have implemented the Droplist worksheet editor successfully. There is a visual problem though and I'm not sure if this is a known issue or something I can work around. The issue is once I select the cell and the droplist appears, the cell in the next row shows thru. I successfully set the background color of the drop down to white, but it still shows thru, so I am not sure what is going on. I am attaching a screen shot to show the issue. Please let me know if there is a workaround for this, or if I am doing something wrong.

 

Thank you..

Lorie

[Jeff Johnston]

You might need to go through the JavaScript and see if you see anything in there.

JMesa 4 is actually right around the corner now. I will just send you a link to read the notes but we have simplified things a lot from the JavaScript side, and for for the droplist we just use the regular html select box now.

http://code.google.com/p/jmesa/wiki/JMesa4

It doesn't really help you out now...unless you want me to cut you a release and help test things. Be sure to read the release "Things To Consider" section as we need to re-think the worksheet client side validation again. The only other thing that is a breaking change is the way custom toolbars are created. Other than that internally we are getting ready to deploy the trunk code to production so it is in a pretty good place right now.

-Jeff

[Lorie]

I will go thru the JavaScript, if I can not figure anything out I will go from there.

Thank you.

Lorie

[zaq]

Was a solution ever found for this?  Looking at the javascript and css I do not see anything that should cause the select box to be transparent.  I have even tried setting the div, and select box to be position absolute to bring it to the front but that doesn't work either.

[Jeff Johnston]

More than likely it is some CSS that is cascading in to make it not look right.

The next release should be out soon. As long as you do not mind losing client side validation with the worksheet it does make things a lot easier from the JavaScript side now as most of it is gone now.


- Jeff Johnston

[zaq]

From looking at the javascript it seems to use the same logic to generate the in worksheet dropLists as it does for the filter rows droplist.  However the filter rows droplist is not transparent and causing that issue.

As far as CSS goes and if something is cascading down, I have removed all css files except the jmesa stylesheet for testing purposes.  And the problem still exists for worksheet droplists, but not for filter row droplists.

Next I decided to look at the jmesa.css file since it must be the culprit.  I downloaded the latest jmesa (3.0.4) I am currently running 3.0.3.  And replaced the jmesa.css file I was using with the one from the 3.0.4 release.  That seems to have fixed it.  Doing a comparison of the two css files doesn't have anything sticking out as "this line is the cause", but switching to the 3.0.4 css file did fix the problem.

Now I'm going to switch out the js files to the 3.0.4 and just make sure everything still works smoothly with that.    Hopefully nothing big changed with 3.0.4 that I can just upgrade and all will be good.

Hope this might help Lorie as well if she was using the 3.0.3 release.