<div>
Works perfect. It was a new angle to solving the problem, but it definitively did the trick. Thanks.
</div>


Works perfect. It was a new angle to solving the problem, but it definitively did the trick. Thanks.

<div>
Glad it worked for you, nbtnt1. Thanks for the A!
</div>


Glad it worked for you, nbtnt1. Thanks for the A!

<div>
<div class="content wysiwyg-content">
I want to create a spreadsheet using OpenOffice Calc where each line is like a row in a database.<br />
Each cell should be designed as a dropdown/pulldown list showing values from a predefined column of cells in another tab in the spreadsheet.<br />
When I create a pulldown object it is &quot;floating&quot; 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).<br />
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.<br />
Please adviise.
</div>
</div>


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.
Please adviise.

Dropdown list = cell in OpenOffice Calc

LibreOffice is a free and open source office suite. The LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. It is available in 110 languages. LibreOffice uses the international ISO/IEC standard OpenDocument file format as its native format to save documents for all of its applications. LibreOffice is also compatible with other major office suites through a variety of import/export filters. LibreOffice is available for a variety of computing platforms, including Windows, OS X) and Linux.

LibreOffice

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.