Re: [libreoffice-users] A feature, or ...?

2013-07-14 Thread Cor Nouws
Virgil Arrington wrote (14-07-13 00:37) I certainly wouldn't consider that a bug; it seems to me to be the way it was deliberately designed. It is :) -- - Cor Nouws - http://nl.libreoffice.org - The Document Foundation Membership Committee Member -- To unsubscribe e-mail to:

[libreoffice-users] Visible currency rounding

2013-07-14 Thread Marino / WellnessWebshop.se
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,

Re: [libreoffice-users] HSLQLDB syntax

2013-07-14 Thread Mark Stanton
Google When you spell it right, with just those two words you'll get, if it's the same as for me, 116k hits. Mark Stanton One small step for mankind... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Visible currency rounding

2013-07-14 Thread Tom Davies
Hi :) Is AVKORTA = Truncate, ie just chopping the last digits off?  What does HELTAL do?  Is it some sort of Average or a division such as x/3 or x/2?  Usually computer calculations work well if you avoid doing any rounding-off until the final figure.  Even then avoid rounding off.  Just use

Re: [libreoffice-users] HTML Source

2013-07-14 Thread Virgil Arrington
I just tried this following the same instructions with an HTML file. Rather than saying it doesn't work, I would simply say that in LO 3.6.6.2 running under Win7, there is no option under the View menu to select HTML source. Is this a new feature found in LO 4 or is the online documentation

[libreoffice-users] Re: Visible currency rounding

2013-07-14 Thread Tinkerer
I do not understand your formula, but you can set the result to a number of decimal places and I assume that is what you have done. Calc displays the number of places you set, but this is not the exact result, eg it may display two decimal places, but in fact is carrying forward three decimal

[libreoffice-users] Re: HTML Source

2013-07-14 Thread Tinkerer
In the Mac version LO 4.04.2 the Data Source is in the View Menu and you can obtain it by pressing F4. Tink -- View this message in context: http://nabble.documentfoundation.org/HTML-Source-tp4065331p4065360.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe

Re: [libreoffice-users] Visible currency rounding

2013-07-14 Thread Marino / WellnessWebshop.se
Hi Tom! Thanks for your answer. I have tried to chance to your example, but it don´t work. A small explanation of the Swedish words (you are right; this is Swedish :-) ), maybe this will make it easier: OM = IF HELTAL = to make it round up/down to a sum without any decimal. AVKORTA =

Re: [libreoffice-users] Re: HTML Source

2013-07-14 Thread Virgil Arrington
Yes, I also have Data Source in my View Menu (LO 3.6.6.2, Win7), but when I select it on an HTML file, I do *not* get HTML source code. Rather, I get a link to a Bibliography, which my document doesn’t have. If I recall, Bibliography is one of the default registered databases, which of course

[libreoffice-users] Re: Visible currency rounding

2013-07-14 Thread Tinkerer
Marino Format Cells Numbers nil decimal places. To get a correct roundup go to Tools Options Calc Calculate, make sure that Precision as shown checked. Tink. -- View this message in context: http://nabble.documentfoundation.org/Visible-currency-rounding-tp4065342p4065363.html Sent from the

Re: [libreoffice-users] Visible currency rounding

2013-07-14 Thread Brian Barker
At 09:11 14/07/2013 +0200, Marino Noname wrote: I want to have visible currency rounding on an invoice template that I have made in Libre Office. I have this formula in the cell for currency rounding:

[libreoffice-users] Macros in templates

2013-07-14 Thread Graham Luffrum
I am using LO version 4.0.4.2 under Windows 7 and have a number of spreadsheets with macros in them. My macro security settings are set so that I am always asked if I want to open them with or without the macros and this happens. I would like to set these spreadsheets as templates. This I have

Re: [libreoffice-users] HTML Source

2013-07-14 Thread Regina Henschel
Hi Andrew, Andrew schrieb: This link: https://help.libreoffice.org/Common/HTML_Source says: Displays the source text of the current HTML document. To view the HTML source of a new document, you must first save the new document as an HTML document. Choose View - HTML Source Open context menu

[libreoffice-users] RE: HELP WITH DELETING A FILE FROM RECYCLE BIN PLEASE!!

2013-07-14 Thread Kiran Masood
Hi,      I previously sent a Libreoffice impress file, which I downloaded from the internet and saved to my documents. I then moved the file  directly to the recycle bin. However when I tried to delete it from the recycle bin this message came up: Cannot move DC616: it is being used by

[libreoffice-users] Re: HTML Source

2013-07-14 Thread V Stuart Foote
The UI Instructions are correct, if a little terse. The missing key is that the document must be a valid .HTM or .HTML file type. Done to a ODF formated document, by either *Export *to XHTML, or by using the*Save as* and selecting the HTML Document (Writer) and allowing the conversion to other

Re: [libreoffice-users] RE: HELP WITH DELETING A FILE FROM RECYCLE BIN PLEASE!!

2013-07-14 Thread Gabriel Risterucci
This kind of issue wouldn't survive a reboot. If you can't reboot, check that there is no more soffice.exe process running (under windows, check the process manager with ctrl+alt+del). -- Cley Faye http://cleyfaye.net 2013/7/14 Kiran Masood kiranmasoo...@yahoo.com Hi, I previously

Re: [libreoffice-users] RE: HELP WITH DELETING A FILE FROM RECYCLE BIN PLEASE!!

2013-07-14 Thread Kracked_P_P---webmaster
If you are running Windows, and you have set up the quick start options, i.e. you see an icon for LO on the task bar after you close it, then you are still running a part of LO and the deletion may not work - some times. I could not upgrade some extension because of that option. You really

Re: [libreoffice-users] RE: HELP WITH DELETING A FILE FROM RECYCLE BIN PLEASE!!

2013-07-14 Thread Tom Davies
Hi :) Yes, the easiest way to deal with this sort of thing is to shut-down the machine.  Then switch it on again.  Before opening LibreOffice again delete the offending file.  When you do open LibreOffice it might ask if you want to recover the file.  Just click on the Cancel button to open

Re: [libreoffice-users] Re: HTML Source

2013-07-14 Thread Andrew
Thanks to all that responded. The semi-correct answer was provided to me privately. I'll respect that privacy by not posting his name, however here are his instructions - with my addition. This works, someone needs to update the help file, wiki, etc. etc. to start. In addition, it would be

[libreoffice-users] Re: Macros in templates

2013-07-14 Thread Mindaugas
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

Re: [libreoffice-users] Benford's Law

2013-07-14 Thread Toki Kantoor
On 07/13/2013 11:01 PM, Brian Barker wrote: Unless I misunderstand,the formula =10^RAND() should create random variates in the range (1,10) following the law. 10^RAND generates a set of random numbers that does _not_ adhere to Benford's Law. I need a random number generator whose output does

Re: [libreoffice-users] Benford's Law

2013-07-14 Thread Brian Barker
At 21:01 14/07/2013 +, Toki Jonathan Kantoor wrote: On 07/13/2013 11:01 PM, Brian Barker wrote: Unless I misunderstand,the formula =10^RAND() should create random variates in the range (1,10) following the law. 10^RAND generates a set of random numbers that does _not_ adhere to Benford's

Re: [libreoffice-users] Benford's Law

2013-07-14 Thread Steve Edmonds
On 2013-07-15 09:01, Toki Kantoor wrote: On 07/13/2013 11:01 PM, Brian Barker wrote: Unless I misunderstand,the formula =10^RAND() should create random variates in the range (1,10) following the law. 10^RAND generates a set of random numbers that does _not_ adhere to Benford's Law. I need

RE: [libreoffice-users] Benford's Law

2013-07-14 Thread Dennis E. Hamilton
Uniform random number generators do not conform to Benford's law. To get uniform digits in the range 1 to 10, try =FLOOR(10*RAND();1;1) However, Benford's law is about the *first* digit of a wide variety of numbers. See http://en.wikipedia.org/wiki/Benford%27s_law#Mathematical_statement. To

Re: [libreoffice-users] Benford's Law

2013-07-14 Thread Brian Barker
At 21:01 14/07/2013 +, Toki Jonathan Kantoor wrote: 10^RAND generates a set of random numbers that does _not_ adhere to Benford's Law. Incidentally, if you would like your random numbers in binary instead of decimal, I can provide an even easier formula for the initial digit of Benford's

RE: [libreoffice-users] Benford's Law

2013-07-14 Thread Dennis E. Hamilton
I meant, of course, that large samples of =FLOOR(10^RAND();1;1) should satisfy the chi-squared distribution for conformance to the Benford Distribution. -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Sunday, July 14, 2013 02:55 PM To: 'Toki Kantoor'

Re: [libreoffice-users] Benford's Law

2013-07-14 Thread Mark LaPierre
On 07/14/2013 05:01 PM, Toki Kantoor wrote: On 07/13/2013 11:01 PM, Brian Barker wrote: Unless I misunderstand,the formula =10^RAND() should create random variates in the range (1,10) following the law. 10^RAND generates a set of random numbers that does _not_ adhere to Benford's Law. I

[libreoffice-users] Fwd: Help for Calc Macros

2013-07-14 Thread Jean Weber
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