[libreoffice-users] BASE : How add data without primary key

2013-07-15 Thread Jean Milot
Hello, I search to use some tables from Access so i want to copy all data in base ( i don't want to connect to the access db). How i can add data without create a primary key ? Thanks. Sincerely, Jean Milot -- MILOT Jean Tél. : 0659514624 milot.j...@gmail.com -- To unsubscribe e-mail to:

Re: [libreoffice-users] BASE : How add data without primary key

2013-07-15 Thread Regina Henschel
Hi Jean, Jean Milot schrieb: Hello, I search to use some tables from Access so i want to copy all data in base ( i don't want to connect to the access db). How i can add data without create a primary key ? Why do you want to avoid using a primary key? Do you know the database tutorial? See

Re: [libreoffice-users] BASE : How add data without primary key

2013-07-15 Thread Jean Milot
Hi, I want save my time. I don't want modify all the tables. I have a mdb file, so i need already to create all the form so i f i can use all the table without modifications. Thanks Sincerely, Jean 2013/7/15 Regina Henschel rb.hensc...@t-online.de Hi Jean, Jean Milot schrieb: Hello,

Re: [libreoffice-users] BASE : How add data without primary key

2013-07-15 Thread Regina Henschel
Hi Jean, Jean Milot schrieb: Hi, I want save my time. Setting the primary key on table import is 1 click. Avoiding it does not save time, but produces trouble. I don't want modify all the tables. ?? I thought you want to write data? I have a mdb file, so i need already to create all

[libreoffice-users] Pull-down styles menu

2013-07-15 Thread Séamas Ó Brógáin
My version of Libre Office (4.0.2.2) on GNU/Linux (Ubuntu 13.04) has a feature that I decidedly don’t want: illustrating the styles in the pull-down style menu in the actual typeface and size (some huge, some tiny). I’ve searched everywhere for the option of turning it off, but with no success.

Re: [libreoffice-users] BASE : How add data without primary key

2013-07-15 Thread Jean Milot
Hi, In the mdb file, i have a lot of forms ... I haven't make this file and we will use only libreoffice not MS Office. Thanks. Sincerely, Jean 2013/7/15 Regina Henschel rb.hensc...@t-online.de Hi Jean, Jean Milot schrieb: Hi, I want save my time. Setting the primary key on

Re: [libreoffice-users] BASE : How add data without primary key

2013-07-15 Thread Wolfgang Keller
I want save my time. Not defining a primary key *will* cost you a *lot* of time. In fact it's such a sick idea not to define one that sane RDBMSs don't even allow it. Sincerely, Wolfgang -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] BASE : How add data without primary key

2013-07-15 Thread Toki Kantoor
On 07/15/2013 11:26 AM, Wolfgang Keller wrote: In fact it's such a sick idea not to define one that sane RDBMSs don't even allow it. What else would you expect from The Jet Database Engine? jonathon -- LibreOffice in a Multi-Lingual Environment. -- To unsubscribe e-mail to:

Re: [libreoffice-users] Benford's Law

2013-07-15 Thread Toki Kantoor
On 07/14/2013 09:54 PM, Dennis E. Hamilton wrote: However, Benford's law is about the *first* digit of a wide variety of numbers. First three digits, not first digit. The fourth and subsequent digits should be uniformly distributed. jonathon -- LibreOffice in a Multi-Lingual Environment.

Re: [libreoffice-users] Benford's Law

2013-07-15 Thread Brian Barker
At 12:26 15/07/2013 +, Toki Jonathan Kantoor wrote: On 07/14/2013 09:54 PM, Dennis E. Hamilton wrote: However, Benford's law is about the *first* digit of a wide variety of numbers. First three digits, not first digit. The fourth and subsequent digits should be uniformly distributed.

[libreoffice-users] Re: [Libreoffice-qa] QA Triage Contest

2013-07-15 Thread Bjoern Michaelsen
On Thu, Jul 11, 2013 at 06:36:29PM +0200, Nino Novak wrote: can we see the effect graphically? https://bugs.freedesktop.org/reports.cgi?product=LibreOfficedatasets=UNCONFIRMED Best, Bjoern -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: Macros in templates

2013-07-15 Thread Tom Davies
Hi :) Any chance of adding a comment to the bug-report so that the devs know it still exists?  Regards from Tom :) From: Mindaugas minda...@freemail.lt To: users@global.libreoffice.org Sent: Sunday, 14 July 2013, 18:50 Subject: [libreoffice-users] Re:

Re: [libreoffice-users] Visible currency rounding

2013-07-15 Thread Tom Davies
Hi :) I think the equation is unnecessarily over-complicated?  Surely it should just be something like K50 = Sum of the price of all products  ? K51 = Round (Tax)  ? Total to pay = K50 + K51 or maybe do an extra round just to make completely sure Total to pay = Round (K50 + K51) So, in

Re: [libreoffice-users] HSLQLDB syntax

2013-07-15 Thread anne-ology
And just what is HSLQLDB ;-) oh, memorizing acronyms seems to me a mighty complicated way to organize one's thoughts ... wouldn't it be simpler - easier - to just state the object(s) rather than leaving the listener trying to interpret what's being meant by what's

[libreoffice-users] Re: QA Triage Contest

2013-07-15 Thread Nino Novak
Am 15.07.2013 13:40, schrieb Bjoern Michaelsen: On Thu, Jul 11, 2013 at 06:36:29PM +0200, Nino Novak wrote: can we see the effect graphically? https://bugs.freedesktop.org/reports.cgi?product=LibreOfficedatasets=UNCONFIRMED Yep, nice - thanks :) Though, a significant decline seems to have

Re: [libreoffice-users] HSLQLDB syntax

2013-07-15 Thread Tom Davies
Hi :) My guess is that he meant H Sql Db SQL = the standard language used by most database programs.  Most add a little bit (few extra commands and stuff) to the basic language to help ensure that people can't easily switch to another program even though they all ostensibly use Sql.  Db =

Re: [libreoffice-users] HSLQLDB syntax

2013-07-15 Thread Felmon Davis
On Mon, 15 Jul 2013, anne-ology wrote: And just what is HSLQLDB ;-) oh, memorizing acronyms seems to me a mighty complicated way to organize one's thoughts ... wouldn't it be simpler - easier - to just state the object(s) rather than leaving the listener trying to

RE: [libreoffice-users] HSLQLDB syntax

2013-07-15 Thread V Stuart Foote
STOP! Anne, glad you're back but seriously? HSQLDB is the short title and Web address for HyperSQL, the Java language based SQL relational database that StarOffice then Sun chose as the imbedded database for the project. Currently we include the 1.8 release, and efforts will either see that

Re: [libreoffice-users] Re: LibreOffice website security

2013-07-15 Thread Tom Davies
Hi :) I think it is a legitmate concern especially if you only have one machine to look after and therefore can't afford to do any experimentation with using different antivirus programs.  I was hoping that the chap would download the Windows version on a GnuLinux box and then run an

[libreoffice-users] Errores de certificado en la web

2013-07-15 Thread Jairo de Jesús López Ayola
Cordial saludo, Les escribo primero para felicitarlos y darle las gracias por seguir desarrollando este noble proyecto. Me permito reportarles que la página web oficial de LibreOffice me está apareciendo con errores de certificado, usando el navegador IE versión 9.0.8112.16421. Esto puede estar

Re: [libreoffice-users] Re: QA Triage Contest

2013-07-15 Thread Tom Davies
Hi :) Errr, that graph is rather confusing me.  It's good when it dips lower, right?  Although could that be bad in some way?  Does it mean less bugs being reported?  If less bugs ARE being reported then is that because of less bugs or less people using LO or less confidence in the

Re: [libreoffice-users] Errores de certificado en la web

2013-07-15 Thread Tom Davies
Hi :) So, from Spanish into English (using Quick Translate because it seems to make some amusing gaffs but is mostly fairly good) Regards, I write first to congratulate and thank you all for continuing to develop this noble project. I would report that the official website of LibreOffice is

Re: [libreoffice-users] Pull-down styles menu

2013-07-15 Thread Girvin R. Herr
Seamas, If I understand you correctly, you don't like the font preview pull-down when selecting a font in the toolbar? Have you tried: Tools - Options - Libreoffice - View And under Font Lists, uncheck Show preview of fonts This is in 3.6.6, so 4.x may be different. I tested this and unchecking

[libreoffice-users] saving as docx turned very paragraph into a page break

2013-07-15 Thread zoidicus
A 3 page resume turned into 28 pages when saving as DOCX, because almost every paragraph got turned into a page break. I've seen some posts concerning hard page breaks that can't be fully deleted (they show up if you save/load a docx format), but in my case I had only 3-4 page breaks to start

Re: [libreoffice-users] saving as docx turned very paragraph into a page break

2013-07-15 Thread Jay Lozier
Try saving as doc not docx. The older format is still read by MSO and is often less problematic. What is your OS? On Mon, 15 Jul 2013 13:50:06 -0400, zoidicus zoidi...@comcast.net wrote: A 3 page resume turned into 28 pages when saving as DOCX, because almost every paragraph got turned into

Re: [libreoffice-users] HSLQLDB syntax

2013-07-15 Thread Doug
On 7/15/2013 12:25 PM, Felmon Davis wrote: On Mon, 15 Jul 2013, anne-ology wrote: And just what is HSLQLDB ;-) This is not an acronym. It can't be pronounced as a word. (See dictionary definition in URL below.) oh, memorizing acronyms seems to me a mighty complicated way to

Re: [libreoffice-users] saving as docx turned very paragraph into a page break

2013-07-15 Thread Tom Davies
Hi :) Try Doc instead of DocX.  File - Save As ... - File Types - Microsoft Word 97/2000/XP/2003 Many companies are unaware of what format they receive as long as it opens.  MS Office 2013 and Office 365 now open Odt, the right Odt.  MS Office 2007 and 2010 opened the ancient version of Odt

Re: [libreoffice-users] HSLQLDB syntax

2013-07-15 Thread Girvin R. Herr
To keep the record straight, Stardivision's StarOffice did not use HSQLDB. Unless the name has been changed, Stardivision used the ADABASE D database engine in their StarOffice. As far as I can research, Sun dropped the proprietary Adabase D engine in favor of HSQLDB after it took over the

Re: [libreoffice-users] Re: QA Triage Contest

2013-07-15 Thread Tom Davies
Hi :) WoooH!!! That's kinda what i felt when i read about the decline starting in April.  It would be really nice to see this graph again in a few weeks when it's easier to see the impact of the QA competition.  I was trying to be very dry and play devil's advocate in my previous email but

Re: [libreoffice-users] Pull-down styles menu

2013-07-15 Thread Séamas Ó Brógáin
Hello, Girvin. No, it’s the pull-down menu of paragraph styles––beside the font names. I already have the latter de-embellished (?), but I don’t see a similar option for the former. And I’m pretty sure this is a new feature. -- To unsubscribe e-mail to:

[libreoffice-users] Re: How to insert date/time in a LibreOffice Writer text?

2013-07-15 Thread Steve
Dan Lewis elderdanlewis at gmail.com writes: On 05/20/2013 04:02 PM, Luuk wrote: On 20-05-2013 19:27, André Ricardo Silva wrote: Hi. There is a command to insert date/time in a LibreOffice Writer text? Thank you in advance. In the English version follow the menu's: Insert /

[libreoffice-users] Re: Visible currency rounding

2013-07-15 Thread Tinkerer
Tom Let me put it another way. Take the following sales: 50 items @ 1.37 VAT @20% = 68.50 VAT = 13.70 If the same items are sold separately, the VAT would be different. 1 item @ 1.37 VAT @ 20% = 0.274 for the VAT This would be rounded to 27p and 50 x 0.27 = 13.50 Rounding has caused a difference

[libreoffice-users] Re: Visible currency rounding

2013-07-15 Thread Tinkerer
Tom The post said he wanted to round everything including the tax on his invoice template. As I said earlier. He needs to go into Tools Options Calc Calculate and check the Precision as shown box. This will make all his calculations precise as displayed. ie if he sets to two decimal places then

[libreoffice-users] Re: HSLQLDB syntax

2013-07-15 Thread V Stuart Foote
Grivin, Thanks, no doubt you're correct as I admittedly did not research adoption of HSQLDB further. And that predates my use of OpenOffice. Was fighting with Sybase and Oracle products, while avoiding MS Access. Interesting history none the less :-) Stuart Girvin R. Herr wrote To keep

Re: [libreoffice-users] Re: How to insert date/time in a LibreOffice Writer text?

2013-07-15 Thread Tanstaafl
On 2013-07-15 2:25 PM, Steve sjohnson332...@gmail.com wrote: The default date acceptance pattern seems to have been M/D/Y/;M/D but that didn't work, so I changed it to //, since I want the day, month, day of the week, and year to display and that doesn't work either. It comes up

[libreoffice-users] Re: Macros in templates

2013-07-15 Thread Mindaugas
Added already Best regards Mindaugas -- View this message in context: http://nabble.documentfoundation.org/Macros-in-templates-tp4065366p4065576.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: QA Triage Contest

2013-07-15 Thread Nino Novak
Am 15.07.2013 19:18, schrieb Tom Davies: Errr, that graph is rather confusing me. It's good when it dips lower, right? Although could that be bad in some way? Does it mean less bugs being reported? That's correct, so ideally the chart should simultaneously show the # of bugs reported.

Re: [libreoffice-users] Fwd: Help for Calc Macros

2013-07-15 Thread Andrew Douglas Pitonyak
Mr. Ek, I recommend that you subscribe to the user's mailing list and ask there; Jean forwarded your request to that list already. I am responding to the list and using CC for you in case you are not already subscribed. There are numerous materials available related to macro programming,

Re: [libreoffice-users] Re: Visible currency rounding

2013-07-15 Thread Tom Davies
Hi :) Ahhh, that makes sense.  HMRC are the Vat collectors for the Uk but the Swedish one is likely to have similar rules.  Regards from Tom :)  From: Tinkerer j_taylo...@btinternet.com To: users@global.libreoffice.org Sent: Monday, 15 July 2013, 19:38

Re: [libreoffice-users] Errores de certificado en la web

2013-07-15 Thread Jairo de Jesús López Ayola
Thank you for your quick answer, y really appreciate it, So, IE8 is working fine and it starts an automatic download (i'm not sure if it has to behave like that). And What about IE9 ? It is not really a big problem to me, i can just allow the conection, but ¿what about all the other potential new

Re: [libreoffice-users] Errores de certificado en la web

2013-07-15 Thread Tom Davies
Hi :) Thanks for reporting it! :)  I don't think i have IE 9 on any machine so i can't test it myself.  Also testing on just 1 or 2 machines does not mean it always happens that way on all machines.  It really takes a larger sample.  People on this list sometimes have a quick go on their own

[libreoffice-users] Re: saving as docx turned very paragraph into a page break

2013-07-15 Thread zoidicus
As many suggested, word97 (doc) format worked well. Still had 3 page breaks but they cleaned up easily and remained gone through save/load. Thank you. Fyi, this is on win7. On Jul 15, 2013 10:58 AM, Jay Lozier [via Document Foundation Mail Archive] ml-node+s969070n4065559...@n3.nabble.com wrote:

Re: [libreoffice-users] Help for Calc Macros

2013-07-15 Thread Andrew Douglas Pitonyak
Lots of questions... On 07/15/2013 10:42 PM, Harold Ek wrote: Andrew, Thank you very much for all the information that you provided! I have scanned thru most of the references you provided, but certainly have much more studying to do. Perhaps the answers are in the info but I have a couple