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

[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 sorts
the entries and extracts the "last date" for a piece ID provided on the
first sheet. I am using a French locale, so you may need to change the date
formats to yours to make the date display work.

If the upload link does not work, I will send the file directly to your
personal e-mail.

I hope this helps.

Rémy.
DateSorting.ods

  



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 for details.

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 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'::text,
> now()) NOT NULL
> );
>
> In LibreOffice I created a form containing these elements, and set the
> property “Input required” on the “Data” tab to “No” for all of them.
>
> Using LibreOffice 6.0.6.2 (Build-ID: 1:6.0.6-0ubuntu0.18.04.1) coming with
> Ubuntu 18.04, this works just fine, in particular it is /not/ necessary to
> enter a value for “id” (marked “” in the form) or for “modtime”.
>
> However, using the official package (Version 6.1.2.1; Build ID:
> 65905a128db06ba48db947242809d14d3f9a93fe) the form is broken.  When I do
> not enter anything in the “modtime” entry, LibreOffice rejects adding a new
> record: a popup is shown, reading
>
> 
> Error writing data to database
> Input required in field 'modtime'. Please enter a value.
> 
>
> which is obviously wrong.
>
> It looks as if LibreOffice 6.1.2 ignores the “Input required” property
> (Actually, in the more complex real project, LibreOffice 6.1.2 requires
> input for columns which are /not/ defined as “NOT NULL” *and* have “Input
> required” set to “No”, but it seems to be harder to reproduce it in a
> minimalistic example).
>
> Did I miss something in the configuration (what?), or is this a bug?
>
> Thanks in advance,
> Albrecht.
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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'::text, now()) 
NOT NULL
);

In LibreOffice I created a form containing these elements, and set the property 
“Input required” on the “Data” tab to “No” for all of them.

Using LibreOffice 6.0.6.2 (Build-ID: 1:6.0.6-0ubuntu0.18.04.1) coming with Ubuntu 
18.04, this works just fine, in particular it is /not/ necessary to enter a value for 
“id” (marked “” in the form) or for “modtime”.

However, using the official package (Version 6.1.2.1; Build ID: 
65905a128db06ba48db947242809d14d3f9a93fe) the form is broken.  When I do not 
enter anything in the “modtime” entry, LibreOffice rejects adding a new record: 
a popup is shown, reading


Error writing data to database
Input required in field 'modtime'. Please enter a value.


which is obviously wrong.

It looks as if LibreOffice 6.1.2 ignores the “Input required” property 
(Actually, in the more complex real project, LibreOffice 6.1.2 requires input 
for columns which are /not/ defined as “NOT NULL” *and* have “Input required” 
set to “No”, but it seems to be harder to reproduce it in a minimalistic 
example).

Did I miss something in the configuration (what?), or is this a bug?

Thanks in advance,
Albrecht.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 with their equivalents. I want to look up the value find the 
equivalent from the second sheet and enter it in the adjacent column. 
Cannot use VLOOKUP ...


Er, you probably can ...


... because the value is not in first column.


I'm not sure what you are thinking of when you say "first column" here!


What is best way forward please?


First, there is no restriction in all this for anything to be in the 
first column in the sense of column A of any sheet: your material can be 
anywhere. Secondly, the only restriction in the use of VLOOKUP() is that 
the column in which you are searching for a match should be to the left 
of the column containing the corresponding value you wish to harvest - 
and not even necessarily adjacent. In your case, that means that your 
two-column table on the second sheet needs to have its values on the 
left and the equivalents to the right - very probably what you would 
arrange naturally anyway.


If your (second sheet) table was part of the spreadsheet's printed 
output and you specifically wanted the columns in the other order (which 
is perhaps unlikely), you could always make a copy in the other order of 
columns somewhere out of your print range and use that for the VLOOKUP() 
search. By "copy", I mean a dynamic one using formulae, of course, not 
just a dump of the current values of the data.


I trust this helps.

Brian Barker



Hi Brian,
I am struggling here because I get an Err:502 but all looks OK with the 
VLOOKUP.  BTW How on earth can I just copy and paste the formula so I 
can copy it here?  It becomes highlighted in black and I cannot right 
click to copy.


Could my problem be that the values I am looking up are not unique but 
can be one of several values I am looking up in order to find the substitue?


---
This email has been checked for viruses by AVG.
https://www.avg.com


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy