Hi :) I think Andreas was just pointing out that given a zip code it might be fairly easy to find the city, State and such but given a State or even a specific city it might not be easy to guess which of the zip codes is right. I think you can get part of the zip code that way buit not all of it? In England the first 2 letters give the 'State'/County (well, approximately).
Anyway the technical part of the question is how to get one drop-down to look-up and fill in a value based on the entry made elsewhere on the page. Is Chapter 8 or 10 in the Calc Guide helpful? http://wiki.documentfoundation.org/Documentation#LibreOffice_Calc_Guide Regards from Tom :) --- On Fri, 23/9/11, NoOp <[email protected]> wrote: From: NoOp <[email protected]> Date: Friday, 23 September, 2011, 3:26 On 09/22/2011 01:40 AM, Andreas Säger wrote: > > This is impossible because big cities have more than one ZIP and there > are ambiguous city names. Actually it's not if you have (in the US) the USPS 5 digit Zip Code database: https://www.usps.com/business/address-information-systems.htm# Five-Digit ZIP® Product Provides 5-digit ZIP Code data that can be appended to computerized mailing lists via address-matching software. With that (or similar) I think that you could easily build a dropdown that links to that. You'd probably need to fine tune by address as each city, street, business may have differing Zip/Postal Codes Unfortunately the USPS doesn't offer an easy way to order: For more information on the AIS View, please contact the National Customer Support Center at 1-800-238-3150, Option 6 and then Option 2 to speak to a customer service representative. > You may enter a city name and then choose the actual city and zip from > suggested data. > > I use to enter zip codes. Each zip code belongs to one particular city > in one state. > > Apart from this, big companies and public sectors have their own zip codes. > > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
