[libreoffice-users] Re: Cannot add primary key after saving without primary key.
Le 23/10/2012 07:38, David Smith a écrit : Hi David, > Strange.. It said it was completed successfully. When I do this, I > can now see the ID column and it appears I can add records. However, > when I go into the design view for the table, there is no ID column or > primary key columns and it shows only the columns I had before. It > also throws an error when I try to put in any records. "Attempt to > insert null into non-nullable column "?".But I don't have any > columns labeled "?". > Did you restart LO (and reload the ODB file) each time you made a structural change ? > Also, there is a problem with adding auto-incrementing fields using > the design view. It just doesn't allow you to do it if the > auto-incrementing field isn't the first field in the table. With your > SQL, I now see an auto-incrementing field at the end of the table > which is pretty nice, and something I was trying to do earlier. If the behaviour you describe above is reproducible, that would be a bug. There shouldn't be AFAIK a requirement for the first field to be an autoincrementing primary key in hsqldb. > > Should I be filing bug reports? IMHO, yes. At least someone else can then test, confirm/deny. Alex -- 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] Tags in addition to Table of Contents?
In a document I have most major headings marked to that they'll appear in the Table of Contents (which is at the beginning of the document). It looks very nice. What I'd like to do is "tag" each of the major headings within the document with key words that can also be used to form a topic list so a Topic list can be created quickly from the tagged words. For example; Table of Contents (each document will have this regardless of any other tags) Cat Whiskers 1 Dog noses 3 Cat food 4 What I'd like to have created(in addition to the usual Table of Contents) Topic list (have a topic list which is created from tagged words) Length of whiskers 1 Whisker cleaners 1 Dark whiskers 5 No whiskers 6 I've tried to find "Smart Tags" extension but there is none. Any ideas or suggestions? -- www.eBookRing.net The designer and maker of the original eBookRing The perfect stand for eReaders, iPads, iPhones, tablet computers and other electronic devices. Patent Pending -- 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
Re: [libreoffice-users] Writer randomly fails to print
I am now convinced that this is bug 50784 If I change the client timeout on the CUPS server the amount of time it takes before LO stops printing exactly matches. In the end I have made my timeout 5400 which is 90 mins which since we are a school is OK. It's a bit of a nasty hack but it seems to work. M _ From: Steve Edmonds [mailto:steve.edmo...@ptglobal.com] To: Malcolm Moore [mailto:st-malcolm.mo...@whsg.info] Cc: users@global.libreoffice.org Sent: Wed, 24 Oct 2012 00:41:23 + Subject: Re: [libreoffice-users] Writer randomly fails to print Hi. Are these PCs by any chance wireless or have power saving activated. I think I saw this once on my mac when it went to sleep, powered the wireless down and when it woke up the printers were gone in LO. Can't be sure as it was a while ago. Steve On 2012-10-24 07:50, Malcolm Moore wrote: > Some more experimentation led me to believe it's not random, > it's time related I am now minded to believe it's bug 50784 > which is posted against version 3.5.2 > > I will investigate more tomorrow and if it is as I fear, and the bug > continues into 3.5.4 and 3.6.1. I will add a note to that bug report > > Many thanks to everyone > > M > >_ > > From: Steve Edmonds [mailto:steve.edmo...@ptglobal.com] > To: Malcolm Moore [mailto:st-malcolm.mo...@whsg.info] > Cc: users@global.libreoffice.org > Sent: Tue, 23 Oct 2012 18:30:06 + > Subject: Re: [libreoffice-users] Writer randomly fails to print > > >On 2012-10-24 03:59, Malcolm Moore wrote: >> _ >> >> From: Malcolm Moore [mailto:st-malcolm.mo...@whsg.info] >> To: users@global.libreoffice.org >> Cc: Jay Lozier [mailto:jsloz...@gmail.com] >> Sent: Tue, 23 Oct 2012 15:24:14 + >> Subject: Re: [libreoffice-users] Writer randomly fails to print >> >> From: Jay Lozier [mailto:jsloz...@gmail.com] >>To: users@global.libreoffice.org >>Sent: Tue, 23 Oct 2012 14:53:39 + >>Subject: Re: [libreoffice-users] Writer randomly fails to print >> >>On 10/23/2012 09:20 AM, Malcolm Moore wrote: >> > As the subject says. Occasionally users find they can't >> > print. They click print and nothing happens. If they close >> > and re-open Write and re-open the document it prints OK >> > >> > >> > This is LO 3.6.1 on openSuse 12.1. The machines are set to >> > print to a single CUPS server. >> > >> > >> > As far as I can see the CUPS server never saw the print job. >> > It doesn't matter which printer they use ( students have 12 >> > to choose from ). Once it happens you can't print to any printer >> > in the list. >> > >> > >> > If you have two copies of LO open you have to close them both >> > and re-open them and the document before it will print again. >> > >> > >> > Any ideas ? >> > >> > >> > Ta >> > >> > >> > Mal >> > >> > >> Mal >> >> Are they having problems printing from other programs? >> >> Are all the work stations reporting the problem? >> >> My thoughts are it is: >> >> 1. An bug in LO; possibly specific to openSUSE >> >> 2. A local bug in openSUSE >> >> 3. the print server has a bug >> >> I have not had any random print problems with LO using Linux Mint 13 >> with a printer directly connected via USB port. >> >> Sometimes renaming the .config/libreoffice/user/3 folder clears up a lot >> of problems. LO will regenerate a new default folder if it is missing >> when starting up. >> >> -- >> Jay Lozier >> jsloz...@gmail.com >> >> >> -- >> 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 >> >> >> >> >>I have just got my machine to stop printing! ha ! >>I have tried several other apps ( Firefox, Softmaker, Gimp ) >>and they can still all print. Calc and Impress can't. >> >> >>Mal >>-- >>For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org >>Problems? http://www.libreoffice.org/get-help/mailin
[libreoffice-users] Writer: AutoCorrect language resets and sticks to English after Japanese script is inserted
Good evening. I'm running LibreOffice 3.6.2.2 on Windows 7. My default language in LibreOffice is set to Brazilian Portuguese. When I'm typing a text in Portuguese and insert Japanese text, the AutoCorrect changes the language to the following text to English. The text that has already been typed as Portuguese remains unaffected. I am able to set the text manually back to Portuguese, but as soon as Japanese text is typed, the roman script that comes afterward is treated again as English. Is this a known problem? Do anyone know a solution or workaround that doesn't require manually changing the language every time? Thank you. - Raphael Campos -- 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