[libreoffice-users] BASE : How add data without primary key
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: 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
Re: [libreoffice-users] BASE : How add data without primary key
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 LibreOffice Base Handbook on https://wiki.documentfoundation.org/Documentation/Publications Kind regards Regina -- 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
Re: [libreoffice-users] BASE : How add data without primary key
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, 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 LibreOffice Base Handbook on https://wiki.**documentfoundation.org/**Documentation/Publicationshttps://wiki.documentfoundation.org/Documentation/Publications Kind regards Regina -- To unsubscribe e-mail to: users+unsubscribe@global.**libreoffice.orgusers%2bunsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- MILOT Jean Tél. : 0659514624 milot.j...@gmail.com -- 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
Re: [libreoffice-users] BASE : How add data without primary key
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 the form so i f i can use all the table without modifications. If you will keep the mdb file untouched, you can do this: (1) Make a copy of the mdb file and connect to this copy. (2) Connect to the mdb file and then drag the table to a new database using the embedded hsqldb. (3) Export the access table into Excel format and use it in Calc or import it to a new hsqldb. (4) Export the access table into dBase format and connect to this dBase table. (5) Export the access table into a csv table and use this as text table in hsqldb (requires SQL). You need to tell in more details what you really want to do and why you do not simple connect to the mdb file, see option (1). Kind regards Regina -- 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] Pull-down styles menu
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. Any hints gratefully received. -- 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
Re: [libreoffice-users] BASE : How add data without primary key
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 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 the form so i f i can use all the table without modifications. If you will keep the mdb file untouched, you can do this: (1) Make a copy of the mdb file and connect to this copy. (2) Connect to the mdb file and then drag the table to a new database using the embedded hsqldb. (3) Export the access table into Excel format and use it in Calc or import it to a new hsqldb. (4) Export the access table into dBase format and connect to this dBase table. (5) Export the access table into a csv table and use this as text table in hsqldb (requires SQL). You need to tell in more details what you really want to do and why you do not simple connect to the mdb file, see option (1). Kind regards Regina -- To unsubscribe e-mail to: users+unsubscribe@global.**libreoffice.orgusers%2bunsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- MILOT Jean Tél. : 0659514624 milot.j...@gmail.com -- 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
Re: [libreoffice-users] BASE : How add data without primary key
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? 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] BASE : How add data without primary key
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: 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
Re: [libreoffice-users] Benford's Law
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. -- 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
Re: [libreoffice-users] Benford's Law
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. The striking thing about variates that follow Benford's Law is indeed that the initial digits are not equally distributed. But such variates don't stop being what they are after some arbitrary number of significant figures - whether it be one, three, or any other. The values come from the distribution - so all their decimal digits are part of the story. If you want values that follow Benford's Law up to three digits, you can easily take the true values from my suggested formula, truncate (or round?) them after three digits, and add further random digits selected from a uniform distribution. But I'm not at all sure why you would want to do this. Does the source of this suggestion mean merely that, although the early digits are not uniformly distributed, later ones are more nearly so - and that there is little point in worrying about the difference after, say, three digits? If so, there is equally no point in worrying that these later digits might be too right! Brian Barker -- 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: [Libreoffice-qa] QA Triage Contest
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? 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] Re: Macros in templates
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: Macros in templates It's a bug (https://bugs.freedesktop.org/show_bug.cgi?id=60883). It's a pity but it still exists in 4.1 RC2. Best regards Mindaugas -- View this message in context: http://nabble.documentfoundation.org/Macros-in-templates-tp4065366p4065403.html Sent from the Users mailing list archive at Nabble.com. -- 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 -- 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
Re: [libreoffice-users] Visible currency rounding
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 Swedish K51 = HELTAL (Tax) ? Total to pay = HELTAL (K50 + K51) The trickiest bit should be the Tax calculation which is surely just Tax = K50 x Vat% Assuming none of the products is exempt from Vat or rated at a different Vat%! In England i think we have to truncate instead of Round. So K51 = AVKORTA ( K50 x Vat% ) but even if you do have to do that in Sweden the final figure should still be rounded Total to pay = Round (K50 + K51) Regards from Tom :) From: Marino / WellnessWebshop.se mar...@wellnesswebshop.se To: users@global.libreoffice.org Sent: Sunday, 14 July 2013, 8:11 Subject: [libreoffice-users] Visible currency rounding Hi! I want to have visible currency rounding on an invoice template that I have made i Libre Office. I have this formula in the cell for currency rounding: =OM(HELTAL(K50+K51)-(K50+K51)-0,5;AVKORTA(HELTAL(K50+K51)-(K50+K51);3);AVKORTA(HELTAL((K50+K51)+1)-(K50+K51);2)) But something is wrong, sometimes there is a diff of 0,01 in the sum. Perhaps there is a better formula for this? My invoice looks like this, on the bottom rows: - Sum for all products on invoice - Tax - Currency rounding - Sum to pay Best regards, Marino -- 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 -- 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
Re: [libreoffice-users] HSLQLDB syntax
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 being said ;-) see - http://www.merriam-webster.com/dictionary/acronym AND - did you happen to notice in that URL, this phenomenon only started in 1943 ;-) before then communication was simply speaking to be understood ;-) BTW - many of these acronyms are duplicated - which causes even more confusion to the listener ;-) On Sat, Jul 13, 2013 at 1:07 PM, Mark LaPierre marklap...@aol.com wrote: On 07/13/2013 05:36 AM, Alexander Thurgood wrote: HSLQLDB is a bit picky about the syntax Does anyone know where I can find a good reference on HSLQLDB syntax? -- _ °v° /(_)\ ^ ^ Mark LaPierre Registered Linux user No #267004 https://linuxcounter.net/ -- 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: QA Triage Contest
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 started in April already. Keep on! Nino -- 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
Re: [libreoffice-users] HSLQLDB syntax
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 = Database H is the only bit that distinguishes exactly which program is being talked about. Note that other programs also use Sql or Db in their name. For example MySql/MariaDb, Postgresql. Only Access doesn't have any of that in it's name. Of course MS make many claims that Access does use Sql but it's such a heavily tweaked version of Sql that it's almost unrecognisable. If you learn Access then you need to forgetre-learn if you want to switch to anything else. The others tend to just have a few differences so it's not so tough to move between them. At least, so i have heard. Regards from Tom :) From: anne-ology lagin...@gmail.com To: Mark LaPierre marklap...@aol.com Cc: Mail List LibreOffice users@global.libreoffice.org Sent: Monday, 15 July 2013, 16:38 Subject: Re: [libreoffice-users] HSLQLDB syntax 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 being said ;-) see - http://www.merriam-webster.com/dictionary/acronym AND - did you happen to notice in that URL, this phenomenon only started in 1943 ;-) before then communication was simply speaking to be understood ;-) BTW - many of these acronyms are duplicated - which causes even more confusion to the listener ;-) On Sat, Jul 13, 2013 at 1:07 PM, Mark LaPierre marklap...@aol.com wrote: On 07/13/2013 05:36 AM, Alexander Thurgood wrote: HSLQLDB is a bit picky about the syntax Does anyone know where I can find a good reference on HSLQLDB syntax? -- _ °v° /(_)\ ^ ^ Mark LaPierre Registered Linux user No #267004 https://linuxcounter.net/ -- 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 -- 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
Re: [libreoffice-users] HSLQLDB syntax
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 interpret what's being meant by what's being said ;-) see - http://www.merriam-webster.com/dictionary/acronym AND - did you happen to notice in that URL, this phenomenon only started in 1943 ;-) do you know SPQR? or INRI? or Q.E.D.? before then communication was simply speaking to be understood ;-) BTW - many of these acronyms are duplicated - which causes even more confusion to the listener ;-) On Sat, Jul 13, 2013 at 1:07 PM, Mark LaPierre marklap...@aol.com wrote: On 07/13/2013 05:36 AM, Alexander Thurgood wrote: HSLQLDB is a bit picky about the syntax Does anyone know where I can find a good reference on HSLQLDB syntax? -- _ °v° /(_)\ ^ ^ Mark LaPierre Registered Linux user No #267004 https://linuxcounter.net/ -- Felmon Davis -- 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
RE: [libreoffice-users] HSLQLDB syntax
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 ripped out of LibreOffice to be replaced, or the version of HSQLDB will be upgraded to a current 2.3 release. Mark, et al., all the details you could ever want are on the project webpage at hsqldb.org, just mind the version differences. Stuart From: Tom Davies [tomdavie...@yahoo.co.uk] Sent: Monday, July 15, 2013 11:15 AM To: anne-ology; Mark LaPierre Cc: Mail List LibreOffice Subject: Re: [libreoffice-users] HSLQLDB syntax 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 = Database H is the only bit that distinguishes exactly which program is being talked about. Note that other programs also use Sql or Db in their name. For example MySql/MariaDb, Postgresql. Only Access doesn't have any of that in it's name. Of course MS make many claims that Access does use Sql but it's such a heavily tweaked version of Sql that it's almost unrecognisable. If you learn Access then you need to forgetre-learn if you want to switch to anything else. The others tend to just have a few differences so it's not so tough to move between them. At least, so i have heard. Regards from Tom :) From: anne-ology lagin...@gmail.com To: Mark LaPierre marklap...@aol.com Cc: Mail List LibreOffice users@global.libreoffice.org Sent: Monday, 15 July 2013, 16:38 Subject: Re: [libreoffice-users] HSLQLDB syntax 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 being said ;-) see - http://www.merriam-webster.com/dictionary/acronym AND - did you happen to notice in that URL, this phenomenon only started in 1943 ;-) before then communication was simply speaking to be understood ;-) BTW - many of these acronyms are duplicated - which causes even more confusion to the listener ;-) On Sat, Jul 13, 2013 at 1:07 PM, Mark LaPierre marklap...@aol.com wrote: On 07/13/2013 05:36 AM, Alexander Thurgood wrote: HSLQLDB is a bit picky about the syntax Does anyone know where I can find a good reference on HSLQLDB syntax? -- 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
Re: [libreoffice-users] Re: LibreOffice website security
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 antivirus scan using something other than Avira. He did kindly re-download but then scanned with Avira again. I've finally got around to sitting at an Xp machine and downloaded LibreOffice 4.04. The Xp machine here is running Microsoft Security Essentials and Avg. Neither complained about the LO downloads. In Firefox it did give me the bar at the top, saying Firefox prevented this page from automatically redirecting to another page. The download didn't start straight away so i clicked on the link, inside the page, that said If your download does not start automatically, please click here. Then i tried the page again and this time when the bar appeared in clicked on the Allow button to allow the page to automatically redirect to another page. This way around the download also started. I guess i should really download Avira and try the whole thing again to see if Avira complains on that Xp machine. If you don't trust your antivirus then why use it? You really have to take notice if it grumbles about something otherwise what is the point in having it? All antivirus programs have problems with false-positives but when the program grumbles you have to consider that it really might have found something. I typically try to run 2 antivirus programs on Windows but i would be stuck if one grumbled and the other didn't. Which one would i trust? Of course having any active program running all the time in the background is going to impact on performance and having 2 (that also might conflict with each other) is going to hurt even more. [shrugs] But then if people cared about the speed of their machine they wouldn't be using Windows in the first place. Regards from Tom :) From: V Stuart Foote vstuart.fo...@utsa.edu To: users@global.libreoffice.org Sent: Saturday, 13 July 2013, 18:40 Subject: [libreoffice-users] Re: LibreOffice website security Petre, As has been pointed out to you several times since last month. This is not a problem of the LibreOffice download web servers. http://nabble.documentfoundation.org/Security-Issue-td4061840.html It is likely a FALSE Positive reported by your AVIRA anti-virus packages heuristic detection routines. http://www.avira.com/en/support-threats-description/tid/4142/tlang/en Your system is probably fine, please stop spreading FUD and it would be most productive if you were to properly submit a report to AVIRA so they can verify a the TDF site is clean and correct their detection routines--especially necessary with heuristic methods. Also, as AVIRA publishes frequent updated definitions and detection routines, having raised the specter of a Malware issue it is only good etiquette to test issue is resolved and to report its resolution back to this forum. Everyone else, please let's abandon this thread pending substantive reporting back from Petre regards what AVIRA finds--and move attention to more productive discussions actually related to LibreOffice. Stuart -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-website-security-tp4061786p4065309.html Sent from the Users mailing list archive at Nabble.com. -- 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 -- 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] Errores de certificado en la web
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 impidiendo que mas gente acceda a este programa. Agradezco la atención prestada yque puedan corregir esta situación. Que tengan un feliz día, -- 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
Re: [libreoffice-users] Re: QA Triage Contest
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 bug-reporting system? (Obviously it's not because of less people because we know that LO usage is sky-rocketing) Any chance of seeing a graph of bugs that ARE confirmed? ie ones that are getting through the triage filtering process. Sorry, of course it is excellent to see the graph because it combines neatly with other graphs and pie-charts that show the issues that troubled me in the first paragraph. We can't have everything all at once. Regards from Tom :) From: Nino Novak nn.l...@kflog.org To: users@global.libreoffice.org Cc: libreoffice...@lists.freedesktop.org Sent: Monday, 15 July 2013, 17:12 Subject: [libreoffice-users] Re: QA Triage Contest 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 started in April already. Keep on! Nino -- 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 -- 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
Re: [libreoffice-users] Errores de certificado en la web
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 appearing with me certificate errors, using IE browser version 9.0.8112.16421. This may be preventing more people access to this program. yque appreciate the attention given to correct this. Have a happy day, Ok, i have just tried with Internet Explorer 8 on Xp and had no trouble with certificates. It did give me a top-bar similar to the one Firefox gave me earlier. IE's said To help protect your security, Internet Explorer blocked this site from downloading files to your computer. Click here for options. The 1st time i clicked on that top-bar and then the download started. The 2nd time i clicked on the link inside the page, If your download does not start automatically, please click here.. Again the download started. Both times it showed me the download was coming from mirrors.coreix.net Regards from Tom :) From: Jairo de Jesús López Ayola jairodejesuslo...@gmail.com To: users@global.libreoffice.org Sent: Monday, 15 July 2013, 17:53 Subject: [libreoffice-users] Errores de certificado en la web 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 impidiendo que mas gente acceda a este programa. Agradezco la atención prestada yque puedan corregir esta situación. Que tengan un feliz día, -- 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 -- 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
Re: [libreoffice-users] Pull-down styles menu
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 this option presents a list of fonts in plain text, not in their actual style. Hope this helps. Girvin Herr Séamas Ó Brógáin wrote: 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. Any hints gratefully received. -- 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] saving as docx turned very paragraph into a page break
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 with. How did I end up with 28? I really want to save as DOCX for portability reasons (many companies won't accept ODT or PDF). Suggestions? -- View this message in context: http://nabble.documentfoundation.org/saving-as-docx-turned-very-paragraph-into-a-page-break-tp4065556.html Sent from the Users mailing list archive at Nabble.com. -- 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
Re: [libreoffice-users] saving as docx turned very paragraph into a page break
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 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 with. How did I end up with 28? I really want to save as DOCX for portability reasons (many companies won't accept ODT or PDF). Suggestions? -- View this message in context: http://nabble.documentfoundation.org/saving-as-docx-turned-very-paragraph-into-a-page-break-tp4065556.html Sent from the Users mailing list archive at Nabble.com. -- Jay Lozier jsloz...@gmail.com -- 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
Re: [libreoffice-users] HSLQLDB syntax
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 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 being said ;-) see - http://www.merriam-webster.com/dictionary/acronym AND - did you happen to notice in that URL, this phenomenon only started in 1943 ;-) do you know SPQR? or INRI? or Q.E.D.? None of these are acronyms either. Senatus PupulusQue Romanus: did you know that the Roman street catchbasins and manhole covers are marked SPQR? Yes, today. Iesus Nazarenus Rex Iudaeorum Quod Erat Demonstrandum --doug -- 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
Re: [libreoffice-users] saving as docx turned very paragraph into a page break
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 but 2013 and 365 open the one that everyone else is using. So Odt kinda works even on those. So, it's rapidly getting better for Odt but we are still probably not quite fully there yet. Quite a lot of companies are still on MS Office 2003 and just about to leap-frog onto 2010 or 2013. Still the best format right now for sharing is probably still the old Doc. For storing documents i think Odt is probably better now. Regards from Tom :) From: zoidicus zoidi...@comcast.net To: users@global.libreoffice.org Sent: Monday, 15 July 2013, 18:50 Subject: [libreoffice-users] saving as docx turned very paragraph into a page break 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 with. How did I end up with 28? I really want to save as DOCX for portability reasons (many companies won't accept ODT or PDF). Suggestions? -- View this message in context: http://nabble.documentfoundation.org/saving-as-docx-turned-very-paragraph-into-a-page-break-tp4065556.html Sent from the Users mailing list archive at Nabble.com. -- 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 -- 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
Re: [libreoffice-users] HSLQLDB syntax
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 StarOffice code from Stardivision. I never was able to get Adabase D working for me back then, but I was ignorant of real (non-Access) databases then and the StarOffice Adabase D database documentation was terrible. Girvin Herr V Stuart Foote wrote: 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 ripped out of LibreOffice to be replaced, or the version of HSQLDB will be upgraded to a current 2.3 release. Mark, et al., all the details you could ever want are on the project webpage at hsqldb.org, just mind the version differences. Stuart From: Tom Davies [tomdavie...@yahoo.co.uk] Sent: Monday, July 15, 2013 11:15 AM To: anne-ology; Mark LaPierre Cc: Mail List LibreOffice Subject: Re: [libreoffice-users] HSLQLDB syntax 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 = Database H is the only bit that distinguishes exactly which program is being talked about. Note that other programs also use Sql or Db in their name. For example MySql/MariaDb, Postgresql. Only Access doesn't have any of that in it's name. Of course MS make many claims that Access does use Sql but it's such a heavily tweaked version of Sql that it's almost unrecognisable. If you learn Access then you need to forgetre-learn if you want to switch to anything else. The others tend to just have a few differences so it's not so tough to move between them. At least, so i have heard. Regards from Tom :) From: anne-ology lagin...@gmail.com To: Mark LaPierre marklap...@aol.com Cc: Mail List LibreOffice users@global.libreoffice.org Sent: Monday, 15 July 2013, 16:38 Subject: Re: [libreoffice-users] HSLQLDB syntax 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 being said ;-) see - http://www.merriam-webster.com/dictionary/acronym AND - did you happen to notice in that URL, this phenomenon only started in 1943 ;-) before then communication was simply speaking to be understood ;-) BTW - many of these acronyms are duplicated - which causes even more confusion to the listener ;-) On Sat, Jul 13, 2013 at 1:07 PM, Mark LaPierre marklap...@aol.com wrote: On 07/13/2013 05:36 AM, Alexander Thurgood wrote: HSLQLDB is a bit picky about the syntax Does anyone know where I can find a good reference on HSLQLDB syntax? -- 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
Re: [libreoffice-users] Re: QA Triage Contest
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 what i really wanted to say was WHhoo!!! It feels great to know that there are more people out there that know how to do QA and are able to work through outstanding bug-reports to get them confirmed and get them onto the next stage. Good work everyone in QA and everyone that joined them recently or 'just' took part in the competition. Very much appreciated Regards from Tom :) From: Nino Novak nn.l...@kflog.org To: users@global.libreoffice.org Cc: libreoffice...@lists.freedesktop.org Sent: Monday, 15 July 2013, 17:12 Subject: [libreoffice-users] Re: QA Triage Contest 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 started in April already. Keep on! Nino -- 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 -- 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
Re: [libreoffice-users] Pull-down styles menu
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: 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: How to insert date/time in a LibreOffice Writer text?
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 / Fields / Date Insert / Fields / Time In addition to this, you can right click either the date or time that you have created. Select Fields to open the Edit Fields dialog. At the bottom of the Format list, select Additional formats. This opens the Number Format dialog. Look through the Format list to find the timestamp format. It also has a Format code box in which you can specify the specific code you want to use. --Dan This is LO 4.0, so it may not have the elements you are talking about. I used help and repeatedly did everything it said to insert the date. 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 Date (fixed) no matter what. I only downloaded and installed writer since that is the only part of LO I will be using. Do I need to have installed one of the other sections as well? or something else? thanks in advance. -- 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: Visible currency rounding
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 of 20p When paying tax, you are required to pay what you have collected. If you calculate as you suggest you may hand over more tax than you have collected. What I think he is looking for is a simple way of calculating the VAT due on his total with each individual item rounded down and that cannot be done. Each item has to be calculated, rounded down and then a total obtained for the rounded figures. HMRC take the view that VAT is payable on the total value of cash sales plus the VAT calculated on Invoiced sales. In my examples the VAT due would be 27.20 assuming that the 100 items sold would consist of 50 invoiced and 50 cash sales. Tink. -- View this message in context: http://nabble.documentfoundation.org/Visible-currency-rounding-tp4065342p4065571.html Sent from the Users mailing list archive at Nabble.com. -- 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: Visible currency rounding
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 Calc will concatenate the result to two places. There is no need for fancy formulas. Tink. -- View this message in context: http://nabble.documentfoundation.org/Visible-currency-rounding-tp4065342p4065572.html Sent from the Users mailing list archive at Nabble.com. -- 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: HSLQLDB syntax
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 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 StarOffice code from Stardivision. I never was able to get Adabase D working for me back then, but I was ignorant of real (non-Access) databases then and the StarOffice Adabase D database documentation was terrible. Girvin Herr -- View this message in context: http://nabble.documentfoundation.org/HSLQLDB-syntax-tp4065310p4065574.html Sent from the Users mailing list archive at Nabble.com. -- 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
Re: [libreoffice-users] Re: How to insert date/time in a LibreOffice Writer text?
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 Date (fixed) no matter what. You are showing the actual field name rather than the value. Hit 'CTRL-F9' Or Click 'View' 'Field Names' -- 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: Macros in templates
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? 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] Re: QA Triage Contest
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. Nino -- 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
Re: [libreoffice-users] Fwd: Help for Calc Macros
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, including the help pages. If you are not versed in LO macro programming, examples may be useful to start, and there is a macro recorder. A link to AndrewMacro.odt (below) includes numerous examples, as does OOME (also available from my web site). Ignoring my web site, check here https://wiki.documentfoundation.org/Documentation/Publications Getting Started With Macros is very similar to chapter 1 in OOME (that was the starting point for the chapter). https://wiki.documentfoundation.org/images/0/0c/GS4013-GettingStartedWithMacros.odt Calc Macros https://wiki.documentfoundation.org/images/d/d7/CG4012-CalcMacros.odt Calc as a Simple Database (has lots of macro stuff I think) https://wiki.documentfoundation.org/images/4/4a/CG4013-CalcAsASimpleDatabase.odt Enough to get you started I hope? On 07/14/2013 11:04 PM, Jean Weber wrote: Forwarding to the users support list. -- Forwarded message -- From: Harold Ek hal...@bellsouth.net Date: Mon, Jul 15, 2013 at 12:43 PM Subject: Help for Calc Macros To: jeanwe...@gmail.com I am a newbie in LibreOffice and recently I am trying to convert an Excel Sheet that includes macros. While searching thru the various help paths I came across your name. My topic may well not be your main area, but I wonder if you could either forward this letter or tell me who I might contact. I guess I would state my need as Tips to convert macros from Excel to Calc. Thanks for any help! -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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
Re: [libreoffice-users] Re: Visible currency rounding
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 Subject: [libreoffice-users] Re: Visible currency rounding 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 of 20p When paying tax, you are required to pay what you have collected. If you calculate as you suggest you may hand over more tax than you have collected. What I think he is looking for is a simple way of calculating the VAT due on his total with each individual item rounded down and that cannot be done. Each item has to be calculated, rounded down and then a total obtained for the rounded figures. HMRC take the view that VAT is payable on the total value of cash sales plus the VAT calculated on Invoiced sales. In my examples the VAT due would be 27.20 assuming that the 100 items sold would consist of 50 invoiced and 50 cash sales. Tink. -- View this message in context: http://nabble.documentfoundation.org/Visible-currency-rounding-tp4065342p4065571.html Sent from the Users mailing list archive at Nabble.com. -- 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 -- 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
Re: [libreoffice-users] Errores de certificado en la web
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 user of the program? should them trust you blindly and enter a site flagged as suspicious? I'm just reporting, and i would be grateful if you fix it, but in the end is your call to fix it or not, i'll undestand it if you people can't right now. I'm truly sorry for my lousy english xD Have a nice day! 2013/7/15 Tom Davies tomdavie...@yahoo.co.uk 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 appearing with me certificate errors, using IE browser version 9.0.8112.16421. This may be preventing more people access to this program. yque appreciate the attention given to correct this. Have a happy day, Ok, i have just tried with Internet Explorer 8 on Xp and had no trouble with certificates. It did give me a top-bar similar to the one Firefox gave me earlier. IE's said To help protect your security, Internet Explorer blocked this site from downloading files to your computer. Click here for options. The 1st time i clicked on that top-bar and then the download started. The 2nd time i clicked on the link inside the page, If your download does not start automatically, please click here.. Again the download started. Both times it showed me the download was coming from mirrors.coreix.net Regards from Tom :) -- *From:* Jairo de Jesús López Ayola jairodejesuslo...@gmail.com *To:* users@global.libreoffice.org *Sent:* Monday, 15 July 2013, 17:53 *Subject:* [libreoffice-users] Errores de certificado en la web 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 impidiendo que mas gente acceda a este programa. Agradezco la atención prestada yque puedan corregir esta situación. Que tengan un feliz día, -- 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 -- 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
Re: [libreoffice-users] Errores de certificado en la web
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 system(s) and report back so that we can make a better bug-report or a better report to the websites team. Note that IE is made by a 3rd party competitor that has good reason to want to see LibreOffice (and all other OpenSource products) fail. The more they can do to discredit LibreOffice the more likely they are to sell more of their own product and make more money. So, if IE doesn't behave we might not be able to do anything about it. You might notice that people in here recommend a variety of other web-browsers. Regards from Tom :) From: Jairo de Jesús López Ayola jairodejesuslo...@gmail.com To: Tom Davies tomdavie...@yahoo.co.uk Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Monday, 15 July 2013, 19:27 Subject: Re: [libreoffice-users] Errores de certificado en la web 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 connection, but ¿what about all the other potential new user of the program? should them trust you blindly and enter a site flagged as suspicious? I'm just reporting, and i would be grateful if you fix it, but in the end is your call to fix it or not, i'll undestand it if you people can't right now. I'm truly sorry for my lousy english xD Have a nice day! 2013/7/15 Tom Davies tomdavie...@yahoo.co.uk 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 appearing with me certificate errors, using IE browser version 9.0.8112.16421. This may be preventing more people access to this program. yque appreciate the attention given to correct this. Have a happy day, Ok, i have just tried with Internet Explorer 8 on Xp and had no trouble with certificates. It did give me a top-bar similar to the one Firefox gave me earlier. IE's said To help protect your security, Internet Explorer blocked this site from downloading files to your computer. Click here for options. The 1st time i clicked on that top-bar and then the download started. The 2nd time i clicked on the link inside the page, If your download does not start automatically, please click here.. Again the download started. Both times it showed me the download was coming from mirrors.coreix.net Regards from Tom :) -- *From:* Jairo de Jesús López Ayola jairodejesuslo...@gmail.com *To:* users@global.libreoffice.org *Sent:* Monday, 15 July 2013, 17:53 *Subject:* [libreoffice-users] Errores de certificado en la web 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 impidiendo que mas gente acceda a este programa. Agradezco la atención prestada yque puedan corregir esta situación. Que tengan un feliz día, -- 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 -- 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 -- 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: saving as docx turned very paragraph into a page break
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: 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 [hidden email]http://user/SendEmail.jtp?type=nodenode=4065559i=0 wrote: 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 with. How did I end up with 28? I really want to save as DOCX for portability reasons (many companies won't accept ODT or PDF). Suggestions? -- View this message in context: http://nabble.documentfoundation.org/saving-as-docx-turned-very-paragraph-into-a-page-break-tp4065556.html Sent from the Users mailing list archive at Nabble.com. -- Jay Lozier [hidden email] http://user/SendEmail.jtp?type=nodenode=4065559i=1 -- To unsubscribe e-mail to: [hidden email]http://user/SendEmail.jtp?type=nodenode=4065559i=2 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 -- If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/saving-as-docx-turned-very-paragraph-into-a-page-break-tp4065556p4065559.html To unsubscribe from saving as docx turned very paragraph into a page break, click herehttp://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4065556code=em9pZGljdXNAY29tY2FzdC5uZXR8NDA2NTU1NnwyMTE1ODY5MDkz . NAMLhttp://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://nabble.documentfoundation.org/saving-as-docx-turned-very-paragraph-into-a-page-break-tp4065556p4065618.html Sent from the Users mailing list archive at Nabble.com. -- 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
Re: [libreoffice-users] Help for Calc Macros
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 of very basic questions. 1. Is the info describing the details to use a macro in AndrewMacro.odt directly applicable to LO macros (OO vs LO)? Should be so. In the OOME book, I embedded links to try many of the macros directly so you can tell that they work. Certainly there have been some changes, but, for the most part, things should function. At first, there was only OOo (OpenOffice.org). LO split from OOo and OOo eventually became AOO (Apache OpenOffice). So, they are all very much related. No idea how closely things will be say 10 years from now, but, major changes in the internal APIs that cause working things to no longer function are not commonly intentional (in other words, they are usually bugs if it happens). 2. What exactly must I do to subscribe to the 'User's mailing list'. Is this like a forum where I should submit my question to the list and then review it frequently to uncover any responses? From here: http://www.libreoffice.org/get-help/ I find this link: http://www.libreoffice.org/get-help/mailing-lists/ That link recommends that you send an email here: users+subscr...@global.libreoffice.org mailto:users+subscr...@global.libreoffice.org Note that then you will receive all the emails for the list. Every email for the list provides instructions as to how unsubscribe if you receive too many email messages * * * * ***(**HAROLD* *)*** On 7/15/2013 5:34 PM, - Andrew Douglas Pitonyak wrote: 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, including the help pages. If you are not versed in LO macro programming, examples may be useful to start, and there is a macro recorder. A link to AndrewMacro.odt (below) includes numerous examples, as does OOME (also available from my web site). Ignoring my web site, check here https://wiki.documentfoundation.org/Documentation/Publications Getting Started With Macros is very similar to chapter 1 in OOME (that was the starting point for the chapter). https://wiki.documentfoundation.org/images/0/0c/GS4013-GettingStartedWithMacros.odt Calc Macros https://wiki.documentfoundation.org/images/d/d7/CG4012-CalcMacros.odt Calc as a Simple Database (has lots of macro stuff I think) https://wiki.documentfoundation.org/images/4/4a/CG4013-CalcAsASimpleDatabase.odt Enough to get you started I hope? On 07/14/2013 11:04 PM, Jean Weber wrote: Forwarding to the users support list. -- Forwarded message -- From: Harold Ek hal...@bellsouth.net Date: Mon, Jul 15, 2013 at 12:43 PM Subject: Help for Calc Macros To: jeanwe...@gmail.com I am a newbie in LibreOffice and recently I am trying to convert an Excel Sheet that includes macros. While searching thru the various help paths I came across your name. My topic may well not be your main area, but I wonder if you could either forward this letter or tell me who I might contact. I guess I would state my need as Tips to convert macros from Excel to Calc. Thanks for any help! -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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