[libreoffice-users] Re: Macro to open form + pass on value from current form
Am 19.12.2014 um 04:21 schrieb Andrew Douglas Pitonyak: And, when you can solve a problem without a macro, that is generally the better path :-) And for most of the rest we have: http://extensions.libreoffice.org/extension-center/access2base -- 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: SEPA setup
Vielleicht gelingt es, meine Empfehlung an die richtige Stelle zu bringen. Dann können die festlichen Zeiten beginnen. Mit freundlichen Grüßen Franz Kurz Maybe it manages that my recommendation reach the correct position. Then the festive times may come. Sincerely Franz Kurz Simple user in Old Europ's Germany -- Forwarded message -- From: Tutorials For OpenOffice cont...@tutorialsforopenoffice.org Date: 2014-12-18 21:26 GMT+01:00 Subject: Re: SEPA setup To: Franz Kurz fkur...@gmail.com Original Message From: Franz Kurz fkur...@gmail.com fkur...@gmail.com To: Tutorials For Openoffice cont...@tutorialsforopenoffice.org Date: Thu, 18 Dec 2014 08:59:25 +0100 Foreseen is envelop in Open Office Writer. I prepared 'envelop' provisional for money transfer form. Are you able to provide better standard solution. Grateful for assistance. Thank you. Franz Kurz Hi Franz, Thank you for contacting the Tutorials For OpenOffice project, but please be aware that we are not a general support contact for either the LibreOffice or Apache editions of the software. We are a very small *independent* volunteer user group and lack the resources to provide answers to all of the many general support questions we receive every day. This email address is mainly intended for issues specifically related to the use of, or questions about, our tutorials. We recommend you post your question to one of the official user support forums. The attached document Support.pdf provides *IMPORTANT* information and advice about contacting user support. Regards Dave Barton Project Coordinator Tutorials For OpenOffice -- 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: image anchoring
Am 17.12.2014 um 00:16 schrieb Hedley Finger: All: Why not stay with the advantages of LibreOffice instead of trying to make it as hideous as MS Office!!? Can MS Office be more hideous than this? I decided to make a small database of bicycle spare parts in Calc, in which I would include a photo of each part as it's easier to scan a printout for a picture than look up words. Copying a graphic file from Gimp, etc. (or even another cell) and pasting into a cell produces these results: A spreadsheet is not a database. Pictures in a spreadsheet are mere decoration. LibreOffice comes with a database component that is able to link picture files to form controls. A simple double-click on the form control lets you assign a picture file to the report. The report builder that is shipped with LibreOffice produces professional database reports with pictures. -- 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: image anchoring
On Fri, 2014-12-19 at 14:00 +0100, Andreas Säger wrote: Am 17.12.2014 um 00:16 schrieb Hedley Finger: All: Why not stay with the advantages of LibreOffice instead of trying to make it as hideous as MS Office!!? Can MS Office be more hideous than this? I decided to make a small database of bicycle spare parts in Calc, in which I would include a photo of each part as it's easier to scan a printout for a picture than look up words. Copying a graphic file from Gimp, etc. (or even another cell) and pasting into a cell produces these results: A spreadsheet is not a database. Pictures in a spreadsheet are mere decoration. LibreOffice comes with a database component that is able to link picture files to form controls. A simple double-click on the form control lets you assign a picture file to the report. The report builder that is shipped with LibreOffice produces professional database reports with pictures. ...except that the report function (in the OpenSuse 13.2 Linux / LOVersion: 4.3.3.2 Build ID: 430m0(Build:2) configuration) is currently not working because the JavaLoader is missing (OpenSuse Bug 906688) Cheers Harvey -- 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] Dot separated date in YYYY.MM.DD format
Hello all, In a spreadsheet, I need the dot separated date in .MM.DD format, e.g. 2015.01.012015.12.11 Should I file a bug report to add this feature? Is it currently not available? Please advise. Thanks. C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- 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] Dot separated date in YYYY.MM.DD format
I think it is already available. You have to change the cell format (date type) in .MM.DD, nothing more Federico Quadri C. H. D. webofht-libreoffice...@yahoo.com.hk ha scritto: Hello all, In a spreadsheet, I need the dot separated date in .MM.DD format, e.g. 2015.01.012015.12.11 Should I file a bug report to add this feature? Is it currently not available? Please advise. Thanks. C. H. D. -- 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] Dot separated date in YYYY.MM.DD format
On Fri, 19 Dec 2014 14:47:02 + (UTC) C. H. D. webofht-libreoffice...@yahoo.com.hk wrote: Hello C., In a spreadsheet, I need the dot separated date in .MM.DD format, e.g. 2015.01.012015.12.11 Go to Format Menu, Cells... then select Numbers tab - Time. Enter time in the format you require in the entry box. Should I file a bug report to add this feature? Is it currently not available? No bug report required. Not all options are offered out of the box; There are simply way too many permutations. -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent Bet you thought you had it all worked out Problem - Sex Pistols -- 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] Dot separated date in YYYY.MM.DD format
At 14:47 19/12/2014 +, Conly Honly Donly wrote: In a spreadsheet, I need the dot separated date in .MM.DD format, e.g. 2015.01.012015.12.11 In the Format Cells dialogue, you can create your own User-defined formats. Just enter your .MM.DD in the Format code box there. Some formats get complicated by locale-specific properties, but I doubt there is any problem with this one. Alternatively, you could always create a formula to develop from a genuine date value a text string (in a separate cell) representing any format you wanted. Should I file a bug report to add this feature? Probably not. Is it currently not available? It is - as above. 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
Re: [libreoffice-users] Dot separated date in YYYY.MM.DD format
Hello all, When I enter 2015.01.01, it is recognized not as a date. How do I make it one step only? I enter it and it is detected as a date. 01-01-2015 is recognized as a date. Then I need to format this. Two steps are required. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- 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] Dot separated date in YYYY.MM.DD format
I tried this, which seem to work: specifying the cell format with a custom format .MM.DD. When I input a date in this form, it is kept this way, and is recognized as a date (possible to use it in formula). Is that not enough? Maybe I misunderstood the question. -- Cley Faye http://cleyfaye.net 2014-12-19 16:27 GMT+01:00 C. H. D. webofht-libreoffice...@yahoo.com.hk: Hello all, When I enter 2015.01.01, it is recognized not as a date. How do I make it one step only? I enter it and it is detected as a date. 01-01-2015 is recognized as a date. Then I need to format this. Two steps are required. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- 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] Dot separated date in YYYY.MM.DD format
Hi all: I think you need to use this format: /MM/DD Regards, Jorge Rodríguez El vie, 19-12-2014 a las 14:47 +, C. H. D. escribió: Hello all, In a spreadsheet, I need the dot separated date in .MM.DD format, e.g. 2015.01.012015.12.11 Should I file a bug report to add this feature? Is it currently not available? Please advise. Thanks. C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- Atentamente, Jorge Rodríguez -- 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] Dot separated date in YYYY.MM.DD format
On 19 December 2014 at 08:47, C. H. D. webofht-libreoffice...@yahoo.com.hk wrote: In a spreadsheet, I need the dot separated date in .MM.DD format, e.g. 2015.01.012015.12.11 I suspect you would have more success using the ISO format of -MM-DD instead of a non-standard format. -- T. R. Valentine A rich heart may be under a poor coat. -- 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: Dot separated date in YYYY.MM.DD format
Add the input format to your Date acceptance pattern? Tools - Language Settings - Languages: Language Of... Date acceptance patterns -=from en-US help=- Date acceptance patterns Specifies the date acceptance patterns for the current locale. Calc spreadsheet and Writer table cell input needs to match locale dependent date acceptance patterns before it is recognized as a valid date. Default locale dependent date acceptance patterns are generated build time, but it is possible to add more or modify them in this edit box. Additionally to the date acceptance patterns defined here, every locale accepts input in an ISO 8601 Y-M-D pattern, and since LibreOfficeDev 3.5 that also leads to the -MM-DD format being applied. Syntax: Y means year, M means month, and D means day, regardless of localizaton. -- View this message in context: http://nabble.documentfoundation.org/Dot-separated-date-in--MM-DD-format-tp4133212p4133233.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] Product support question please!
PLEASE NOTE = Please forward this email to the people who handle product support questions for LibreOffice Writer. Dear Sir or Ms., I have been a very please long time user of your various products especially your writer product but now I have a question which I can not find the answer to and here is my question: +) I am attempting to build an HTML Business Plan because I want several people to read it and I do not know what kind of word processors they will be using. In the Business Plan I wish to have a Sound Track so to speak playing a certain song while they are reading the business plan. I attempted to insert Sound using the insert Movie Sound command but whatever sound I attempt to insert it always tells me that it is the wrong format. I have searched online and read the LibreOffice Writer owners manual to no avail AND I AM HOPING THAT YOU CAN HELP ME WITH THIS PROBLEM. +) WHAT AUDIO FORMATS ARE ACCEPTABLE IN LibreOffice Writer? I thank you in advance for your assistance. Very truly yours, Dennis Regan -- 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] Dot separated date in YYYY.MM.DD format
Hi :) If the formatting is set to display the date in the way that you want then when you type in; 19/12 then it should display as 19.12.2014 (or whatever your formatting is for dates). So if you have a whole column, or row of dates then it's not really a 2 step process, more like (n+1)/n steps as the initial step set-up lots of cells all at once. Sorry that is not a huge help! It's an awkward work-around. You really kinda need to be able to type in roughly the way it is meant to look. Regards from Tom :) On 19 December 2014 at 15:27, C. H. D. webofht-libreoffice...@yahoo.com.hk wrote: Hello all, When I enter 2015.01.01, it is recognized not as a date. How do I make it one step only? I enter it and it is detected as a date. 01-01-2015 is recognized as a date. Then I need to format this. Two steps are required. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- 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: Dot separated date in YYYY.MM.DD format
Am 19.12.2014 um 16:57 schrieb T. R. Valentine: I suspect you would have more success using the ISO format of -MM-DD instead of a non-standard format. Why? Load a Calc document and apply English .MM.DD or German .MM.TT, Spanish .MM.DD or anything like that. Checking this out takes not more than a minute. -- 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] Dot separated date in YYYY.MM.DD format
At 15:27 19/12/2014 +, Cony Honly Donly wrote: When I enter 2015.01.01, it is recognized not as a date. How do I make it one step only? Aha! This is a different question: you need Calc to recognise your entered text as a date, to convert the text string to the internal number representing that date (that's probably 42005 in your example case), and to set the cell's format to a date format if you have not already done this. There are two solutions to this: o As has already been suggested, if this format is not accepted by default in your locale, you may be able to add it at Tools | Options... | Language Settings | Languages | Language of | Date acceptance patterns. o Failing this, you could easily set up a formula. Enter your desired text into, say, column A. In B1, say, enter something like =DATE(LEFT(A1;4);MID(A1;6;2);RIGHT(A1;2)) and fill this down the column. If you want to be able to read column B, you will need to format it with your desired format. But you may be happy reading column A instead. Any formulae for calculations depending on your input would depend on column B, so would work as soon as you had entered your text into A. So this technique passes your one step test. o You might find that =DATEVALUE(A1) works as well, but I imagine that this will work only with date formats that follow one of the acceptance patterns anyway. 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
Re: [libreoffice-users] Product support question please!
On 19-12-2014 17:03, dprega...@gmail.com wrote: PLEASE NOTE = Please forward this email to the people who handle product support questions for LibreOffice Writer. Dear Sir or Ms., I have been a very please long time user of your various products especially your writer product but now I have a question which I can not find the answer to and here is my question: +) I am attempting to build an HTML Business Plan because I want several people to read it and I do not know what kind of word processors they will be using. In the Business Plan I wish to have a Sound Track so to speak playing a certain song while they are reading the business plan. I attempted to insert Sound using the insert Movie Sound command but whatever sound I attempt to insert it always tells me that it is the wrong format. I have searched online and read the LibreOffice Writer owners manual to no avail AND I AM HOPING THAT YOU CAN HELP ME WITH THIS PROBLEM. +) WHAT AUDIO FORMATS ARE ACCEPTABLE IN LibreOffice Writer? I thank you in advance for your assistance. Very truly yours, Dennis Regan You fail to say which audio format you tried. My first attempt, after reading above, was to add an mp3-file, it works! final question: Music in a HTML Business Plan. What kind of business are you in? BTW: want several people to read it and I do not know what kind of word processors they will be using Publish it in PDF-format would be a good choice! -- 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] U.K. Cabinet Office Adopts ODF as Exclusive Standard for Sharable Documents - ConsortiumInfo.org
http://www.consortiuminfo.org/standardsblog/article.php?story=20140722125241786 -- 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] Bug LO 4.3.5
Dear Sirs, My OS - Win 7 x64. I want to tell you about new bug in LO 4.3.5. If I try to insert the page numbers in the footer I got simple text instead number there (see attached pictures please). I tried to change the data format but nothing changed. I didn't see that bug before (for LO 4.3.4). Could you please help me? Thank you in advance! Best regards, Andrey -- 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] Bug LO 4.3.5
Hi, Андрей. All attached files are deleted in this mailing list . Upload a screenshot somewhere and send a link with a message. If you think it is an bug, you should submit a report in Bugzilla. https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOfficebug_status=UNCONFIRMED or https://www.libreoffice.org/get-help/bug/ You can find instructions on this page: https://wiki.documentfoundation.org/QA/BugReport/ru Perhaps it will be easier to communicate in Russian for you. Now we support mailing lists ( https://wiki.documentfoundation.org/Local_Mailing_Lists/ru ), forums ( http://forumooo.ru/ )and IRC-channel on freenode ( https://wiki.documentfoundation.org/Website/Support/ru ). Best regards, Lera В письме от 20 декабря 2014 05:43:30 пользователь Aндрей написал: I want to tell you about new bug in LO 4.3.5. If I try to insert the page numbers in the footer I got simple text instead number there (see attached pictures please). I tried to change the data format but nothing changed. I didn't see that bug before (for LO 4.3.4). Could you please help me? Thank you 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] Libre office has been put on my computer by gleek squad and i am not sure how to use it.
I need assistance with the word documents. Sent from my Samsung tablet -- 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] Libre office has been put on my computer by gleek squad and i am not sure how to use it.
Here yer go: https://www.libreoffice.org/get-help/documentation/ the guides are a bit old but you will get the general gist. Cheers On 20/12/14 10:05, visajo.lj wrote: I need assistance with the word documents. Sent from my Samsung tablet -- 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