Re: [libreoffice-users] A feature, or ...?
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: 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] 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
Re: [libreoffice-users] HSLQLDB syntax
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? 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 :) 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 formatting to limit the number of figures displayed. The problem with that is if you are doing VAT Returns or something else where you just truncate the number rather than rounding properly. In proper rounding the number is rounded to the nearest figure. So ,005 or ,006 or above goes up to ,01. While ,006 is obviously closer to ,01 than it is to ,00 it is not so obvious with ,005. With ,006 we see that ,01 - ,006 = ,004 but with ,005 ,01 - ,005 =,005 I think it's an example of a potential fence-post error ,000 ,001 ,002 ,003 ,004 all round down to ,00 but ,005 ,006 ,007 ,008 ,009 should all round up to ,01 So, i suspect that in some of those calculations. For example; AVKORTA((HELTAL(K50+K51)-(K50+K51);3) = ,0066 which is getting truncated to ,00 instead of the more correct rounding to ,01 In 1/3 calculations it is wrong. When the result happens to be , or ,0033 the truncated answer is the right answer. However that rounding might sometimes be corrected by a problem in the next equation if AVKORTA(HELTAL((K50+K51)+1)-(K50+K51);2) = ,005 then that too is getting truncated to ,00 instead of being properly rounded to ,01 So this 2nd equation might be mitigating against the problem of the 1st equation. Two wrongs do sometimes make a right = quite the contrary of the 'wisdom' of the common phrase. Unfortunately i don't really know what those equations are doing because they are in Swedish (i think). So i don't really know what AVKORTA, HELTAL or OM are doing. However, a ,01 inaccuracy appearing intermittently could be explained by my above assumptions. If i am right then maybe this equation might be better? =OM(HELTAL(K50+K51)-(K50+K51)-0,5;AVKORTA((HELTAL(K50+K51)-(K50+K51);3);(HELTAL((K50+K51)+1)-(K50+K51);2))) ie, just move the truncate command outside of the calculation? 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] HTML Source
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 wrong? Virgil -Original Message- From: Mark LaPierre Sent: Sunday, July 14, 2013 12:02 AM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] HTML Source On 07/13/2013 09:32 PM, Andrew wrote: 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 in an HTML document ~ I followed these instructions precisely (although context menu is a pretty vague phrase in this context). This doesn't work. So either the docs are incomplete, or just plain wrong; I leave it to you folks to decide what semantics you prefer, however in the meantime I'd appreciate some accurate instructions as to how to actually view HTML source (and ideally edit it as well) . Thank you What LO tool are you using to view this hypothetical HTML file? If you are using Firefox to view the HTML page then you can view the source by right clicking on the page and selecting View Page Source from the resulting menu. But I get the feeling that you are referring to something else. -- _ °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
[libreoffice-users] Re: Visible currency rounding
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 places. To correct this go to Preferences (Mac) or ToolsOptions(Windows) Set the Calc Calculate to Precision as shown. The result will then be as shown in the cell. BTW. The UK VAT calculations allow you to round down to the nearest penny and this should equal the amount paid to the HMRC. Tink. -- View this message in context: http://nabble.documentfoundation.org/Visible-currency-rounding-tp4065342p4065358.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: HTML Source
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 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 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 = SHORTENING Any new idea? Kind regards, Marino -Ursprungligt meddelande- From: Tom Davies Sent: Sunday, July 14, 2013 11:02 AM To: Marino / WellnessWebshop.se ; users@global.libreoffice.org Subject: Re: [libreoffice-users] Visible currency rounding 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 formatting to limit the number of figures displayed. The problem with that is if you are doing VAT Returns or something else where you just truncate the number rather than rounding properly. In proper rounding the number is rounded to the nearest figure. So ,005 or ,006 or above goes up to ,01. While ,006 is obviously closer to ,01 than it is to ,00 it is not so obvious with ,005. With ,006 we see that ,01 - ,006 = ,004 but with ,005 ,01 - ,005 =,005 I think it's an example of a potential fence-post error ,000 ,001 ,002 ,003 ,004 all round down to ,00 but ,005 ,006 ,007 ,008 ,009 should all round up to ,01 So, i suspect that in some of those calculations. For example; AVKORTA((HELTAL(K50+K51)-(K50+K51);3) = ,0066 which is getting truncated to ,00 instead of the more correct rounding to ,01 In 1/3 calculations it is wrong. When the result happens to be , or ,0033 the truncated answer is the right answer. However that rounding might sometimes be corrected by a problem in the next equation if AVKORTA(HELTAL((K50+K51)+1)-(K50+K51);2) = ,005 then that too is getting truncated to ,00 instead of being properly rounded to ,01 So this 2nd equation might be mitigating against the problem of the 1st equation. Two wrongs do sometimes make a right = quite the contrary of the 'wisdom' of the common phrase. Unfortunately i don't really know what those equations are doing because they are in Swedish (i think). So i don't really know what AVKORTA, HELTAL or OM are doing. However, a ,01 inaccuracy appearing intermittently could be explained by my above assumptions. If i am right then maybe this equation might be better? =OM(HELTAL(K50+K51)-(K50+K51)-0,5;AVKORTA((HELTAL(K50+K51)-(K50+K51);3);(HELTAL((K50+K51)+1)-(K50+K51);2))) ie, just move the truncate command outside of the calculation? 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 -- 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: HTML Source
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 has nothing to do with HTML code. So, unless I'm mistaken, Data Source is not the same as HTML Source. LO's online documentation says to select HTML Source under the View menu. Virgil -Original Message- From: Tinkerer Sent: Sunday, July 14, 2013 7:08 AM To: users@global.libreoffice.org Subject: [libreoffice-users] Re: HTML Source 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 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: Visible currency rounding
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 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] Visible currency rounding
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: =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 I'm not sure what you mean by visible currency rounding and am having to guess. I fear you have done what many an enquirer does: to give only a vague idea of what you are trying to achieve but add a formula that is the one thing you know is *not* working - so it cannot define your problem! Apart from anything else, what you will see as the result of this formula will depend on the cell formatting: how many fractional places you are choosing to display. Is the Sum to pay simply the Sum for all products on invoice plus the Tax? (And I imagine that it is only the tax that will need rounding?) How are you calculating the sum to pay: are you simply summing the first two values and rounding the result, or are you using your separate rounding value to correct it? I think you must be doing the former, as using the latter you would get consistent results, even if they were wrong! Why not do this a different way? o Calculate your sum to pay directly from the earlier sum and the tax. You are probably doing this already, but you may be trusting the cell formatting to achieve any required rounding. Instead, modify the formula for the sum to carry out the rounding explicitly - so that the value actually stored in the cell (which you could see if you extended the displayed fractional places in the cell formatting) is correctly rounded. o Now simply calculate the amount of rounding by finding the difference between the true sum of the earlier values and the rounded sum that you have already calculated in the bottom line. (There is no reason why the spreadsheet cannot calculate back up the column, of course.) I trust this helps. 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] Macros in templates
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 tried to do, but when I open a new spreadsheet based on one of these templates, the macros are blocked and when I try to run them I am told to look at my security settings. I have tried to find a security setting that relates to macros in templates, but without success. I am missing something? By the way, in my previous version of LO (3.5 something) it worked, i.e. when I created a new spreadsheets from the templates I was asked what I wanted to do with the macros. -- 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] HTML Source
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 in an HTML document ~ I followed these instructions precisely (although context menu is a pretty vague phrase in this context). The sentence Open context menu in an HTML document should be deleted. The item HTML source does not exist in context menu. This doesn't work. You need to be in Writer/Web. For a new document use File New HTML document. For an existing document use the filter Web pages. So either the docs are incomplete, or just plain wrong; I leave it to you folks to decide what semantics you prefer, however in the meantime I'd appreciate some accurate instructions as to how to actually view HTML source (and ideally edit it as well) . See above. LibreOffice is a bad HTML editor. You should not use it. It will make a lot of changes to your markup, which you do not like. It is in the state of HTML 4.0, was already bad that time, and is not maintained any longer. 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] RE: HELP WITH DELETING A FILE FROM RECYCLE BIN PLEASE!!
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 another person or program. Close any programs that might be using the file and try again. There were no other programs open and I have tried numerous times to delete the file but the same message keeps coming up repeatedly. I would be grateful, if you could please tell me how to remove this file, completely from the system. Thank You Miss Kiran Masood -- 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: HTML Source
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 than ODF format. http://nabble.documentfoundation.org/file/n4065381/SavaAs_convertToHTML%28Writer%29dialog.jpg So either export to HTML or save a copy of an .ODT file being edited to HTML. Simply renaming using Widnows Explorer won't do the conversion, it needs to actually be HTML. Then when being edited in Writer, the View menu will show the HTML source. http://nabble.documentfoundation.org/file/n4065381/Menu_VeiwHTML.jpg Which can also be toggled with an ALT+V, ALT+M accelerator when document has been detected as valid HTML or XHTML. -- View this message in context: http://nabble.documentfoundation.org/HTML-Source-tp4065331p4065381.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: HELP WITH DELETING A FILE FROM RECYCLE BIN PLEASE!!
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 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 another person or program. Close any programs that might be using the file and try again. There were no other programs open and I have tried numerous times to delete the file but the same message keeps coming up repeatedly. I would be grateful, if you could please tell me how to remove this file, completely from the system. Thank You Miss Kiran Masood -- 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] RE: HELP WITH DELETING A FILE FROM RECYCLE BIN PLEASE!!
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 need to shut down the computer and reboot it. If you cannot, then try logging off the user and then log back on again. That may or may not work. Rebooting is the preferred option. With modern CPU speeds, the quick starting option[s] are really not needed anymore. For me, most of my systems open [to the splash screen] LO withing 15 seconds for the slowest ones, and 5 seconds on the faster ones. On 07/14/2013 07:42 AM, Kiran Masood wrote: 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 another person or program. Close any programs that might be using the file and try again. There were no other programs open and I have tried numerous times to delete the file but the same message keeps coming up repeatedly. I would be grateful, if you could please tell me how to remove this file, completely from the system. Thank You Miss Kiran Masood -- 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: HTML Source
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 really really nice if someone fixed this Rube Goldberg-like procedure as this is horrible and painful to have to go through all of this just to convert view/edit a document as HTML. o If they are text documents, you first need to use Save As... within LibreOffice to save copies as HTML Document - probably with an .htm or .html extension. It's actually a .DOC file in my case. The help file does mention saving the file this way, which I did. o Now close the document and reopen it. If I open it using File | Recent Documents, I get the wrong result: it opens as a text document. So I need to use File | Open... or to right-click the file outside LibreOffice and use Open With | sweb. I think the window header should say LibreOffice Writer/Web, not LibreOffice Writer. The above is the missing step. However, there is STILL ANOTHER missing step! Once I EXIT LibreOffice and right click in the file folder, and use Open With, I have to also click on Choose Program followed by Browse, and then find sweb.exe in my Programs folder. Only after doing that does LibreOffice Writer (Web) show up in the context menu. o Now you can go to View | HTML Source or click the HTML Source button in the Standard toolbar. o Edit the HTML source. Yes, with the missing step this works. Someone PLEASE update the various sources of documentation and ideally FIX the program so one can simply SAVE AS (or perhaps - CONVERT/EXPORT TO HTML) and then have it accessible in a simple manner without all these contortions. This really needs to be a one maybe two click operation. 1) CONVERT TO HTML 2) VIEW AS HTML? (yes, a question presented to the user as there's a good chance if I just converted it, I want to view it, however that may not always be the case. I might just want to convert and be done with it, hence the question.) Thank you to all that responded. -- 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
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
Re: [libreoffice-users] Benford's Law
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 adhere to Benford's Law. 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 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 Law. Well, I must say you have not exactly offered much evidence for this assertion! If we knew why you thought this was so, we might be able to help. Probabilities of initial digits according to Benford's Law and proportions from 10 000 trials of my formula: 1 2 3 4 5 6 7 8 9 .301 .176 .125 .097 .079 .067 .058 .051 .046 .310 .171 .126 .093 .080 .066 .059 .053 .043 How much closer would you expect these trials to get? Have you done a chi-squared test? I need a random number generator whose output does adhere to Benford's Law. And I wish you good luck in persuading someone to help! 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
Re: [libreoffice-users] Benford's Law
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 a random number generator whose output does adhere to Benford's Law. jonathon Hi From http://en.wikipedia.org/wiki/Benford%27s_law Therefore, this is the distribution expected if the mantissae http://en.wikipedia.org/wiki/Significand of the /logarithms/ of the numbers (but not the numbers themselves) are uniformly and randomly distributed http://en.wikipedia.org/wiki/Uniform_distribution_%28continuous%29. In a logarithm the part after the decimal point is the mantissa. Convert a logarithm to decimal by number=10^(logarithm). For numbers between 1 and 10 logarithm will be between 0 and 1. Therefore 10^(rand()) should produce numbers randomly between 1 and 10 conforming with Benford's law. =10^RAND() is the same as 10^(rand()) Steve -- 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
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 get the Benford distribution of digits 1 to 9, I think you want =FLOOR(10^RAND();1;1) What makes you think these do not have the Benford distribution? How are you testing that. You should be able to create a histogram for the frequencies of values of 1, 2, 3, ..., 9 and show that it approaches the Benford distribution as you increase the number of samples. While the RNG used for RAND() may not be cryptographically wonderful, I expect it would pass a reasonable test (say chi-squared) for correspondence to the Benford distribution. - Dennis -Original Message- From: Toki Kantoor [mailto:toki.kant...@gmail.com] Sent: Sunday, July 14, 2013 02:01 PM Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Benford's Law 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 adhere to Benford's Law. 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 -- 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 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 Law variates: =1 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
RE: [libreoffice-users] Benford's Law
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' Cc: 'users@global.libreoffice.org' Subject: RE: [libreoffice-users] Benford's Law 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 get the Benford distribution of digits 1 to 9, I think you want =FLOOR(10^RAND();1;1) What makes you think these do not have the Benford distribution? How are you testing that. You should be able to create a histogram for the frequencies of values of 1, 2, 3, ..., 9 and show that it approaches the Benford distribution as you increase the number of samples. While the RNG used for RAND() may not be cryptographically wonderful, I expect it would pass a reasonable test (say chi-squared) for correspondence to the Benford distribution. - Dennis -Original Message- From: Toki Kantoor [mailto:toki.kant...@gmail.com] Sent: Sunday, July 14, 2013 02:01 PM Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Benford's Law 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 adhere to Benford's Law. 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 -- 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 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 need a random number generator whose output does
adhere to Benford's Law.
jonathon
Hey Jonathon,
This is the distribution I got after 100 million cycles:
10^RAND
9 - 0.045
8 - 0.051
7 - 0.057
6 - 0.066
5 - 0.079
4 - 0.096
3 - 0.124
2 - 0.176
1 - 0.300
I don't think you are going to get any closer to Benford's law
distribution than that.
Here is the code I used:
use strict;
use warnings;
my $num;
my $lpcnt;
my @Distribution;
$Distribution[0]=0;
srand;
$lpcnt = 1;
while ($lpcnt) {
$num=substr(10**rand(),0,1);
++$Distribution[$num];
--$lpcnt;
}
$lpcnt = 9;
while ($lpcnt) {
print $lpcnt - .substr($Distribution[$lpcnt]/1,0,5).\n;
--$lpcnt;
}
--
_
°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] Fwd: Help for Calc Macros
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! -- * * * * ***( HAROLD** EK **)*** -- 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
