Many people use spreadsheets as a tool to exchange information. For example, you can get a spreadsheet from your supplier with request to list your order details there. On another side, you can create a similar spreadsheet to your customer, or even for household needs: keeping budget, or inviting friends to the party. The range of spreadsheets' use is large.
The video in this post gives you a guidance how you can create the lists for certain cells in LibreOffice Calc. Similar instructions are valid for OpenOffice Calc too.
Hope you enjoy! There are some other how-to videos you can check too.