[libreoffice-users] Re: libreoffice base/postgres - null columns with trigger/default values
kjo...@o2.pl (Kamil Jońca) writes: > Drew Jensen writes: > [...] > > > https://bugs.documentfoundation.org/show_bug.cgi?id=120245 > > Today I upgraded my debian packages and in: Version: 1:6.1.3~rc1-1 there is no mentioned bug. Thank you! KJ -- http://stopstopnop.pl/stop_stopnop.pl_o_nas.html Jak ktoś ma pecha, to złamie ząb podczas seksu oralnego (S.Sokół) -- 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
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
[libreoffice-users] Re: libreoffice base/postgres - null columns with trigger/default values
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
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] libreoffice base/postgres - null columns with trigger/default values
(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
[libreoffice-users] Re: mimetype=text/csv opened in writer
Cley Faye writes: > 2015-09-16 10:50 GMT+02:00 Kamil Jońca : > >> Are there any rules which decide "this csv is to open with writer, and >> that by calc?" >> > > On what OS ? Linux + XFCE > At least on Windows and most Linux, it' the OS that decide what application > is used to open a file. On Linux it's mostly driven by mime types, while on > Windows the filename extension play a major role. > As far as I know, after installation, LibreOffice will not register itself > to handle different file types. > For example, on one of my installation (Debian Linux with KDE), the > text/csv file type is associated with, in that order, LOCalc, some basic > text editors, LOWriter, some file viewers. LibreOffice have no saying in > this. I understand. So now question is why some CSV files are open by calc, while the others by Writer. > To help, it would be useful to know more about your system, and if you did > install/uninstall software recently that might have caused this behavior. > In any case, the fix most likely lies in the system configuration. Nothing were installed recently, but I could change something accidentally. KJ -- http://wolnelektury.pl/wesprzyj/teraz/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: mimetype=text/csv opened in writer
Andreas Säger writes: > Am 16.09.2015 um 09:04 schrieb Kamil Jońca: >> >> I have strange problem since about two days. >> I have to open a lot of csv files from WWW (with firefox) , these files >> going with >> mimetype=text/csv about two days they started in writer instead in >> calc. >> I change nothing (at least intentionally ) but I may click something >> accidentally. >> What to check? firefox options? libreoffice options? >> KJ >> > > firefox options I'm afraid not. New facts: some local csv files are opened by writer also. I don't know why. Are there any rules which decide "this csv is to open with writer, and that by calc?" KJ -- http://stopstopnop.pl/stop_stopnop.pl_o_nas.html The more the merrier. -- John Heywood -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] mimetype=text/csv opened in writer
I have strange problem since about two days. I have to open a lot of csv files from WWW (with firefox) , these files going with mimetype=text/csv about two days they started in writer instead in calc. I change nothing (at least intentionally ) but I may click something accidentally. What to check? firefox options? libreoffice options? KJ -- http://stopstopnop.pl/stop_stopnop.pl_o_nas.html "Spock, did you see the looks on their faces?" "Yes, Captain, a sort of vacant contentment." -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc - no grid lines in spreadsheet
Stefan Weigel writes: > Hi, > > Am 04.11.2011 15:08, schrieb Kamil Jońca: > >> I have strange problem - cannot see grid lines in most of my >> spreadsheets. >> Cannot turn on them via button "Toggle Grid lines for current sheet" nor >> via Tools->Options -> LibreOffice.Calc -> View > > There is a new feature in Calc (for better MS Excel compatibility): > > Grid lines are visually "behind" the cells. So, If you have a > coloured background in your cells, the grid lines are hidden behind > them. You can either set your cell background to "No Fill" or you > can use cell borders. Yes, it works that way. (Although I think, that proper "compatibility option" would be better ;) ). Thanks. KJ -- http://blogdebart.pl/2010/03/17/dalsze-przygody-swinki-w-new-jersey/ Nie przerywaj mi, kiedy ja przerywam --W.Churchill -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Calc - no grid lines in spreadsheet
I have strange problem - cannot see grid lines in most of my spreadsheets. Cannot turn on them via button "Toggle Grid lines for current sheet" nor via Tools->Options -> LibreOffice.Calc -> View Any ideas? KJ -- http://modnebzdury.wordpress.com/2009/10/01/niewiarygodny-list-prof-majewskiej-wprowadzenie/ "In order to form an immaculate member of a flock of sheep one must, above all, be a sheep" - Albert Einstein -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted