We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How to make auto-complete list in a cell in calc? [closed]

asked 2015-11-07 10:33:10 +0200

Andyfc gravatar image

updated 2015-11-07 10:35:08 +0200

I have a two step question.

I have a table that contains "ID" (a primary key), "Country name", "Region name", "City name", "Latitude" and "Longitude". A city name appears more than once, since there are cities with the same name in different regions and countries. However the set "City name", "Region name" and "Country name" is unique.

I would like to do the following:

  1. when someone starts typing a city name in a cell, he gets a list of the cities that start with what he has typed so far, the region and the country of the city (in order to see that he selects the one in the right country and region).

  2. when he is happy with the list being small enough, then he selects the appropriate city from the list.

  3. two other cells should be filled: one with the latitude and one with the longitude of the selected city, looking up the right one by the set of city, region and country names.

I'm not afraid of moving the table to base and using sql queries, if that makes it easier.

Is something like this even possible with LibreOffice?

Thank you.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-14 19:06:59.751435

2 Answers

Sort by » oldest newest most voted

answered 2015-11-08 20:48:23 +0200

doug gravatar image

This is precisely the functionality of the List Box and Combo Box controls on the Form object. For foundational information, see help page or Chapter 4 of the Base handbook.

edit flag offensive delete link more


@doug Thanks, I got the Combo Box to work. Now I need to go further, but I asked a new question for that: https://ask.libreoffice.org/en/questi...

Andyfc gravatar imageAndyfc ( 2015-11-09 07:55:31 +0200 )edit

answered 2015-11-07 14:17:46 +0200

I am not good with pc

edit flag offensive delete link more

Question Tools



Asked: 2015-11-07 10:33:10 +0200

Seen: 1,916 times

Last updated: Nov 08 '15