Article View: dk.edb.mac
Article #59Re: LibreOffice Base (Var: Mangler jeg RAM?)
From: Per Rønne
Date: Mon, 23 Jan 2012 08:37
Date: Mon, 23 Jan 2012 08:37
27 lines
3036 bytes
3036 bytes
Kurt Hansen <kurt@ugyldig.invalid> wrote: > Den 22/01/12 12.34, Per R�nne skrev: > > Kurt Hansen<kurt@ugyldig.invalid> wrote: > > > >> Sammenligning/betinget formattering bruger jeg f.eks. hvor jeg har to > >> ark med de samme data med 14 dages mellemrum. S� sammenligner jeg > >> EAN-kolonnerne med hverandre for at se hvilke der er kommet til siden > >> sidst. I praksis g�r jeg det, at jeg kopierer kolonnen fra ark2 over i > >> ark1, da jeg ikke kan finde ud af at k�re betinget formattering mellem > >> forskellige ark. > > > > Det virker for mig temmelig omst�ndigt ;-(. > > Det er det ogs�, men jeg kender ikke andre metoder. Metoden er at k�re Excel-databasen over i en rigtig database. Og her kan du jo fra starten n�jes med en flad tabel. Som den du allerede har. Er der tale om en SQL-database, som i dag vel n�rmest er standard, kan du altid lave det hele om til en ikke-flad base ved s�ninger som �create table <name> as select distinct <field-list> from <table-name> where <conditions>�. -- Per Erik R�nne http://www.RQNNE.dk Errare humanum est, sed in errore perseverare turpe
Technical Details
Message-ID:
<1kebfvs.h0pliu1o4cyl8N%per@RQNNE.invalid>Path:
arc1-ca.pugleaf.net!lh20ni214253pbb.0!nntp.google.com!news1.google.com!eweka.nl!feeder.eweka.nl!feeder.erje.net!newsfeed.datemas.de!news.datemas.de!perReferences:
<4f1a4374$0$4888$c3e8da3$40cdd511@news.astraweb.com> <1ke9dwp.1svsnymo9k9kwN%per@RQNNE.invalid> <4f1bb074$0$19518$c3e8da3$efbdef2c@news.astraweb.com> <1ke9hsy.cspntkk1p26cN%per@RQNNE.invalid> <1ke9jbn.1l2zv1dv63kj7N%per@RQNNE.invalid> <1ke9jp5.1p7w0nr4ic0j2N%per@RQNNE.invalid> <4f1bd407$0$2529$c3e8da3$4e334b76@news.astraweb.com> <1ke9uel.yxzh53ffk8kuN%per@RQNNE.invalid> <4f1c1d69$0$19067$c3e8da3$6d1d8cbd@news.astraweb.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 113201,c60719c679f48243
X-Google-NewGroupId: yes
X-Google-Thread: fcdf9,fa7ee80cd03e4888
X-Google-NewGroupId: yes
X-Google-Attributes: gidc2189c6bd6,gid5233a24ee9,domainid0,public,usenet
X-Google-Language: DANISH,ASCII
Received: by 10.68.74.201 with SMTP id w9mr4815340pbv.0.1327307849383;
Mon, 23 Jan 2012 00:37:29 -0800 (PST)
Path: arc1-ca.pugleaf.net!lh20ni214253pbb.0!nntp.google.com!news1.google.com!eweka.nl!feeder.eweka.nl!feeder.erje.net!newsfeed.datemas.de!news.datemas.de!per
From: per@RQNNE.invalid (Per Rønne)
Newsgroups: dk.edb.mac,dk.edb.database
Subject: Re: LibreOffice Base (Var: Mangler jeg RAM?)
Date: Mon, 23 Jan 2012 09:37:28 +0100
Organization: Datemas.de http://www.news.datemas.de
Lines: 27
Message-ID: <1kebfvs.h0pliu1o4cyl8N%per@RQNNE.invalid>
References: <4f1a4374$0$4888$c3e8da3$40cdd511@news.astraweb.com> <1ke9dwp.1svsnymo9k9kwN%per@RQNNE.invalid> <4f1bb074$0$19518$c3e8da3$efbdef2c@news.astraweb.com> <1ke9hsy.cspntkk1p26cN%per@RQNNE.invalid> <1ke9jbn.1l2zv1dv63kj7N%per@RQNNE.invalid> <1ke9jp5.1p7w0nr4ic0j2N%per@RQNNE.invalid> <4f1bd407$0$2529$c3e8da3$4e334b76@news.astraweb.com> <1ke9uel.yxzh53ffk8kuN%per@RQNNE.invalid> <4f1c1d69$0$19067$c3e8da3$6d1d8cbd@news.astraweb.com>
Reply-To: spam@RQNNE.dk (Per Rønne)
Mime-Version: 1.0
X-Trace: news.datemas.de UqcMC5NUKL1vVAA9ntdPLtQVnyXqcQz3kxvnvUH87CvwSzsjCEenwWlBlWF8uRSvKlaCJG8n7tnjW2BwcK/jxjp3Mn9UJbfKzmns6pNHKCSBJ6Tbt9bg38oC3RarY8AlZr7KhkikHH1zK89OCZkIAXhy7xSjUxJi
X-Complaints-To: abuse@datemas.de
NNTP-Posting-Date: Mon, 23 Jan 2012 08:37:28 +0000 (UTC)
X-Face: -Ec]fH;)|5`=g?&$Zh-)dV|x:w#VG#S}<SEgcEV6v%v]1l'"v<nAf{BR\-}QF
/>C@|s&Og$a~PWByK#FcE"c1eV]<oBYWgsvFx)X.1IV=wcC9^!onQ4M8ewM
User-Agent: MacSOUP/2.8.3 (Mac OS X version 10.7.2 (x86))
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit