Re: [libreoffice-users] Question about document/template interaction
I think I read once about Something as * Save the file under another name (to be sure not to loose it). * Open again and delete any content. * Save as a (new) template. Je la 31/03/2018 21:29, anne-ology skribis : Here's hoping you'll receive a response soon; I wish I could help, but I don't know any thing(s) which might solve your issue. Surely somebody on this list can help you, I've been awaiting a response to my query, & still waiting with hopefulness. From: John HerronDate: Mon, Mar 26, 2018 at 12:09 PM Subject: [libreoffice-users] Question about document/template interaction To: users@global.libreoffice.org LibreOffice 5.1.6.2 / 5.3.5.2 on Linux Lite. I wrote a document based on a specific template. As I did so, I added four new styles to the document. Is there a way to automatically incorporate these new styles into the specific template, such that when I create a new document based on it, the new styles will be included in it? Thanks for helping. John Herron -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Which printer for best libreoffice integration ?
If you do want low cost printing, investigate CISS (continuous ink system). You can find printers equipped, and avid to install youself, which is somehow tricky Je la 01/03/2018 23:31, Tim-L skribis : Actually, I tend to look for third party ink sources, to help with my smaller fixed income. I know that I sometimes choose Postscript Level 3 instead of the default PDF option, when it is shown as an option. Right now, I do much more color work, so my only laser printer is slowly using the toner. I have had a replacement toner on the for several years now. I think I have about 500-600 pages to go before I need to change out the empty one. I love the HPLIP system. That system is the best driver system over any other printer brand I have used. For Canon, I have to find drivers in UK or other English countries since Canon USA does not support Linux - officially from their support people. That was before the Canon TS like of printers. I bought a TS-9020 printer and it had basic support for Linux. The scanner package is very limited compared to the MG6200 line's scanner package. At least Canon is starting to believe that the US market also has Linux users that want to use Canon printers. As for CUPS, I have CUPS-pdf driver/printing service installed as one of my printers. There seems to references to a newer PDF creating package, but have not found it. So, here is my list of network printers: Canon TS9020 inkjet all-in-one [wired and wireless] HP Laserjet 2300dn - postscript driver used HP Officejet 7000-E809a - hpcups used I had others, but they died from use. The color laser's image "belt" somehow got "scratched" during a toner install or a paper flow issue. So the middle of the printout had major issues. It would cost less to get another color laser than it would to repair it. So I chose not to replace it. On 03/01/2018 03:35 PM, Steve Edmonds wrote: I have an HP photosmart premium ink jet networked that prints and scans well, uses the HPLIP software. Don't know about the postscript support. In the office we have a networked Brother HL3170CDW that is colour laser printer only. Prints well including postscript files. Brother also seem to have good driver support. CUPS, LPR/LPRng on Linux. Steve On 02/03/18 01:58, Kurt Jaeger wrote: Hi! Our printer in the office is ending its life in colorful printouts, and we need a replacement. Current printer is a Brother MFC-9465CDN. It printed approx. 50K pages during approx. 5 years. It has duplex support, but it had its issues. We print using lpr, mostly postscript. Therefore I ask the community for feedback: Which printer works best in a mostly-libreoffice enviroment ? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] what version of LO would work on a really old system?
Since you use Ubuntu the unwanted parts can be uninstalled, or, better, unselected when preparing LO installation Je la 24/02/2018 09:35, zahra a skribis : i wished that LO has one version for home users to not install engineering programs like math, draw, base. i only need writer and have to have one office suite which most features are for engineers, businesses, companies etc. since i am not programmer and cant use linux, i should use xp. On 2/24/18, Tim-Lwrote: Hey Guys. I found two 512MB memory sticks. It now gives me about 800MB after the shared video memory. Did you know that the Ubuntu repositories do not install LO Math with LO? Found that out about an hour ago. On 02/23/2018 03:40 PM, Tom Davies wrote: Hi :) Yeh, the KDE people put a serious amount of work into it a lot lighter and faster. Initially i only tried it out for a laugh but i was quite flabergasted at how phenomenally slick it had become. Regards from a Tom :) On 23 February 2018 at 18:11, David Burleigh wrote: It's interesting to hear of Kubuntu working well on an old machine. When I last tried using it a few years ago, Nepumuk and Aconadi bogged it down so much that it became unusable. On Fri, 2018-02-23 at 16:42 +, Tom Davies wrote: Hi :) Would Gnome Office (ie Abiword and Gnumeric) be better? Also last time i tried distro-hopping on 'old' machines i found that Kubuntu was much faster and lighter-weight than even Lubuntu and Xubuntu. There was a ton of stuff to figure out and apps etc to add o really get the most out of it but the default set-up looks really swish and is very usable. Perhaps best to let the new owner enjoy their own voyage of discovery. Kubuntu uses a different office suite and i found that so light and fast that i didn't bother to try out LibreOffice on it. KOffice/Calligra uses the same file-formats as LibreOffice. Regards from a Tom :) On 23 February 2018 at 14:43, M Henri Day wrote: 2018-02-23 3:02 GMT+01:00 Tim-L : I am getting an old HP desktop, that originally WinXP, ready to give away. It has 64-bit AMD 3300+ CPU, 512MB ram, and only 160GB drive. It was an original Windows XP 32-bit OS system on a 64-bit hardware. Since it needs ALL of the old user's info removed, and XP OS "damaged", It was better to just make it a Linux system - for security reasons. I just installed Ubuntu MATE 16.04 64-bit on it. Their specs stated 32-bit would be best but the system keeps failing due a SIS630 "module missing". So with these specs, what is the newest version of LO you would install? With this low RAM, it may not be able to handle the newest versions. As I type this, the old system is now in the "software updating" cycle. So, it is installing the newest LO that is in Ubuntu 16.04's repository. To be honest, this system is a little old for my needs, but for a free giveaway system [HP desktop, keyboard, mouse, and a HP "square" 15 inch monitor], I do not have any parts to upgrade it and do not want to buy any hardware for it. So, what is the newest version I can install without and problems?. Tim, if you've managed to successfully install 64-bit Ubuntu MATE 16.04 on this system, you should be able to install and run any version of LO - why not take the latest, 6.0.1 (or 6.0.2 to which LO just updated itself via the PPA om my Linux box) ? The only thing I'd recommend beyond this would be installing a bit more RAM. Even if you've made clear that you don't wish to buy any hardware for it, you should be able to obtain some used DDR-2 sticks, which the motherboard is almost certain to support, for next to nothing, which would make a great deal of difference in how you experience the computer (the system requirements for 64-bit LO 6.0.1 are listed as 256 MB RAM, with 512 MB recommended) Henri -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-t o- unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Net iquette List archive: https://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? https://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://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? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and
Re: [libreoffice-users] My YouTube email showed a German language LO video
C'est une vidéo sur l'impression d'une feuille de calcul Video about printing a calc sheet Je la 23/02/2018 17:54, M Henri Day skribis : 2018-02-23 17:48 GMT+01:00 Tim-L: I get a newsletter email from YouTube showing various videos that I might like. One of them was a German language video about Calc. It is weird to get a non-English video notice, but at least the newsletter email service showed a LibreOffice video. Hopefully I get an English LO video notice. Here is German video "name" and the URL. Since I do not read or speak German, someone else needs to inform me what the video is about. Maybe I can look at an English version. "Seite und Drucker einrichten in Calc - LibreOffice 6 (German/Deutsch)" https://www.youtube.com/watch?v=CAbrnD8nm64=em-subs_digest Set page and printer in Calc Henri -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: base table window navigation tool
Je la 24/01/2018 18:35, Alexander Thurgood skribis : Le 24/01/2018 à 14:57, leleu a écrit : further suggestions happened in the French list, leading to a solution Ubuntu Tweak > Adjustments> Theme Gtk select HighContrast (not very nice, but readable) So, a distrib-specific problem then with regard to GTK theming ? I haven't encountered an Ubuntu distrib-release version of LibreOffice yet (and I've been through a fair few), that hasn't had more bugs than the version provided by TDF... Alex I don't think so, since the problem affects only "base" windows, but not "calc" ones. I'll try to run another version of LO, but is it possible to install it in parallel ? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: base table window navigation tool
Je la 24/01/2018 11:06, leleu skribis : Je la 24/01/2018 10:38, Alexander Thurgood skribis : Le 23/01/2018 à 19:19, robert leleu a écrit : Robert, At least under Ubuntu Gnome this tool is awfully small, unreadable. How to enlarge it ? I tried using gnome_color chooser (suggested by the French forum), to no avail. Please indicate which version of Ubuntu Gnome you are running. Please also indicate which version of LibreOffice you are attempting to use, i.e. distro-provided, extra PPA, or TDF download. Your problem might be distro-sepcific and UI specific, in which case it is unlikely to be a LO problem. Alex I should have specified again (I did in the French forum, does Esperanto has a future?) that I'm using Version: 5.4.2.2 Build ID: 1:5.4.2-0ubuntu0.17.10.1 i.e. the distro-provided version Indeed it seems to me that some months ago this problem was not there... Robert further suggestions happened in the French list, leading to a solution Ubuntu Tweak > Adjustments> Theme Gtk select HighContrast (not very nice, but readable) -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: base table window navigation tool
Je la 24/01/2018 10:38, Alexander Thurgood skribis : Le 23/01/2018 à 19:19, robert leleu a écrit : Robert, At least under Ubuntu Gnome this tool is awfully small, unreadable. How to enlarge it ? I tried using gnome_color chooser (suggested by the French forum), to no avail. Please indicate which version of Ubuntu Gnome you are running. Please also indicate which version of LibreOffice you are attempting to use, i.e. distro-provided, extra PPA, or TDF download. Your problem might be distro-sepcific and UI specific, in which case it is unlikely to be a LO problem. Alex I should have specified again (I did in the French forum, does Esperanto has a future?) that I'm using Version: 5.4.2.2 Build ID: 1:5.4.2-0ubuntu0.17.10.1 i.e. the distro-provided version Indeed it seems to me that some months ago this problem was not there... Robert -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] base table window navigation tool
Je la 23/01/2018 19:48, Robert Großkopf skribis : Hi Robert, At least under Ubuntu Gnome this tool is awfully small, unreadable. How to enlarge it ? I tried using gnome_color chooser (suggested by the French forum), to no avail. Could you please explain where to find "base table navigation tool"? Doens't know what you mean. I have read "base table" and thought it has to be something for the database of LO. But when I read gnome-color chooser I couldn't guess, what is "small and unreadable". Regards Robert Many thanks. Indeed it's related to the window used by the base module to display tables. The left part of the low border of the window shows icons to go to First, Previous, Next, Last.. These, small, icons are the poblem À demain ! -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] base table window navigation tool
At least under Ubuntu Gnome this tool is awfully small, unreadable. How to enlarge it ? I tried using gnome_color chooser (suggested by the French forum), to no avail. does anybody know ? Bonsoir -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Reports Libre Base
Some weeks ago, under Ubuntu 17.10 I struggled with an old report, I had eventually to kill. There is two possibilities to build reports (as proposed by the query contextual menu) Report Builder Assistant Rapport There was also an old device Oracle Report Builder Message d'avertissement This extension was not updated recently. It might not work with latest versions of OpenOffice. I attributed my difficulties to the previous build with Oracle which was, if I remember well, an extension. It seems to be no longer installed on my computer Je la 27/11/2017 16:04, Peter skribis : Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2 Ubuntu 16.4 When I first found the problem I removed LibreBase and reinstalled it but the problem with reportsremained the same. Peter On 28/11/17 01:33, Alexander Thurgood wrote: Le 27/11/2017 à 10:58, Peter a écrit : Hi Peter, It might help us more to know which version of LibreOffice you are using and on which version of Ubuntu or Ubuntu-based distribution. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] missing checkboxes and radio-buttons in all dialogues
In Ubuntu 17.04 LO 5.3.1.2 no problem Je la 19/10/2017 13:14, zahra a skribis : hello. in windows, i did not have such issue until now. can you try repairing libreoffice or if does not fix the problem, you can completely uninstall it with all fulders and settings and reinstall it again. God bless you and his infinite mercy be for you! On 10/19/17, Mike Scottwrote: Pretty much as the subject. I have a machine running 5.1.6.2 (mint; version not to hand) that works correctly. My desktop box - 5.4.2.2 (mint 18.1) - shows no checkboxes in any (AFAICS) dialogue box. So I can't set any option anywhere, whether eg for printing or in the options. I seem to suffer from long-standing bugs :-( I see from bugzilla from *2011* "[Bug 36345] Checkboxes missing from Options panel". Also 36263 - Zip file handling broken. OK, on windows, but I get /exactly/ the same symptoms: no checkbox and top of label text missing. I also see "Debian Bug report logs - #870745 libreoffice-style-galaxy: Missing checkboxes and button icons" which says the issue is fixed by installing libreoffice-style-tango. This is available in synaptic, and I've installed it on the system. But I can't see how to tell LO to use it. For one thing, I don't have any checkboxes in the options dialogues. Catch-22 maybe :-{ Help please? -- Mike Scott (unet2 [deletethis] scottsonline.org.uk) Harlow Essex England "The only way is Brexit" -- anon. -- 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] Is there any way to turn off that splash screen?
Under Ubuntu 17.04, I just added "--nologo " to the command line in the menu, te get libreoffice --nologo %U and similar for calc and so on Je la 14/10/2017 23:04, Remy Gauthier skribis : Hi, If you have root access on Linux, you can always edit the file sofficerc located in the same folder as soffice.bin. Setting the Logo keyword to zero seems to do the trick for me. I have not found a way to carry this setting to my local environment (copying the file to $HOME/sofficerc or $HOME/.sofficerc does not seem to work). Perhaps someone would know how to do that? I hope this helps. Rémy Gauthier.Le samedi 14 octobre 2017 à 20:13 +0200, Philip Jackson a écrit : On 14/10/17 00:48, MR ZenWiz wrote: I don't use Windows if I can avoid it, but this may come in handy, too. If you're using linux, you can get LO to start on a different desktop. I habitually use 7 desktops with email, browser, etc assigned to specific desktops by using gDevilspie. You can assign a keyboard shortcut to pass rapidly from desktop to desktop - like for example Ctrl+Alt+left/right arrow keys. Just an idea but it works for me. Philip -- 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] convert xlsx to CSV (and utf8?)
http://mooedit.sourceforge.net/ allow to "save as" changing the codage. Je la 28/08/2017 19:21, A skribis : Thank you for responding. Yes it opens without issue. Yet another look at the conversion details made me notice I needed changes. Below are two incarnations. For one thing I had left out column formatting, which I guess is required? No difference in any event. apb@yellow:/usr/local/src/greetonix/src$ /usr/lib/libreoffice/program/soffice.bin -env:UserInstallation=file:///tmp/libreoffice-1 --headless --nolockcheck --convert-to txt:Text \(encoded\):UTF8 --infilter=MS Excel 97:44,34,76,1,1/2/2/2,1033,true,false KGI_Discontinued.xlsx Error: source file could not be loaded Error: source file could not be loaded Error: source file could not be loaded convert /usr/local/src/greetonix/src/KGI_Discontinued.xlsx -> /usr/local/src/greetonix/src/KGI_Discontinued.txt using filter : Text Error: Please verify input parameters... (SfxBaseModel::impl_store failed: 0xc10) Also tried: apb@yellow:/usr/local/src/greetonix/src$ /usr/lib/libreoffice/program/soffice.bin -env:UserInstallation=file:///tmp/libreoffice_1 --infilter='MS Excel 97:44,34,76,1,1/2/2/2,1033,true,false' --headless --nolockcheck --convert-to 'csv:Text - txt - csv (StarCalc):44,34,76,1' KGI_Discontinued.xlsx *Error: source file could not be loaded* apb@yellow:/usr/local/src/greetonix/src$ ll KGI_Discontinued.xlsx -rw-rw-r-- 2 apb apb 88334 Aug 18 16:00 KGI_Discontinued.xlsx Which is an improvement, but not the solution. All I really did was rearrange the order of the parameters, change a hyphen to an underscore in the tmp file path and change double quotes to single quotes. I think I recall reading somewhere that order matters so that's what likely eliminated the "verify input parameters" message. You may also notice I changed output from utf8 to csv. I need *both* utf8 & csv. Maybe I need yet another rearrangement to eliminate the file load error? Thank you! On 08/27/2017 06:41 PM, James Knott wrote: On 08/27/2017 08:59 PM, A wrote: I'm trying to convert a file from .xlsx to CSV. After googling until my eyes were bleeding, the below is the best I could come up with. I've tried various incarnations of the below this is just the latest. Any ideas what's wrong here? The input file clearly exists. ubuntu 16.04 LibreOffice 5.1.6.2 10m0(Build:2) Thank you in advance! ~ apb@yellow:/usr/local/src/greetonix/src$ /usr/lib/libreoffice/program/soffice.bin -env:UserInstallation=file:///tmp/libreoffice-1 --headless --nolockcheck --convert-to csv:Text \(encoded\):UTF8 --infilter=MS Excel 97:44,34,76,1,,1033,true,true,false,false KGI_Discontinued.xlsx Error: source file could not be loaded Error: source file could not be loaded Error: source file could not be loaded convert /usr/local/src/greetonix/src/KGI_Discontinued.xlsx -> /usr/local/src/greetonix/src/KGI_Discontinued.csv using filter : Text Error: Please verify input parameters... (SfxBaseModel::impl_store failed: 0xc10) apb@yellow:/usr/local/src/greetonix/src$ apb@yellow:/usr/local/src/greetonix/src$ ll KGI_Discontinued.xlsx -rw-rw-r-- 2 apb apb 88334 Aug 18 16:00 KGI_Discontinued.xlsx apb@yellow:/usr/local/src/greetonix/src$ What happens if you just open the file in LibreOffice? -- 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] Unwanted Alternative Image Names
Did you try to deliver these manuals as pdf ? How do the users copy to html? Using the LO menu "Save as"? or selectng, then "Edition>Copy" .? Je la 24/07/2017 16:48, anne-ology skribis : From my experience, I would say you've uncovered a 'bug' since the name of the image should only appear if the image cannot for some reason. Here's hoping you can find a solution anon, From: gordon cooperDate: Sun, Jul 23, 2017 at 5:23 PM Subject: [libreoffice-users] Unwanted Alternative Image Names To: users@global.libreoffice.org We are using Libre Office in the writing of technical manuals where some users make html copies. Finding that the file names of images are being displayed beside or below the images in the html versions. Because all images are given a caption, we do not want the file names too. I can remove them by going to each image Properties>Options and deleting one at a time but this is time consuming when there are many images - over 100 in one manual. Is there a setting that can automatically prevent the file names being displayed? Have looked through the Help but found nothing, did I overlook it? Gordon Tauranga N.Z. -- 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: convert csv to xlsx command line UTF8 coding problem
Je la 22/06/2017 10:44, Uwe Brauer skribis : "Michael" == Michael D Setzerwrites: > The help shows no --utf-8 option, it is a filter not an option? > I think this is what it would look like? Not sure of the LF,,, part of it? > /usr/bin/soffice --headless --infilter=Text (encoded):UTF8,LF,,,--convert-to xlsx test.csv Thanks I tried it out in various variations /usr/bin/soffice --headless --infilter="Text(encoded):UTF8" --convert-to xlsx test.csv But the encoding is still broken. I had recently a coding problem (for PHP .htaccess), because my favourite text editor "gedit" handles only UTF8 I was able to understand and solve using "medit", a text editor available through synaptic in my Ubuntu 17.04. It allowed me to chane the code of the file, which I switched to "occidental", and so made visible all the UTF8 characters (or parts of) -- 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] Failure to Apply Text Color
With Ubuntu 17.04 and LO 5.3.1.2 (the "standard" for 17.04) I don't see any problem. Je la 11/06/2017 18:35, Tim-L--Elmira-NY skribis : Hey Joe. . . I just installed 5.3.3.2 on my Ubuntu 16.04 laptop. I had 5.2.x installed but I realized that I had forgotten to install the newest version when I did on a different laptop [17 inch]. That different one had a fresh install of both Ubuntu 16.04 and Windows 10 Home. Here is what I tried. I pasted some text into Writer. I selected a large block of text and then clicked on the font color [red was the last one used]. I had no problems with it changing the text to red. I tried changing colors and no issues there. Since I do not have 17.04 installed, I could not test it using that OS. Just for reference - what version of LibreOffice was installed with Ubuntu 17.04? I tend to installed the latest version of LO after I upgrade to a newer OS. Of course, I tend to forget to upgrade LO after that. 3 strokes can do that. On 06/09/2017 03:26 PM, Brian Barker wrote: At 12:06 09/06/2017 -0700, Joe Conner wrote: When I select and mark some test then click on the Writer Font Color icon to apply a color the text remains unchanged. Clicking on the Highlight Color icon will apply highlighting to the marked text. Has anyone else seen this? Am I doing something wrong or maybe have some setting is set wrong? You probably have Tools | Options... | LibreOffice | Accessibility | Options for high contrast appearance | Use automatic font colour for screen display ticked. Remove the tick. (You may need to reload any document before its display will change.) With this option ticked, the text is coloured in the document file and will print as coloured - but does not display as such. You can see the true text colour in Page Preview - unless you also have Tools | Options... | LibreOffice | Accessibility | Options for high-contrast appearance | Use system colours for page previews ticked. Should I open a bug report? Probably not. 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] sort order
for instance, see http://collation-charts.org/mysql60/mysql604.utf8_unicode_ci.european.html Je la 12/03/2017 19:07, leleu skribis : see https://en.wikipedia.org/wiki/Unicode_collation_algorithm now the problem is "where is the "collation algorithm" of calc ? An algorithm which obviously has to change according to the language. Je la 12/03/2017 18:50, Gary Collins skribis : Thank you, yes it does. I got it to work with Greek iota which is about the least obtrusive. Strangely (to my mind) some less obtrusive characters with higher unicode *dont* work. Its a bit of a mystery whats going on, i can only surmise that there is somewhere a table of 'blacklisted' characters which are not taken into account for sorting purposes. This new (ish) sort order lark has been a right pain in the proverbials for me, generally speaking. I'll now just scour the table in the hope of finding something even better but at least there is *something* that'll work Thanks, G. On Sun, 12/3/17, Brian Barker <b.m.bar...@btinternet.com> wrote: Subject: Re: [libreoffice-users] sort order To: users@global.libreoffice.org Date: Sunday, 12 March, 2017, 5:51 At 17:58 11/03/2017 +, Gary Collins wrote: >I'd like to know if there is a character, preferably some sort of >discrete punctuation mark, that will come *after* z in the sort >order when using natural sort. My problem is that i have some codes >beginning Aa which really speaking should come after Z. As a number >of up to 3 digits follows the letter(s) in each case, im getting A# >followed by Aa# then B# which really wont do. I have to use natural >sort as i need eg A12 to come after A3. Ive tried a few punctuation >characters and some special characters but i cant find one that >works. Any light that can be shed on this would be very welcome >indeed. I really dont want to have to precede Aa with a z if that >can possibly be avoided. These are not punctuation marks, but a bit of experimentation suggests that any Greek character, upper or lower case, will serve. 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 -- 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] sort order
see https://en.wikipedia.org/wiki/Unicode_collation_algorithm now the problem is "where is the "collation algorithm" of calc ? An algorithm which obviously has to change according to the language. Je la 12/03/2017 18:50, Gary Collins skribis : Thank you, yes it does. I got it to work with Greek iota which is about the least obtrusive. Strangely (to my mind) some less obtrusive characters with higher unicode *dont* work. Its a bit of a mystery whats going on, i can only surmise that there is somewhere a table of 'blacklisted' characters which are not taken into account for sorting purposes. This new (ish) sort order lark has been a right pain in the proverbials for me, generally speaking. I'll now just scour the table in the hope of finding something even better but at least there is *something* that'll work Thanks, G. On Sun, 12/3/17, Brian Barkerwrote: Subject: Re: [libreoffice-users] sort order To: users@global.libreoffice.org Date: Sunday, 12 March, 2017, 5:51 At 17:58 11/03/2017 +, Gary Collins wrote: >I'd like to know if there is a character, preferably some sort of >discrete punctuation mark, that will come *after* z in the sort >order when using natural sort. My problem is that i have some codes >beginning Aa which really speaking should come after Z. As a number >of up to 3 digits follows the letter(s) in each case, im getting A# >followed by Aa# then B# which really wont do. I have to use natural >sort as i need eg A12 to come after A3. Ive tried a few punctuation >characters and some special characters but i cant find one that >works. Any light that can be shed on this would be very welcome >indeed. I really dont want to have to precede Aa with a z if that >can possibly be avoided. These are not punctuation marks, but a bit of experimentation suggests that any Greek character, upper or lower case, will serve. 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 -- 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] sort order
Just google for "characters sorting order"...you'll have to choose by yourself... Je la 11/03/2017 18:58, Gary Collins skribis : Hello Id like to know if there is a character, preferably some sort of discreet punctuation mark, that will come *after* z in the sort order when using natural sort. My problem is that i have some codes beginning Aa which really speaking should come after Z. As a number of up to 3 digits follows the letter(s) in each case, im getting A# followed by Aa# then B# which really wont do. I have to use natural sort as i need eg A12 to come after A3. Ive tried a few punctuation characters and some special characters but i cant find one that works. Any light that can be shed on this would be very welcome indeed. I really dont want to have to precede Aa with a z if that can possibly be avoided. Thanks Gary -- 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.2 not starting
There should be some difference between the ~/.config/libreoffice/4 repertories of each user, shouldn't ? Je la 09/03/2017 09:43, Fiorenza Meini skribis : Hi there, I installed Libreoffice 5.2 on a linux distribution (Edubuntu 14.04), where there are configured multiple users. For two of them, when Libreoffice is executed, the system advises that Libreoffice is not installed... Where could be the problem ? Libreoffice is installed and working for other users... Thank and regards Fiorenza Meini -- 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] Default font in LO calc
Je la 20/02/2017 20:32, Philip Jackson skribis : On 20/02/17 16:30, Bruce Hohl wrote: To the right of 'Properties' there is a drop down icon which if you mouse-over has the tag 'Side bar setting'. Click that icon to select 'Styles and Formatting'. (If someone knows another way please chime-in.) I'm with Ian on this one. Those changes you suggest work for the current spreadsheet but as soon as you do : File > New > Spreadsheet, the new sheet opens with Liberation Sans 10 selected and in place. If you open the Default style by right-click > modify > Font tab, you can set the font to anything else you like but one thing that makes me think the default is set at a deeper level is that on the style modify dialog, there is a fourth button (at RHS) labeled 'Standard'. Clicking this sets Liberation Sans 10 again. According to the help info, the Standard button "Resets the values visible in the dialog back to the default installation values" If I prepare a new blank spreadsheet with my preferred font and save it as a new template, whenever I open a new spreadsheet by File > New > Templates > Spreadsheets tab > select my new template > click Open, I get a new blank spreadsheet with my fonts I selected. So this is available as a workaround but it involves a lot of clicks just to get what is needed. More clicks than it takes to change the font in the default spreadsheet. Moreover, within the new spreadsheet from the new template, if I open the style modification dialog and click the 'Standard' button, then I'm again in the Liberation Sans 10 font. So where to go to change the 'Standard' setting remains a useful question. Could the answer be in the Tools > Options > LibreOffice > Advanced and then look at org.openoffice.VCL > DefaultFonts where I see that the Liberation family gets lots of mentions ? Perhaps someone more used to modifying these Advanced settings could comment ? Philip Under Ubuntu 16.10 a command with the entry libreoffice --calc /home/leleu/.config/libreoffice/4/user/template/essai.ots does open a unnamed sheet conform to the model essai.ots Robert Leleu -- 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: Base and Java
Je la 29/11/2016 16:21, Dave skribis : Hi Alex, Is this an issue exclusive to the Mac edition? I am using the current version (5.2.3 x64) of Base on both 64bit Linux and Windows with JRE only and have not encountered any problem. Based on the mail headers of the previous posts in this thread, they appear to come from Windows users. Dave As a confirmation Linux Ubuntu 16.10 lo 5.2.2.2 and the associated JRE 2.1.8_57 ubuntu1 -- 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] a very important question about libreoffice and macro! the developers please help!
LO behaviour is configurable. Default is the safest See Tools>Libreoffice>Security Je la 02/10/2016 18:08, nasrin khaksar skribis : hi. my system was infected by ransomware. most of my files, there extentions and content has changed to random number and letters with cerber3 ransomware! someone told me that macros are dangerous and maybe i opened one document which contains macro! i want to know libreoffice's behaviour with macro. does libreoffice run them automaticly, disable them or ask the users? i want to know its default behaviour. i am realy worried for my files which are very valuable for me, so please help me. God bless you all and divine mercy and bounties i request for you all. -- 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] Base: Table Data View missing controls
Je la 14/09/2016 16:02, Paul D. Mirowsky skribis : LibreOffice Version: 5.2.1.2 Windows 7 64bit In the lower left hand corner of "Table Data View" there is a blank rectangle. Aren't there supposed to be a record count, <, > and >> for moving from record to record there? Please confirm. Thanks Grasp the low horizontal side of the table, and move it down a bit. They'll appear. Pay attention that only some data lines are displayed. Click >> to display the whole table. -- 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] LO Writer in UbuntuStudio 16.04.1
with compliments of my Ubuntu 16.04 (et LO 5.1.4.2), and I don't remember any special java installation. leleu@leleu-portable:~$ /usr/bin/java -version openjdk version "1.8.0_91" OpenJDK Runtime Environment (build 1.8.0_91-8u91-b14-3ubuntu1~16.04.1-b14) OpenJDK 64-Bit Server VM (build 25.91-b14, mixed mode) Je la 14/08/2016 20:19, Tim---Kracked_P_P---webmaster skribis : I am wondering if the "default" open-source java is installed or some other version. - openjdk-8-jre for amd64 [my install on Ubuntu/MATE 16.04LTS] If I remember correctly, you may have several versions of java and choose which one you want to run with LO. I do not remember which version of LO is installed, by default, when I upgraded from 15.10 to 16.04, but I currently run the 5.2.0.4 version on "this laptop". I still have not upgraded my 6.25 TB [plus 6.0 TB USB backup] main desktop from 14.04 to 16.04, since I am having issues sitting at my desk. I believe I was running a later version of 4.1.x or 4.2.x on it. On 08/13/2016 06:36 PM, Tom Davies wrote: Hi :) Can you check to see if Java is enabled within LibreOffice? Something like; Tools - Options - Java or Advanced or something There 'should be' a line telling you what your machine and that line should be ticked or bullet-pointed, or something. Regards from Tom :) On 13 August 2016 at 19:13, Philip Jackson <philip.jack...@nordnet.fr> wrote: I've just migrated the desktop from 14.04 to 16.04 and so my working LibreOffice environment has changed overnight from 4.2.8.2 to 5.1.4.2 First impressions are very positive and I've imported all my templates into Writer and things seem to work fine. Where I do have a problem is with a couple of extensions for Writer. When I reloaded my extensions I found several of them were flagged up by the LO website as 'not having been updated for over a year and maybe no longer supported'. That was disappointing but I loaded the French dictionaries anyway and they seem to be ok. The 2 extensions that cause me a problem are : Writer2xhtml - which I found very useful for exporting into ePUB format. It has lots of adjustments that you can make. Not updated beyond LO 4 series. Language tool - also not updated beyond LO 4 series. I am not so bothered by this one. I installed both these two anyway to see what would happen. Neither can be 'enabled' in the Extension Manager Tool and the error I get with both of them is the same : "Could not create Java implementation loader" This makes me wonder if the problem is within my new UbuntuStudio 16.04 support for Java rather than a problem with the extensions not having been updated ? Does anyone out there on this list have any ideas that could help ? Thank you. Philip -- 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] extracting data from uri
Je la 18/07/2016 18:20, Paolo Debortoli skribis : Hi. I am working on a calc sheet and need to insert data from an url: https://finance.google.com/finance/info?client=ig=NASDAQ%3aAAPL I guess it generates a csv output (in the browser it is like: // [ { "id": "22144" ,"t" : "AAPL" ,"e" : "NASDAQ" ,"l" : "99.92" ,"l_fix" : "99.92" ,"l_cur" : "99.92" ,"s": "0" ,"ltt":"12:13PM EDT" ,"lt" : "Jul 18, 12:13PM EDT" ,"lt_dts" : "2016-07-18T12:13:44Z" ,"c" : "+1.14" ,"c_fix" : "1.14" ,"cp" : "1.15" ,"cp_fix" : "1.15" ,"ccol" : "chg" ,"pcls_fix" : "98.78" } ]). I would need to isolate the number with 'l' label and insert it into a cell. I also tried menu -> link external data -> url; it opens the page, sees the table, but doesn't show it in the dialog box (with the checkbox 'update every x seconds' bug??). Thanks if you can help. Paolo If the structure is always the same locate the 15th ", cut keeping the right part, locate the next, cut keeping the left part. The formula for the whole operation occupy a cell, next to the one which shall receive the data... -- 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] ubuntu problem
Under Ubuntu 16.04 I just checked some ods and xlsx. They opened lo 5.1.4.2 (the present version in Ubuntu) without problem. Je la 02/07/2016 09:01, Tim Lloyd skribis : Hi, I wonder whether any of the ubuntu users have an input on this thread in LQ. http://www.linuxquestions.org/questions/linux-software-2/help-with-libreoffice-calc-not-opening-documents-and-freezing-4175583418/ Basically, calc is experiencing difficulties in LO but all is fine in OOo. I am sure I have heard mentions of GTK problems before on this forum. Cheers -- 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] How to display text using a research function
in french : CHERCHE("trans";A2) give the position of "trans" in cell A2 Je la 13/06/2016 13:07, valcoteau skribis : Hello, I have two columns A and B Column A contains emails and column B is empty I wish that each time in column A is detected certain words like 'trans', 'sped' ... can be directly displayed in column B on the same line the word 'transportation and Logistics'. I don't know which function to use Thanks in advance for your help Regards -- View this message in context: http://nabble.documentfoundation.org/How-to-display-text-using-a-research-function-tp4186030.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