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:
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,
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?
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
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
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
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
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 =
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
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
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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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'
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
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
27 matches
Mail list logo
