[ Date Index ]
[ Thread Index ]
[ <= Previous by date /
thread ]
[ Next by date /
thread => ]
[LUG] libre office macros/dialogs
- To: list@xxxxxxxxxxxxx
- Subject: [LUG] libre office macros/dialogs
- From: Tom via list <list@xxxxxxxxxxxxx>
- Date: Thu, 23 Apr 2020 15:25:29 +0100
- Cc: Tom <madtom1999@xxxxxxxxxxxxxx>
- 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-Type: Content-Transfer-Encoding:Cc:Reply-To:From:List-Subscribe:List-Help:List-Post :List-Unsubscribe:List-Id:Subject:MIME-Version:Date:Message-ID:To:Content-ID: Content-Description:Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc :Resent-Message-ID:In-Reply-To:References:List-Owner:List-Archive; bh=0CESD7BDy0vibLCdYmwwxzavJI5CUkADyX3Qo2HvFGA=; b=4Igu8bcxb+cxbu3V/QQ/BHJwFj OmPK0YwHw8ALYWK0GDu3ScFJapdq0dU1MdSYrgc7MAdc1p+zQMgbKaWtmidGXP2C5qwOA8awfI1Sp w/8IXimRoLWX81pTJOHHBAVZ44alpwC2TukprFrKZOZXe3En4Vp8puDxiEo3ERLNAWXs=;
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=20161025; h=to:from:subject:message-id:date:user-agent:mime-version :content-transfer-encoding:content-language; bh=OonW/ypdnKzBoeUQUET51tTZZfY5/jsmcRXQRNSoVkM=; b=ZekKSuZIDPpUrwkIRlM1clIU6wa9mTyW+no/mJLwwruCTIVLQDKjtr8nK0NtGlJc/L bZ2aaH1CTqBpNxQbJOix3dQNR4kwQWa9gPwlOxaqceurlVp0Muo/njfxVloPABWBjFzd Gpjo4rFKNRftn9JmdtNoqHwSr+gRIx2y2FdBitr6J8SeFNlxzmKRnaqprpB4sMYWr5pg S5423engJaI40XwxJcCbWPfJ63OmTogN7Hj+gFHmEwj3SrXNQ+mUr/Ubzx0OgHUiZ0/e QFVRCuqtMFodl6KIpagdiPnHwmhQZhRVHTloPwPpe6raRfvEvtYnGhAZYQXJFHVRuzW5 IOuA==
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
--
The Mailing List for the Devon & Cornwall LUG
https://mailman.dcglug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq