Re: [libreoffice-users] Conditional formatting and speed of calc
Hi all I`m not sure but increasing memory in LO: Menu, Tools, Options, Memory or uncheck in spanish: Menu, Herramientas, Contenido de Celdas, Cálculo Automatico y luego usar F9 para recalcular todo. Regards, Jorge Rodríguez El jue, 21-03-2013 a las 19:00 +, david_lynch escribió: Johnny, Thanks for your reply. Further details: 17 sheets about 105000 active cells largest sheet 256 by 112 conditional formatting is on 60 cells and each test is a VLOOKUP on 30 cells. David Lynch On 20 March 2013 16:30, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2013/3/19 david_lynch david_ly...@blueyonder.co.uk: I have a large and complex spreadsheet: 17 sheets and 1.4Mb. Normally, it runs acceptably fast (although not at lightning speed). I added conditional formatting to about 80 cells: it then takes about a minute to respond to any input, whether in the cells with conditional formatting or not. Am I doing anything wrong? Is there a way to get conditional formatting without this speed degradation? Depends on what you are doing now. Exactly what do your conditions look like? For instance, if you test 80 cell values against all the values in a giant cell range, let's say 1 cells, then Calc needs to work through 1 cells 80 times. If you, for instance, test a cell value against highest value in a very big cell range, then it's better to calculate the max value in a cell, then comapre each of the 80 cells to that cell. Then the max calculation only needs to be done once. But I don't know what you did, so this is only a wild guess. Johnny Rosenberg I'm running 3.6.3.2 on Vista SP2. David Lynch -- For unsubscribe instructions e-mail to: users+h...@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 -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] How to extract a color from a text?
Hi all: I think in Calc you can use copy and paste special (Select only format). In Writer you can select the word or letter that have the color you need to know. Then you can go to Menu - Format -Character- Font Color and there you can see the Number of the color (Grafico 10 -in spanish in my case as example). Now you can find it in the icon of the color select ... there you can see the number when you put the pointer of the mouse on each color. Regards, Jorge Rodríguez El sáb, 25-05-2013 a las 14:07 -0400, Robert Funnell escribió: On Sat, 25 May 2013 11:42:53 +0200 Axel Braun axel.br...@gmx.de wrote: Any idea how to extract the font color and make it available for all text? There might be an easier way, but if you use an unzip file to look at the zip'd contents of a .odt file, you'll find content.xml. In there will be style definitions that include colours specified in hexadecimal. For example, from a little test file that I made: style:style style:name=T4 style:family=textstyle:text-properties fo:color=#008000//style:style text:span text:style-name=T4green/text:span You can then use Tools Options LibreOffice Colours to add any desired colour to your GUI. Is this what you wanted? - Robert -- 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] LibreOffice 3.6 Base Handbook published
Thank you very much Regards, Jorge Rodríguez El mar, 04-06-2013 a las 15:09 +1000, Jean Weber escribió: LibreOffice 3.6 Base Handbook has been published. Thanks to the authors of the original German book and those who translated, edited, and proofread the English translation. Free PDFs can be downloaded from here: https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook Printed copies can be purchased here: http://www.lulu.com/content/paperback-book/libreoffice-36-base-handbook/13899494 -- 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] CNET is claiming the best free MSO alternative is not LO
Hi all: I have installed Kingsoft in my Android Tablet because at this moment I think is the best option in that plataform and we don't have LibreOffice or OpenOffice for Android. But I didn't know that they have a version for windows. I didn't use it a lot because I use my tablet for others things, but when I used it, its perfomance is good. Of course, until I remember it doesn't have all the features that LibreOffice or OpenOffice have (At least as I rememberd and I didn't use my last update of this program in my Tablet to know is it it is true as I tell you) Regards, Jorge Rodríguez El jue, 06-06-2013 a las 17:24 -0400, Kracked_P_P---webmaster escribió: well I never heard of that product and if there is any truth of what the commenter states, I would not want to try it. I really do not see any free office product that is better than LibreOffice. I have been using LibreOffice since it was just about to be released off of the release candidate stage. Have been supporting LO since 3.3.2 or 3.3.3. I have been handing out brochures of one type or another promoting LO, and CDs and DVDs with LO on them since the spring/summer of 2011. I believe that LibreOffice is better than MSO, not just a free alternative to MSO. I stopped buying MSO with the 2003 release. So, I do not agree with your article. I believe in LibreOffice and all of its pros and cons. I use it and promote it. So, I have never heard of Kingsoft's office package. I have never seen any other articles stating that Kingsoft was a good or great free package. On 06/06/2013 02:55 PM, jack wallen wrote: The author of that article was me...just so ya know. I never even heard of this office packages company. If the commenter is correct, then CNET really need to rethink their recommendations. - http://reviews.cnet.com/8301-33153_7-57587824-10391733/kingsoft-office-2013-the-best-free-microsoft-office-alternative/ Kingsoft Office 2013: The best free Microsoft Office alternative? Not only does it have the best interface around, it also brings innovations like tabbed document viewing and drag-and-drop paragraph adjustment. Rick Broida by Rick Broida June 5, 2013 10:52 AM PDT --- One of the replies to that article is as follows --- the_brigadier 25 minutes ago You do know Kingsoft is a communist Chinese company whose nation has been conducting unrelenting hack attacks to strip America of all its technology? If you can't build it, steal it is their credo. What better way to open up a million backdoors then by offering free software that exactly emulates Microsoft's flagship program. By the way read their EULA very carefully. IT CLEARLY STATES THAT ANYTHING CREATED USING THEIR SOFTWARE BECOMES THE PROPERTY OF KINGSOFT. Have you read it Karyn? I downloaded this software several years ago read that EULA and used Revo to deepscan uninstall that software. It had put tendrils all through my computer. Revo is very good and got it all, but don't be fooled. This is part and parcel to China's hacking attempts and for cnet to recommend it is both incredibly naive and questionable at best. -- 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 -- 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] Re: LO Calc - Find in a column
Hi all: Why not use a filter ? Regards El vie, 07-06-2013 a las 11:52 +0200, Luuk escribió: On 07-06-2013 11:35, Suo Kunlong wrote: 06/07/2013 05:07 PM, Ian Whitfield : Hi All Is it possible to get Calc to search/Find in a specific column?? I have a three column list of names, (A=First, B-Surname, C=Former Name), with about 3000 entries and want to get the Search function (CTRL-F) to look in just the specific column related to the Search. I have tried to pre-select the column, (right-click), but the Search function still looks at all the columns. PCLOS 2013 and LO 3.6.5.2 Thanks for any help. IanW Pretoria RSA Select a column, then Find Replace (CTRL+H), and make sure the Current Selection Only option is selected within More Options. You may also use regular expressions if you wish. But after the first 'find', the selection is cleared, therefore it will not be possible to find second occurance in that selection. LO 4.0.3.3 / Win7 -- 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] It would [not!] be a bug
Hi: Thank you by your help Regards, Jorge Rodríguez El lun, 24-06-2013 a las 08:30 +0100, david_lynch escribió: On 23/06/2013 23:30, Brian Barker wrote: At 12:08 23/06/2013 -0600, Jorge Rodríguez wrote: ... this other chart No. 2: Oficina Ventas Ala18 Here 16 Punta 3 Total Resultado 37 I've used VLookUp function to get data from chart No 2 to this other chart: Function: =BUSCARV(A3;'Tabla dinámica_Hoja2_1'.$A$11:$B$15;2) Show Should Show Office Sells Sells Ala 18 18 Punta 3 3 Here 16 16 Cart18 0 Lim 16 0 As you can see, the chart is order by office but I got 18 and 16 in Cart and Lim but It should show 0 in both. The LO program get datas from Ala and Here for Cart and Lim. What happens? There is no bug - but two mistakes. As you know, if you omit the optional fourth parameter in the VLOOKUP() function, the data is assumed to be sorted. But as the help text makes clear, a value is always returned in this case - corresponding to the the last value smaller than the criterion. In your case, Ala is next before Cart and Here is next before Lim. To prevent this, you need to add FALSE or 0 as the fourth parameter to VLOOKUP(). Second, there is no magic process by which Calc will guess that you wish for a zero value when no match is found: there is simply no value to return! The value #N/A will be returned instead. If you want zero values here, you need to test for this error value and replace it with zero. You can do this using the ISNA() function, using something like: =IF(ISNA(VLOOKUP(Xn;array;2;0));0;VLOOKUP(Xn;array;2;0)) or, more simply, (new in LO 4): =IFNA(VLOOKUP(Xn;array;2;0);0) I trust this helps. Brian Barker -- 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: off-list Re: [libreoffice-users] Re: any word about 4.0.4 portable coming out?
another portable version is running). Finally the WinPenPack binaries seem to be somewhat optimized because they run faster on slow computers (like my netbook). Conclusion: I highly recommend X-LibreOffice ;) http://sourceforge.net/projects/winpenpack/files/X-LibreOffice/releases/ BTW X-LibreOffice version 4.0.4 is available since June 19th... Just my 2 cents ;) -- View this message in context: http://nabble.documentfoundation.org/any-word-about-4-0-4-portable-coming-out-tp4063162p4063198.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 -- 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] Calc: COUNTBLANK(A1,B3) tell me Err 504
Hi all: You would be use: =CONTAR.BLANCO(B1:C6) Regards, Jorge Rodríguez El vie, 05-07-2013 a las 17:02 +0800, minhsien0330 escribió: Dear Dries Feys and Brian Barker: =COUNTBLANK(A1)+COUNTBLANK(B3) It really works !!! Thank you very much! Best Regards, Minhsien0330 -- 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] stable vs new
Hi all! Thank you very much for the information ! Regards, Jorge Rodríguez El dom, 04-08-2013 a las 15:58 +, V Stuart Foote escribió: Folks, In opening this thread ( Nabble http://nabble.documentfoundation.org/stable-vs-new-tp4068750.html ) Tom is correct in a practical sense. Stability is an inherent component of a mature product. And testing during the development cycles by more potential user willing to invest a little time in QA is essential to the health of the project. But a key aspect Tom omits is that LibreOffice development and release stages are tightly timed--and by proxy so is its support. Nor does he mention that the project has stayed on schedule since inception--synchronizing to a six month minor release cycle implemented in a broader ecosystem of Free and Open Source Software. The Release Plan for LibreOffice publishes the release schedule, current status and a historical record of the project, worth a read: https://wiki.documentfoundation.org/Release_Plan Keeping to the time based release plan means that the delay between initial release on a minor version and the next minor version release is just six months. And that the delay between the x.x.0 release and each bug fix release has been and will continue to be just one month. So, while I don't completely agree Toms' assessment of how far along each bug fix takes things--it is just not the way the user feedback, QA,and development work proceeds--but it is not unreasonable practical advise. Support has kept to the same cycle--for the most part--user documentation (static HTML or wiki based, and published) can always use more active contributors and lags a bit as a result. This is not just development churn, there is solid User eXperience, QA and development work at every tick of the release cycle. And as a minor release nears end of its development life it gets less and less development attenetion--QA and development resources long since shifted to new development and bug fixes. Enhancements and bug fixes become more and more costly to push backward with each tick in development cycle--so less likely to occur. In a sense that also is stability, or maybe stagnation. The project is on sound footings as a time based release, that is not going to change so no sense in debating it here. Rather, if you have specific questions or comments about its implementation or how best to make use of software from time based release manged project that would be a worthwhile discussion. Stuart a LibreOffice QA volunteer, focusing on accessibility issues. p.s. For use Accessibility and Assistive Technology tools the use of a Java 7, Java Runtime Environment and the Java Access Bridge v2.0.3 was not ported backward to the 3.6.x branch. It was included in the 4.1.0 release, and has been patched for the upcoming 4.0.5 release. Users of 3.6.x must continue to use a Java 6 JRE (e.g. 1.6u45) and manual install of Java Access Bridge v2.0.2. -- 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] Book-writing with Writer
Hi all ! Virgil, How did you try to install the writer2epub ? Did you use the wizzard that have LO or AOO ? Regards, Jorge Rodríguez El mar, 13-08-2013 a las 20:36 -0400, Virgil Arrington escribió: I got mine from http://lukesblog.it/ebooks/ebook-tools/writer2epub/. There's a version that words for LO 3, LO 4 and AOO 3, along with a separate version for AOO 4. My problem wasn't that I had the wrong version. I got the version that was designed for LO. It just wouldn't install as long as I had AOO on my system. Once I uninstalled AOO, the extension worked fine with LO. Of course, I have no idea *why* this behavior occurred. I won't blame AOO or anything else. I can't even scientifically say that LO and AOO had a conflict. I just know that, once I uninstalled AOO, I was able to install the writer2epub extension into my LO. I recalled someone else on the list saying that LO and AOO may conflict by sharing common Windows registry entries. That stuff is beyond my abilities, but I just shared it for others who may be interested. Virgil -Original Message- From: Kracked_P_P---webmaster Sent: Tuesday, August 13, 2013 7:41 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Book-writing with Writer There is a version for AOO, several actually written by a guy with an Italian country code. One for version if for 3.x, another for 4.0, and a new Beta one. So you may need to look into which one you are using for which version of LO or AOO. I found this out by Googling odf to epub converter On 08/13/2013 04:15 PM, Virgil Arrington wrote: Another thing I noticed about the writer2epub extension. When I first downloaded it, it would not properly install into my LO 3.6.7. I then uninstalled my AOO 3.4.1 and AOO 4.0. The writer2epub extension then installed into LO. It appears (as others have alluded) that LO and AOO have some conflicts when installed side by side on the same machine (registry perhaps which is beyond my knowledge). Since I'm finding that LO is progressing better than AOO, I'm happy to commit to just one of the suites. Virgil -Original Message- From: Virgil Arrington Sent: Tuesday, August 13, 2013 2:58 PM To: Tom Davies Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Book-writing with Writer I just redid the Writer2epub test with my theology paper after applying default LO styles. It worked a *lot* better. I really liked the way it handled the default Text Body style by not indenting the first paragraph after a heading and then indenting subsequent paragraphs. That is excellent typography (a standard in LaTeX) and often missing in EPUB files. However, it still ignored my attempt to apply outline numbering to the default Heading styles. But, it did recognize the heading styles for my table of contents and navigation keys on my Kindle. As you allude, this is a good tool as long as you understand what it will, and will not, do. Work within its parameters and you'll like the result. Try to make it work *your* way, and it will disappoint. Virgil -Original Message- From: Tom Davies Sent: Tuesday, August 13, 2013 2:41 PM To: Virgil Arrington Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Book-writing with Writer Hi :) That sounds a lot like LaTeX being best if you stick with their defaults so it kinda makes sense to me. I think the Docs Team (i think mostly Dan Jean wasn't it?) experimented with a few ways of getting ePubs from the guides and they might have useful ideas about it even though it's years later already. Regards from Tom :) From: Virgil Arrington cuyfa...@hotmail.com To: Tom Davies tomdavie...@yahoo.co.uk; e-letter inp...@gmail.com Cc: users@global.libreoffice.org Sent: Tuesday, 13 August 2013, 19:22 Subject: Re: [libreoffice-users] Book-writing with Writer I just did a couple experiments with LO and Writer2epub. I tried converting the entire 390 page Getting Started book to EPUB. It choked. I then tried doing the same with just the 18 page introduction. Same result. No EPUB output file was generated. I noticed that Writer2epub doesn't like custom styles. It is apparently designed for fairly simple documents, using LO's built-in styles. It can't handle the elaborate formatting of the LO User Guides. I then tried it using a theology paper I wrote a few years ago. I have several outline numbered styles, which again, Writer2epub doesn't translate well. I think Writer2epub will work best with a document that is designed from the beginning for EPUB, but if you want to translate an existing document, you may need to do considerable work to make it ready for the extension. These are just my observations after a half-hour experiment. Virgil
Re: [libreoffice-users] Re: Sophie's blog Fw: [libreoffice-marketing] Sophie's blog article on LibreOffice Marketing contributors
Thank you Tom by this ! Regards, Jorge Rodríguez ___ El sáb, 10-11-2012 a las 11:46 +, Tom Davies escribió: Hi :) One video by Drew Jensen http://www.youtube.com/watch?v=rC587veMfIEfeature=youtu.be Regards from Tom :) From: Tom Davies tomdavie...@yahoo.co.uk To: Users@Global.LibreOffice.Org Users@Global.LibreOffice.Org Cc: documentat...@global.libreoffice.org documentat...@global.libreoffice.org; accessibil...@global.libreoffice.org accessibil...@global.libreoffice.org Sent: Saturday, 10 November 2012, 11:25 Subject: Sophie's blog Fw: [libreoffice-marketing] Sophie's blog article on LibreOffice Marketing contributors Hi :) There have been a number of interesting articles about LibreOffice recently. I keep meaning to pass a list of the links on to the Users List and perhaps relevant ones in a list to other mailing lists too. Sophie's blog is interesting because she was one of the original founders. Marc also updates the events calendar. 1.If you find there is an event locally then please do drop in and meet people from TDF and other LibreOffice users. Make yourself known. Perhaps grab some swag, perhaps help out for half an hour or so. 2.If your work sends you to an event that might have a TDF and LO presence then you can check the calendar and you'd be welcomed at the TDF, LO stall. 3.If you hear of an event that you think should be on the calendar then state your case to the marketing list and let them know how much help you could give. There is talk of having a go bag of marketing materials (perhaps including a roller-banner) that could be mailed to a local-users group for such events. 4.If you fancy making a special effort to travel to one of the events then it would be smart to join the marketing list for a bit and perhaps see if others are going from your area or what arrangements other people have made (especially if you need to stay overnight. For one event an excellent cafe allowed people to use their premises overnight so doubtless nearly everyone woke up to wonderful smells and fantastic coffee. At other events it might have been possible to get a group discount at a hotel, perhaps making all the rooms on one floor into conference quarters). Regards from Tom :) - Forwarded Message - From: Marc Paré hidden To: market...@global.libreoffice.org Sent: Saturday, 10 November 2012, 10:24 Subject: [libreoffice-marketing] Sophie's blog article on LibreOffice Marketing contributors So, you are on the marketing list, either contributing with discussions on marketing; either on the sidelines, just curious to see what we do; on the sidelines not knowing what to do or how to do it ... Have a read of Sophie's blog article on marketing. This may clear up some aspects of our marketing team's job.[1] If you see somewhere you can help out, even if it is just for one little request for help or even helping out with larger time-consuming requests ... any help is appreciated. Even better if you think you can help representing LibreOffice at conferences; check out our international events calendar and you may find an upcoming conference happening near you.[2] Have a read of the blog article. It is really worth it! Cheers, Marc [1] http://sophiegautier.com/blog/index.php/2012/11/08/181-are-you-a-contributor-part-4-marketing [2] http://www.libreoffice.org/about-us/libreoffice-international-events-calendar/ -- Marc Paré -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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: [3.5.3.2/Writer] Split screen in half horizontally?
Hi: If I remember well...with LO you can compare two documents...and in Ubuntu there are some programs to do the same Regards, Jorge Rodríguez El vie, 07-12-2012 a las 00:21 +, Tom Davies escribió: Hi :) Side-by-side is fairly easy on Win7 and Ubuntu 12.04. Not sure about others but it's got to have originated somewhere and is probably on the cards elsewhere. Not sure about synchronised scrolling though, that part sounds like a good item for a feature-request / bug-report. http://wiki.documentfoundation.org/Bug_Report So, in Ubuntu 12.04 and Win7 just grab the first document's window and drag it to the far left as though you are dragging it off-screen. When a weird shadow fills half the screen let go. Whatever size and shape the windo had been it now fills half the screen. Do the same to the 2nd document's window but drag it to the right. Errr i choose left first just because it feels more comfortable to me. If you try to drag it off the top of the screen then the window tries to maximise. Of course you could use Alt Tab to flick between any windows on the workspace you are on and that can be a good way to compare quickly. Most GnuLinux distros also let you flick between different work-spaces quickly so changes jump out at you that way too. Windows users probably aren't familiar with the spinning cube (which i can never get to work). Of course Ubuntu kinda lost that quick flick between workspaces in 11.04 using Unity (unless i'm missing a key-combo (which is highly likely)) Regards from Tom :) From: Dr. R. O Stapf reinh...@stapf-online.com To: users@global.libreoffice.org Sent: Thursday, 6 December 2012, 23:10 Subject: Re: [libreoffice-users] Re: [3.5.3.2/Writer] Split screen in half horizontally? This would realy be a good feature. I also miss the possibility to compare to documents side by side and synchronized scrolling. I hate to say it but this is a good feature of MSO. Just hope that our devs can add ti to LibO. On 2012-12-05 20:50, Gilles wrote: I agree. I also miss being able to split a document horizontally in two halves. It's very useful when going through a big document. -- View this message in context: http://nabble.documentfoundation.org/3-5-3-2-Writer-Split-screen-in-half-horizontally-tp3991983p4022603.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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 -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] spreadsheet - sum one column based on the value of other
Hi all: Why not use the pilot table (Dinamic table) ? If you don't know How ? , let me to know and I will try to help you. Regards, Jorge Rodríguez El dom, 08-09-2013 a las 17:29 +0100, Brian Barker escribió: Name - Category - Value lunch - food - 20 fuel - transportation - 100 dinner - food - 20 repairs - transportation - 200 -- 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] LibreOffice and printers
Hi. I think that it isn't a LibreOffice problem. Probably you made a printer from Printer Debian Feature (Menu-Printer). In this case you have to eliminate the printer from there and check the other as default. It is because as my experience, LibreOffice use this cups to get the available printers installed in Operative System. If you keep both installed, and tp1 as default, LibreOffice gets it as a first option. Regards, Jorge Rodriguez El dom, 26-06-2011 a las 20:07 +0200, Heinrich Stoellinger escribió: I run LibreOffice 3.3.3 under Debian/Wheezy, cups and turboprint. Everything is just fine, but... Some time ago I had to install another printer instead of my original one. This printer was then listed under tp1 (the first one being tp0). Now I have got my original printer back (from repair!) and have eliminated the second one in the respective .cfg-files of cups and turboprint. However , when I print something under LibreOffice, it still offers me BOTH printers as a choice. But, ofcourse tp1 doesn't really exist anymore. How do I eliminate it under LibreOffice. This is certainly only a cosmetic issue, but I would still be interested in understanding it. Thanks -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- Atentamente, Jorge Rodríguez -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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] Match cell against any of range of regexes?
Hi: I would suggest to do as this (If you have order the information as you explain and show in your e-mail): 1) Sheet 1: a) Put 1 (without ) in each search engine but in column B b) Put 2 (without ) in each information relative to search engine in column B too. Something like this: Data Clasification google 1 cnn 2 bin 1 hotmail 2 Sport 2 mamma 1 c) Use Automatic Filter (Data Menu) and select all 1 Clasification. Copy and paste in Sheet 2 in column A. Like This: Search Engine google bin mamma d) Do the same process for 2 and the result copy and paste in Sheet 2 in column B and the final result it could be like this: Search Engine Information google cnn bin hotmail mamma Sport I hope you understand me and solve your problem. Regards, Jorge Rodríguez _ El jue, 30-06-2011 a las 14:22 +0100, Ryan Jendoubi escribió: Hi all, Is the operation in the subject line possible? More info (maybe I'm asking the wrong question): I have a (long) list of URLs, and want to categorise them. The categories themselves could be pretty broad: news sites, search engines, music sites, etc. Similar URLs (different pages on the same site) come up many times. So what I'd like to do is define regexes to say If the URL has 'guardian.co.uk' in it, make it a 'News' site. Sheet 1 (list to process; I want to insert the categorising function in col B) A | B google.com cnn.com/foo guardian.co.uk/foo duckduckgo.com cnn.com/bar/baz bing.com Sheet 2 (columns of site name regexes; col A is news sites, B is search engines, etc) A | B cnn | google guardian | duckduckgo | bing The SEARCH function doesn't seem to take a range or array as its findtext. Any ideas on how to go about this? Many thanks! --Ryan -- Atentamente, Jorge Rodríguez -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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] Match cell against any of range of regexes?
Hi again: The e-mail made a change. The final Result is like this: Search Engine Information Google CNN Bin Hotmail Mamma Sports Regards, Jorge Rodríguez _ El jue, 30-06-2011 a las 10:09 -0600, jorge escribió: Hi: I would suggest to do as this (If you have order the information as you explain and show in your e-mail): 1) Sheet 1: a) Put 1 (without ) in each search engine but in column B b) Put 2 (without ) in each information relative to search engine in column B too. Something like this: Data Clasification google 1 cnn 2 bin 1 hotmail 2 Sport 2 mamma 1 c) Use Automatic Filter (Data Menu) and select all 1 Clasification. Copy and paste in Sheet 2 in column A. Like This: Search Engine google bin mamma d) Do the same process for 2 and the result copy and paste in Sheet 2 in column B and the final result it could be like this: Search Engine Information google cnn bin hotmail mamma Sport I hope you understand me and solve your problem. Regards, Jorge Rodríguez _ El jue, 30-06-2011 a las 14:22 +0100, Ryan Jendoubi escribió: Hi all, Is the operation in the subject line possible? More info (maybe I'm asking the wrong question): I have a (long) list of URLs, and want to categorise them. The categories themselves could be pretty broad: news sites, search engines, music sites, etc. Similar URLs (different pages on the same site) come up many times. So what I'd like to do is define regexes to say If the URL has 'guardian.co.uk' in it, make it a 'News' site. Sheet 1 (list to process; I want to insert the categorising function in col B) A | B google.com cnn.com/foo guardian.co.uk/foo duckduckgo.com cnn.com/bar/baz bing.com Sheet 2 (columns of site name regexes; col A is news sites, B is search engines, etc) A | B cnn | google guardian | duckduckgo | bing The SEARCH function doesn't seem to take a range or array as its findtext. Any ideas on how to go about this? Many thanks! --Ryan -- Atentamente, Jorge Rodríguez -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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 with formatting footnotes...
Hi I don't know if there are others ways to solve your problem, but I would sugest this way: To make a macro (How?) Like this: 1) Menu Tools-Macros-Save Macro 2) Here Appears a little windows that says something like this Stop to save macro (Not to click yet) 3) Menu Insert-(Footnotes-Final Note). Here appears a windows for Footnotes. Click Accept. 4) Click in window Stop to save Macro (Point 2)). Here appear a window. Select MyMacros-Standard and then Select New Module: Appears a window: Write the name- Footnotes and Accept. 5) Menu Tools-Macros-Organize Macros-OpenOffice.org Basic... Here appear a window. Select MyMacros-Standard-Footnotes (Your Macro). Click Asign. Appears a new window. Select Save in OpenOffice.org-Writer (Below the Comands Chart). 6) Now, select ADD, and appear a new window. Here, in the chart Category, roll down until the end to find + Macros OpenOffice.org. Click it (+) and there appears + My Macros. Click it and Standard and select Footnotes and Click ADD. 7) Now in the Commands Chart you can find Footnotes command. If You select it you can modify the name if you want, with the command at right. Then Assure that the tool bar is Standard (At the top of Chart) 8) Click Accept. 9) Now, in the Tool Bar of your document Appears a Footnotes icon (At the top of the document). If you click it, it insert a footnote in your document. Now You not need go to Menu-Insert-Footnotes and make the footnote each time. With only one click you are going to insert the footnotes that you need. It respect the consecutive numbers although you save and close the document and then open and continue working. I hope this help you to solve your problem. If you need adicional help say me, Regards, Jorge Rodríguez _ El mié, 06-07-2011 a las 12:33 -0700, gena_hill escribió: Hi! I'm new to LibreOffice, and I'm having problems trying to figure out how to format more than one footnotes at a time. Everything else is working beautifully for me, but this is really an important feature for me since I deal with tons of footnotes on a regular basis. Any help would be much appreciated! Thank you! -- View this message in context: http://nabble.documentfoundation.org/Help-with-formatting-footnotes-tp3145923p3145923.html Sent from the Users mailing list archive at Nabble.com. -- Atentamente, Jorge Rodríguez -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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 formatting footnotes...
Hi Gina, Do you have to share yours documets with yours colleagues and they have to make changes ? If not you can do your work with LibreOffice and make a pdf document with LibreOffice and send it to your collegues. Regards, Jorge Rodríguez __ El vie, 08-07-2011 a las 08:44 -0700, gena_hill escribió: Hi All! Thank you for the replies! When I say footnotes, I am talking about the type used in academic writing. Endnotes also have the same problem... For a simple explanation of what footnotes and endnotes are, see: http://www.aresearchguide.com/7footnot.html Let me be a little more specific about my problem . . . while I am writing, I use Zotero to insert footnotes containing citation information. Also, I add footnotes manually when I need to add a little extra information. These footnotes come up in a different font than I am using, and I also like to change the font size to be a little smaller. I can not select all the footnotes at once and change these things. I have to do each one manually, which adds up quickly when you consider there are 50-60 per chapter of my 8 chapter dissertation. And then there are other documents that I am working on too. I almost never have a piece of writing without footnotes. The next problem I have encountered is how footnotes and endnotes appear in .docx format; especially when I open them in Microsoft Word 2008 or 2011 for Mac. Unfortunately, no matter how much I'd like to use LibreOffice instead of Word, I have to submit my documents in .docx form to be read in Word. I have already done this once, and I had to re-insert every footnote in Word after transferring the document. Because of these two problems, at this point, LibreOffice is simply unusable for me - and probably for most academics and university students. It's a shame, because I really love it otherwise - especially its support for uncommon fonts (which I use a lot of). I can use N'Ko with LibreOffice, but not with Word 2011. (For more info on N'Ko, see: http://en.wikipedia.org/wiki/N%27Ko_script). While creating a macro may work, footnotes and endnotes are something that really should work automatically - especially for people who aren't good with computers, like me! :) And even if I do get that working, .docx files need to transfer seamlessly to Word 2011. Unfortunately, even if I switch to LibreOffice, the rest of my colleagues probably won't and so I need to be able to work with them without problems. I hope this explains everything! Thanks again! -- View this message in context: http://nabble.documentfoundation.org/Help-with-formatting-footnotes-tp3145923p3152214.html Sent from the Users mailing list archive at Nabble.com. -- Atentamente, Jorge Rodríguez -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Feature request: native BibTeX support
Hi LibreOffice has a Menú: Insert-Index-Bibliographic entry that could be used. I have to advice that I never use it and I don't know How to use, but if some one know he would share with us and solve the problem. Regards, Jorge Rodríguez __ El lun, 11-07-2011 a las 01:10 -0700, drorlev escribió: There are several (free and non-free) reference managers in the market. Zotero is one of them, JabRef is another, personally I use (and recommend) Bibus. There are even more. A comparison can be found http://en.wikipedia.org/wiki/Comparison_of_reference_management_software here . Most can handle BibTex. It seems to me that implied in the original post is the question whether LibO should join this market, offering a (full fledged?) bibliography/reference manager. This will require, of course, the ability to directly import Bibtex files. My impression is that: (1) there are plenty of good-enough (and getting better) reference manager programs; (2) developing a good one is not trivial; (3) the variety of programs indicate a variety of needs and usage style - implementing one in LibO might make people unhappy with LibO because they don't like the way it handles bibliography, which is not its main object in the first place... so I think that LibO should focus on providing a good and easy to use interface (API?) for other /programs/ that take bibliography/reference as their main business. -- View this message in context: http://nabble.documentfoundation.org/Feature-request-native-BibTeX-support-tp3157370p3158509.html Sent from the Users mailing list archive at Nabble.com. -- Atentamente, Jorge Rodríguez -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Conditional formatting cell copying?
Hi You can do it like this: 1) Select two columns and all rows that you need format. 2) Select Menu-Format-Conditional Format 3) Make the format that you need 4) Accept I know that this conditional format is for all area selected and it didn't show a special cell formula o condition... It looks transparent. Regards, Jorge Rodríguez ___ El mié, 13-07-2011 a las 21:04 +0200, Hylton Conacher (ZR1HPC) escribió: Hi Dave, Thanks for the answer, and sorry for the belated reply, however it doesn't work using LibreOffice 3.3.1 OOO330m19 (Build:8) tag libreoffice-3.3.1.2 On OpenSuse 11.0 You are quite correct that the conditional formulae are copied too, however the formulae still refer to the same cell references given in the copied cell. In other words if you copied cell C3 and pasted special on C4:c10, the conditional formatting would be copied but the cell references in cell C10 for the conditional formatting would point to the same cell as those referenced in cell C3. Please confirm if this is the case. Regards Hylton -- Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A) http://www.fishhoeklionsclub.org.za being part of the worlds largest NGO -- Atentamente, Jorge Rodríguez -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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] [Calc] Create and export chart
Hi I sent an e-mail answer to Mr. Kampe with How to I think he would solve his problems. I sent directly because I think this users@ list not accept add files and I sent three files to him with the answer, because is to hard to explain all with words. If someone wants to know the answer with How to, send an e-mail to this users@ list and I will send a copy. Regards, Jorge Rodríguez ___ El mié, 13-07-2011 a las 19:13 +0200, Thorsten Kampe escribió: Hi, I have a Calc file which contains multiple sheets. - every sheet contains one month of data: from May 2010 to July 2011. - every sheet has two columes: in column A the days and in column B the actual data. For example: [July 2011 Sheet] A B 1 07/02 75.6 2 07/03 3 4 07/04 76.4 5 07/05 76.3 6 07/06 76.2 7 07/07 8 07/08 75.6 The data entries are sometimes empty (07/07 for example), do not always start on the 1st and there are some empty rows in between. Problem 1: I want to create a chart of all sheets/months. What do I have to enter for Date Range in step 2 of the chart wizard (pre-selected is $'July 2011'.$A$1:$B$3)? Problem 2: I'd like to automatically create this chart every day and export it to a PNG file. Is that doable via LibreOffice Calc? Thanks in advance, Thorsten -- Atentamente, Jorge Rodríguez -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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] Ability to change currency as needed across a spreadsheet in Calc?
Hi Excuse me but I think you have another problem (Not only change de currency symbol): The type change currency between USD and other countries (If you want that the people looks a correct value). Regards, Jorge El jue, 14-07-2011 a las 14:05 -0400, planas escribió: Hi Geoff, On Thu, 2011-07-14 at 08:04 -0700, floridabrits wrote: Hello LibreOffice fans... I'm looking for some help with calc on a spreadsheet that I have set up. I'm not sure if it needs a macro set up, or if there's something in LibreOffice that will do this for me, or if I have to seek custom development to do this Here's the problem: - I have a large risk management spreadsheet that contains a number of cells with currency based risk numbers in it; some of these are manually entered by the user and some are calculated from cells where the user enters the information. - Currently, the financial risk cells are all in USD ($) currency. - If I have a user in another country that wants to use this spreadsheet, I'd like that person to be able to either press a button, or select from a drop-down list, a list of available currencies to choose from. - When they choose their currently, I want a macro (or something!) to go and find all the US currency based cells in the spreadsheet and change them to the currency selected by the user. - If I can get this to work, then this spreadsheet could pretty much be used in any country/currency and the user would not have to go into every single currency based cell and make the changes needed (which would be time prohibitive). - i.e. Looking for a minimum click solution to achieve this. I do realize that the local install will change the currency for the user by default, but I want to be able to over-ride this so that if a local user sees the spreadsheet in USD and changes it to, for example, GBP, then when he sends it back to me, I see the numbers in GBP and not my local language setting (which would default back to USD). I hope I have explained this clearly! If not please don't hesitate to ask... Has anyone done this before or have any ideas how to achieve what I am looking for? Many thanks in advance. Regards, Geoff -- View this message in context: http://nabble.documentfoundation.org/Ability-to-change-currency-as-needed-across-a-spreadsheet-in-Calc-tp3169381p3169381.html Sent from the Users mailing list archive at Nabble.com. If I understand you problem, you want to show the currency in a user defined manner. One possibility is to have a cover worksheet that summarizes the data in any currency. You might use a macro to set the proper currency and exchange rates. One idea that might make finding all the cells with data to be converted is to name each one as a one-cell range (ex the cell sheet4!C3 is named 'Fred'). -- Jay Lozier jsloz...@gmail.com -- Atentamente, Jorge Rodríguez -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Base record access unacceptably slow
Hi Thanks you for this tips and to all for Base and data bases tips ! Regards, Jorge Rodríguez El vie, 29-07-2011 a las 17:55 -0700, ponsiarceds escribió: . tomcloyd wrote: , On 07/28/2011 12:53 AM, Tom Cloyd wrote: Ug. This is getting ugly really fast. I'm really not on home ground here at all. FWIW, here is a relatively painless way to install an older JRE along side the default Ubuntu one. ( I'm using Ubuntu 10.10 64bit ) It definitely sped up my Base table browsing, but then I don't have any binaries embedded in my tables. It has the bonus of not messing with the existing JRE Overview: 1. Download the JRE archive (approx. 20 mb) 2. Extract in /tmp 3. as root, copy the extracted directory to /usr/lib/jvm 4. set this JRE as the JRE of choice in LO (ToolsOptionsJava) 5. Exit LO restart Instructions: 1.Download jdk-6u21-linux-i586.bin (for i386) or jdk-6u21-linux-x64.bin for x86_64 from http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html#jdk-6u21-b07-oth-JPR JRE archive at ORACLE . Save to /tmp 2.run it using: sh jdk-6u21-linux-i586.bin . The JRE is now extracted to /tmp/jre1.6.0_21/ 3. copy to /usr/lib/jvm sudo cp -a jre1.6.0_21/ /usr/lib/jvm 4. Exit restart office. In ToolsOptionsJava, choose 1.6.0_21. Exit restart office 5. Load you Base file compare the speed. If you want to remove it simply set the JRE back to the old one in ToolsOptionsJava sudo rm -rf /usr/lib/jvm/jre1.6.0_21/ -- View this message in context: http://nabble.documentfoundation.org/Base-record-access-unacceptably-slow-tp3202820p3211034.html Sent from the Users mailing list archive at Nabble.com. -- Atentamente, Jorge Rodríguez -- Unsubscribe instructions: E-mail to users+h...@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] new book
Thank You Mr. Pitonyak for your Book. El vie, 05-08-2011 a las 09:49 -0300, rogerio dandrea escribió: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Need Calc help
Hi There are two programs that you can use for check the diferences between both files: 1) Meld 2) Kdiff3 Both programs are in the Ubuntu repository. Regards, Jorge Rodríguez __ El vie, 05-08-2011 a las 19:50 -0300, Preston Smith escribió: Hi, Hopefully someone can help me out. I maintain in Calc the regional section of a National membership file of Alumni. There are about 650 members in my regional Calc file. Each record is keyed to an unique College number and consists of about 26 fields of data including First/Last names, address, telephone number, etc. On a monthly basis, the national office sends me a 'pull' in Excel format from their national database. Since changes, additions, and deletions are not annotated by National, I have to manually compare each record in the latest listing with the appropriate record in my files. As you can imagine, doing this manually takes a long time when there are about 650 records involved. Assuming that the Column headers are the same in both files (not necessarily in the same order), is there a way that I can compare the two files to create a listing by College Number of fields that do not agree, and records that have been deleted or added? I am computer savvy but failed programming miserably so I need the input of the many smart people on this list. I do follow instructions well so could be led by the nose to create what is required. Thank you for your patience and help Preston -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] LibreOffice Calc: Format column titles in DataPilot
Hi I suggest you this: 1) Make the pilot data 2) If you format cell orientation (cell of pilot selected), you can chage the orientation (Vertical in grade that you want, except the first column). If you want to change the titles of headers, select the cell and use F2 to do it. 3) If you want to change all the columns headers orientations you can copy the pilot data to other space or sheet and then change the format cell orientation (Menu-Format-Cell) Regards, Jorge Rodríguez _ El mar, 09-08-2011 a las 11:13 -0500, Giovanni Romero Pérez escribió: Hello, everybody! I used DataPilot in LibreOffice Calc, but I would like to format the column headers. More specifically, I want to change the text orientation or these headers. Thank you for your help. GIOVANNI ROMERO PÉREZ -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Calc will not save file after sheet deleted.
Hi Check if the file is opened as read only If it is like that you have to save the file with new name for changing it. Regards, Jorge Rodríguez __ El mié, 10-08-2011 a las 09:46 +1000, Simon Cropper escribió: Hi, I have an old spreadsheet in ODS format. The file was originally an XLS file then converted to ODS format several years ago *and* has been used weekly over that period without any problems. When I try an delete a sheet from the file I get an error Error saving the document FILE: Write Error. The file could not be written. If, prior to attempting the sheet removal, I change the contents of a cell the file is saved without any problems. When the error occurs the saving progress bar appears, moves to ~20% completion stops for several seconds, then progresses to ~80% completion at normal saving speed, stops again for several seconds then crashes. This is in contrast to a normal save where the progress bar moves at a constant rate for the entire saving process. If I attempt to insert a sheet I get the same problem. *I should point out* here that the sheet being deleted and inserted are mid-file, that is I have 18 tabs and I am trying to delete sheet 7. When I insert a sheet I am inserting after sheet 7 or 8 (does not really matter). What I have noticed is if I use the 'add sheet' tab -- that is the last tab with the green '+' sign instead of the name to add a sheet; a sheet can be added and the document saved. This same sheet can be deleted, although the progress bar behaves as if the error is going to happen, that is it pauses at 20% and 80% completion; except this time it finishes without the error dialog appearing. My tests indicate that the last sheet of the original untouched file can be deleted. Like above the progress bar behaves an unusual way but does complete without the error dialog appearing. I can not reproduce the error on a new clean file. If I work back through the historical copies of the file, I can only reproduce the error in this years version. It is as if the file has become partially corrupted. The question is how and can it be easily fixed. Before I spend the time recreating the file from scratch or modifying one of the old backups... *Has anyone encountered or heard of a similar problem?* *Anyone got some ideas?* *Is it worth upgrading LibreOffice?* I am running LibreOffice 3.4.1 OOO340m1 (Build:103) on Ubuntu 10.04 LTS. The java version used is Sun Microsystems Inc. 1.6.0_26, although I have also checked and verified the problem occurs on 1.6.0_20 (which just happened to be on the system). LibreOffice was manually installed from downloaded DEB files *not* installed from the LibreOffice PPA repository or the Ubuntu Software Centre. -- Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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 Calc: Format column titles in DataPilot
Hi I'm sorry but I made an example with Style and the first column header (Title) wasn't changed. Besides, I refreshed the pilot table and lost the headers format. What did I wrong ? Regards, Jorge Rodríguez El mié, 10-08-2011 a las 13:48 +0200, Andreas Säger escribió: Am 10.08.2011 01:57, jorge wrote: Hi I suggest you this: 1) Make the pilot data 2) If you format cell orientation (cell of pilot selected), you can chage the orientation (Vertical in grade that you want, except the first column). If you want to change the titles of headers, select the cell and use F2 to do it. 3) If you want to change all the columns headers orientations you can copy the pilot data to other space or sheet and then change the format cell orientation (Menu-Format-Cell) When you do this by means of hard attributes, they will be lost on refresh. When you do this by means of styles, it applies to the row headers as well. When you copy the pilot you don't have a refreshable pilot anymore. -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Calc will not save file after sheet deleted [SOLUTION]
Congratulations,... it was an interesting investigation. Regards, Jorge Rodríguez __ El jue, 11-08-2011 a las 11:50 +1000, Simon Cropper escribió: On 10/08/11 16:41, Simon Cropper wrote: *The upshot* Unless someone recognised these symptoms and can put forward some ideas, I am treating this as a corrupt file. I have drawn this conclusion because (a) I can only reproduce the error on the effected file, (b) the comment insert/delete trick is suggestive but not consistent (or at least from what I can tell) - random sheets cause the file save error if comments are inserted; inserting comments into new sheets also trigger the error. I just hope that recreating this file does not corrupt the new file as I will need to copy blocks of text, numbers and formulas. *My attempts at recreating a clean file* ATTEMPT 1 Created a new file with one less tab. All tabs were named the same as the original. I then cut-and-paste all the data from the original to this newly created file. This took about 10 minutes. The problem is that all tab / sheet references after the omitted sheet moved across one. Despite the formula referencing the sheet name, the name is actually just a human readable cue for the underlying sheet number. So sheet Accounts (sheet #17 on the original file), which pointed to 'accounts lookup list' now points to the Tax sheet, which was #18 but is now #17 in the new file. ATTEMPT 2 Created a new file with exactly the same number of tabs. All tabs were named the same as the original. I then cut-and-paste all the data from the original to this newly created file. This took about 10 minutes. Then with baited breath I deleted the unrequired sheet that triggered this journey in the first place and clicked save. *It worked* - that is, it saved without triggering a write error. I have checked - (a) all data is intact, and (b) all the formulas are working. :) -- Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Calc will not save file after sheet deleted [FOLLOW-UP]
Hi I'm some confused. Was the comment or the image the problem ? or Both ? Regards, Jorge Rodríguez _ El vie, 12-08-2011 a las 13:52 +1000, Simon Cropper escribió: Hi Everyone, I have been doing some follow-up investigations that I thought you might like to be made aware. First, why? Well after testing the file that I recreated by copying the text, formula and styles I could not cause the error to occur again. This is what I reported yesterday. I then proceeded with importing the few images and 'artwork' objects from the old file to the new. After several saves and sheet manipulations I noticed the file became unstable again. The outcome of my investigation was that one of the image files used on one of the sheets had become corrupted* and adding this file in caused the file to become unstable - eventually exhibiting the problem I mentioned about not being able to save after a sheet was deleted. These 'corrupted' files are relatively benign with the error only becoming apparent *once* you attempt to delete the sheet. So somehow the error caused problems with the broader 'workbook' structure not the sheet structure. Although I compared files between different versions of the file the XML were too varied (usually style names and definitions; content was identical). * note I say corrupted but it rendered OK and only resulted in the observed behaviour one a sheet is deleted. I 'deem' it corrupted as once replaced with a clean version render and saved as a new file by GIMP, the problem disappeared. The error was with the particular corrupt objects. On recreating new images and inserting them into a file I have not been able to trigger any problems. If I cut-and-paste from the original 'corrupt' file the file becomes unstable after a few saves and sheet manipulations. So the steps for salvage is... 1. recreate a new file with the exact number of sheets as the original. Ensure each sheet names are the same. 2. Cut and Paste each sheet. Make sure you 'Paste special' limiting the content being placed in the new file to text, numbers, date time, formulas and formats. 3. If you have images in the file. Recreate / Save using another package. As mentioned I used GIMP. 4. Insert new copies of the images into file. *Don't* cut-and-paste objects from the old file. 5. If you have any lines, text boxes and artwork; recreate them from new. During this process... - Save as a new version (+tabs, +data, +images, +other objects) following each step. - Test each version thoroughly before proceeding. - Only add one object at a time, so if something goes wrong you can isolate the problem component. - To check it is not a bug try and recreate with a fresh file. A couple of quick notes that may be valuable to others... - ODS files are archives. Use an archive facility to extract the data inside. Inspect the contents in the folders to see what is different. - On every 'Save as' the file size changes. This is not due to changes in the file contents, but rather in changes in how the components of the file is compressed/archived. If you open a file, add objects then save, the file size with be so big. Open that file and Save as a new name and the file will be a different size. If you extract the files the contents of all the files and directories are identical. It is just the internal archive facility in LO will decide the best compaction routine based on what it encounters. - The content.xml file can be quite large and has no internal end-of-line characters. This make it difficult to open and be parse by various text editors, xml viewers and comparison facilities. To insert a EOL character after the end of each tag (i.e. ), I used the following command in the terminal (requires Linux). cat content.xml | sed -e 's//\n/g' content_with_linebreaks.xml cat just spews the content of the text file to the standard output. I then pipe it to sed, where I used regular expressions to find '' and replace every instance of it with '\n'. I then compared the contents with Diffuse. On 11/08/11 14:44, jorge wrote: Congratulations,... it was an interesting investigation. Regards, Jorge Rodríguez __ El jue, 11-08-2011 a las 11:50 +1000, Simon Cropper escribió: On 10/08/11 16:41, Simon Cropper wrote: *The upshot* Unless someone recognised these symptoms and can put forward some ideas, I am treating this as a corrupt file. I have drawn this conclusion because (a) I can only reproduce the error on the effected file, (b) the comment insert/delete trick is suggestive but not consistent (or at least from what I can tell) - random sheets cause the file save error if comments are inserted; inserting comments into new sheets also trigger the error. I just hope that recreating this file does not corrupt the new file as I will need
Re: [libreoffice-users] Re: LibreOffice Calc: Format column titles in DataPilot
Hi Thank you, I understand now. I used it as you say and I could modify all the headers (The first Column included), but the data headers (Where the sum, average or other calcs are), change to its original formats when the pilot data is refreshed (The first column header and Data Title keep its format changed. Regards, Jorge Rodríguez _ El jue, 11-08-2011 a las 11:24 +0200, Andreas Säger escribió: Am 11.08.2011 01:28, jorge wrote: Hi I'm sorry but I made an example with Style and the first column header (Title) wasn't changed. Besides, I refreshed the pilot table and lost the headers format. What did I wrong ? The pilot uses one distinct set of automatically generated styles. For column headers in the English GUI the style is named DataPilot_Category. When the pilot is rebuilt on refresh, all formatting falls back to that style. - Application of some other style will be reset to DataPilot_Category. - Hard attributes will be reset to the bare DataPilot_Category settings. - Modifying DataPilot_Category itself will format both, row headers and column headers. -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Calc will not save file after sheet deleted [FOLLOW-UP]
Hi I don't know what will be happening. But I think that if in other computer or program LO 3.3.2 you don't have problem to use the file, ...the file ins't corrupted and newer LO neither. I think that Vista or the OpenOffice 3.1.0 would lose something as program by whatever way and / or the computer where you have it installed has something fisical bad. I suggest you a probe (If you have some free time): Why not install again OpenOffice 3.1.0 in other computer and try to use the file? (With and without new Vista installation) Regards, Jorge Rodríguez ___ El vie, 12-08-2011 a las 16:04 +1000, Simon Cropper escribió: *** Jorge, as I respond to your email I find out a range of things of note, as I try and support or refute my ideas. It is enlightening to read the entire post but you can just as easily jump to HERE *** Sorry Jorge, I suppose it is confusing. The problem is the corruption due to the insertion of the image is not immediately obvious. Then as the file becomes more progressively more corrupt. The sequence was like this 1. Cut-and-paste data 2. Reinsert images and objects 3. Other stuff... 4. Issue with comments noted What surprised me was after recreating a clean file for use I then ended up with an error popping up. No comments were found anywhere. So I stripped the file back to the individual components -- data, format, images, etc. Adding each one separately then testing extensively. On adding the images I noted some funny stuff happening to the file size. as I saved, re-saved, deleted sheets, re-saved, etc... I noticed that the file showed more problems rendering images (images disappeared as well as references to files disappeared). Soon afterwards the file had problems saving after deletion of the sheet. So I presume that the images caused the corruption of the structure, the problem progressively got worse, then the comments field tipped the scale and caused the error in saving after the deletion of the sheet. anyway that seems as plausible as any explanation I have seen already. As stated I am unable to reproduce these errors on new files. despite trying repeatedly for hours. As stated previously I was able to shake the problem by cutting-and-pasting the data into the spreadsheet. This included everything images and all. I could not trigger the error despite hours of testing. Consequently I posted the 'solution' to this thread. After several hours of adding and deleting data, the problem reappeared. As stated I then recreated the file including data-formula-format, minus other objects then progressively built up the file until it mimicked the original. Each step I tested, retested and checked yet again. In the end I noted things got 'wonky' after insertion of the images-artwork. this did not particularly make sense to me but I persisted in splitting the objects being inserted in the document until I could identify the culprit. This eventually identified a single image (originally a GIF that was converted to a PNG). Add this image to the sheet and progressively problems appear. If I recreate a PNG file using GIMP and insert this I can't get the problems to appear. This is using the same file, data and files - side by side. Very confusing. There is only two conclusions (a) that the file is corrupt, something corrupted it and at present the first thing I notice a problem occurring after it is inserted is this image. (b) that LO accesses and manipulated the file incorrectly. In other words their is a bug in the code. As I am not inclined to post a file with all my financial details on the Internet, and I have no other versions of LO around to test the second theory I am in a quantry. HERE Well... As it turns out I have an old version of OpenOffice 3.1.0 OOO310m11 (Build: 9399) lying around on an old Windows Vista laptop I was unaware about. Exact same file (except for one computer is accessing the local drive and the other a SAMBA network drive)... - LO baulks with the error blah blah unable to write - OO does not! Wh? Alright I am on Ununtu. I opened a copy of the file via nautilus from a local drive mounted using fstab - the error occurs. If I use nautilus to locate and access the same samba share the windows machine used - the error occurs. Somehow I am relieved. OK, I test using another machine ubuntu-ubuntu using LO 3.3.2, both via a NFS mount and Samba share. Both sheet deletions and saved worked on the exact same file that my machine baulks with - that is the error did not occur. I am bloody confused! The problem is computer specific and file specific. As part of the entire exercise I completely uninstalled every LO related package and reinstalled them with all the dependencies. I have check and rechecked the file permissions, ownerships and groups. Nothing untoward
Re: [libreoffice-users] Opening PDF files in Draw
Hi Excuse me, but it is important to know what do you need to do with PDF file: Edit, copy something...? It is because you would use other programs specialized for that. OCR program is used for images txt documents for example. If your PDF document haven't image txt datas you don't need OCR program to access the PDF document. Regards, Jorge Rodríguez _ El sáb, 13-08-2011 a las 18:21 -0400, R. Derek Pattison escribió: Hello all, Is there a way to open a PDF file in Draw, or another LibreOffice program, without having the program use OCR? I have some PDF files that are basically just pictures of book pages and when LibreOffice tries to parse the mediocrely-scanned text it becomes unreadable. Thanks in advance for any help! Derek -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Opening PDF files in Draw
Hi You can look this other program: http://code.google.com/p/formulatepro/ http://code.google.com/p/formulatepro/downloads/list Regards, Jorge Rodríguez _ El dom, 14-08-2011 a las 20:38 -0400, R. Derek Pattison escribió: Thanks everyone! Derek On Aug 14, 2011, at 5:11 PM, Steve Edmonds wrote: Hi. In preview you can split and join PDFs. Print the individual page or groups of pages you want as a pdf. Then in preview open the first pdf, drag subsequent PDFs into the thumbnail side bar viewer thingy in the order you want and then save the whole thing as your new PDF. As for editing, if the text is text, I can edit it in Draw. If the text is an image, opening in Gimp enables me to delete the current text (to a white background) and then type in new text with the text tool. From Gimp I can print to file as a PDF. Then join the PDFs in Preview. steve On 15/08/11 8:44 AM, R. Derek Pattison wrote: So to clear a couple things up, first I am on a Mac, not Linux. Secondly, there is no particular reason I /have/ to use LibreOffice to edit the PDFs, I could use another PDF editor, but since OpenOffice was a suggestion given in a GoogleSearch, and I already used LibreOffice, I thought I would try it. Also, I was hoping to use something free, since this is not for anything professional, just for personal purposes. I’ve used Preview on my Mac, and it does like 75% of what I want, but the ability to copy pages from one PDF to another and merge them or cut one PDF into multiple ones eludes me, which is why I was trying with LibreOffice. But as I said, it tends to try and read the pictures of words as text, and since the scans aren’t that great, it ends up just being gobbledygook. I tried the plugin suggested in a previous post, but that was already installed in my default install of LibreOffice. I will try GIMP and maybe some other image editors and see if they work for what I need. Any other suggestions are welcome! Thanks, Derek On Aug 14, 2011, at 2:44 PM, Steve Edmonds wrote: Hi Tom. You should be able to Print to PDF from Gimp. steve On 15/08/11 6:34 AM, Tom Davies wrote: Hi :) Ahah, I edit pictures and stuff in Pdfs using Gimp. Draw might do it and now the official Draw documentation has been released i might be a bit more happy about trying Draw. The problem with doing this using Gimp is that i can't save as pdf from Gimp. Regards from Tom :) From: Johnny Rosenberggurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Sun, 14 August, 2011 7:34:13 Subject: Re: [libreoffice-users] Opening PDF files in Draw 2011/8/14 planasjsloz...@gmail.com: Hi Derek, On Sat, 2011-08-13 at 22:22 -0400, R. Derek Pattison wrote: Hi Jorge, Basically I want to do some minor editing of the pictures in the PDF. Delete some pages, move some from one document to another, delete parts of pages. The problem is that LibreOffice is trying to interpret the text in the images as text and that makes it unreadable. I just want to edit them as images. Thanks, Derek Why do you need to do that in LibreOffice? There are other software out there, you know… Tried PDF edit? If you have Ubuntu it's in the repositories (or ”sudo apt-get install pdfedit” in a terminal). Regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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: export sql to odb?
Hi I used many years ago access data base and I remember that you can export de data base to spreadsheet (excel). Then you would do: 1) Open Base program and open directly the excel spreadsheet and save as data Base. or 2) Open the excel spreadsheet with Calc, save as .ods and then open Base and import the spreasheet .ods. Both methods permit change your original data base to native LO Data Base. Regards, Jorge Rodríguez ___ El lun, 15-08-2011 a las 09:33 +0100, Dave Sergeant escribió: Perhaps drifting off thread a little. I have a DBF database which dates back many years - in fact to Lotus Works in MS DOS days. It works well via LO Base, once one has worked out how to do it, which is far from obvious. I have often wondered whether it is worth converting this to a native LO database, ie on the lines of your mentioned HyperSQL. I guess it is not, and in fact I would guess that most users only use Base as an interface to other database formats. The 'Help' in LO, practically identical to that in OOo, is far from helpful and is pretty short of practical guidance. Every time I look at it it leaves me confused. Maybe an 'idiots guide' to using Base in real life situations, as part of the installation, is long over due. It would reduce all these sorts of threads. Dave On 15 Aug 2011 at 16:24, Simon Cropper (The foss Workflow Guides) wrote: Base is primarily a translator between various backends and LibreOffice. It does however use HyperSQL [1, 2] to create stand alone databases. [1] http://hsqldb.org/ [2] http://hsqldb.org/web/hsqlUsing.html This is a relational database engine written in Java. http://www.davesergeant.com -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Kexi
Hi Many days ago some of us were talking about BASE and its problems. One of you noted about Kexi base program that's part of Office Suite of KDE ... as alternative of BASE. I installed that Office suite in Fedora 15 and opened access 2003 data base that I have. I can't probe with 2007 access data base because I don't have an example of that. I'm not use it a lot but it looks good. I suggest to others to test it if have time and are interested because it would be an alternative to BASE if it won't improve in the next time. I have to say that the KDE complete Office suite (Included Kexi) isn't in Ubuntu 10.04 lts repositories. I think is a recently improved program of KDE. I hope this post help some one though it isn't part of LO. Regards, -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Kexi
Hi Thank you Tom for this adicional information. Regards, Jorge Rodríguez El lun, 22-08-2011 a las 02:54 +0100, Tom Davies escribió: Hi :) Kexi is the database app in Calligra. Calligra is a fork of KOffice. KOffice gave all their remaining database devs to Calligra and dropped their version of the database. Calligra seems very active. Unfortunately Calligra and KOffice are really quite dependant on the K Desktop Environment (KDE). They do have a port for Windows (and possibly Mac, i'm not sure). Calligra have also developed a few apps that can work on mobile platforms but that doesn't include Kexi yet. So, the non-KDE versions of distros are going to ask for a lot of dependencies, probably Qt libraries and stuff. You will probably need to add the appropriate official repos. For Ubuntu you can try sudo apt-get install kubuntu-desktop to install all of Kubuntu into Ubuntu but you might want to revert to your Gnome or Unity DE at the login prompt (have a look along the bottom task-bar/panel when you get the login prompt). A few people are now working on Base. A couple of devs and i think 1 for documentation (might be 2). It is a tough challenge but that makes it fun right? Regards from Tom :) From: jorge jrodrigue...@cpcecr.com To: users@global.libreoffice.org Sent: Mon, 22 August, 2011 1:30:27 Subject: [libreoffice-users] Kexi Hi Many days ago some of us were talking about BASE and its problems. One of you noted about Kexi base program that's part of Office Suite of KDE ... as alternative of BASE. I installed that Office suite in Fedora 15 and opened access 2003 data base that I have. I can't probe with 2007 access data base because I don't have an example of that. I'm not use it a lot but it looks good. I suggest to others to test it if have time and are interested because it would be an alternative to BASE if it won't improve in the next time. I have to say that the KDE complete Office suite (Included Kexi) isn't in Ubuntu 10.04 lts repositories. I think is a recently improved program of KDE. I hope this post help some one though it isn't part of LO. Regards, -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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 -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Kexi
Hi You are right. We can't use .kexi DB with other program. It isn't a standard file. I hope than in the future they change it. Regards, Jorge Rodríguez _ El lun, 22-08-2011 a las 16:34 -0400, Don Parris escribió: I have been looking at Kexi as well. As I understand it, Kexi currently offers read-only access to DBs not actually created from within Kexi. If you have already created a database, you will not have write access to that DB. That said, if you create the DB from within Kexi, you can use it more or less as a front-end. I haven't tried it yet on my Debian-KDE box, but I may do just that. I think Calligra is going to be worth watching. I have used Base and learned a fair amount in the process. Based on the number of postings about Base here on the list, I certainly hope it gets more attention. I would offer to jump in, but I honestly can't code my way out of a wet paper bag. :-( I have used OOo/LO for several years now, but mind you, I am supportive of most libre projects. Don On Mon, Aug 22, 2011 at 05:59, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) You are welcome. I just stumbled on that info just before reading your post. I had heard of Kexi and Calligra before and had a quick hunt around their site and wikipedia but just before your post i'd had to look a bit deeper. Spooky timing! :) Regards from Tom :) From: jorge jrodrigue...@cpcecr.com To: users@global.libreoffice.org Sent: Mon, 22 August, 2011 7:41:21 Subject: Re: [libreoffice-users] Kexi Hi Thank you Tom for this adicional information. Regards, Jorge Rodríguez El lun, 22-08-2011 a las 02:54 +0100, Tom Davies escribió: Hi :) Kexi is the database app in Calligra. Calligra is a fork of KOffice. KOffice gave all their remaining database devs to Calligra and dropped their version of the database. Calligra seems very active. Unfortunately Calligra and KOffice are really quite dependant on the K Desktop Environment (KDE). They do have a port for Windows (and possibly Mac, i'm not sure). Calligra have also developed a few apps that can work on mobile platforms but that doesn't include Kexi yet. So, the non-KDE versions of distros are going to ask for a lot of dependencies, probably Qt libraries and stuff. You will probably need to add the appropriate official repos. For Ubuntu you can try sudo apt-get install kubuntu-desktop to install all of Kubuntu into Ubuntu but you might want to revert to your Gnome or Unity DE at the login prompt (have a look along the bottom task-bar/panel when you get the login prompt). A few people are now working on Base. A couple of devs and i think 1 for documentation (might be 2). It is a tough challenge but that makes it fun right? Regards from Tom :) From: jorge jrodrigue...@cpcecr.com To: users@global.libreoffice.org Sent: Mon, 22 August, 2011 1:30:27 Subject: [libreoffice-users] Kexi Hi Many days ago some of us were talking about BASE and its problems. One of you noted about Kexi base program that's part of Office Suite of KDE ... as alternative of BASE. I installed that Office suite in Fedora 15 and opened access 2003 data base that I have. I can't probe with 2007 access data base because I don't have an example of that. I'm not use it a lot but it looks good. I suggest to others to test it if have time and are interested because it would be an alternative to BASE if it won't improve in the next time. I have to say that the KDE complete Office suite (Included Kexi) isn't in Ubuntu 10.04 lts repositories. I think is a recently improved program of KDE. I hope this post help some one though it isn't part of LO. Regards, -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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 -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
[libreoffice-users] Kexi Data Base as Alternative of Base of LO
Hi Excuse me if I don't understand very well but not allways I understand all the english meaning languaje. But I try ! I did a new topic as I understood your coment. Excuse me if I bother you with this topic but I think it would be important for someone. I red that we can use Sqlite 3 to access .kexi data base file and I installed Sqliteman (front end of Sqlite) and accessed it and made changes and save it. Then I opened with kexi again and they was recognized. Regards, -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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: Kexi Data Base as Alternative of Base of LO
Excuse me: I read (past) not red (pronunciation) Regards, Jorge Rodríguez _ El mar, 23-08-2011 a las 19:44 -0600, jorge escribió: Hi Excuse me if I don't understand very well but not allways I understand all the english meaning languaje. But I try ! I did a new topic as I understood your coment. Excuse me if I bother you with this topic but I think it would be important for someone. I red that we can use Sqlite 3 to access .kexi data base file and I installed Sqliteman (front end of Sqlite) and accessed it and made changes and save it. Then I opened with kexi again and they was recognized. Regards, -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Alternative to Outlook
Hi I'm using Evolution and it has e-mail, contacts, shedule, jobs and notes. I think it is a complete program for business and for personal use. The only think that I would think improve is that notified with sound and message to the screen when it's time to do something (jobs for ejamples). Regards, Jorge Rodríguez El mié, 07-09-2011 a las 22:56 -0700, At0mic escribió: I notice some people are talking about Thunderbird and other alternatives to Outlook. I should probably remind some people that Outlook is not just a mail client. It has a Calendar, Tasks manager, voting system, and a few other titbits that all exist within the same application which gives it a very high level of integration. The problem is that this integration is very important for a lot of people in the corporate world, and an ad hoc bundling of various applications to do the same stuff but not quite as well integrated might not sit well with some people, particularly if you can't give the same level of functionality. Outlook is what it is not just for the email side of things. -- View this message in context: http://nabble.documentfoundation.org/Can-Libre-Office-be-installed-on-an-external-drive-tp3309620p3318776.html Sent from the Users mailing list archive at Nabble.com. -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Adopting LibreOffice in Corporate Environments
+1 El vie, 09-09-2011 a las 07:21 +0100, Onyeibo Oku escribió: I felt it only logical to make this discussion a new thread. It appears interesting. I suspect it wont be the first time it is discussed and I do hope the Devs take such comparative discussions seriously. That said, I'd like to start with a Quote from At0mic: Aye. It's just that working in the real world as opposed to ranting on a Linux forum showed me how far Linux and open-source has to go for even making a dent in the monopoly Microsoft has on the corporate desktop. It would be NICE of course if Libre/OpenOffice was used more, but it isn't, and there isn't as yet much imputus to change. Change, as constant as it is doesn't come easy for the majority. Habits are hard to break even when proven wrong. Microsoft is both a majority and a habit and it takes the daring and strong to be free. Linux and open-source is not a place for lazy people. Change starts when enough people question status-quo. When I released this, I decided it's better to stop being so fanatical about Linux and open-soruce and instead understand WHY people use things such as Outlook so much, and I discovered it's because Microsoft are damn good at finding out what their customers want. Implementation needs a little work sometimes, but they aren't stupid. That's a good one. Guess what people want? The want to get on with their lives and really done care how the catalysts get created. So, it follows that if they're already doing that with Option-A, they wont see reasons to try Option-B even when Option-B may be more suitable for them. I speak based on observations from my environs. People here use M$-Office not because they know about exchange or cool features like automation. They do so because they first knew M$-Office. 90% of these people cant understand serious formula syntaxes for Excel or Calc. They are happy with Summations only or a few more basic stuff. Guess what? I'm discussing business here not individuals. You and I know that Calc will conveniently replace their pirated bloat-ware (bloat-ware because they use less than half the features packed into it ... and worse, its a hacked product). These are the people who need Calc and open-source products the most. They cant afford bloat-ware but for some weird reason they just want the label -- Hey, I know/use M$-Office too -- Its crazy Like you said, Microsoft knows how to take advantage of their customer's inclinations (its about the money eventually). These people are lazy so 'ease' matters. Implementation may not be so good underneath but who cares ... they don't even see it. So they 'dope' the less enlightened majority with 'ease' while they tidy up on the hidden mess gradually. It works because changing the majority's collective choice later will be harder when the habit is formed. Here is another example: For instance, I have been porting a tool I developed for 'easing' the pain of fellow lecturers in creating grade/result sheets at our University. It was written for Excel 2003 in VBA. It was relatively 'easier' to develop compared to my route in LibreOffice (well that, because I chose a different language. BASIC would have been much the same ... probably). My discovery is that developing extensions for LibreOffice is W.O.R.K! What is the advantage? The developer is made more aware of the internal workings of LibO. What is the loss? Time! The curve is much more and someone who wants to get going is already gone. So the 'ease' concept sells again for macro developers in M$ world but that doesn't make for better/experienced 'black-belt' developers in the long run (... yeah, I can hear you almost say 'who cares!'). Getting LibO into offices around here means presenting it first before M$ products find their way into those machines. Then the users will never try M$ again even with all the vanilla coatings they come with --OR-- You induce the change by providing 'ease' in form of Extensions in LibO and install libO with those for those businesses then carefully silence M$ products. They wont even miss it. I do that here because those M$ products are pirated anyway. It just makes them more honest business men (lol!). I bet they wont consider M$ again when they're told to PAY FOR THE REAL THING! -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Should LibreOffice even support Microsoft secret formats?
Hi I agree with you Regards, Jorge Rodríguez El sáb, 10-09-2011 a las 15:08 -0500, Anthony Papillion escribió: I agree, but is not supporting saving in secret formats really isolating them from the rest of the world? Especially if the other software can read the open format, wouldn't it be preferable to just tell them 'don't worry about it, you're compatible' and leave it at that? Besides, I'd think that creating a plugin that helps Microsoft Offices users read .odf files is a lot easier than constantly playing catchup with the secret Microsoft formats. Anthony Subject: Re: [libreoffice-users] Should LibreOffice even support Microsoft secret formats? To: users@global.libreoffice.org From: twoho...@gmail.com Date: Sat, 10 Sep 2011 19:45:02 + Makes sense but u need to be able to reach others. I think the edge is in supporting a broader range of options not just the vendors. Those moving to opensource solutions need an air of security that they are not isolated from the rest of the world - from twohot@device.mobile :) -Original Message- From: Anthony Papillion papill...@gmail.com Sender: anth...@cryptofreaks.tk Date: Sat, 10 Sep 2011 14:28:27 To: LibreOffice Mailing Listusers@global.libreoffice.org Reply-To: users@global.libreoffice.org Subject: [libreoffice-users] Should LibreOffice even support Microsoft secret formats? I've been thinking a lot about this lately as many of my clients are coming to LibreOffice from Microsoft Office and I deal with both packages quite a bit. Many times, one of the first things I do once LibreOffice is set up is to show clients how to save in Microsoft format as opposed to .odf. It's actually one of the first questions they ask. Lately, I've been wondering about the wisdom of an open source package actively supporting a secret format like the Office ones. Would it not be preferable to support *only* saving in the open document format and then providing a plugin for Microsoft Office users who needed it? IMHO, allowing users to save in secret formats just continues the problem. They're still using proprietary software, just packaged a different way. Thoughts? Cheers, Anthony -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] LibreOffice / OpenOffice Calc very slow with Excel File
Hi I suggest you to do this (I did and it was good with your sample.xls file)(But I did with OpenOffice 3.2 but I supposed it will be good too with LO): 1) Open file with LO. 2) Save file in format microsoft excel 5.0 (xls) with Save As Menu I did and the file was opened fast and well. Then I used that file to save as .ods and all was well too. Regards, Jorge Rodríguez ___ El dom, 25-09-2011 a las 22:01 +0530, Vinod Nadiadwala escribió: Hi, there I am using LibreOffice 3.4.3 on Windows 7, i am moving my ogranization office suite to LibreOffice from ms-office, but having some issues with large excel files, most of the excel files works very very slow with libreoffice, i have searched google but unable to find the solutions, you can download sample file from the following URL which i have uploaded to my organization website. http://www.bhushitech.com/downloads/sample.xls (File Size: Around 8 MB ) This is lowest size which i have, if i open this file in excel it works well, but when i try to open it with LibreOffice Calc application it works very slow, i have also tried it with OpenOffice 3.3 but still the issue is same. I have also tried converting it to the .ODS using fileconverter.com, file size dramatically reduced (Around 300kb only) but still it takes around 15 min to open the file, and after opening if i move cursor it take lot of time to move from one screen to another screen. (MY PC Configuration is enough good, so the configuration is not an issue, as i have also tried it on IBM X3400 SERVER's with 16 GB Memory) Vinu -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Symbols: alpha
Hi You can select in Writer or Calc, menu: Insert-Symbol-Subset-Basic Greek and there you found alpha symbol and other like this. Regards, Jorge Rodríguez __ El jue, 29-09-2011 a las 20:21 +0200, Johnny Rosenberg escribió: 2011/9/29 H.S.Rai hardeep@gmail.com: In OpenOffice, there was provision to insert symbols like: %aplha but I found this method is not working in LO Could it be that you spelled it wrong, like you did above? Or why not just entering the Unicode for it (α=U+03B1)? You didn't mention your operating system and desktop environment, but Gnome users type Ctrl+Shift+u 03b1 Enter. You could also add it to your auto-correction table, but that is not as convenient in some situations. There are other methods as well, but that's probably not what this was all about… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ May I know how we can type such symbols, not by using icon / mouse, rather by typing as such? -- H.S.Rai -- For unsubscribe instructions e-mail to: users+h...@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 -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Impress PowerPoint
+ 1 El lun, 03-10-2011 a las 10:46 +0100, e-letter escribió: On 02/10/2011, Mr. Jack Nash III jack.n...@familianash.com wrote: All, Has anyone been able to get PowerPoint´s to display correctly in LibreOffice Impress? I am having a lot of trouble with .ppt and .pptx presentations, as they simply do not display well in LibreOffice. The background, the text, the formatting, is all messed up and distorted. No, why should it? The priority is display of odf format documents. Since you are experiencing difficulty, pay m$ and use their formats; they are irrelevant to LO. It would be higher priority and more interesting to know: does m$ view odp documents correctly? is any failure due to LO failing to adhere to the odf standard? is failure due to m$ failing to adhere to the odf standard? Answering these questions should enable you to send your questions to the appropriate software supplier ;) -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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-marketing] Interviewer, anyone?
Hi I would be an interviewer but I want to know more about that: 1) How good have to be my english ? 2) Who is the person that I will interview ? 3) How is going to be the interview: chat, write, videoconference ? and more so on ... Regards, Jorge Rodríguez ___ El mar, 04-10-2011 a las 19:41 +0100, Tom Davies escribió: Hi :) Does anyone have marketing experience or is anyone interested in doing some voluntary work in marketing? There is a one-off task that could be a good start. You could draft the questions in advance to get feedback from the marketing list. Regards from Tom :) --- On Tue, 4/10/11, Florian Effenberger flo...@documentfoundation.org wrote: From: Florian Effenberger flo...@documentfoundation.org Subject: [libreoffice-marketing] Interviewer, anyone? To: market...@global.libreoffice.org Date: Tuesday, 4 October, 2011, 12:35 Hello, is there really nobody outside who would like to work on the interview for the Hackfest? We should get this one done rather soon, as the Hackfest has been a month ago, but at the moment, my time is really low due to many other TDF work I do. Doesn't someone of you want to be an interviewer and ask one of our fellow developers some nice questions about the Hackfest? :-) Florian -- Florian Effenberger flo...@documentfoundation.org Steering Committee and Founding Member of The Document Foundation Tel: +49 8341 99660880 | Mobile: +49 151 14424108 Skype: floeff | Twitter/Identi.ca: @floeff -- Unsubscribe instructions: E-mail to marketing+h...@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/marketing/ All messages sent to this list will be publicly archived and cannot be deleted -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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-marketing] Interviewer, anyone?
Florian: I think that I can do because I usually understand the e-mails of the users@global list. I suggest this way: 1) I will prepare some questions for the interviewed and I will send him o her. 2) I will receive his o her answer of the questions. 3) I will prepare a second group of questions from his or her answer (2))to know more about him or her and their activities and thoughts. 4) I will order all the questions and answers and send them where you say and in the document format you need (.odt or .pdf or .txt). Regards, Jorge Rodríguez ___ El mié, 05-10-2011 a las 09:12 +0200, Florian Effenberger escribió: Hello, thanks for your interest! jorge wrote on 2011-10-05 02:29: 1) How good have to be my english ? it should be a good English, since we want to publish the interview in printed form and you need some understanding of the responses. It is about the progress and achievements at the Hackfest that took place at the beginning of September. 2) Who is the person that I will interview ? One of our developers volunteered to be interviewed. 3) How is going to be the interview: chat, write, videoconference ? Best would be via e-mail. Florian -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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-marketing] Interviewer, anyone?
Ok Tom, Thank you. Jorge Rodríguez __ El jue, 06-10-2011 a las 09:56 +0100, Tom Davies escribió: Hi Jorge :) I think you are likely to do a good job. Don't worry about trying to write perfect English and also try not to spend too much time on it. The aim is to get them talking and that might be easier if everyone is relaxed and friendly. Just my 2 euros Regards from Tom :) --- On Wed, 5/10/11, jorge jrodrigue...@cpcecr.com wrote: From: jorge jrodrigue...@cpcecr.com Subject: Re: [libreoffice-users] Re: [libreoffice-marketing] Interviewer, anyone? To: Florian Effenberger flo...@documentfoundation.org Cc: users@global.libreoffice.org Date: Wednesday, 5 October, 2011, 18:34 Florian: I think that I can do because I usually understand the e-mails of the users@global list. I suggest this way: 1) I will prepare some questions for the interviewed and I will send him o her. 2) I will receive his o her answer of the questions. 3) I will prepare a second group of questions from his or her answer (2))to know more about him or her and their activities and thoughts. 4) I will order all the questions and answers and send them where you say and in the document format you need (.odt or .pdf or .txt). Regards, Jorge Rodríguez ___ El mié, 05-10-2011 a las 09:12 +0200, Florian Effenberger escribió: Hello, thanks for your interest! jorge wrote on 2011-10-05 02:29: 1) How good have to be my english ? it should be a good English, since we want to publish the interview in printed form and you need some understanding of the responses. It is about the progress and achievements at the Hackfest that took place at the beginning of September. 2) Who is the person that I will interview ? One of our developers volunteered to be interviewed. 3) How is going to be the interview: chat, write, videoconference ? Best would be via e-mail. Florian -- Atentamente, Jorge Rodríguez -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Working on an archive site/pages for LO and the DVD[s] I have been working with
Hi I think that usually some people refers that 3.3.x is more stable than 3.4.x and say too which is better for workstation and wich for experimental. But usually forget to explain in simples and few words the features differences between both that are very necesary to decide what version we would use. I suggest to make a list features that 3.4.x has and hasn't has 3.3.x. I suggest include a general descripcion about code changes that not take change in features but yes in efficient. Regards, Jorge Rodríguez ___ El jue, 06-10-2011 a las 21:12 -0400, webmaster for Kracked Press Productions escribió: I have had the idea for a few months now, so I figured it was time to start working on it. The original NA-DVD site has a set of archive pages for the installs that went into the NA-DVD[s]. There are all of the OSs and the language and help packs that were linked within the default install page[s]. This version of the site pages will have the contents of the DVDs, but will have installs for: 3.3.2, 3.3.3, 3.3.4 3.4.1, 3.4.2, 3.4.3 plus the new ones when they come out. See what you think. I need to work on the wording to describe the differences between the 3.3.x line and the 3.4.x line. I could use some words to describe what line is best to use where. I know that soon the 3.4.x line will be enterprise ready and the most stable and cutting edge words soon will not be the best. Also, when 3.5.x line comes out, most stable will be describing 3.4.x versions. So maybe not using that phrase would be better for marketing. http://libreoffice-na.us/multi-version/install.html Any advice could be helpful. -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Working on an archive site/pages for LO and the DVD[s] I have been working with
Hi And simple list about bugs solve in 3.4.x and exist in 3.3.x Thanks for your idea and job, Regards, Jorge Rodríguez ___ El vie, 07-10-2011 a las 15:45 -0600, jorge escribió: Hi I think that usually some people refers that 3.3.x is more stable than 3.4.x and say too which is better for workstation and wich for experimental. But usually forget to explain in simples and few words the features differences between both that are very necesary to decide what version we would use. I suggest to make a list features that 3.4.x has and hasn't has 3.3.x. I suggest include a general descripcion about code changes that not take change in features but yes in efficient. Regards, Jorge Rodríguez ___ El jue, 06-10-2011 a las 21:12 -0400, webmaster for Kracked Press Productions escribió: I have had the idea for a few months now, so I figured it was time to start working on it. The original NA-DVD site has a set of archive pages for the installs that went into the NA-DVD[s]. There are all of the OSs and the language and help packs that were linked within the default install page[s]. This version of the site pages will have the contents of the DVDs, but will have installs for: 3.3.2, 3.3.3, 3.3.4 3.4.1, 3.4.2, 3.4.3 plus the new ones when they come out. See what you think. I need to work on the wording to describe the differences between the 3.3.x line and the 3.4.x line. I could use some words to describe what line is best to use where. I know that soon the 3.4.x line will be enterprise ready and the most stable and cutting edge words soon will not be the best. Also, when 3.5.x line comes out, most stable will be describing 3.4.x versions. So maybe not using that phrase would be better for marketing. http://libreoffice-na.us/multi-version/install.html Any advice could be helpful. -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Working on an archive site/pages for LO and the DVD[s] I have been working with
Hi Thank you Jay and Tom for your information. Regards, Jorge Rodríguez ___ El vie, 07-10-2011 a las 18:49 -0400, planas escribió: On Thu, 2011-10-06 at 21:12 -0400, webmaster for Kracked Press Productions wrote: I have had the idea for a few months now, so I figured it was time to start working on it. The original NA-DVD site has a set of archive pages for the installs that went into the NA-DVD[s]. There are all of the OSs and the language and help packs that were linked within the default install page[s]. This version of the site pages will have the contents of the DVDs, but will have installs for: 3.3.2, 3.3.3, 3.3.4 3.4.1, 3.4.2, 3.4.3 plus the new ones when they come out. See what you think. I need to work on the wording to describe the differences between the 3.3.x line and the 3.4.x line. I could use some words to describe what line is best to use where. I know that soon the 3.4.x line will be enterprise ready and the most stable and cutting edge words soon will not be the best. Also, when 3.5.x line comes out, most stable will be describing 3.4.x versions. So maybe not using that phrase would be better for marketing. http://libreoffice-na.us/multi-version/install.html Any advice could be helpful. Could describing the difference as the newer release has more features and is undergoing major development while the earlier release is being concurrently supported and updated for 1 year (whatever the long term support period is). Allowing users the choice of using the current release series or beng able to use the older series allowing them to upgrade at their convenience. This similar to Ubuntu's LTS release, the LTS is support for 3 years for Ubuntu while the other releases are supported for 18 months. Note Ubuntu is currently using 3.4.3 as yesterday/today, 3.3.4 was upgraded to 3.4.3 on my box today. -- Jay Lozier jsloz...@gmail.com -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Working on an archive site/pages for LO and the DVD[s] I have been working with
Hi I'll try to contribute with something. I think that a LTS version of whatever product has to do the job well (Their main performance for which it was made). In this case, LO Software, I think that if It makes well all thinks that the Menu expose, it is a LTS version because it is able to solve users usual needs. What about bugs. I think that the bugs usually are special features that we expect of LO, ... In others words, if there is a bug or bugs that affects the calcs (actions), that we usually hope to do with the Menu, that bug afffects seriously the version and it can't be LTS. And I think too that is necesary to support what ever official LTS version until comes another new LTS version. I analized this thinking in a company, profesional or student. What they need ? At least that the software does what it says that it can do (On the Menu- Its performance). Regards, Jorge Rodríguez ___ El dom, 09-10-2011 a las 12:05 -0400, planas escribió: Cor On Sun, 2011-10-09 at 12:05 +0200, Cor Nouws wrote: Hi Tom, Tom Davies wrote (08-10-11 12:10) At this point we could probably start thinking about longer-term support than just 1 year. A lot has changed this year and the future seems much more solidly certain for TDF and LO. Regards from Tom :) No one will hold you from thinking about that. But before building expectations, it is good to realise that decisions about release cycles are made by the people that do the development work. Regards, -- - Cor - http://nl.libreoffice.org I think we are growing to point were the issue of long term support probably needs to be addressed. I think this more an issue with corporate users rather than home/home office users. Large organizations dislike having to update very frequently and we need to find the best balance for them and us. Linux users are probably affected less because of the distros will provide one of the more recent versions. But Windows and Mac users need to update manually or in a corporate environment the IT department will need to roll out the new version/update. Firefox has received criticism for their rapid versioning from 4 to 7 in the last several months from corporate users. There are several possibilities. We could say every odd or even (3.3 vs 3.4) is the LTS with support for 2 or 3 years and the other is supported for 1 year for example. We could say every, say third release (3.3 the 3.6) is the LTS with support for the other version. One of the years releases (3.3, 3.4, and 3.5?) could be designated the LTS. Please note these are just ideas put out to stimulate thinking and discussion for us to determine what is best overall for LO and our users. Obviously, this is not an issue that can be decided without discussing with others such as the devs before a decision is reached but one that probably needs to addressing in the near future. The goal is to have a policy that can be used for planning by us and by users and is reasonable for both. -- Jay Lozier jsloz...@gmail.com -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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 in Opensuse 11.4
Hi Put the cursor on the name of the Form. Then click right of the mouse. There appear some options, ... select Edit. When you did that appers your form in Edition way. You can use the Menu or the different bars that you can find around it for making changes. Regards, Jorge Rodríguez ___ El lun, 10-10-2011 a las 12:49 +0200, Sebastian Gödecke escribió: Hi, i'm using : LibreOffice 3.3.1 OOO330m19 (Build:8) tag libreoffice-3.3.1.2 from Opensuse 11.4 I create a form in base. Now i want to modify these form, but i can't do anything to modify. I can't add a view-form-draft or any other form-boxes. What could i do to modify my form ? Regards Sebastian -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] New! TexMaths, a LateX equation editor for LibreOffice
Hi Good for us. Thank you to put this extension for us, I already download. Regards, Jorge Rodríguez ___ El lun, 10-10-2011 a las 01:15 -0700, roland65 escribió: Hi, I released last week TexMaths, a new extension for LibreOffice. TexMaths is an easy to use equation editor that alows to edit and generate LaTeX equations in Writer, Impress and Draw documents. TexMaths is a based on ooolatex, which is not maintained anymore. You can find all the details at this website : http://roland65.free.fr/texmaths Best regards, RB -- View this message in context: http://nabble.documentfoundation.org/New-TexMaths-a-LateX-equation-editor-for-LibreOffice-tp3408883p3408883.html Sent from the Users mailing list archive at Nabble.com. -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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: Calc - Merge multiple discontiguous selections at the same time?
Hi: I didn't the question but it interest me. I tried to use macro but I can't use because: a) If I selected all the cells that I want to merge ... nothing pass. b) If I select the first and run the macro ... appears a mesage that merge isn't found method. This macro woud be usefull ... thank you if you help us. The other method that I know to merge string is this: For example: merge A1, A6 and B10: +A1A6B10 Regards, Jorge Rodríguez El mar, 11-10-2011 a las 21:26 +0200, Andreas Säger escribió: Am 11.10.2011 20:48, Tanstaafl wrote: Does anyone know if there is an extension that makes this possible? Or, if there is already a Feature Request for it? Thanks Sub MultiMerge sel = ThisComponent.getCurrentSelection() e = sel.createEnumeration() while e.hasMoreElements() rg = e.nextElement() rg.merge(true) wend End Sub -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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: Calc - Merge multiple discontiguous selections at the same time?
Hi: I know that is better using a macro, off course. That was I request to help us with this macro that you did, because I tried to run and it failed. Now I tried to run like this: A1 = jor A2= ge B3 = Rodrí B4 = guez D2 = Fon D3 = seca I selected all ranges and run the macro...the result was: Merge A1 with A2 but lost ge Merge B3 with B4 but lost guez Merge D2 with D3 but lost seca I thought that merge multiple range macro would bring this: Merge the content of A1:A2 with B3:B4 and with D2:D3 in other cell, like this: D6 = jorgerodriguezfonseca I expose you all this because I think is a good idea and usefull to get a macro like this. Excuse me if I'm abusing of your time and knowledge Regards, Jorge Rodríguez ___ El mié, 12-10-2011 a las 02:28 +0200, Andreas Säger escribió: Am 12.10.2011 02:16, jorge wrote: For example: merge A1, A6 and B10: +A1A6B10 Regards, Jorge Rodríguez Replacing a formula with a macro would be useless. My macro merges multiple selections of ranges such as A1:B4 D3:D5 E1:G1 as menu:FormatMerge does with one selected range at a time. -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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: Calc - Merge multiple discontiguous selections at the same time?
Hi Thank for the clarification. Regards, El mié, 12-10-2011 a las 18:20 +0200, Andreas Säger escribió: There are horizontal vectors, vertical vectors and rectangles of cells. A multiple selection may include all of these in arbitrary arrangements across sheets. All this can be handled in the most convenient way by means of function CONCATENATE or operator . -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Summary of bugs
Hi Thank you I think it is a good and necesary job. Regards, Jorge Rodríguez ___ El mié, 19-10-2011 a las 10:15 +0100, e-letter escribió: Readers, A useful summary of bugs in LO: https://bugs.freedesktop.org/report.cgi?x_axis_field=bug_statusy_axis_field=componentz_axis_field=query_format=report-tableshort_desc_type=allwordssubstrshort_desc=product=LibreOfficelongdesc_type=allwordssubstrlongdesc=bug_file_loc_type=allwordssubstrbug_file_loc=status_whiteboard_type=allwordssubstrstatus_whiteboard=keywords_type=allwordskeywords=bug_status=UNCONFIRMEDbug_status=NEWbug_status=ASSIGNEDbug_status=REOPENEDbug_status=RESOLVEDbug_status=VERIFIEDbug_status=CLOSEDbug_status=NEEDINFOemailassigned_to1=1emailtype1=substringemail1=emailassigned_to2=1emailreporter2=1emailqa_contact2=1emailcc2=1emailtype2=substringemail2=bugidtype=includebug_id=chfieldfrom=chfieldto=Nowchfieldvalue=format=tableaction=wrapfield0-0-0=nooptype0-0-0=noopvalue0-0-0=. Thought it would be useful to share. -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] OO Base will not run in LO Base
Hi If not other thing run, try to do this: 1) With Calc Ooo-Base, use Browser and select one by one all the tables from the Ooo-Base db file. 2) Save the file as .ods 3) Then, in Lo-Base, connect (Browser-spreedshet) from .ods (I think you can recover the tables. At least you can recover the tables but you have to do again forms, etc. Regards, Jorge Rodríguez ___ El vie, 28-10-2011 a las 11:47 +0200, Ian Whitfield escribió: Hi All I have written in on this subject before but got no 'real' answers and it is now becoming urgent!! I have a Database that I developed several years ago in OO. It runs well and is used every day. I currently run it in OO (3.2.1). When LO first came out I installed this on a second machine and tried to run my DB with it but with no luck. I have had a tries as new versions of LO became available but always no luck. My second machine recently started to give problems so I moved everything onto the main computer. I now have OO and LO (3.3.4) on the same machine. It still refuses to run my DB. So I have to have my DB open with OO and do my other work in LO. I have noticed a lot more crashes and freezes and other strange behavior since having everything on one machine. I read on the Forum just a day or so back that it is not recommended to run both programs at the same time which is no doubt the reason I'm seeing problems. When I open LO Base it opens and shows me all my tables and forms etc. But when I select 'Forms' to start the program LO just closes. It has done this since the beginning!! If I do the same steps in OO it works fine!! How can I transfer my DB to LO or what steps must I take to convert it to LO format!!??? As I said this has now become a priority for me. If this can not be done I will have to drop LO and stay with OO which I don't want to do. My OpSys is Linux Mint 10 KDE. Thanks Guys - I hope at least one of you can supply me with an answer. -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Headers in calc
Hi I'm sorry but I think it is wrong because Background is different to Hedears. If you use background image what everthing that you put in a cell appear in the image. I understood that he needs to put as header (out of the rest of the sheet- on the top -). Regards, Jorge Rodriguez ___ El mar, 01-11-2011 a las 17:59 +, Tom Davies escribió: Hi :) Hopefully ElCico's answer helps! It looks good to me :) The Faq has only just started to be written and is mostly being translated from the French Team's excellent one, slowly - any offers of help doing that would be welcomed. Official documentation is at http://www.libreoffice.org/get-help/documentation/ and also at the wiki https://wiki.documentfoundation.org/Documentation/Publications The wiki sometimes has extra links to 3rd party documentation such as the Macro's Guide by Andrew Pitonyak (there is another Macros Guide that i need to add soon). Hopefully that adds to the documentation you have been looking at but i am not certain. ElCico's answer is probably the best help. Regards from Tom :) --- On Tue, 1/11/11, elcico2001 एल्चिको elcico2...@yahoo.it wrote: From: elcico2001 एल्चिको elcico2...@yahoo.it Subject: Re: [libreoffice-users] Headers in calc To: users@global.libreoffice.org Cc: neil.bow...@yahoo.co.uk Date: Tuesday, 1 November, 2011, 17:45 Il 01/11/2011 16:31, Neil Bowser ha scritto: Hello, I've looked through the help text, I've looked through your FAQ's and documentation (what there is of it), and I can't find how to do it. What I want to do is have a picture file (bmp) as a header when I print out my spreadsheet. I can see how to add things like dates, text etc, but how do I add a picture? Thanks Hello, I'm at the moment on Debian stable (still OpenOffice calc) but it should be the same on LibreOffice calc: Format -- Page -- Header -- Extra -- Background. Choose as image, locate the folder with your image, then select it. You may have to try different positions to have your image to be seen in the header; be sure also you have the needed space (header hight and distance from borders). Namastè! :) -- cico Icq/Licq/Gaim #175451007 Debian Powered Linux Registered User #310800 at http://counter.li.org No retreat baby no surrender http://www.retenergie.it - coop di produttori e utilizzatori di energia da fonti rinnovabili tad evaarthamaatra-nirbhaasaM svaruupa-shuunyam iva samaadhiH Sanskrit - Realize it's the common language ;-) -- For unsubscribe instructions e-mail to: users+h...@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 -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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: Microsoft Works-2
Hi I think that it would be better if LO support MS Work directly but the windows users can instal LO or OpenOffice to solve the problems too. It is esear for all. Regards, Jorge Rodriguez ___ El jue, 17-11-2011 a las 15:26 -0800, NoOp escribió: On 11/17/2011 11:29 AM, Alex Thurgood wrote: Le 17/11/2011 18:33, John Gregson a écrit : Hi John, I can now open some of the MS Works, Word Processor files (.WPS) However, I find that any Works file .wps; that has a Table in it will not open in Libre Office. Am I missing something? Probably not, the MSWorks WPS filter was never perfect and I doubt that it will be improved. The LibO project is phasing out the former binary filters that were required to open StarOffice binary formats, so it is unlikely that any developers are going to be interested in improving the WPS import filter. ... Sorry to hear that. Many Win7 users may not be able to afford MS Office proper use MS Works. MS Works version 9.0 in Win7 (that is included for free in most Win7 versions... at least it is in Win7 Home Premium) is actually quite a nice suite. Were I not a linux user used Win7 outside of testing, and didn't know about OOo/LO, I'd be quite comfortable using it on a regular basis. Note: I am quite familiar with MS Office 2003 and earlier (I have MSO 97, 2002, and 2003). http://www.microsoft.com/products/works/ProductDetails.aspx?pid=003active_tab=Features I think that LO would be making a mistake by not continuing to support MS Works files (at the the newer versions), at least to properly open and display the files. @John Gregson: I just did a test MS Works (9.0) file with a small table in it. Four columns, 4 rows. When saved as an .wps the table in LO 3.4.4 appears as: [OBJ][OBJ][OBJ][OBJ] Test Test1 ... Test17 In other words, the table is not present instead converted to text. Note: I just filled the table with Test, Test1 etc. No idea what the ' [OBJ][OBJ][OBJ][OBJ]' bits are about. I then saved the same file (from MS Works) as a .doc file reopened in OOo 3.3.0 (table appears fine, albeit outside the page text borders), and in LO 3.4.4 with the same results as OOo 3.3.0. I'd have to uninstall LO 3.4.4 to test with LO 3.3.4, perhaps a Win7 user w/LO 3.3.4 can test as well? -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Regards
Good Morning, Happy New Year for all ! From Costa Rica ... Central America. -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] How can I import excel file to libreoffice base as data souces
Hi: I suggest you to do this: 1) Open BASE program 2) Select third opción (Connect database exist) 3) Select below Spreadsheet and following find the .xls that you need to include in database. 4) Open database (Save) and use. Base will get all sheets that the .xls has and convert each one to a database table Regards, Jorge Rodríguez ___ El dom, 08-01-2012 a las 07:59 -0800, bobby_winon escribió: hello everybody , I am new to the libreoffice ,and I wish someone can tell me how can I import excel file to libreoffice base as data source.thank u for your noticed -- View this message in context: http://nabble.documentfoundation.org/How-can-I-import-excel-file-to-libreoffice-base-as-data-souces-tp3642216p3642216.html Sent from the Users mailing list archive at Nabble.com. -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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: PROBLEM WITH VBA MACRO IN CALC FROM EXCEL
Hi: I had the same error (13) but I continue trying and it runs all well. It was in OpenOffice 3.2 ... I think that in LibreOffice should run well. Regards, Jorge Rodríguez ___ El vie, 13-01-2012 a las 05:54 -0800, Tom escribió: Hi :) I don't use macros at all so i don't know how to access the code. Jay's idea seemed smart. In LibreOffice go up to the menus at the top and click on Tools - Options - + Load/Save - VBA Properties and then tick all the options in there and then re-load the invoice. You might also need to let LibreOffice know what the data-source is? When i tried to open the file it gave me a warning about my security settings blocking macros and i think that might be a default setting. Try Tools - Options - LibreOffice - Security - Macro Security - Security Level Mine was set to the 2nd highest so i set it lower. This time it enabled macros but gave me the error mesage BASIC run-time error 13 Data type mis-match which i guess is because i don't have the data-source/contacts-sheet. I did find it interesting that LibreOffice allows macros to be written in a choice of 4 languages; LibreOffice (Basic), Python, BeanShell (!?!) and JavaScript (worth avoiding?). The subject-line is a lot clearer now. I think the VBA Basic of MS Office is slightly different from the Basic used by LibreOffice. Capital letters are usually used to shout or be abusive towards someone. So a lot of people might view this thread as being hostile. I think you are using capital letters to be clearer because you are not a native-English-speaker. Most people wont know about that so they might be taking offence and hiding away. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/PROBLEM-WITH-VBA-MACRO-IN-CALC-FROM-EXCEL-tp3656548p3656705.html Sent from the Users mailing list archive at Nabble.com. -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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 enter Dates in a format to allow the counting of days lapsed between a from a date cell and a to a date' cell
Hi: You only have to input like this example: in cell A1 : 10/12/2011 in cell B1 : 12/12/2011 in cell C1 : +B1-A1 --- Result = 2 in cell C1 Regards, Jorge Rodríguez ___ El jue, 19-01-2012 a las 08:25 -0800, Tom escribió: Hi :) I think you are not fully subscribed to the list yet. Is there a confirmation email waiting in your spam/junk folder? Don't you just format the cells as Dates rather than numbers or text and then just do one cell - the other and have the answer cell formatted as date too? Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/How-to-enter-Dates-in-a-format-to-allow-the-counting-of-days-lapsed-between-a-from-a-date-cell-and-al-tp3671720p3672798.html Sent from the Users mailing list archive at Nabble.com. -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Add pdf as page in document
Hi: There are some programs to manage .pdf format documents,... like PDF-Shuffler, PDF Chain and others that you can find for it. If you you use Ubuntu, Open Suse or similar flavors of GNU/Linux you can find those programs in the Install Program repositories. Regards, Jorge Rodríguez ___ El lun, 23-01-2012 a las 21:37 -0800, upscope escribió: On Monday, January 23, 2012 09:32:29 PM Jeff Prater wrote: Your best bet would be to convert your newsletter to a PDF first. Then, insert the form into the PDF using PDF authoring software like Adobe Acrobat. That's what I would do. This will not work. First I use Linux, Second I cannot afford Adobe Acrobat which to the best of my knowledge does not have a Linux version. I can create pdf's from LibreOffice and Scribus. I have not had time to try this in Scribus, it is supposed to import pdf's, but latest update gives error on trying to open pdf. Need to report bug. Thanks for your reply anyway. In order to get bulletin out I just recreated the whole document as a pdf form in LibreOffice and then save whol bulletin as pdf. Alot of extra work. - Jeff Prater On Fri, Jan 20, 2012 at 12:53 PM, upscope upsc...@nwi.net wrote: Is there a way to put a pdf form into a page of a newletter? I know you can create one, but this form was sent to me to be included in the newsletter so people can fill it in and then print it for mailing. From writer: CODE: --- file--open and selected the document and file type as .pdf. /CODE: - It opens the pdf in draw instead of the select document page in writer. I know I save it as an image and insert it but then the users will not beable to use it. Thanks for any ideas. -- Russ LibreOffice 3.4.5 OOO340m1 (Build:502) [from L.O website] openSUSE 12.1(Linux 3.1.0-1.2-desktop x86_64)|KDE Platform Version 4.7.4 (4.7.4) Release 11|Intel core2duo 2.5 MHZ, |8GB DDR3| GeForce 8400GS (NVIDIA-Linux-290.10-13.1.x86_64) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscri be/ 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 -- Russ -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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: Write2epub
Hi: I found a program to convert html o xhtml and .txt to epub format. Its name is eCub an it is a solution about you are talking. For example, if you make a document in .odt format, then you can select the export option in File menu and save as html o xhtml and then with this eCub program you can do it. I did an example and it was good (But it was made with a simple document and I don't know how is going on with a complex document) You can find it here: http://www.juliansmart.com/ecub It is able for GNU/Linux, Mac and Windows Regards, Jorge Rodríguez ___ El sáb, 11-02-2012 a las 12:37 -0600, Ron Johnson escribió: On 02/11/2012 11:20 AM, Pedro wrote: [snip] 1st - if we continue this, and I would not mind at all, how about we kick it over to the discuss list? Unfortunately this is not a Forum, we can not move topics :) We would have to start all over at the Discuss mailing list... Cross-post? It does have an occasional valid purpose... :) -- How does being physically handicapped make me Differently-Abled? What different abilities do I have? -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] Fw: LibreO-Base is lying about my age!
Hi:
I suggest to do this:
If
A1: 2/11/1939
B1: =Now()
Input in A3:
=ROUNDDOWN ((B1-A1)/365)
outcome: 72
Regards,
Jorge Rodríguez
___
El jue, 16-02-2012 a las 13:40 +0200, p...@elisanet.fi escribió:
--- Alkuperäinen viesti ---
Aihe: LibreO-Base is lying about my age!
Päiväys: 15.2.2012 17:46
Lähettäjä: Pertti Rönnberg [p...@elisanet.fi]
Kopio: Pertti Rönnberg [p...@elisanet.fi]
Dear all of you,
First an opinion - correct me if wrong!
I've got the idea that this is kind of a help-desk where every LibreO
user can both ask for help and give info about problems related to
LibreO's components. Without any bad feelings afterwards!
Referring to the irrelevant debates recently and also my own
experiences some weeks ago I would say that a real expert has the
ability to concentrate on the question as-it-is and give a relevant
answer -- he has knowledge enough to understand that there are no silly
or wrong questions.
Every question has its reason - and every question is valuable because
it indicates that there may be something to repair or do better in LibreO.
There is a truth in quality systems (e.g. ISO 9000): without
identifying the weaknesses there is no development.
_And now to my contribution to make LibreO better:_
I need to calculate in LO-Base the difference between an 'olddate' and
today expressed in whole years (no decimals)
The main procedure seems to be the same in LO-Base and OOo as in MSAccess.
The function I placed in the query field is (ref. also to guides in LO
OOo):
datediff('year',table1.olddate,current_date) or
datediff('year',olddate,current_date)
When I inserted my birthdate (2.11.1939) in 'olddate' my computer states
that I am 73 - I'm NOT, I'm still only 72!
The correct result is 72,225 years; and the desired answer without
decimals 72.
I got the same wrong result (73) both in LO-Base and in OOo-Base
the wrong result is not logical - it can not be a rounding up, nor
is it a result of an 'int()'-function
if I replaced 'year' with 'dd' or 'mm' or 'yy' the function works
-- but
when replaced 'year' with '' the function stopped working (why -
'year' and '' ought to be equal!)
the query field does not accept the expression int(datediff(..etc))
the date-format is equal (finnish - see above) in every relevant field
my OS is Windows7Professional/32Bit
I also tried the formula /year(current_date - olddate)/ but the query
did not accept it as a valid expression - can I put that formula
anywhere else?
Anyone there who can tell me how I shall get the LO-Base to be honest?
Regards
Pertti Rönnberg
--
Atentamente,
Jorge Rodríguez
--
For unsubscribe instructions e-mail to: users+h...@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] Differences between LibreOffice and OpenOffice
Hi: I think it is a good and necesary job for users to know about and take the best option but with knowledge. And this summary could show how LO has been improved. Regards, Jorge Rodríguez El mar, 13-03-2012 a las 13:52 +0200, Dotan Cohen escribió: There is a discussion on the Debian list right now about the differences between LibreOffice and OpenOffice. As the two office suites diverge, it will become more and more important to document the differences between them. Therefore I have started a page to document these differences: http://dotancohen.com/eng/difference_openoffice_libreoffice.html If you come across any other differences, or if any corrections need to be made, then please contact me and I will update the document. It is currently just a list of bugs but I intend to develop the page into stand-alone explanation of the differences intended for the layman. Thank you. -- Dotan Cohen http://gibberish.co.il http://what-is-what.com -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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] 3.3.2 Export to PDF on Kubuntu 11.04
Hello: I suggest you that copy the first page or sheet in a new document and then export it to PDF. You can solve your current problem and then you can solve your menu problem ! Regards, Jorge Rodríguez _ El dom, 01-05-2011 a las 21:21 -0400, John Moore escribió: There are two Export to PDF options available on menus. One is named as shown. The other is Export Directly to PDF. On my system, they both behave identically, there is no PDF creation dialog, you simply export the entire document, and get the same filename dialog.. Is there some configuration option I may have accidentally set--and if so, how do I unset it. I tried removing the Export to PDF option from the File menu and then adding it back to the menu, but that did not help. I need to export only the first sheet from a large spreadsheet, but today, I had to print it and then scan it to a PDF =( John Moore Atlanta, GA -- = For a copy of my PGP Public Key, just reply to this e-mail with the subject Get PGP Key = -- Atentamente, Jorge Rodríguez -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] using libre office with portable apps
Other thing that could be making problem is: 1) Xp 2) If you have an Antivirus that check the USB before allow you to use it El jue, 19-05-2011 a las 08:11 -0500, Vic Dura escribió: On Thu, 19 May 2011 10:01:37 +0100, Colin co...@wtpcomptrain.co.uk wrote Re [libreoffice-users] using libre office with portable apps: 1) When using Writer or any other of the programms from LO through Portable Apps off a USB stick, is it normal that it takes about 2 mins or more to load I seem to wait forever. I have other applications I use and they seem to load much quicker, I am using this mainly on XP pro. USB sticks are much slower than hard disk drives, but 2 minutes seems excessive. Did you actually time the load with a timer? -- Atentamente, Jorge Rodríguez -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] How to remove options from the Save As list (Writer)
I think that you have to use the simple Save option and the document will save with the format that you are using. The first time it put a message that says that it isn't save and when you click ok, it go to save option. At this time you have to select the format that you want to use for it. For the rest time that you use the simple Save option, it save as it was save the first time. Whe you chose .doc, it put a message if you want to keep the format o change ... but it has a chek box to select it won't appear again. Regards, Jorge Rodríguez __ El mié, 01-06-2011 a las 10:11 -0700, aharown07 escribió: Haven't found this info anywhere: When I do a Save As in Writer, a pile of options appear in the drop down, including something like three different versions of .doc. I don't need all of these and the cluttered list slows me down a little every time I do a Save As... which is quite often. So, can I edit that list somewhere to only show what I have use for? (By the way: would be a nice future feature to have this in Options somewhere) -- View this message in context: http://nabble.documentfoundation.org/How-to-remove-options-from-the-Save-As-list-Writer-tp3011755p3011755.html Sent from the Users mailing list archive at Nabble.com. -- Atentamente, Jorge Rodríguez -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Chart data
Hi: I could suggest you to select a greatter range than you are going to use at the begining. For example. Imagine you need make a chart with the information of all the months of the year but at this moment you have only seven mounth, like this: Row A B 1 J 10 2 F 20 3 M 30 4 A 40 5 My 40 6 J 50 7 Jy 60 But you expect five additional months: Row A B 8 A ? (Keep in blank) 9 S ? (Keep in blank) 10 O ? (Keep in blank) 11 N ? (Keep in blank) 12 D ? (Keep in blank) When you select the initial range you can select: A1:B12 as complete series In this case the chart only show elements graphics for months that have numbers...the others only by referens...but if you dont want show these in the chart you can hide its part of range-rows-(Partial or Total), and the chart adjusts automatically its range. I hope this help you to make your chart better and easier, Regards, Jorge Rodríguez El mié, 23-07-2014 a las 10:48 +0100, Gordon Burgess-Parker escribió: Hi! I'm trying to create a chart where when I add data I don't have to edit the data range each time to include the new row. I can't see how to do that. (Probably something I've missed). Can anyone help? Ta! -- 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] Chart data
Hi: I'm sorry for you but LO is quite different to excel not all that you can do in LO you can do in excel and invece ... They usually do almost all but in different way...sometimes one or other improve process that the other doesn't do by different issues. Is like a car, if you change a car you can't expect its perfomance is equal to other car. I tried to give you a way to solve your problem using LO Car ! Regards, Jorge Rodriguez El sáb, 26-07-2014 a las 17:00 +0200, Rob Jasper escribió: In MS Excel one can select a full column by just leaving off the rownumber, example: MAX(B:B). If I open the .xls file with LibreOffice this formula gets translated in MAX(B$1:B$983040) Tried to enter the original formal but that responds #NAME?. Apparently LibreOffice does not have the functionality. Rob. Op 23 jul. 2014, om 16:39 heeft jorge het volgende geschreven: Hi: I could suggest you to select a greatter range than you are going to use at the begining. For example. Imagine you need make a chart with the information of all the months of the year but at this moment you have only seven mounth, like this: Row A B 1 J 10 2 F 20 3 M 30 4 A 40 5 My 40 6 J 50 7 Jy 60 But you expect five additional months: Row A B 8 A ? (Keep in blank) 9 S ? (Keep in blank) 10 O ? (Keep in blank) 11 N ? (Keep in blank) 12 D ? (Keep in blank) When you select the initial range you can select: A1:B12 as complete series In this case the chart only show elements graphics for months that have numbers...the others only by referens...but if you dont want show these in the chart you can hide its part of range-rows-(Partial or Total), and the chart adjusts automatically its range. I hope this help you to make your chart better and easier, Regards, Jorge Rodríguez El mié, 23-07-2014 a las 10:48 +0100, Gordon Burgess-Parker escribió: Hi! I'm trying to create a chart where when I add data I don't have to edit the data range each time to include the new row. I can't see how to do that. (Probably something I've missed). Can anyone help? Ta! -- 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 -- 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] Chart data
Hi Tom: Thank you by your words Regards, Jorge Rodríguez El dom, 27-07-2014 a las 19:06 +0100, Tom Davies escribió: Hi :) I think you give good answers. We can't always solve everyone's questions. Hopefully we do push enough of them in the right direction but it is not always possible. There are other places people can use to try to find answers too. Also we are not just about giving answers but are also about showing people that this is a comfortable place to mull over issues and to maybe pick up some new ways of thinking. Those new ways might help people with other problems. Sometimes problems only get solved when several people ask because it takes time for us to learn how to cope with something new. Sometimes the functionality is not there yet so we push for new features. Sometimes it's something that is not widely known about so we all learn. So, don't worry when you can't help a person directly. Just trying to help shows them that they are not alone and that can be a huge help. Good work! Much appreciated :) Regards from Tom :) On 26 July 2014 19:00, jorge jrodrigue...@cpcecr.com wrote: Hi: I'm sorry for you but LO is quite different to excel not all that you can do in LO you can do in excel and invece ... They usually do almost all but in different way...sometimes one or other improve process that the other doesn't do by different issues. Is like a car, if you change a car you can't expect its perfomance is equal to other car. I tried to give you a way to solve your problem using LO Car ! Regards, Jorge Rodriguez El sáb, 26-07-2014 a las 17:00 +0200, Rob Jasper escribió: In MS Excel one can select a full column by just leaving off the rownumber, example: MAX(B:B). If I open the .xls file with LibreOffice this formula gets translated in MAX(B$1:B$983040) Tried to enter the original formal but that responds #NAME?. Apparently LibreOffice does not have the functionality. Rob. Op 23 jul. 2014, om 16:39 heeft jorge het volgende geschreven: Hi: I could suggest you to select a greatter range than you are going to use at the begining. For example. Imagine you need make a chart with the information of all the months of the year but at this moment you have only seven mounth, like this: Row A B 1 J 10 2 F 20 3 M 30 4 A 40 5 My 40 6 J 50 7 Jy 60 But you expect five additional months: Row A B 8 A ? (Keep in blank) 9 S ? (Keep in blank) 10 O ? (Keep in blank) 11 N ? (Keep in blank) 12 D ? (Keep in blank) When you select the initial range you can select: A1:B12 as complete series In this case the chart only show elements graphics for months that have numbers...the others only by referens...but if you dont want show these in the chart you can hide its part of range-rows-(Partial or Total), and the chart adjusts automatically its range. I hope this help you to make your chart better and easier, Regards, Jorge Rodríguez El mié, 23-07-2014 a las 10:48 +0100, Gordon Burgess-Parker escribió: Hi! I'm trying to create a chart where when I add data I don't have to edit the data range each time to include the new row. I can't see how to do that. (Probably something I've missed). Can anyone help? Ta! -- 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] Intermittent Calc Issues
Hi: It would be about the amount memory assigned in Calc (Menu: Tools- Options - Memory) Regards, Jorge Rodríguez El lun, 04-08-2014 a las 22:25 -0500, Gregory Forster escribió: Hi, I haven't been on this users group for over two years, primarily because everything worked great, until now. I have an inconsistent and not often issue with Calc. Well, it's more annoying than anything else, because I can easily correct it, but it shouldn't be. Calc does weird things now and then. I was creating an elaborate spreadsheet file consisting of 13 worksheets to record my wife's and mine different Roth and Traditional IRAs vested in Mutual Funds. Each worksheet shows the DATE, transaction DESCRIPTION, DEBIT, CREDIT, share PRICE, SHAREs obtained, share BALANCE, $ AMOUNT (share PRICE * share BALANCE), percentage of gain or loss both yearly and per investment, all in separate columns. Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. As I said, these issues are very inconsistent. They may not happen for days, then after a few days, they may happen several times, then intermittent, or not at all. This all started in early July. I ran anti-malware scanners, anti-virus scanners, cleaned the registry, and defragged. I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. I have installed some new software, some with start up files. Those software programs were not really all that important, so I deleted them, the registry entries, and any start up files. However, the IRA spreadsheet file is all done, and I don't know if I'll still have those issue until I start another spreadsheet project. This is all done on an HP Probook 440 G1 14 notebook with a Jan 2014 UEFI, an Intel dual core I3 2.4Ghz Haswell, 4GB DDR3L, and Windows 7 64 bit home premium purchased late last March. My questions are: Has anyone else experienced the same? Does my reasoning sound feasible? Any ideas? Greg --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com -- 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] Re: LibreOffice Still?
Hi, good night all: As I understand there are some official versions. I think that could be better that The Document Foundation only has one version for all languages for production and makes its firsts efforts to solve all the most important bugs (This would be by user and programmer votes) before to start a new version. In this way The Document Foundation assures to step up when the before version is really OK ! for all and production. I think is better go more slowly but complete all important issues of the official version than growing fast fast fast but would be with disorders. And in this time as I know the version of production even has bugs stand by to be solve. This words are because I appreciate so much the all efforts for get the best for Libre Office but some times when we don`t focus in the same we would loss some of them. Regards, Jorge Rodríguez El mié, 06-08-2014 a las 21:40 +0100, Tom Davies escribió: Hi :) I usually get mails from the Marketing List but didn't see any discussion about the new ideas for branch names. If i had i might have mentioned that Fresh vs Stagnant branch held some unfortunate connotations that might not have been obvious. Regards from Tom :) On 6 August 2014 20:57, Paul paulste...@afrihost.co.za wrote: On Wed, 6 Aug 2014 20:54:10 +0200 Charles-H. Schulz charles.sch...@documentfoundation.org wrote: Paul, The fresh branch is stable enough for everyone to use. LibreOffice does not pilot planes, it does not usually crash, it does the job. There are people who want newer features and people who want more tested versions. There's food for everyone. Yes, there is, and no one is saying any different. In fact, I am saying that there are people who want both, and so *both* should be offered. But by your own admission, one of those branches is more stable. The difference might be slight, but it is enough for the people behind LO to continue to offer it when the newer, more featureful branch is also being offered. So for me first prize would be to have both branches as equal downloads on the LO download page. With a clear, concise explanation of what each offers, and a link to a slightly longer, fuller explanation. That is exactly what I am proposing should be done. But barring that, if LO wants to keep a single download as the primary download, as it currently is, then I am firm in my belief that the primary download should not be the less stable branch, but should instead be the more stable branch. More experienced users will know where to look for the version they require, but it is my belief that new users, the kind that will simply click on the big shiny download button, prefer stability over features. In the case of an office suite like LO, how much of the new features do they even use? Of course people want new features, I just think that new users would prefer stability, or even better yet, a clearly explained choice, rather than features at the expense of stability. If you have statistics to show otherwise, I'm sure you would have presented them by now. If you disagree, that is of course fine, but it remains purely our individual opinions until someone presents some pertinent facts. Although as far as I can tell from the responses, it seems most people here agree with me, so if I were the marketing team, I would give it careful consideration. Now: if you have ideas for new names, etc. you are welcome to contribute to our marketing team. Well, this particular discussion was about how the downloads are presented, not about the names for each branch, and I have already made my opinions on the branch names clear, but I will reiterate them here for clarity: Still should be Stable Fresh *can* stay the same, but should rather be Current or Development Feel free to pass that on to the marketing team. I don't think I will be joining another mailing list, one with an agenda that I am largely not interested in, just to contribute that. This discussion was opened here, and I contributed my opinions; I am happy leaving it at that. I'm sure the right people are aware of this discussion, or, if not, that someone who is on both lists will pass along our sentiments. Paul Best, Charles. Le Wed, 6 Aug 2014 20:07:41 +0200, Paul paulste...@afrihost.co.za a écrit : Just to add another point... (see inline) On Wed, 6 Aug 2014 20:04:56 +0200 Paul paulste...@afrihost.co.za wrote: On Wed, 6 Aug 2014 19:01:19 +0200 Florian Reisinger flo...@libreoffice.org wrote: Hi Tom, If we do not find the bugs in the fresh version, they won't be resolved until the rename to Stable/Still. If less use Fresh, the quality of the next stable will be lower Does this help? That is true, but it still
Re: [libreoffice-users] 'exporting' Odt into Scribus
Hi Tom: I check the Scribus open file format and it accept .pdf, I made a probe with one document of mine, and Scribus open it. I suggest you to export your .odf file to .pdf and then open it with Scribus. I don't know how it will configure the pages opens but it would be well. Regards, Jorge Rodríguez El mié, 17-12-2014 a las 14:11 +, Tom Davies escribió: Hi :) I do my company newsletter in Writer but want to do the finishing touches in Scribus. Has anyone else tried this? A few years ago someone from this mailing list offered to give me a hand but i had no time to even try it back then. It's suddenly become quite viable to put some time into this at work. The one thing that Writer doesn't seem able to do is use curved text-frames. I'm kinda trying to get some nicely rounded corners to upgrade the newsletter from Win98 style to Xp style. Regards from Tom :) -- 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
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] Happy Christmas all! :)
Hi Tom: Thank you very much, and the same for you and all. Regards, Jorge El jue, 25-12-2014 a las 19:42 +, Tom Davies escribió: Hi :) I hope everyone had or is having a good Christmas day, even if you don't celebrate it as being a special day. Many regards to all from Tom :) -- 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] HoooRaaa! :))) Re: [tdf-announce] The City of Munich joins The Document Foundation Advisory Board
+ 1 Very Good News Regards, Jorge Rodríguez El lun, 12-01-2015 a las 14:38 +, Tom Davies escribió: Hi :) It is really great to see another fairly massive organisation join the TDF Advisory Board. Regards from Tom :) On 12 January 2015 at 10:34, Italo Vignoli it...@documentfoundation.org wrote: Berlin, January 12, 2015 - The Document Foundation (TDF) announces that the city of Munich has joined TDF Advisory Board, where it will be represented by Florian Haftmann. Back in 2003, the city of Munich - the third largest in Germany - has launched Project LiMux to migrate their software systems from closed-source, proprietary products to free and open-source software. The project was successfully completed in late 2013, which involved migrating 16,000 personal computers and laptops of public employees to free and open-source software. The City of Munich has hosted a LibreOffice HackFest since 2011, to improve features targeted to enterprise environments. The city of Munich is a healthy reference for every migration to free software, and as such will add a significant value to our Advisory Board, where it will seat side by side with MIMO, representing the migration to LibreOffice of French Ministries, and with other companies providing value added services on top of LibreOffice, says Thorsten Behrens, Chairman of The Document Foundation. Doctor Florian Haftmann will be introduced to other members of TDF Advisory Board during next planned meeting, on January 15, 2015. TDF Advisory Board has 17 members: AMD, CIB Software, City of Munich, CloudOn, Collabora, FrODeV (Freies Office Deutschland), FSF (Free Software Foundation), Google, Intel, ITOMIG, KACST (King Abdulaziz City of Science and Technology of Saudi Arabia), Lanedo, MIMO (Consortium of French Ministries), RedHat, SPI (Software in the Public Interest), Studio Storti and SUSE. About the City of Munich and Project LiMux Munich, Bavaria’s capital, between 2005 and 2013 has successfully managed to migrate around 16,000 PCs in 11 business units and 4 municipal undertakings to an open source based, standard and stable operating system. Munich is the largest public-sector open source stake holder in Germany, and Project LiMux has always had a high visibility. Project LiMux has been able to reduce in a significant way the dependence from legacy proprietary software products, and attain - in the long term - the desired flexibility of software and architecture, based on three fundamental decisions: - Introduce a free and open source operating system, with office communications based on open standards for all workstations; - To acquire or develop platform independent administrative procedures; - To use a standardised IT platform with consolidated applications and databases. In such a scenario, a suitable desktop office suite is a strategic core product. In the beginning, LiMux has started to deploy OpenOffice.org, but by now the reference office suite is LibreOffice. Short link to TDF blog post: http://wp.me/p1byPE-wU -- Italo Vignoli - The Document Foundation mob IT +39.348.5653829 - mob EU +39.392.7481795 sip it...@libreoffice.org - skype italovignoli hangout / jabber italo.vign...@gmail.com email it...@documentfoundation.org GPG Key ID - 0xAAB8D5C0 DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 -- To unsubscribe e-mail to: announce+unsubscr...@documentfoundation.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ List archive: http://listarchives.documentfoundation.org/www/announce/ -- 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] Where is Base?
Hi all: Would you please open Calc as you can did ? Then in the Menu select please Tools-Options. There select Advance (Option No. 13), there automatic appear JAVA Environment that you have installed in your PC System. Is there nothing appear ... I think is necesary to install JRE 7 or 8 (JAVA Environment) in windows 7 to run BASE of LibreOffice. I hope this help you, Regards, Jorge Rodríguez El jue, 12-02-2015 a las 00:55 -0700, pranzar escribió: Hello. I just installed 4.4.03 on Windows 7. I'd like to use Base. When I click on the LibreOffice icon on my desktop, I see a screen with list of buttons on the left under Create. I select Base Database but nothing happens. The only buttons that work are Writer and Calc. What am I doing wrong? Thanks -- View this message in context: http://nabble.documentfoundation.org/Where-is-Base-tp4139808.html Sent from the Users mailing list archive at Nabble.com. -- 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] Re: [libreoffice-marketing] TDF Birthday video?
Hi all: Thanks to all people to make this posible ! and thanks for the video. Regards, Jorge Rodríguez El mié, 25-02-2015 a las 11:16 +, Tom Davies escribió: Hi :) It was our birthday and we missed it! Happy birthday all! :)) Regards from Tom :) On 23 February 2015 at 20:33, Marc Paré *hidden* wrote: Is it just me or did we just forget to advertise the TDF 3rd birthday video on our mailing lists? Thanks for the wonderful video Italo! And thanks to all of the wonderful people in the photos with the wonderful smiles, not to mention all of the volunteers who make the foundation such a wonderful place to contribute. The Document Foundation: the third anniversary (Feb. 17th) https://www.youtube.com/watch?v=BJLooSMPp6gfeature=youtu.be Marc -- 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] Calc suddenly very slow on loading
Hi all: I think it would be because you have low memory asigned for your big spreadsheet. I suggest this: 1) Menu 2) Tools 3) Memory There you find some topics where you can increase the memory that Libre Office use for the program. If you increase them your Libre Office able to manage more data and information in each spreasheet. I hope this help you Regards, Jorge Rodríguez El mié, 04-03-2015 a las 11:01 +0100, Milos Sramek escribió: Hi, I have an ods file with about 1800 lines and 25 columns. In each line there are about 50 hyperlinks (they are links to web or local files - I have two versions of the document). Until recently (two weeks ago), LO was able to open it in a second or two, and I was able to work with it normally (adding columns, sorting etc). Suddenly everything has changed - loading takes about 10 minutes and then no work is possible, since the response is horribly slow. I have several versions of LO installed and I am sure that the 4.3 an 4.4.0 versions were OK. Recently, I have upgraded 4.4.0 to 4.4.1 and installed 4.5 alpha. What surprises me is that also 4.3 is slow now and removing of 4.4.1 and 4.5 does not change the situation. I am using Ubuntu 14.10. I suspect that the problem is somewhere outside LO. A version of the document without the hyperlink loads instantly, so the problem resides in them Do you have any idea? Thank in advance Milos -- email jabber: sramek.mi...@gmail.com -- 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] Re: Heads up -- LibreOffice 5.0 is on the horizion
Hi Tom: Thank you Regards, Jorge Rodríguez El lun, 13-04-2015 a las 17:33 +0100, Tom Davies escribió: Hi :) +1 Also hoping we get some other new great themes developing as a side-effect but i think the focus needs to be on the opportunity at hand. Thanks Jorge, for setting the bar so high! :) Regards from Tom :) On 13 April 2015 at 15:31, V Stuart Foote vstuart.fo...@utsa.edu wrote: jonathon-4 wrote For some of us, those thumbnails are a security flaw. And all cleared with a single menu button click. So, it never has been a flaw--rather as designed ;-) Otherwise, hoping to see some great artwork and visual design suggestions from the user community. Stuart -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4146130.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 -- 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] Re: Heads up -- LibreOffice 5.0 is on the horizion
Hi all: Thank you, excuse me but I haven't match that word with that perfomance. It is clear now. Regards, Jorge Rodríguez El dom, 12-04-2015 a las 20:29 -0700, V Stuart Foote escribió: The thumbnail views are iconic representations of the documents that have recently been opened and are listed on the File - Recent Documents listing. As circled in red in this screen clip... http://nabble.documentfoundation.org/file/n4146081/StartCenter_master_with_recentDocumentThumbnailViews.jpg -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4146081.html Sent from the Users mailing list archive at Nabble.com. -- 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] Re: Heads up -- LibreOffice 5.0 is on the horizion
Hi Bill: Thank you for the information Regards, Jorge Rodríguez El lun, 13-04-2015 a las 05:26 -0400, William Drago escribió: The thumbnail view of recently used docs is one of the things that I LOVE about LibreOffice. To hear that it is a critical design element that can not be removed is wonderful news to me. Thanks, -Bill On 4/12/2015 1:42 PM, V Stuart Foote wrote: Jorge Rodríguez Thank you for submitting. I've uploaded your proposed StartCenter mockup to the Wiki--please log-in there (create an account if you do not already have one) and adjust the licensing and description for your artwork. https://wiki.documentfoundation.org/Design/Whiteboards/5.0_Branding Also, please consider that in your mockup, you appear to have eliminated the thumbnail view of recently used documents. That is a critical design element that can not be removed. So, your design needs additional work. You'll need to rework your mockup to show where thumbnail views and templates would be presented. Stuart -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4146064.html Sent from the Users mailing list archive at Nabble.com. -- 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] Re: Heads up -- LibreOffice 5.0 is on the horizion
Hi Cor and all: Ok, I'm going to think ... Regards, Jorge Rodríguez El mar, 21-04-2015 a las 21:16 +0200, Cor Nouws escribió: jorge wrote on 21-04-15 18:28: https://wiki.documentfoundation.org/File:Design_White_Board-LibreOffice.png Thanks for your work on this Jorge. But IMO a design for our needs must be more cute, straight and so. Yours look more as an idea for a poster - so I would suggest to keep and improve it for such an opportunity. Regards, Cor -- 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] Re: Heads up -- LibreOffice 5.0 is on the horizion
Hi Jim, Cor and all: Yes, it would be a good idea, thank you, Regards, Jorge Rodríguez El mar, 21-04-2015 a las 13:17 -0700, James E Lang escribió: Cor and Jorge, IMO a design like this would be acceptable in a private user environment but not in many corporate environments. Maybe LibreOffice could consider offering two themes. -- Jim -Original Message- From: Cor Nouws oo...@nouenoff.nl To: jorge jrodrigue...@cpcecr.com Cc: users@global.libreoffice.org Sent: Tue, 21 Apr 2015 12:18 Subject: Re: [libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion jorge wrote on 21-04-15 18:28: https://wiki.documentfoundation.org/File:Design_White_Board-LibreOffice.png Thanks for your work on this Jorge. But IMO a design for our needs must be more cute, straight and so. Yours look more as an idea for a poster - so I would suggest to keep and improve it for such an opportunity. Regards, Cor -- Cor Nouws GPD key ID: 0xB13480A6 - 591A 30A7 36A0 CE3C 3D28 A038 E49D 7365 B134 80A6 - vrijwilliger http://nl.libreoffice.org - volunteer http://www.libreoffice.org - The Document Foundation Membership Committee Member -- 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] Re: Heads up -- LibreOffice 5.0 is on the horizion
Hi all: I've modified the first suggestion of WhiteBoard design for Libre Office 5.0. I include the thumbnail as Stuart request, and licence and description of artwork: https://wiki.documentfoundation.org/File:Design_White_Board-LibreOffice.png Regards, Jorge Rodríguez El dom, 12-04-2015 a las 10:42 -0700, V Stuart Foote escribió: Jorge Rodríguez Thank you for submitting. I've uploaded your proposed StartCenter mockup to the Wiki--please log-in there (create an account if you do not already have one) and adjust the licensing and description for your artwork. https://wiki.documentfoundation.org/Design/Whiteboards/5.0_Branding Also, please consider that in your mockup, you appear to have eliminated the thumbnail view of recently used documents. That is a critical design element that can not be removed. So, your design needs additional work. You'll need to rework your mockup to show where thumbnail views and templates would be presented. Stuart -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4146064.html Sent from the Users mailing list archive at Nabble.com. -- 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] Re: Heads up -- LibreOffice 5.0 is on the horizion
Hi Stuart and all: Thank you very much. I'm not shure about what the meaning of thumbnail in this case ... would you please explain me or somebody else ? Of curse I'm going to rework with templates and thumbnail and licensing and description for my artwork with pleasure, and create the account. Regards, Jorge Rodríguez El dom, 12-04-2015 a las 10:42 -0700, V Stuart Foote escribió: Jorge Rodríguez Thank you for submitting. I've uploaded your proposed StartCenter mockup to the Wiki--please log-in there (create an account if you do not already have one) and adjust the licensing and description for your artwork. https://wiki.documentfoundation.org/Design/Whiteboards/5.0_Branding Also, please consider that in your mockup, you appear to have eliminated the thumbnail view of recently used documents. That is a critical design element that can not be removed. So, your design needs additional work. You'll need to rework your mockup to show where thumbnail views and templates would be presented. Stuart -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4146064.html Sent from the Users mailing list archive at Nabble.com. -- 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] Re: Heads up -- LibreOffice 5.0 is on the horizion
Hi all: As Mr. V Stuart Foote request, I gave me too an oportunity to design a DashBoard (Known as WhiteBoard) that I suggest to you and to the Libre Office community and it would be apreciate by you and could be selected it as official LOWB. This is the link where the file would be to get: https://www.dropbox.com/s/pt3awswsv1536cx/Design% 20WhiteBoard-LibreOffice%205.png?dl=0 Regards, Jorge Rodríguez El vie, 10-04-2015 a las 19:20 -0700, V Stuart Foote escribió: Current build of master 5.0... with Breeze icons http://nabble.documentfoundation.org/file/n4145916/5.png Breeze icons may or may not end up on the StartCenter panel--we need that design and layout discusion to occur. Feel free to contribute... https://wiki.documentfoundation.org/Design/Whiteboards/5.0_Branding Stuart -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4145916.html Sent from the Users mailing list archive at Nabble.com. -- 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] LibreOffice 5.0 is released
Hi all: I like that L05 webbanner ! The message and design are fine ! Regards, Jorge Rodríguez El mié, 05-08-2015 a las 12:33 +0200, Charles-H.Schulz escribió: ... and we have a banner, please feel free to use it and share: https://wiki.documentfoundation.org/images/0/05/L05_webbanner.png (announcement: http://blog.documentfoundation.org) Cheers, -- Charles-H. Schulz Co-founder, The Document Foundation, Kurfürstendamm 188, 10707 Berlin Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts Legal details: http://www.documentfoundation.org/imprint Mobile Number: +33 (0)6 98 65 54 24. -- 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] [OT] Operating Environment Survey
My remembers and my present: My first contact with a computer was with a main fraime (That all I know and remember of my first job). My second time was with a Unisys system that has a supply system to help my job. A very old kind of terminal. My third contact was my first time with windows (I don't know what was it), but was when I learn lotus-123 as a spreedsheet. My third job. In my four job I used As-400 for Account System, Unisys for the rest of system of the bank. And again, windows where I learn Office include Access (W-95 and its office with the best Access that I've known. Then go down). Here I bought my first personal computer (A clon). With windows and office with out access. In my last three jobs I used w7 and office and introduce to my self use OpenOffice and LibreOffice and Ubuntu 12.04 LTS. My actual personal computer has Ubuntu 14.04 LTS with dual boot with w7 for very especific situations. Both with LibreOffice and the second with OpenOffice too. The laptop has Ubuntu 15.04 LTS with LibreOffice and the tablet use Android with Android Open Office and WPS (Kingsoft Office) and others that I don't rememeber now very well. I hope not tired you with my computer's part of my live. Regards, Jorge Rodríguez El mar, 21-07-2015 a las 11:15 +, Gary Collins escribió: On 07/18/2015 09:25 PM, James E Lang wrote: The big discussion of Linux over the past 24+ hours has me wondering: What operating environment(s) do other members of this list use at home and at work? What factors influence the choice? My first home computer was a BBC micro (anyone remember those?) That was back in the days when programming had to be really tight, only had 32Kb (yes, Kb) of RAM; long term storage was all external on cassette tapes, eventually upgraded to floppy disk drive (and the disks really were floppy). I've still got that computer and AFAIK it still works! My next machine was Acorn Archimedes, followed by RISC PC. It's a great shame that the marketing for those machines was so poor, leading to collapse of the company. The ARM chips had a great architecture and instruction set. After that, I got my first laptop, a Sony Vaio running windows XP. When I upgraded, which I was forced to do due to a machine failure, I got a laptop running Windows 7 - which is still my current machine. A better Windows, once I'd got used to it, but it had a real downer - couldn't get driver for my flatbed scanner - Canon didn't produce one. At work, in my first job I used a computer called a PDP 11 (ghastly thing); can't remember what the OS was called. In my second job I think we started off with some sort of mainframe, the details of which are hazy now. Later we migrated to Sun Spark workstations. In my last real job, used PCs running windows, I think it was XP at that time. Now in my office based voluntary work I use PCs with Windows 7. Did have a play with Win 8 on a laptop, but hated it. It might be OK for tablets, I don't know, but it was horrible to use with normal PC input devices. I have thought about upgrading to Linux but have never got around to it. This is mainly because of familiarity with certain software packages, especially Photoshop. I know there is GIMP for Linux, but it's not a patch - for one thing, it doesn't have the concept of adjustment layers; and that means that all my working files, which tend to be saved as TIFF with layer compression, can't be properly loaded and edited in GIMP.I also make use of a video editor (not free but fairly inexpensive) which can edit MPEG2 files without reencoding unchanged parts of the video, which makes it quite fast and doesn't lose quality. Something like that probably does exist for Linux but I haven't got around to looking, and familiarity is a big part of the story.Another thing is the convenience of plug and play when it comes to hardware - I don't think I've ever had to manually load a driver, everything seems to work out of the box and that's a very good thing, saves a lot of time and effort. I'm not sure what Linux is like in that respect, as I've had no experience. On my phone I have android and I tend to get on reasonably well with that. I'm not sure what I will do if I ever need to change computer again. /Gary -- 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] writer: repeat a cell content (string) in a cell or in text
Hi all: I supoused that you can use A1something that you have in A2 (With out quotes) Regards, Jorge Rodríguez El mar, 21-07-2015 a las 14:41 +0100, Brian Barker escribió: At 14:45 21/07/2015 +0200, Pier Andreit wrote: I would like to do in writer (tables or text) as in calc, if in cell A1 I have something and in cell A2 I insert =A1 in cell A2 I'll have something The syntax would be =A1, I think. I tried with formulas but didn't succeed. it seems that they treat only numbers... It seems so. any suggestion? Yes: create what you need in a spreadsheet and copy and paste the required cell range into your text document. It will appear as a table but will function like the spreadsheet section that it is. I trust this helps. Brian Barker -- 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] Re: Ubuntu 15.10 will include LO 5.0.2.2
Hi Tim and all: Thank you for this information about LibreOffice. By the way, as I know this is the link to Ubuntu Mate: https://ubuntu-mate.org/wily/ And if you want you can install Ubuntu with Unity but installing Mate desktop from its repositories (At least I did with Ubuntu 15.04 in one of my systems) Regards, Jorge Rodríguez El vie, 23-10-2015 a las 10:03 -0400, Tim---Kracked_P_P---webmaster escribió: > I saw the article today, but had not checked if it came out yet. > > I use the MATE desktop instead of Ubuntu's Unity desktop, or even the > newish Ubuntu GNOME distro. > > I think there is a Ubuntu MATE distro out somewhere. > > > On 10/23/2015 08:06 AM, Aurelius Octavian wrote: > > Yes, that's correct. Ubuntu 15.10 and all its flavors (Xubuntu, > > Kubuntu, and so on) came out yesterday and the Werewolf features LO > > 5.0.2.2 . > > > > Typing this on an Ubuntu 15.10 machine with the nice LO 5.0.2.2 > > sitting in the system tray. > > > > Aurelius > > > > > > > > Am 23.10.2015 um 12:52 schrieb Tim---Kracked_P_P---webmaster: > >> > >> If anyone is interested. . . . > >> > >> Ubuntu 15.10, a.k.a. " Wily Werewolf " is scheduled to come out this > >> week, > >> according to an article. > >> > >> The same article has a picture of a LibreOffice "splash screen", > >> showing that > >> this distro will include LibreOffice 5.0.2.2. > >> > >> I run 14.04LTS and 15.04, so on the 15.04 system, I should be > >> upgrading it in > >> a few weeks. I have not upgraded that system's LO beyond 4.4.5.2, > >> though > >> another system has 5.0.2.2 currently installed. > >> [I run Ubuntu, Linux Mint, and/or Windows 10 on my various systems] > > > > > > -- 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] Fwd: [libreoffice-l10n] My post on OpenSource.Com : Celebrating the success of LibreOffice in Denmark
Hi Tom and all: Thank you to share this article...very interesting and important for our community ! ( And thanks too to Rajesh ) Regards, Jorge Rodríguez El mié, 21-10-2015 a las 23:25 +0100, Tom Davies escribió: > Hi :) > Rajesh Ranjan posted a link to an article about a recent L:ibreOffice event > that i thought that some people here might find interesting. > Regards from > Tom :) > > > -- Forwarded message -- > From: Rajesh Ranjan <*hidden*> > Date: 21 October 2015 at 10:05 > Subject: [libreoffice-l10n] My post on OpenSource.Com : Celebrating the > success of LibreOffice in Denmark > To: l...@global.libreoffice.org > > > https://opensource.com/business/15/10/celebrating-success-libreoffice-denmark > > -- > Rajesh Ranjan > www.rajeshranjan.in > @kajha <https://twitter.com/kajha> > > Join the largest l10n conference of FOSS world - FUEL GILT Conference 2015 > > http://fuelproject.org/gilt2015/index > -- 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] The UK government embraces open source with the help of LibreOffice - TechRepublic
Hi all: It looks like a Troll with a web site, isn't it ? Regards, Jorge Rodríguez El mié, 11-11-2015 a las 11:48 -0500, James Knott escribió: > http://www.techrepublic.com/article/the-uk-government-embraces-open-source-with-the-help-of-libreoffice/?tag=nl.e011_cid=e011=e011=TRE475558a > > -- 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] The UK government embraces open source with the help of LibreOffice - TechRepublic
Hi all: Thank you for the information and comments to clear my thinking. Regards, Jorge Rodríguez El mié, 11-11-2015 a las 18:37 +, Brian Barker escribió: > At 11:36 11/11/2015 -0600, Jorge Rodríguez wrote: > >It looks like a Troll with a web site, isn't it ? > > No - here's the straight dope: > https://www.gov.uk/government/news/collabora-deal-will-provide-savings-on-open-source-office-software > > Brian Barker > > -- 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
