I want to create a spreadsheet using OpenOffice Calc where each line is like a row in a database.
Each cell should be designed as a dropdown/pulldown list showing values from a predefined column of cells in another tab in the spreadsheet.
When I create a pulldown object it is "floating" around on top of the tab and is not linked toany particular cell. I can't figure out how this is done (or if it is possible).
The main reason for creating this in a spreadsheet and not as a database application is the need to transfer it to my cellphone (and other platforms) where I don't neccesarily have OpenOffice installed.