[libreoffice-users] Re: libreoffice base/postgres - null columns with trigger/default values

[Kamil Jońca]

Drew Jensen  writes:


> Best way, IMO, since you noticed it first here would be to go ahead and do
> that yourself.
> This URL assumes you have an account in the bug tracking system.
> https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice;component=Base
> If you don't have one and register then submit it you will get
> notifications as it is worked.
>
> Otherwise, if you really would rather not than one of us in the QA group
> can do it.
>


https://bugs.documentfoundation.org/show_bug.cgi?id=120245


KJ

-- 
http://stopstopnop.pl/stop_stopnop.pl_o_nas.html
I brought my BOWLING BALL -- and some DRUGS!!

-- 
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] Re: libreoffice base/postgres - null columns with trigger/default values

[Drew Jensen]

Hi,

I would not be surprised if a change in behavior happened recently, there
was some reworking of the sdbc drivers recently which I think had the
chance to touch basically all of them. NOTE: I'm not a developer of that
code but I try to follow along with the generalities through the QA group.

Given two folks seeing the same problem with the latest 6.1.2 build then
whether the postgreSQL driver should be updated for that option or needs
fixing I can't say, but the step right now is to open an issue and get it
started whichever way.

Best way, IMO, since you noticed it first here would be to go ahead and do
that yourself.
This URL assumes you have an account in the bug tracking system.
https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice;component=Base
If you don't have one and register then submit it you will get
notifications as it is worked.

Otherwise, if you really would rather not than one of us in the QA group
can do it.

Let us know.

Thanks

Drew

On Mon, Oct 1, 2018 at 12:57 PM Kamil Jońca  wrote:

> Drew Jensen  writes:
>
> > Hi,
> >
> > You would want to open an issue in the LibreOffice bug tracker and the
> > module would be Base.
> > postgreSQL should be in the summary of course.
> >
> > I know you said this form works with LibreOffice 6.1.1 rc, but I'm
> curious
> > how long it was working in your production environment. Was it working in
> > 6.0 for instance?
>
> I never have registered such probolem, and I use my "application" for
> years.
>
> KJ
>
>
> --
> http://stopstopnop.pl/stop_stopnop.pl_o_nas.html
> "I never let my schooling get in the way of my education."
> -- Mark Twain
>
> --
> 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] Re: libreoffice base/postgres - null columns with trigger/default values

[Kamil Jońca]

Drew Jensen  writes:

> Hi,
>
> You would want to open an issue in the LibreOffice bug tracker and the
> module would be Base.
> postgreSQL should be in the summary of course.
>
> I know you said this form works with LibreOffice 6.1.1 rc, but I'm curious
> how long it was working in your production environment. Was it working in
> 6.0 for instance?

I never have registered such probolem, and I use my "application" for
years.

KJ


-- 
http://stopstopnop.pl/stop_stopnop.pl_o_nas.html
"I never let my schooling get in the way of my education."
-- Mark Twain

-- 
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] Re: libreoffice base/postgres - null columns with trigger/default values

[Kamil Jońca]

Drew Jensen  writes:

> Also,
>
> In the issue be sure to show which version of PostgreSQL you are using?
>
> Thanks

--8<---cut here---start->8---
$psql
Pager usage is off.
Border style is 0.
psql (10.5 (Debian 10.5-1))
Type "help" for help.

kjonca=> select  version();
   version  
   
--
PostgreSQL 10.5 (Debian 10.5-1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 
8.2.0-3) 8.2.0, 64-bit
(1 row)

kjonca=> 

--8<---cut here---end--->8---

KJ


-- 
http://stopstopnop.pl/stop_stopnop.pl_o_nas.html
I never take work home with me; I always leave it in some bar along the way.

-- 
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] paste from calc to writer table

[Brian Barker]

At 15:28 01/10/2018 +, Gary Collins wrote:
What i'd like to do now is select part of a row of cells in calc and 
copy the contents to a corresponding part of a row of cells in a 
writer table. Can i do this?


Perhaps not directly.

It seems paste (= paste calc) inserts a text box, paste unformatted 
inserts all the format marks as characters, ...


What "format marks"? If you mean the non-printing characters, these 
should be displayed in your text document according to your current 
choice there, nothing to do with the choice of paste operation.


Do you see either HTML or "Formatted text" in the Paste Special... 
options? Either of these should paste your spreadsheet material into 
a newly created table. It is a simple task to do this into a spare 
area of your text document (or even another text document) and then 
copy from there into your existing table. You can easily delete the 
temporary table, of course.


I trust this helps.

Brian Barker


--
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] Re: Page numbering issue

[Pierre-lo]

Thank you, that was the problem !

I did not though of looking in that style.



--
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] Page numbering issue

[Remy Gauthier]

Hello,

Your «Titre 3» style has a forced page break before, with a setting of
the page number to 5. Removing the setting makes the page number
correct again. The setting is part of the style, so Display Styles
(F11) > Find «Titre 3» in the paragraph styles > Text Flow
(Enchaînements) > Unset the page number and style command.

I hope this helps.

Rémy.


Le lundi 01 octobre 2018 à 01:30 -0700, Pierre-lo a écrit :
> Hello,
> 
> I am a teacher, and I have a weird issue with one of my student's text
> document.
> We are working on page style and page numbering. I showed them how to break
> page numbering using page styles and manual page break.
> 
> However, on the following document, I don't understand why the page
> numbering breaks between pages 7, 8,9 and 14,15.
> There is no sections, no page break, no manual modification.
> 
> What am I missing ?
> 
> rapport_de_stage.odt
> 
>   
> 
> 
> 
> --
> 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] Re: libreoffice base/postgres - null columns with trigger/default values

[Drew Jensen]

BTW

Currently the native MySQL ( MariaDB) sdbc has a setting '
FormsCheckrequiredFields' which can turn that function on or off.
Checking just now the PostgreSQL sdbc code does not currently have that
option.
Yeah, that needs to go into the issue tracker for sure.

Drew

On Mon, Oct 1, 2018 at 10:50 AM Alexander Thurgood 
wrote:

> Le 01/10/2018 à 12:08, Kamil Jońca a écrit :
>
> Hi Kamil,
>
>
> >
> > I  use libreoffice with libreoffice-sdbc-postgresql driver. I do not
> > know where the bug is.
> >
> > I have simple form based on postgresql table.
> > In this table there is a column
> >
> > nametype  nullable
> default value
> > utw timestamp without time zone   not null now()
> >
> > This column does not have its field in form.
> > With package:
> >
>
> I can reproduce this with :
>
> MacOS 10.13.6
> postgres 9.5
> LibreOffice 6.1.2.1
> sdbc built-in postgres driver
>
> If I enter the data in Table data edit mode, then the date is added
> automatically.
>
> However, like you, filling in a simple form including the timestamp
> field and leaving the timestamp field blank always throws an error when
> I try to move to either a new record, or back to a previous record. What
> should happen is that the timestamp value should be generated and the
> record validated (as in Table data edit mode).
>
>
> Alex
>
>
> --
> 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] Re: libreoffice base/postgres - null columns with trigger/default values

[Alexander Thurgood]

Le 01/10/2018 à 12:08, Kamil Jońca a écrit :

Hi Kamil,


> 
> I  use libreoffice with libreoffice-sdbc-postgresql driver. I do not
> know where the bug is.
> 
> I have simple form based on postgresql table.
> In this table there is a column
> 
> nametype  nullable default 
> value
> utw timestamp without time zone   not null now()
> 
> This column does not have its field in form.
> With package:
> 

I can reproduce this with :

MacOS 10.13.6
postgres 9.5
LibreOffice 6.1.2.1
sdbc built-in postgres driver

If I enter the data in Table data edit mode, then the date is added
automatically.

However, like you, filling in a simple form including the timestamp
field and leaving the timestamp field blank always throws an error when
I try to move to either a new record, or back to a previous record. What
should happen is that the timestamp value should be generated and the
record validated (as in Table data edit mode).


Alex


-- 
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] libreoffice base/postgres - null columns with trigger/default values

[Drew Jensen]

Also,

In the issue be sure to show which version of PostgreSQL you are using?

Thanks

On Mon, Oct 1, 2018 at 8:08 AM Drew Jensen 
wrote:

> Hi,
>
> You would want to open an issue in the LibreOffice bug tracker and the
> module would be Base.
> postgreSQL should be in the summary of course.
>
> I know you said this form works with LibreOffice 6.1.1 rc, but I'm curious
> how long it was working in your production environment. Was it working in
> 6.0 for instance?
>
> Best wishes,
>
> Drew.
>
>
>
>
>
> On Mon, Oct 1, 2018 at 6:09 AM Kamil Jońca  wrote:
>
>>
>> (This is also described at
>> https://lists.debian.org/debian-user/2018/09/msg01107.html)
>>
>> I  use libreoffice with libreoffice-sdbc-postgresql driver. I do not
>> know where the bug is.
>>
>> I have simple form based on postgresql table.
>> In this table there is a column
>>
>> nametype  nullable
>> default value
>> utw timestamp without time zone   not null now()
>>
>> This column does not have its field in form.
>> With package:
>>
>> --8<---cut here---start->8---
>> Package: libreoffice-base
>> Version: 1:6.1.2-1
>> Package: libreoffice-sdbc-postgresql
>> Version: 1:6.1.2-1
>> --8<---cut here---end--->8---
>>
>> I cannot save filled form to database, because
>> "required utw field has no value"
>>
>> When I drop "not null" from column, and restart libreoffice - form could
>> be saved to database.
>>
>> When I tried with version: 1:6.1.1~rc1-2 of libreoffice packages its
>> works as expected.
>>
>> Should I fill a bug? On debian's page or here? Aginst which
>> package/module?
>> KJ
>>
>>
>>
>> --
>> http://stopstopnop.pl/stop_stopnop.pl_o_nas.html
>> Three may keep a secret, if two of them are dead.
>> -- Benjamin Franklin
>>
>> --
>> 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] Page numbering issue

[Pierre-lo]

Hello,

I am a teacher, and I have a weird issue with one of my student's text
document.
We are working on page style and page numbering. I showed them how to break
page numbering using page styles and manual page break.

However, on the following document, I don't understand why the page
numbering breaks between pages 7, 8,9 and 14,15.
There is no sections, no page break, no manual modification.

What am I missing ?

rapport_de_stage.odt

  



--
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