Re: [libreoffice-users] Issues downloading LibreOffice Portable
Hi, You can also use this plugin: http://extensions.libreoffice.org/extension-center/libreoffice-server-installation-gui You can install any version of LibreOffice in parallel Good luck! 2013/12/18 Tom Davies tomc...@gmail.com Hi :) This link might help https://www.libreoffice.org/download/portable/ There is another portable apps type of place that has every version of LibreOffice but i'm not sure of the address. The marketing team were going to put their link on the same page as the link i just gave but i didn't read the page to see if it's there. Regards from Tom :) On 18 December 2013 01:40, Name Hidden for Security Reasons xmlhttprequest.o...@gmail.com wrote: Hello, Sorry for replying so late. I was just searching my disposable inbox for portable, not expecting to find anything, and found your e-mail. I found that LibreOffice Portable is available on CNet's Download.com service ( http://download.cnet.com/LibreOffice-Portable/3000-18483_4-75449672.html?tag=mncol;1 ). However, the version is shown as 4.1, and last updated July 29, 2013. The LibreOffice Portable site on PortableApps.com lets me download version 4.1.3, but the same problems persist. I've cleared the browser cache, tried different browsers (IE, Firefox, and Chrome), and even tried different computers and wireless networks. I get the same result, in which the browser gets the impression that the download is complete, and upon opening the .paf.exe file, I get Installer integrity check failed. error. I'm using Windows Vista 64-bit. Version 4.1 (downloadable from Download.com) downloaded successfully, and I installed it on my flash drive successfully. Did The Document Foundation quit mirroring their downloads off of Download.com? Thank you. On 12/3/2013 7:55 AM, Tom Davies wrote: Hi :) Did you manage to solve this in the end? I think the Portable Aps version is only for Windows. On Linux it's much easier to install LibreOffice through any of your package managers although you might not get the most up-to-date one. However it is odd that you were having trouble downloading with Firefox. Any nonIE web-browser tend to be able to cope better with intermittent connections. The only way you could usually improve on that is by using the torrent. You probably have a reasonably good torrenting client built-in to your system so just download the tiny torrent and then allow your client to use it or else double-click on it when it's downloaded. Either way the full download should start shortly after. It might be even better to try a different mirror but i've not figured out how to do anything like that. Most people know but it eludes me Regards from Tom :) On 28 November 2013 18:53, Name Hidden for Security Reasons xmlhttprequest.o...@gmail.com wrote: Hello, I was trying to download the LibreOffice 4.1.3 Portable edition from LibreOffice.org, and then tried the download from PortableApps.com. I've tried to download the package using different methods and browsers, and the download (which is supposed to be around 113 MB, according to HTTP headers) stops (at anywhere from 7.9 MB downloaded to 40.2 MB downloaded, in the multiple attempts to download LibreOffice Portable). The browser gets the impression that the download is completed. However, I get an error message when opening the LibreOfficePortable_4.1.3_MultilingualNormal.paf.exe file, saying that the installer integrity check failed. I know that: * I am using a direct connection to the internet router. * I got the same, repeating issue every time I tried to re-download the file. * It appeared as if I were being redirected to a mirror. * Nothing is wrong with my hosts file (%systemroot%\system32\drivers\etc\hosts). * I didn't lose my internet connection. I've come to the conclusion that something might be wrong with the servers of The Document Foundation, LibreOffice, or the mirror mirror.nexcess.net. Is there anything I can do to download LibreOffice Portable without these issues, or is something going on on your servers or the mirror? I also noticed unusual behavior of the LibreOffice website when attempting to download LibreOffice Portable, as described below in the HTTP headers: Data I found questionable is marked red, while data that is unusual is marked yellow, followed by a note. When I clicked the download button for LibreOffice, I noticed that it goes to the url http://download.documentfoundation.org/libreoffice/portable/4.1.3/LibreOfficePortable_4.1.3_MultilingualNormal.paf.exe . However, I get redirected to a mirror url ( http://mirror.nexcess.net/tdf/libreoffice/portable/4.1.3/LibreOfficePortable_4.1.3_MultilingualNormal.paf.exe ). When reviewing the headers of the requests, I found some information in the headers that is
[libreoffice-users] Re: Issues downloading LibreOffice Portable
I recommend that you download the latest version from winPenPack http://www.winpenpack.com/en/download.php?view.1354 or any version you prefer... http://sourceforge.net/projects/winpenpack/files/X-LibreOffice/releases/ X-LibreOffice has more features and is better optimized than Portable LibreOffice from PortableApps. It is also supported by TDF so you can be sure it's not a hacked (in the negative sense of the word) version. Hope this helps ;) -- View this message in context: http://nabble.documentfoundation.org/Issues-downloading-LibreOffice-Portable-tp4085447p4088958.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] FDO/Bugzilla Outages: Technical difficulties, please stand by
The FDO site has been sporadically unavailable for the last hour or so. Anything that interacts with Freedesktop.org Bugzilla may be affected, including - Bugzilla - The BSA - IZBot - EasyHacks wiki pages - Other collections of bug reports on wiki pages - The bug-reporter tool - The MAB tool - etc... NOTE: If you're filing or editing bugs in Bugzilla, please confirm that your edits are *fully saved* before leaving the page. If you get a timeout error, you can usually just hit the back button in your browser and rescue all of your data. If you do hit a timeout or other bug, I *wholeheartedly* recommend that you don't keep on trying to save the tab w/data in it (which might result in some loss), but instead open a 2nd tab in your browser and test FDO every minute or two until it's back up. Once the site is up, promptly save the edits that have been hanging out in your 1st tab. If I hear any updates from FDO, I'll let you know. Best, --R -- 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] multiple file import
I would love this feature, but with one thing added. Imported files would automatically take the name of the original files. Offending characters would be stripped or substituted. Duplicate file names would have an increment adder. On 12/18/2013 3:32 PM, Brian Barker wrote: At 19:13 18/12/2013 +, Nobody Noname wrote: Is there a way to import multiple files into a new document? The existing function only allows multiples files to be imported successively, which is inefficient. If a directory contains file1 file2 file3 it would be beneficial to be able to select all files in the import dialogue window for automatic successive import into the new document. One obvious problem would be the necessity to indicate the order in which multiple files should be incorporated. It would be easy if you had files with carefully organised names, but in general you wouldn't have that. In any case, would file10 become positioned after file9 or between file1 and file2? Would that apply in all operating systems? If you needed either to list the files in the order in which you wanted them incorporated, or else to readjust everything after assembly, you would be better off (and achieve a more reliable result) by simply importing one at a time. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Issues downloading LibreOffice Portable
What are the differences between the winPenPack version of LO and the one from PortableApps.com. What do you mean by more features and better optimized? I thought that the PortableApps.com version that LO's web site links to does not remove any features so the more features statement needs to be clarified. If the winPenPack is so much better than the other one, then why is it not listed in the Portable page of LO's site? On 12/19/2013 07:25 AM, Pedro wrote: I recommend that you download the latest version from winPenPack http://www.winpenpack.com/en/download.php?view.1354 or any version you prefer... http://sourceforge.net/projects/winpenpack/files/X-LibreOffice/releases/ X-LibreOffice has more features and is better optimized than Portable LibreOffice from PortableApps. It is also supported by TDF so you can be sure it's not a hacked (in the negative sense of the word) version. Hope this helps ;) -- View this message in context: http://nabble.documentfoundation.org/Issues-downloading-LibreOffice-Portable-tp4085447p4088958.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] multiple file import
At 09:26 19/12/2013 -0500, Paul D. Mirowsky wrote: At 19:13 18/12/2013 +, Nobody Noname wrote: Is there a way to import multiple files into a new document? The existing function only allows multiples files to be imported successively, which is inefficient. If a directory contains file1 file2 file3 it would be beneficial to be able to select all files in the import dialogue window for automatic successive import into the new document. I would love this feature, but with one thing added. Imported files would automatically take the name of the original files. We must be at cross-purposes here! The original request is for multiple files to be imported into a fresh, single file. There would be no plurality of files to take on a plurality of names: just a single name for the single file made up of the contents of the many component files. You'd name the composite file when you saved it - and you'd very likely put it in the same folder, so you wouldn't want it to have the same name as any of its components. Offending characters would be stripped or substituted. Since the component files already exist, they can have no offending characters - either within their text or in their file names. Duplicate file names would have an increment adder. You cannot have duplicate file names in the single source directory of course - unless you are extending the idea to importing, say, a combination of .odt and .doc files into one document in one process! Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Display running total of Table Control in LibreOffice Base form
On 12/11/2013 07:25 AM, Lelanthran Manickum wrote: Hi all I posted this on stackoverflow with no success; perhaps someone where can help: I'm using LibreOffice 4.0 + MySQL on Linux. I have a form which contains a Table Control. This table has a column that is an integer. I would like to have a different control on the same form that keeps a running total of the above-mentioned integer field in the above-mentioned table control. So far I tried using a parameterised query that gets executed in a subform (which holds the text box control that displays the result of the query), but this prompts me for the parameter each time I change a row in the table. Basically the table control houses a table which is used to record line-items on a purchase receipt. I want a separate control that displays a running total as the user enters line-items. Warm Regards Lelanthran There are things that I do not understand about your table control. You mentioned a running total of a field, but of what is it a running total? Do you need to use the SUM function, or would the COUNT function work? Without knowing what is the purpose of the field, it is hard to know how to get the information you want to appear in the form. A query is likely what you would need to use to solve your problem. But without knowing what fields are contained in the table control, suggestions as to how to solve the problem are hard to make. You will need to use a query for what you want. It will contain your field of interest and at least another field which will limit the query output to the rows which are of interest to you. For example, I have a form containing the foods I eat. One table control contains the nutitional information about the foods as well as a field with a checkbox to select the foods I eat. I want to know the quanity of protein, carbohydrates, and fats that I consume (one query). In another query, I want to know what are the percentage of total calories that I get from protein, carbohydrates, and protein. Using the field with the checkbox, I can limit the data to the rows which have a check. Then I can add, multiply, and divide in the query to get the results I want. --Dan -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Issues downloading LibreOffice Portable
krackedpress wrote What do you mean by more features and better optimized? I thought that the PortableApps.com version that LO's web site links to does not remove any features so the more features statement needs to be clarified. No features are removed on any of the Portable packs. winPenPack allows to choose on first run the language that you want to use as default for the interface and any other language (or languages) as alternative for the GUI as well as for dictionaries. PortableApps only allows to choose between English only OR English (US and GB), Arabic, Chinese (Simplified and Traditional), French, German, Italian, Japanese, Korean, Portuguese (Brazilian and Portugal), Russian, and Spanish There is no option for e.g. Portuguese only. On a slow computer when running LO from a pen drive (connected to a USB 2.0 port...) X-LibreOffice loads faster and seems to respond faster (maybe because it has less language modules?) than Portable LibreOffice Another reason why I prefer winPenPack is that new releases of X-LibreOffice are usually available soon after the official release by TDF (e.g. LO 4.1.4 was announced yesterday and X-LibreOffice 4.1.4 is already available today) This allows me to install a new version (e.g. LO 4.2.0.1 which is a Release Candidate so it overwrites my install) and still have the previous version as a portable ready to test for regressions. krackedpress wrote If the winPenPack is so much better than the other one, then why is it not listed in the Portable page of LO's site? Maybe because X-LibreOffice is only sanctioned by the Italian LibreOffice Community http://it.libreoffice.org/download/portatile/ but not by the German/Global TDF... You should ask that to TDF. -- View this message in context: http://nabble.documentfoundation.org/Issues-downloading-LibreOffice-Portable-tp4085447p4089015.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mail Merge and Labels
** Reply to message from Brian Barker b.m.bar...@btinternet.com on Wed, 18 Dec 2013 17:10:24 + At 07:46 18/12/2013 -0600, Cliff Scott wrote: Initially I just want a sheet with all the labels the same. [...] For now I can obviously copy/paste to each label, but the wizard's way of entering data for one then propagating it to all is handy for like a set of return address labels. If you are using a table, have you tried my suggestion in a related thread? o Put the cursor in the cell containing the text. o Press Ctrl+A to select all the text in that cell. o Press Ctrl+C to copy that text. o Press Ctrl+A again to select the entire table. o Press Ctrl+V to paste copies of the text into all the cells at once. I trust this helps. Thanks Brian. Saw that after I sent my email. Should work fine. Cliff -- 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: Issues downloading LibreOffice Portable
Did someone [other than you] once state that the X-LibreOffice can be run even if you have installed a version of Lo on your Windows system, while the PortableApps version cannot? I do not use Windows, much, unless I need to deal with a Win-only package on my laptop[s]. I mostly use Ubuntu 12.04LTS, which is the only OS on my desktop [Ubuntu 12.04LTS 64-bit, Quad processor with 6 TB of drive space]. I use my laptops for both Ubuntu and Win7 OSs, when needed. So, if I get what you are implying, you would recommend using the X-LibreOffice on a flash drive to show users how well LO could work for them, without having them install LO on their systems. Is there anything else from the winPenPack that should be installed on that flash drive [16 GB would be my choice] to make the use/process be smoother for the demonstration? Also, can you install extra dictionaries and other .oxt extensions to the X-LibreOffice flash drive setup? Some of the extension that are out there might be useful for a potential user, plus my 797,865 word spell checking en_US dictionary is something I tend to install by default on any system that I install LO on. If the X-LibreOffice is a good option, I may add that to the NA-DVD project as a second portable version choice. Since I got out of a week's stay in the hospital, I have been thinking about what I can do to improve that project and the presentation [again] to local business groups. So having more options and more documentation showing how well LO works for the business and educational communities would help. The option of trying out a faster portable version of LO would be one of the helpers. Last time I tried the PortableApps.com version, it was very slow on my dual core laptop. On 12/19/2013 12:04 PM, Pedro wrote: krackedpress wrote What do you mean by more features and better optimized? I thought that the PortableApps.com version that LO's web site links to does not remove any features so the more features statement needs to be clarified. No features are removed on any of the Portable packs. winPenPack allows to choose on first run the language that you want to use as default for the interface and any other language (or languages) as alternative for the GUI as well as for dictionaries. PortableApps only allows to choose between English only OR English (US and GB), Arabic, Chinese (Simplified and Traditional), French, German, Italian, Japanese, Korean, Portuguese (Brazilian and Portugal), Russian, and Spanish There is no option for e.g. Portuguese only. On a slow computer when running LO from a pen drive (connected to a USB 2.0 port...) X-LibreOffice loads faster and seems to respond faster (maybe because it has less language modules?) than Portable LibreOffice Another reason why I prefer winPenPack is that new releases of X-LibreOffice are usually available soon after the official release by TDF (e.g. LO 4.1.4 was announced yesterday and X-LibreOffice 4.1.4 is already available today) This allows me to install a new version (e.g. LO 4.2.0.1 which is a Release Candidate so it overwrites my install) and still have the previous version as a portable ready to test for regressions. krackedpress wrote If the winPenPack is so much better than the other one, then why is it not listed in the Portable page of LO's site? Maybe because X-LibreOffice is only sanctioned by the Italian LibreOffice Community http://it.libreoffice.org/download/portatile/ but not by the German/Global TDF... You should ask that to TDF. -- View this message in context: http://nabble.documentfoundation.org/Issues-downloading-LibreOffice-Portable-tp4085447p4089015.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Issues downloading LibreOffice Portable
krackedpress wrote Did someone [other than you] once state that the X-LibreOffice can be run even if you have installed a version of Lo on your Windows system, while the PortableApps version cannot? That is not true. What I said (and still is true) is that you can not run LibreOffice Portable if your installed LibreOffice is running. You get a message saying Another instance of LibreOffice is already running. Please close other instances of LibreOffice before launching LibreOffice Portable. However you can run as many X-LibreOffice versions simultaneously and at the same time as the installed version as you wish (or your machine handles...) (I had forgotten about that limitation when I mentioned why I prefer X-LibreOffice. Thank you for reminding me :) ) krackedpress wrote So, if I get what you are implying, you would recommend using the X-LibreOffice on a flash drive to show users how well LO could work for them, without having them install LO on their systems. Is there anything else from the winPenPack that should be installed on that flash drive [16 GB would be my choice] to make the use/process be smoother for the demonstration? If your demonstration uses features that require Java you might need to investigate how to get a portable Java (just to be on the safe side in case the PC used for demonstration does not have an installed version of Java...). I know there is one from PortableApps and there should be an equivalent from winPenPack. I don't use Java so I haven't investigated that part. For me one of the greatest advantages of having a fully working version of LibreOffice running from a flash drive is that you can take a presentation in ODP with you AND the software that runs it. So there is no need to convert to PowerPoint and there is no problem if the PC used for presentation doesn't have an ODF compliant office suite or only has one that (deliberately?) has problems in loading an ODP presentation. Just load the Portable LibreOffice (either one) and load the presentation. Easy :) krackedpress wrote Also, can you install extra dictionaries and other .oxt extensions to the X-LibreOffice flash drive setup? Some of the extension that are out there might be useful for a potential user, plus my 797,865 word spell checking en_US dictionary is something I tend to install by default on any system that I install LO on. Yes, of course. On both portable Offices. Any extension or theme (again, check if Java is needed) krackedpress wrote If the X-LibreOffice is a good option, I may add that to the NA-DVD project as a second portable version choice. I think you should. More choices is always good when you are distributing something that can be used in ways that you can't even imagine... krackedpress wrote I have been thinking about what I can do to improve that project and the presentation [again] to local business groups. So having more options and more documentation showing how well LO works for the business and educational communities would help. The option of trying out a faster portable version of LO would be one of the helpers. Last time I tried the PortableApps.com version, it was very slow on my dual core laptop. Actually I just loaded version 4.1.3 of both portable offices from an external USB 3.0 hard disk on a fast computer (Dual Core @3GHz) and there is no noticeable difference. Maybe things have improved (or they are only noticeable on slow computers...) One of the greatest advantages of having a portable version of LibreOffice is that you can suggest people to just try it without the need to install anything. There is no risk. No mess. If they are not happy with it, they can simply erase it and try another version in a few months -- View this message in context: http://nabble.documentfoundation.org/Issues-downloading-LibreOffice-Portable-tp4085447p4089041.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Writer - Tables - problem
In writer in a table I have numerical data entered in a column. I set the column to be right justified and the numeric format to currency. Occasionally I'll enter a number and it will not format correctly and will shift to the left. I can force it to right justify the cell contents, but I can't force it to apply currency numeric format. What am I doing wrong? Paul Whitehurst whan...@aol.com -- View this message in context: http://nabble.documentfoundation.org/Writer-Tables-problem-tp4089049.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] with styles, is not master document functionality unnecessary+
On 18/12/2013, Gabriel Risterucci cleyf...@gmail.com wrote: Master document are not only about sharing styles (in fact, I never saw them in this light), it's about splitting your work in easily manageable smaller files. I don't even know why having styles would concern having the possibility to create a master document. When you're working on a reasonnably large project, it's simply easier to split it. For example, having each chapter in it's own file, instead of loading one huge file. It's more stable and easier to navigate. Ahem, still don't get why you're mixing the presence of styles and master document. The only link I can think of is that a master document's style override the sub-documents, but even then... maybe you can clarify what you meant? Found a list of files in a directory, each file was quite small is size. That's what started to think whether a master document is appropriate or not. If styles are extensive in each of the small files, importing them into a new file would be expected to retain styles and therefore make navigation via 'navigator' to be more convenient than opening multiple individual files -- 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: Importing .xls table into Base
Hi :) I think Base is best when you keep those tables externally, preferably in a dedicated database program such as MySql / MariaDb, Postgresql, HsqlDb or any of the other ones. Access is not so good at linking to external sources for it's data so it's quite a radical difference between Access and Base. It means Base is much easier to upscale (or downscale) just by swithcing which back-end program is storing your data. The link didn't work very well for me either. The close-bracket at the end seems to have grabbed the f which radically changes the address and just got me something like a 404 Page does not exist error. It might be better to look through the wiki's Faq about Base https://wiki.documentfoundation.org/Faq Also the official documentation has a handbook and the 1st 3 chapters of the guide. https://wiki.documentfoundation.org/Documentation/Publications I wonder if the pdf link works better like this? * https://wiki.documentfoundation.org/images/e/e8/BH40-BaseHandbook.pdf Regards from Tom :) On 16 December 2013 21:22, dollyp da...@lochnevis.com wrote: julien2412 wrote Taking a look to the documentation, I read this: Exporting data from Calc into a database Select the data in the Calc worksheet. Hold the left mouse button down and drag the data that you want to turn into a database into the table area of the database browser. (see https://wiki.documentfoundation.org/images/e/e8/BH40-BaseHandbook.pdf) Sorry I can't find this info in the document you linked to. There are several paragraphs about linking to spreadsheets but that's all I can find. Nevertheless, thanks to both responders for the information, which proved to be what I needed. I would say that for folk coming to Base from Access, the lack of a menu option for 'import' does not help. To be fair, select/paste is more intuitive and a plus for Base. Again thanks David -- View this message in context: http://nabble.documentfoundation.org/Importing-xls-table-into-Base-tp4088116p4088435.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
Re: [libreoffice-users] Re: Issues downloading LibreOffice Portable
Hi :) The marketing team did discuss the WinPenPack option and decided it was a great idea and that there should be a link to it on the LibreOffice web-page about Portable Apps. Errr but then we didn't get around to it! :( Sorry! This sort of thing does happen in any organisation but when it happens in other types it's claimed to have been done deliberately but when it happens in an organisation like this one it's held as an example of why CEOs are worth paying vast salaries too. Apols and regards from Tom :) On 19 December 2013 17:04, Pedro pedl...@gmail.com wrote: krackedpress wrote What do you mean by more features and better optimized? I thought that the PortableApps.com version that LO's web site links to does not remove any features so the more features statement needs to be clarified. No features are removed on any of the Portable packs. winPenPack allows to choose on first run the language that you want to use as default for the interface and any other language (or languages) as alternative for the GUI as well as for dictionaries. PortableApps only allows to choose between English only OR English (US and GB), Arabic, Chinese (Simplified and Traditional), French, German, Italian, Japanese, Korean, Portuguese (Brazilian and Portugal), Russian, and Spanish There is no option for e.g. Portuguese only. On a slow computer when running LO from a pen drive (connected to a USB 2.0 port...) X-LibreOffice loads faster and seems to respond faster (maybe because it has less language modules?) than Portable LibreOffice Another reason why I prefer winPenPack is that new releases of X-LibreOffice are usually available soon after the official release by TDF (e.g. LO 4.1.4 was announced yesterday and X-LibreOffice 4.1.4 is already available today) This allows me to install a new version (e.g. LO 4.2.0.1 which is a Release Candidate so it overwrites my install) and still have the previous version as a portable ready to test for regressions. krackedpress wrote If the winPenPack is so much better than the other one, then why is it not listed in the Portable page of LO's site? Maybe because X-LibreOffice is only sanctioned by the Italian LibreOffice Community http://it.libreoffice.org/download/portatile/ but not by the German/Global TDF... You should ask that to TDF. -- View this message in context: http://nabble.documentfoundation.org/Issues-downloading-LibreOffice-Portable-tp4085447p4089015.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
Re: [libreoffice-users] with styles, is not master document functionality unnecessary+
2013/12/19 e-letter inp...@gmail.com On 18/12/2013, Gabriel Risterucci cleyf...@gmail.com wrote: Master document are not only about sharing styles (in fact, I never saw them in this light), it's about splitting your work in easily manageable smaller files. I don't even know why having styles would concern having the possibility to create a master document. When you're working on a reasonnably large project, it's simply easier to split it. For example, having each chapter in it's own file, instead of loading one huge file. It's more stable and easier to navigate. Ahem, still don't get why you're mixing the presence of styles and master document. The only link I can think of is that a master document's style override the sub-documents, but even then... maybe you can clarify what you meant? Found a list of files in a directory, each file was quite small is size. That's what started to think whether a master document is appropriate or not. If styles are extensive in each of the small files, importing them into a new file would be expected to retain styles and therefore make navigation via 'navigator' to be more convenient than opening multiple individual files If I understand correctly, your files are not meant to get glued together, but only to share styles. In that case, there is several things to know: - If the files already exists, you can load styles from one document to another one. It will erase all styles in the current document that share a name with the loaded ones, but subsequent changes in either files won't be repercuted in the other. - If you're creating new files, create a template beforehand (even an empty one) that will be used to create your documents. By doing so, if you change the styles in the template, when opening a file created with this template it will prompt you about updating styles in the document. There's effectively a link between the documents and the template - Additionnaly, you can create that link between a document and a template using the following extension: http://extensions.libreoffice.org/extension-center/template-changer. By doing so, updating the template will have the behavior described before, as in it will prompt you to update the various independant files. Note that this extension, while not updated for long, still work. However having this feature built-in (the ability to change a document's master template) would be nice. -- Cley Faye http://cleyfaye.net -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] with styles, is not master document functionality unnecessary+
On Thursday 19 December 2013 10:56:25 PM Gabriel Risterucci wrote: - Additionnaly, you can create that link between a document and a template using the following extension: http://extensions.libreoffice.org/extension-center/template-changer. By doing so, updating the template will have the behavior described before, as in it will prompt you to update the various independant files. Note that this extension, while not updated for long, still work. However having this feature built-in (the ability to change a document's master template) would be nice. This might not be such a good idea. In MS Word, changing the template used to be a major source of corruption and formatting problems. For all I know, it still is. -- Bruce Byfield 604-421-7189 (on Pacific time) blog: https://brucebyfield.wordpress.com website: http://members.axion.net/~bbyfield/ -- 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 - Tables - problem
At 11:43 19/12/2013 -0800, Paul Whitehurst wrote: In writer in a table I have numerical data entered in a column. I set the column to be right justified and the numeric format to currency. Occasionally I'll enter a number and it will not format correctly and will shift to the left. I can force it to right justify the cell contents, but I can't force it to apply currency numeric format. What am I doing wrong? You may want to experiment with the options at Tools | Options... | LibreOffice Writer | Table | Input in tables. I don't claim to be an expert in exactly what these do, so I won't attempt to explain. But there is one thing of which you should be aware. In some circumstances, any input that does not fit the applied format - in your case, Currency - will automatically reset the format of that cell alone to Text. Note that something as simple as completing an entry into a cell with Enter (instead of an arrow key or a mouse click) will render your entry no longer acceptable as Currency and have this effect. Interestingly, if you press Enter and then Backspace to correct yourself, the problem persists, but Enter followed by Edit | Undo (or Ctrl+Z) works without resetting the cell format. Note also that if you paste in a number from elsewhere, it is quite easy to bring along a trailing paragraph break, just as if you had pressed Enter, and this will likewise cause your problem When you say that you can't force it to apply currency numeric format, do you mean that reapplying the format has no effect? The only reason I can imagine for that would be that your entry cannot be interpreted as Currency: perhaps it contains a rogue character or has misplaced thousands separators, for example. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] State of password support.
Thanks for the link On 12/19/2013 01:05 AM, Massimo Del Zotto wrote: 2013/12/18 Andrew Douglas Pitonyak and...@pitonyak.org mailto:and...@pitonyak.org You mean recently?As in the latest version of LO has a problem with passwords? No, I am referring to OOo. I am considering to switch to LO because of this problem and I'm trying to figure out if this problem is considered more important by LO developers. Oh, I had not considered that you were using OOo. As a side note, I had never considered that any of them did not take passwords seriously. I don't take any of the volunteer responses as not taking it seriously, just super technical (almost to the point of silly when it is mentioned that while displayed, it is not encrypted in memory or something like that). 2013/12/18 Andrew Douglas Pitonyak and...@pitonyak.org mailto:and...@pitonyak.org Which forum, do you have a link to the post? This was in the OOo forum, https://forum.openoffice.org/en/forum/viewtopic.php?f=9t=65690. I'm not well aware how the forum admins interact with the OOo developer base, it looks to me they don't. I'd say this is another problem in itself but luckly, I'm not really interested in that one. You will notice that the forum admins are all listed as Volunteer. None of the people in question likely have any official association with OpenOffice. To my knowledge, they are simply people that help by answering questions and they may have some level of moderator capability. In my mind, an Admin has the ability to help with certain user issues or in literally maintaining the system. Massimo, you seem to be more informed of this than I, but, I am only aware of one (what I consider) real bug that existed with LO and passwords. At one point, I was no longer able to open a password protected file. Specifically, one version of LO was not able to open a password protected file. I am pretty sure it was LO and not AOO anyway. [...omissis...] Thank you very much Andrew, this is very informative. I'm currently inclined to switch to LO. I only remember one glitch with respect to passwords, and that was just related to an inability to open anything with a password. They fixed that pretty quickly. There is some issue related to crashing it seems, but, that is really tough to diagnose and fix. it might even be related to something very difficult to fix even if you do know the problem (like a saved temporary file is stored without encryption). Oh, I see that MaxDZ8 states this. I think that the real way to obtain a fix for this is to create a test case that is reproducible. something like manually killing OOo while it is running. You will need to do this with a recent copy of LO or AOO rather than with OOo for the bug report to be of any use. It is that reproducible thing that is really tough. If you cannot reproduce it, you are not likely to be able to fix it unless you are very lucky. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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