Eva's useful guide to Ubuntu 9.04
Just click on the cell and:
Data > Validation > Settings
and the source field will tell you where the list is. You can then edit
OpenOffice Writer and compiz Desktop Effects + nVidia 3D driver nvidia has long been buggy in redrawing / refreshing the page when you edit or simply scroll it up and down. The bug is actually not of OpenOffice Writer but instead concerns compiz and nvidia propietary drivers. A workaround exists, here is how to enable it:
first install compizconfig-settings-manager
sudo apt-get install compizconfig-settings-manager
then launch the applet from System -> Preferences -> CompizConfig Settings Manager navigate to Utility section and click on Workarounds plugin. Inside enable (tick) “force syncronization between X and GLX”.
That’s it! These changes are applied immediately.