[ Date Index ]
[ Thread Index ]
[ <= Previous by date /
thread ]
[ Next by date /
thread => ]
Re: [LUG] libre office macros/dialogs
- To: list@xxxxxxxxxxxxx
- Subject: Re: [LUG] libre office macros/dialogs
- From: Eion MacDonald <maceion@xxxxxxxxx>
- Date: Thu, 23 Apr 2020 21:05:18 +0100
- Autocrypt: addr=maceion@xxxxxxxxx; prefer-encrypt=mutual; keydata= xsFNBFa2f2QBEADuSyhbUgZ191rG15xTUMtFZSfQHhfnlG22YyJUrbJw/ma+RSkwWIYePebs S9Fh2+snMFYUKSL01EyXbQfL+7kvfUHBis2UGE7j+KE51ai8qjtB6i+uLzwfHr6LmTO0GSLW 0XhSHq4wwkWGu//wJlO6bAzLrNYqv4XYv+HVtjBknihNTaRZlUn3snNmxFkR/U+hyv5ThI6j Yr/4wfSx+tmbIkLu85zNkQqnBHZ88mTXzAlRX1nWZafYXvUznGMeVT3/XfCsBr3nIn4NbJIl ulhV83LV4jCgNXDEJPv2yZ4EZ11VvTUKsLPsqTFPzL0CBKI23EdQC4JejIqkUQfPv0asUqct DHS5Prf63/oPHylknZk5lOKNhzYUnI30zFG3U7AEvZL6/LovSnKLR/3VsOAGsUbhC7fJ/Rhn nk/xN4FCHbxR1b26KaDOTLGjz2XuB3jpHtQNddGyACEbP90fbieK26omdCLVUVaOkdRAOier HRbcOTn32btmsRF+NidTnM1/+Mdp3aiZPCPPHWyz2Rb5SIaG/1HaNupGolWUBeiamnf/7v5h HM1rG5OzDeB/tfFhiVaJzfre/tUQibzHeuU9W9NzFuDE5i51PVBVGD8tUih+2YZWFI9jsXlp ySdxqHAHPXioU0Oow1I5+RurWdKT+04uRkIFeSzZj6Cj9bEKmwARAQABzTlFaW9uIE1hY0Rv bmFsZCAobWFjZWlvbmdtYWlsMjAxNjAyMDYpIDxtYWNlaW9uQGdtYWlsLmNvbT7CwXkEEwEC ACMFAla2f2QCGyMHCwkIBwMCAQYVCAIJCgsEFgIDAQIeAQIXgAAKCRB0Kz2KQSuP4UPsD/9A EcaR3iFiETILJsB83nzgISfKRnoueWKIKxtzZmn0Kb5ZTPGgHpTILuNCHMXOm5fmAz40JSnW OTtBFIlFlpY+jbgWv3IgltsY4/3gBTKyKtJ61W42v27LXBDvup9F4uWXBbjUv5qgRUj9lgkc Tbvo54e0rDzRogaNb9RP6QLEuk4oR6mCvYqANkKnymeQg+D/BRtQk2vcs97tBYr2YgczMkcc cxiv9QbEcapsTYF6GW8twnfvlSSHDmNJ6/KQgbJLfwZOX6G9PdxoVjAkor+fv1MuHq6Wzm2i EPmkFjMgGXc0AOsthQK4XTlJ9huF0lamGz0kaa6eH82eSvZkG6KCXRgDssaQr3OYUyvhXrff nUQMMJ2YwlmspzBLNYNJeRxOm9GUzRbY+cGjE8gnOyJ8v+2p0T697pa1QH9QmiMMG2DMoCbG Z859dclytUIG8aHN4YGtdATrtT3ZwMSMymF+KGzM9kG3MIli0f8HqKSWOdXYL62StDXwVeTu m4wbCk1GSUVrZepf7l+K6cBc9CZTAu6GEer4gm4Ph2Qez6pnUBiS1Db+kFRswPNun7ihmiw4 TF6s3izuPvEOugHVnS564vFptjyxlTNicEApUcPsu3+IvYiFkJudTEHHYSyJNQ0/RKELJwOB eK8PKE+peEivJWTECNGBJZCNl8CkiDQNF87BTQRWtn9kARAA4bR3/iRZ6IPOKkoKoBBpMWn0 y46RW6aJdCroc0/lYfMgTm4jRowzIapkoGEAgi+HK5HWRR02io0FoA5NFrAvVXG+bPNdmqYv 0CDRNB9Ni7bhMoAEgrTLzC+UE7ZcNSPUUyFVnhgZs8ELKbjqDuHtgfJFhpy80WX6A9W+Serm R16T/ltroRQ93Zl36VFWX2mcHP/yehxRSHQBeasYExlGxWb6OuJDrXaKJXzSK2yM8CocmVNM mFrK9AL0TCUlGQvlBIySV2mAnVsGxVnqrl+QNBnBi19NOozc3Y8hL4FjqmwtNwU8e5Ulmbh/ tcFQGqzijg9ZvJ22kShNUcUo9ezt0SW95brFj+VwepDcUwFhnBUGiAA24Iz2hl7cp6KDKQke q/IEYy1lYP1+B8UCBvfwu++1X6kVCz7Y/f7gNTyrjDGJYLNPVy/cp2Lb8Vc9OxK6DSVeRFt+ c9n3J74MMXoAM7jXIQcj/pHdc4eyhoJAtosBsTs6ROd0mlW2/iimuAg2oN1r4tUeQCBP9jk/ xwATrW10mkP6pHrUtEWCXTrFybVj9PRSauM9wCNySlq/Im7NtIBrPRcrnste+Jru/LWo51xg XMU12XvD/nq20ankvZj2V1m4DlwA4CaaCWuhPaIvJ/BvdTq5eHZbCwkaJQwCMWmKKr/N4QJt OdF4eeMOqscAEQEAAcLBXwQYAQIACQUCVrZ/ZAIbDAAKCRB0Kz2KQSuP4WHOD/4qsPq/eAMj vvzAM6GZniK48UDgyLghdA3zr0YmeZDipGcCJu46WHpKGeoR1pSZBloiO9N/oiVjoV8ll+uZ bxGYlKH5muKGZd33Yfo8AGeI9mSGGTMSbL1UjSvDuf/njL2NIlIQVXzRoOp9W46HECNpq4bT 7yFW0PhqKYEwirHJ3iKy+gBrmzakLP8FFJaFsPND5SQU/tiMLZqFBkK/DtsgA6t8/LJAOz7u TGpSbSUKlYZAvDv4rFrhe21BTCkMn2jKoiIzcNreqd7LhWLvGnYTsju1g7LfOZaUvR6Ump5P YLzClzCN7aFHNQMBc/n1B20/8jfKAGPK08KrSn4l9zpgpzp9WgH7pCYRYcGBBoy2kE7PikIR zEP8tG+UPUZryQyrJYMk3qz55d5OaC4frK++uX9IiBSctMoV7bcXEX1gDuVyw3XAGPjyKyWo 1IDmZ4wm6lnmgpifKeyq0M8WxqLyFb6Uw8qtDyqSbryDEqMxL9ssiPvwNQ0WWdMj4au8Oo9/ eetY2D79k+Fhctiy7+kVT2YsYtXXfQdjhW2dGWtG2Jp1YlUd4LHjtwWgoc23MMEc8uGJjyCw pWBTojteGRB6FJM2jeY4PGDQC5I0ford1j+m4A/9sAMu+c14YeYYeyDEXc+t820g1HNKIW65 01PoJ9qVY82qFyqfZPMpvJBzTQ==
- Content-language: en-GB
- Delivered-to: dclug@xxxxxxxxxxxxxxxxxxxxx
- Dkim-signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=dcglug.org.uk; s=1586423162; h=Sender:Content-Transfer-Encoding: Content-Type:Reply-To:List-Subscribe:List-Help:List-Post:List-Unsubscribe: List-Id:Subject:In-Reply-To:MIME-Version:Date:Message-ID:From:References:To: Cc:Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Owner:List-Archive; bh=NHmezFIwFJasxRiK3Vi3iZcVFxuhN8IuPieXsogN+fM=; b=bu8HAihByEgRopsIolgqCD3/VH Lb9CBuBUtXBlLzCN8dkakgqpJKxsL+wR8iQYr4PuZsNcaOm2OXt3wo84s8WR1VgqGA/Vs/J3vlCSo xDXXLGaDzQ+uVpxH81ZqBjIxUTZUPljTCfolLfOP3l23BCBKI2kKuLSJkgrdBJUnp7Hk=;
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:autocrypt:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=OqJ/NmMPXkEOfUbfXAu3Y81sOUNkutgxks4jyfZJf8Q=; b=fgsX34CFM2U5IbQl4yzSYn3EgAreoLYB8EH1rI/k2SIAfhWTY+aYE4OTEAr/Gt2VcH bIj9o1DSx29x7tfP2Yq21g2ydyLk4W2lymrrDQATzQBHLL4Djk0qZfK/KF3P7EkEXqNA nuNqpFLcGbUN+E3+AXvS1aG5WqUXme9JzyqRbrpaILPz0AZtPFCkeOmli2WEbiMR59rc EE3hnBHC6u4M5BsvxgON4k6GLUvrPZWjumt2IcnkZScMe65fyJFkkyidWTm0HTM/tytP mWYZKbFeKDRn4ZwqPVbTrShfDHSSImN0W9OSUbqoh/Z0d9PCb4y1gYYZxDFV0DszDq2J jjdw==
On 23/04/2020 15:25, Tom via list wrote:
> A freind of mine is an archaeologist and pointed me to a lot of free
> data from a long term excavation and it comes in the form of CSV files
> and some pdf docs that describe the structure of the real DB and I
> thought I might just have a play with them in LibreOffice Base. OK so
> you cant read a CSV file in to a table, so I think I'll write macro to
> do it and use a dialog to read in the file location, extract the column
> titles from the first line and do some scanning to ascertain the column
> type etc etc.
>
> OK so I cant find a filefinder dialog to get me to the file and all the
> online help points nowhere! I'm not sure anyone else has ever used Base
> in anger as I can find no useful documentation on the LO site. Have any
> of you got any links to LibreOffice stuff that might help me? I'm on LTS
> Xubuntu 18.03 and Libre Office Version: 6.0.7.3. I have a mind to keep
> kicking this until I can do stuff on Base I could do in access 35 years
> ago!
>
> Tom te tom te tom
>
>
Never used Base in anger, or otherwise.
--
regards
Eion MacDonald
--
The Mailing List for the Devon & Cornwall LUG
https://mailman.dcglug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq