[libreoffice-users] Re: How to get max date < today from list

2018-10-08 Thread remygauthier
Hello, After considering your question, I think my answer was a bit insufficient. I have attached a file to this post which does what I think you want. The first sheet contains a list of items with a date that should correlate to your music number/date sang, in no particular order. The second page

Re: [libreoffice-users] [Base] PostgreSQL column w/ default value & Forms: broken in 6.1.2

2018-10-08 Thread Albrecht Dreß
Thanks for the pointer, looking forward to the new version! Best, Albrecht. Am 08.10.18 20:03 schrieb(en) Drew Jensen: Howdy, Yes that was reported and the issue has been resolved in the coding. Next releases will include the fix. See https://bugs.documentfoundation.org/show_bug.cgi?id=120245

Re: [libreoffice-users] [Base] PostgreSQL column w/ default value & Forms: broken in 6.1.2

2018-10-08 Thread Drew Jensen
Howdy, Yes that was reported and the issue has been resolved in the coding. Next releases will include the fix. See https://bugs.documentfoundation.org/show_bug.cgi?id=120245 for details. Best wishes, Drew On Mon, Oct 8, 2018 at 1:32 PM Albrecht Dreß wrote: > Hi all, > > I use LibreOffice as

[libreoffice-users] [Base] PostgreSQL column w/ default value & Forms: broken in 6.1.2

2018-10-08 Thread Albrecht Dreß
Hi all, I use LibreOffice as frontend for a PostgreSQL 10.5 database, using the native (*not* JDBC) driver. The minimum way to reproduce the issue is a table like CREATE TABLE tab1 ( id bigserial PRIMARY KEY, value text, modtime timestamp without time zone DEFAULT timezone('utc'::t

Re: [libreoffice-users] Looking up value, finding substitution and entering

2018-10-08 Thread Budge
On 05/10/2018 15:53, Brian Barker wrote: At 11:40 05/10/2018 +0100, Budge Noname wrote: I have a value in a column (which is not the first column,) ... What does it matter which column it is in? (Answer: it doesn't.) ... in the first sheet and second sheet with a two column table of values w