Re: [libreoffice-users] libreoffice math formula editor color
Hi Albert and all: As In understood you need to change the color of the letter, variables and similar that you input in a formula that you make with with Math. For this you need to select Attribute option from list below bar. I hope this help Regards, Jorge El jue, 18-10-2018 a las 19:36 +0200, Albert Oszkó escribió: > Hi all, > > I would like to write some mathematical equations in Writer with LO > Math. Unfortunately the formula editor background is dark grey with > black letters. How could I change the background color. I use LO in > openSUSE, tried to change desktop color schemes, window color > schemes > but to no avail. I also tried to modifx LO setting, but obviously, > did > not find the correct one. In LO I also use a dark scheme but now I > cannot change it. I have LO 6.1.2.1 and KDE . > > Thanks, > > Albert > > -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Great File size problem
Hi Remy: Thank you for your answer an explanation. I'm sorry to answer some days after but the e-mail was in the spam folder. I know that I have only 1.5 GB free space on my hard disk. Probably it is the problem if LibreOffice make a temp file wile running it great than 1.5 GB when I'm increasing the spreadsheet size. Regards, Jorge Rodríguez El lun, 24-09-2018 a las 19:25 -0400, Remy Gauthier escribió: > Hi, > I have a spreadsheet that contains Canadian weather data since 1953 > (more or less) for 25 weather stations. For each station, there are > 28 > columns and about 11000 rows of data, with one station per sheet. On > top of that, there are some other sheets that I use to mine into the > data. For good measure, I copied one of the worksheets 3 times, and > added data via copy/paste to have 560 columns on the last worksheet. > Overall, the "big" spreadsheet has these properties (file > > Properties > > Stats): > > 33 worksheets22134827 used cells368 pages10073 formula groups > 53.1 MB of disk space used. > It saved, no problem. HOWEVER, LO uses space in /tmp when it creates > the ODS files (it is a ZIPped archive). While it was saving, I went > to > /tmp and looked at the files that were created during the saving > process. This is the last "ls" before the save was finished: > total 2756644drwx-- 2 remy remy160 24 sep 19:06 > .drwxrwxrwt 18 root root420 24 sep 19:06 ..-rwxr-xr-x 1 remy > remy 43484017 24 sep 18:57 lu4577gvthcz.tmp-rw--- 1 remy > remy 43484017 24 sep 19:06 lu4577gvthd0.tmp-rw--- 1 remy > remy 12288 24 sep 19:06 lu4577gvthd2.tmp-rw--- 1 remy remy > 2683118605 24 sep 19:06 lu4577gvthd4.tmp-rw--- 1 remy > remy 52688515 24 sep 19:07 lu4577gvthd6.tmp-rw--- 1 remy > remy458 24 sep 19:00 NewHelp0.html > As you can see, there is quite a lot of disk space being used (more > or > less 2,7 GB). Could it be that the disk partition you are using to > hold > /tmp is almost full? My /tmp partition (Linux Fedora) is 4GB-large > and > when I look at its usage when saving the workbook, it goes up to 68% > from 2% when nothing is happening. > I can only assume the save fails because you run out of disk space. > This will generate the error message, the ODS file will be small > because pieces will be missing, and the in-memory copy of the > spreadsheet will be intact, as if nothing happened. > I hope this helps. > Rémy. > Le lundi 24 septembre 2018 à 15:02 -0600, jorge Rodríguez Fonseca a > écrit : > > Hi all: > > > > I use LibreOffice 6.1.1.2 Snap process and LibreOffice 6.0.6.2 > > Ubuntu 18.04.1 default. > > > > I tried recently to make a spreadsheet with both LibreOffice > > options and I had problems when the file reached more than > > specified > > size. In my case, the last size that I saw was 13.5 MB (512 columns > > and > > 8,000 rows, more or less) > > > > Then when I included more data into the file, suddently it > > can't be saved in any way, and lost all the content as I can see in > > the > > properties file because it had 35 kb instead 13.5 MB, but in the > > screen > > I could see the spreadsheet as nothing passed. With the file > > browser > > I > > could confirm the size : 35 kb. > > > > LibreOffice sent to my screen the following message (Please see > > the link) > > > > > > https://www.dropbox.com/s/pjvd4tuiz7p0m2w/Great%20File%20size%20-2018 > > -09-24.png?dl=0 > > > > It is in spanish but in english is something like this: > > > > > > "Error when save the document: Sin titulo 1 > > Writing Error > > It couldn't write" > > > > I greatful with any help. It would be a bug ? > > > > Regards, > > > > Jorge Rodríguez > > > > -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Great File size problem
Hi all: I use LibreOffice 6.1.1.2 Snap process and LibreOffice 6.0.6.2 Ubuntu 18.04.1 default. I tried recently to make a spreadsheet with both LibreOffice options and I had problems when the file reached more than specified size. In my case, the last size that I saw was 13.5 MB (512 columns and 8,000 rows, more or less) Then when I included more data into the file, suddently it can't be saved in any way, and lost all the content as I can see in the properties file because it had 35 kb instead 13.5 MB, but in the screen I could see the spreadsheet as nothing passed. With the file browser I could confirm the size : 35 kb. LibreOffice sent to my screen the following message (Please see the link) https://www.dropbox.com/s/pjvd4tuiz7p0m2w/Great%20File%20size%20-2018-09-24.png?dl=0 It is in spanish but in english is something like this: "Error when save the document: Sin titulo 1 Writing Error It couldn't write" I greatful with any help. It would be a bug ? Regards, Jorge Rodríguez -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Re: Flatpak Libreoffice - opens with "(as superuser)" in title bar
Hi: Snap system is a Sandbox way to install now programs in many GNU / Linux distributions. It was develop by Canonical (Ubuntu) and put able for all the distributios want to use. It try to solve the problems of securities because as I understand the software installed by this way can't access nothing than the place where it is installed. Another benefits, it is easier to the own or develops of the programs to prepare software to offer updates to the users (less complicated). It benefits both sides. In this links you can find the repositorie of software prepare with Snap: https://snapcraft.io/store and here: https://snapcraft.io/libreoffice you can find LibreOffice as snap installation. Flatpak is other way that born, as I know, as the same time of Snap and has similar features, but to know what are all the difference between them, is necessary to googleing because I don't know all of them although I red a year ago, more less, an articule in the web about this topic. If you have problems with the Flatpak installation in GNU / Linux Mint, why not probe with the Snap option ? I hope this help, Jorge Rodríguez El vie, 27-07-2018 a las 09:45 -0700, atlan escribió: > I've never heard of snap and am looking for a solution not a > workaround. > > I'm using Flatpak because it is installed by default in Mint 19 and > there is > loads of Flatpak software in the Mint Software Centre to install with > a > single click, which seems a great step forwards to me. > > > > > -- > Sent from: http://document-foundation-mail-archive.969070.n3.nabble.c > om/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/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Re: Flatpak Libreoffice - opens with "(as superuser)" in title bar
I understand now your problem...but what is the difference between LibreOffice version of Flatpak and Snap version ? Why you prefere Flatpak version ? I've installed before in other computer the Snap version and all were well, include I could keep the version .deb that Ubuntu install by default and the more update version by Snap version, and both run without problems. Regards, Jorge Rodríguez El vie, 27-07-2018 a las 08:36 -0700, atlan escribió: > Thanks for your reply, > > I was not looking at uninstalling LibreOffice - just want to get the > Flatpak > version working without being in superuser mode. > > The reason I used the three commands - > > (sudo apt-get remove --purge libreoffice > sudo apt autoremove > sudo apt-get clean sudo apt-get autoremove) > > - was to attempt to remove the previous repository/non-flatpak > version > fully. I did not do that before the first install of the flatpak > version and > subsequently wondered if that omission might have been responsible > for the > superuser message - but apparently not. > > I have also tried removing the Flatpak version using flatpak > uninstall > org.libreoffice.LibreOffice/x86_64/stable as well as with the > Software > Centre, then rebooting and reinstalling, but am still getting the > superuser > notification in the title bar. > > > > -- > Sent from: http://document-foundation-mail-archive.969070.n3.nabble.c > om/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/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Flatpak Libreoffice - opens with "(as superuser)" in title bar
Hi Atlan: GNU / Linux Mint is a branch of Ubuntu. Ubuntu has a similar system of install option known as Snap. You can find in the web as Snap Repositories and then search LibreOffice. There you can install coping the command into the terminal. To remove : sudo snap remove libreoffice. I guess that Flatpak use similar command and it is different to usuall .deb options. When we install a .deb file we can use the command apt-get or apt (only), but Flatpak and Snap use different commands because use different program to manage the installations. If you goggleing as : How to uninstall a Flatpak file, you could find the answer. It would use a command like this: sudo flatpak remove "package file name" I hope this help, Jorge El vie, 27-07-2018 a las 07:17 -0700, atlan escribió: > I'm using Linux Mint 19 (Mate 64 bit) > > Using software manager, I removed Libreoffice and then installed the > Flatpak > version of it. > > It now opens opens with "(as superuser)" in title bar. > > I have repeated the install after running: > sudo apt-get remove --purge libreoffice > sudo apt autoremove > sudo apt-get clean sudo apt-get autoremove > - but the result is the same. > > I'd be grateful if anyone can tell me how to resolve this. > > > > -- > Sent from: http://document-foundation-mail-archive.969070.n3.nabble.c > om/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/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Long comments in calc?
Hi Rakidzija : There is an option that you can use for input a comment into a cell. If you right click mouse over a specific cell, you get a menu with differents options. One of them is "Insert a comment" (The last in my LO Versión: 6.0.3.2). Select that option an appear a little yellow rectangule where you can write your comment about some issue of the content of it cell. This rectangule grow when you input your sentence but when you ending your wrotten the comment. When you did it you, the comment closed an appear a red super little point in the right top corner of the cell where you input the comment. Then, always over the cell that content the comment, you can righ click mouse again and appear 3 more options in the context menu: Edit, Delete and Show the comment. With each of them you can modify your comment of the cell. By the way, only with Show Comment option you can modify the form of the yellow rectangule making more wide (wider ?), for example, to structure the comment to your needs and your sheet. For do this, you have to select the border of the yellow rectangule when it is showed. Then if you click right again you can see again in the menu context but only : Edit,hide (instead show) and delete option menu. With hide option you can do it and show only the red point in the cell. I hope this help, Regards, Jorge Rodríguez El sáb, 02-06-2018 a las 11:34 +0200, David Rakidzija escribió: > Hi, > > what's the best way to insert long comments into calc? A floating > window that > does not interfere with the spreadsheet itself would be best. > 1. the built in commentary for cells seems to be buggy, sometimes > wound't > display corretly, cannot be resized... unusable for me if it's more > than a > couple of words > 2. merging cells is not what I want. Cannot really edit the box as if > it were > a text box and resizing seems difficult > 3. Supposedly there is a text box function, but whenever I click it > nothing > happens (insert -> text box) > > I'm using LO 6.0.4. > > Thanks for your help. > > > -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] [Copying slides from one presentation to another]
Hi Anne and all: Well, if you are using GNU / Linux and open each Presentation From the file browser I'm almost sure that you can keep both open and then select the slides from one Presentation to the other (Selecting all that you want to into the other with copy-paste). I know that it is better using an option insert from the own program but if it isn't able or finding, this other would be solve your problem (If it exist yet). I think that using windows the process is the same, I guess. I hope this help, Regards, Jorge Rodríguez El 17/04/2018 a las 09:19, anne-ology escribió: Thanks for responding. But I have my data & programs on this computer; these clouds are dangerous if one wishes to retain ones data, what if someone, managing these clouds, thinks he has the right to delete everything for some reason. From: jorge Rodríguez <jrodriguez1...@gmail.com> Date: Thu, Apr 12, 2018 at 3:43 PM Subject: Re: [libreoffice-users] [Copying slides from one presentation to another] To: anne-ology <lagin...@gmail.com>, users@global.libreoffice.org Hi Anne and all: As I understood you are working with one Presentation file that is in cloud and the other that you need copy too. Why not try to use two tabs in web browser to open each Presentation file, or use two different web browser to open each file, supposed that you can't download them and then upload them again. I don't know if these suggestions work but nothing to lose trying. Regards, Jorge Rodríguez El 12/04/2018 a las 13:29, anne-ology escribió: yes, & thank you for expressing what obviously I was unable to so do. There's also a problem with their copy & paste suggestion, since that surely requires having more than one copy of LO open at one time, which seems impossible since when I click on LO again, the opened one appears rather than a new version. And when I've gone to the LO archives to attempt to download the previous versions, it merely sends me back to the download page to download the newest version. PLEASE EXPLAIN HOW to download a previous version, if the latest versions will no longer have this option available. From: Virgil Arrington <cuyfa...@hotmail.com> Date: Sun, Apr 8, 2018 at 3:15 PM Subject: Re: [libreoffice-users] [Copying slides from one presentation to another] To: "users@global.libreoffice.org" <users@global.libreoffice.org> On 04/08/2018 03:48 PM, Italo Vignoli wrote: On 08/04/2018 20:59, anne-ology wrote: The 'file'option is missing in LO 6.0.2.1 (at least on Windows) Menu Slide > Insert Slide from File That may work for inserting only one slide, but what Anne wants is to insert an entire Impress presentation, not just a slide or two. This can be done with LO 5.1.6.3 (which is what I use), but it apparently is missing in later versions. I can understand and appreciate Anne's frustration that a former functionality seems to have been deliberately removed from the program (unless it has just been moved to another location on the menu, which nobody seems to have been able to find). Yes, a person can copy and paste select slides, but that is hardly a satisfactory answer when she used to be able to insert an entire file and can no longer do so. Virgil -- 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] [Copying slides from one presentation to another]
Hi Anne and all: As I understood you are working with one Presentation file that is in cloud and the other that you need copy too. Why not try to use two tabs in web browser to open each Presentation file, or use two different web browser to open each file, supposed that you can't download them and then upload them again. I don't know if these suggestions work but nothing to lose trying. Regards, Jorge Rodríguez El 12/04/2018 a las 13:29, anne-ology escribió: yes, & thank you for expressing what obviously I was unable to so do. There's also a problem with their copy & paste suggestion, since that surely requires having more than one copy of LO open at one time, which seems impossible since when I click on LO again, the opened one appears rather than a new version. And when I've gone to the LO archives to attempt to download the previous versions, it merely sends me back to the download page to download the newest version. PLEASE EXPLAIN HOW to download a previous version, if the latest versions will no longer have this option available. From: Virgil Arrington <cuyfa...@hotmail.com> Date: Sun, Apr 8, 2018 at 3:15 PM Subject: Re: [libreoffice-users] [Copying slides from one presentation to another] To: "users@global.libreoffice.org" <users@global.libreoffice.org> On 04/08/2018 03:48 PM, Italo Vignoli wrote: On 08/04/2018 20:59, anne-ology wrote: The 'file'option is missing in LO 6.0.2.1 (at least on Windows) Menu Slide > Insert Slide from File That may work for inserting only one slide, but what Anne wants is to insert an entire Impress presentation, not just a slide or two. This can be done with LO 5.1.6.3 (which is what I use), but it apparently is missing in later versions. I can understand and appreciate Anne's frustration that a former functionality seems to have been deliberately removed from the program (unless it has just been moved to another location on the menu, which nobody seems to have been able to find). Yes, a person can copy and paste select slides, but that is hardly a satisfactory answer when she used to be able to insert an entire file and can no longer do so. Virgil -- 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] [Copying slides from one presentation to another]
Hi Luuk and all: Why not only select the slides that you want to input into the other presentation and copy-paste ? I did it in Impress - LibreOffice version: 4.2.8.2 Ubuntu 14.04 LTS and went well. Regards, Jorge Rodríguez El 07/04/2018 a las 08:30, Luuk escribió: From: Virgil Arrington <cuyfa...@hotmail.com> Date: Wed, Apr 4, 2018 at 7:08 AM Subject: Re: [libreoffice-users] [Copying slides from one presentation to another] To: "users@global.libreoffice.org" <users@global.libreoffice.org> I'm confused as to the flow of the discussion, and I'm not at all sure I know what the issue is, but I have no problem inserting an entire Impress presentation into another Impress presentation. Here's how I do it with LO 5.1.6 on my Linux Mint machine: First, I open one Impress presentation file. I then make sure that the "Slide Panel" is visible by clicking on the menu "View", "Slide Panel" I then click on the slide in the Slide Panel where I want to insert another Impress presentation, keeping in mind that the inserted presentation will appear *after* the slide I click on in the Slide Panel. From my experience, inserting a second presentation only works if my cursor focus is in the Slide Panel. Then, on the menu, I click "Insert", "File...", which on my machine is down toward the bottom of the Insert menu list. From the resulting dialog box, I select the Impress presentation I want to insert and then I am presented with another dialog box from which I can select certain slides from the inserting file. If I want the entire presentation, I simply click on "Ok," and the file is inserted into the original presentation file after the slide I had selected in my Slide Panel. Virgil The 'file'option is missing in LO 6.0.2.1 (at least on Windows) -- 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] LibreOffice Calc column shifting
Hi Vytas and all: It would be happened because the spreadsheet need more memory. You can increase it following these steps: 1) Menu-Tools-Options-LibreOffice-Memory: Here you can increase memory to some options. I hope this help, Regards, Jorge Rodríguez El 04/04/2018 a las 08:40, vytas escribió: Hi All, I am using LibreOffice version 5.4.6.2 (x64) on a Windows 7 computer. I am getting column shifting, playing with the Option/LibreOffice/View parameters have not helped. See the example attached. LibreOffice Calc column shift <https://www.dropbox.com/s/krfnsheaikg1yqv/LibreOffice_Calc_column_Shift.JPG?dl=0> Computer configuration: Video card is a NVIDIA Quadro FX 3500 16GB of memory Tons of free hard drive space Any suggestion greatly appreciated. Cheers, Vytas -- 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] calc taking 97% of cpu
Hi John and all: Would you please tell us to the e-mail list what kind of Operative System do you have and the LibreOffice version do you use ? Regards, Jorge Rodríguez El 29/03/2018 a las 23:49, John R. Sowden escribió: I read in a ascii database into calc. It is taking 97-98% of the cpu resource per htop, yet nothing is happening. I move the cursor to a cell, big gray box, sits ther for > 15 minutes, yet I can move the window, play freecell, et. with no problem. It seems the slowness is in LO, not the system at large. thoughts? John -- 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] One sheet with bullet points - why LO 6 better
Hi Charles and all: In this link you can find the Release Notes of LibreOffice 6.0. There are by Type of Program: Write, Calc, and so on, and other more complex about Core and more. All of them has at least a brief comment about its features. As you can see, the LibreOffice versions before LO 6.0, haven't these features. https://wiki.documentfoundation.org/ReleaseNotes/6.0 Regards, Jorge Rodríguez El 28/03/2018 a las 14:23, charles meyer escribió: Hi Folks, I wondered if anyone has stumbled upon any short list of why is LO 6 better than older versions? Thanks so much! Charles. -- 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] LibreOffice - patches
Hi Lizzy: I use GNU / Linux and happy with it...but if you want to keep windows there is a possible to install both operative system together in your laptop. It would be used Dual Boot process with an .iso file of Ubuntu for example. Regards, Jorge Rodríguez El 22/03/2018 a las 15:52, Luca Daghino @ Libero escribió: Il 21/03/2018 22:51, Miss Lizzy ha scritto: I'm about to get a new laptop as my current one is not in compliance with the new General Data Protection Regulations (it's just over 10years old with Windows 7 so no longer supported by Microsoft regarding patches). It has been suggested I use LibreOffice rather than Microsoft Word, Excel etc. I've read a few articles on Libre, but what I would like to know is - you say Libre is an 'open Source software', and input/ patches is by anyone, that's the way I've digested it. So my concern is, do you actually mean 'anyone' or are the patches development by your own team of software developers? You can obviously see where I'm going with this. I also noticed the software package name has changed over a relatively short period of time. Is it just in name or do folk have to keep down loading new packages? Would appreciate your comments as soon as you can please. Kind regards Liz D'arville Sent from my iPad My comment is to keep your laptop and install linux on it... :) -- 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] Enhancement for outline numbering
Hi Steve: Would you please tell to this e-mail list what version of LibreOffice do you use ? Regards, Jorge Rodríguez El 21/03/2018 a las 14:46, Steve Edmonds escribió: Hi. I never really got my head around outline numbering in Writer and always seemed to muck it up. I've finally done myself a howto reminder and wondered if any flaw can be seen in some enhancements I was going to put on bugzilla. Outline numbering works with styled paragraphs. The position of the numbering is controlled in outline numbering. 2 simple suggestions for an enhancement to avoid making changes in the wrong place are; assuming menus are context aware, when you right click in an outline numbered paragraph -Make Paragraph Paragraph Style... and open the style for editing. -Make Bullets and Numbering. Chapter Numbering and open Tools>Chapter Numbering Interestingly, if I right click on the number of the outline numbered paragraph and select Character, modifying the character attributes modifies the character style for the number, as I feel would be good for the 2 items above. Cheers, steve -- 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: How can I reassign a macro to a custom toolbar button?
Hi Ptoye and all:
You can do the same process but more directly with :
Menu-Tools-Customize
I was using for this explanation: LO 6.0.1.1 with English setting
By the way, The Document Foundation organization, that is in
charge to development LibreOffice, is needing voluntaries to update the
documentation and help, to the new version: 6.0. If you want to
contribute with this, you can e-mail to this list to Olivier Hallot to
know more about this.
Regards,
Jorge Rodríguez
El 03/03/2018 a las 05:09, ptoye escribió:
Firstly - sorry to all. I was getting extremely frustrated in trying to do
what looks like a simple thing, but obviously isn't.
I'm finding it a bit difficult to follow your instructions - I suspect that
you are using a different language (Spanish?) from myself.
In Step 2 there isn't a "All Commands" button - but there's an "Add command"
button - is this what you meant?
What you have suggested here - and many thanks for this - seems to be what I
found out by myself: add new buttons and remove the old ones. This is a very
long-winded way of going about it and I'm surprised that the designers
didn't think of a more user-friendly way of reassigning. Your suggestion
implies that they didn't. I had assumed that I'd missed something simple.
I still think it would be a good thing if the help system mentioned this
mechanism.
jorge Rodríguez wrote
Hi Ptoye and all:
At first, try to be more polite because almost all us are
volunteers and collaborate as we can and all of us try to do better.
As I understand, you can reassign a macro following this steps (Or
solve your problem like this) :
1) Menu-Tools-Macros-Organize Macros-LibreOffice Basic (I use this
because is the only programming language that I've used to make a macro
and assign to a toolbar. I don't know if using other language is the
same to do it.)
2) Select Assign icon to open a Dialog Window. There select Toolbars and
click on "All Commands" option. Scroll down to find Macros and select it.
3) In the Chart Function, appear the places where your macros should be
4) Found what you need
5) Now, at right, you can see the Options bar (Default Standar), where
you can select whatever toolbar existing in LibreOffice Calc. But now,
select the + icon that it place at right of it.
6) Appear a Dialog Window where you can input a name ("MyTools" for
example), to make a new toolbar where you can assign all your Macros or
only some of them. Select too the place where it will be saved (Option
below).
7) Now, select the macros that you previously found ( Chart Function
-point 4 ), and with the Arrow to right move to new toolbar "MyTools"
all the Macros that you want.
8) Click "Ok" and then Close the Window. In the area of the toolsbars
(Top of your spreadsheet), below the two first default bar, you can find
your new MyTools bar icons that each one run each macro assigned.
9) The last step is to eliminate the macros of the other toolbar where
you had assigned some of the macros and where you couldn't find place
for all of them. I hope you know how to do this to doesn't duplicate
icons in your spreadsheets (Two bar of them with some same icons that do
the same). If you had problem, can request again to the user e-mail list
of LibreOffice.
I hope this help,
Jorge Rodríguez
-
Peter
--
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] How can I reassign a macro to a custom toolbar button?
Hi Ptoye and all:
At first, try to be more polite because almost all us are
volunteers and collaborate as we can and all of us try to do better.
As I understand, you can reassign a macro following this steps (Or
solve your problem like this) :
1) Menu-Tools-Macros-Organize Macros-LibreOffice Basic (I use this
because is the only programming language that I've used to make a macro
and assign to a toolbar. I don't know if using other language is the
same to do it.)
2) Select Assign icon to open a Dialog Window. There select Toolbars and
click on "All Commands" option. Scroll down to find Macros and select it.
3) In the Chart Function, appear the places where your macros should be
4) Found what you need
5) Now, at right, you can see the Options bar (Default Standar), where
you can select whatever toolbar existing in LibreOffice Calc. But now,
select the + icon that it place at right of it.
6) Appear a Dialog Window where you can input a name ("MyTools" for
example), to make a new toolbar where you can assign all your Macros or
only some of them. Select too the place where it will be saved (Option
below).
7) Now, select the macros that you previously found ( Chart Function
-point 4 ), and with the Arrow to right move to new toolbar "MyTools"
all the Macros that you want.
8) Click "Ok" and then Close the Window. In the area of the toolsbars
(Top of your spreadsheet), below the two first default bar, you can find
your new MyTools bar icons that each one run each macro assigned.
9) The last step is to eliminate the macros of the other toolbar where
you had assigned some of the macros and where you couldn't find place
for all of them. I hope you know how to do this to doesn't duplicate
icons in your spreadsheets (Two bar of them with some same icons that do
the same). If you had problem, can request again to the user e-mail list
of LibreOffice.
I hope this help,
Jorge Rodríguez
El 02/03/2018 a las 05:26, ptoye escribió:
I have been moving a few macros about, and want to reassign their toolbar
buttons. So I go to the Macro | Organiser, select the macro, click "assign",
select the toolbar button and click "OK". And nothing happens.
There's nothing in the help file about it - the "assigning scripts in LibO"
(why can't they use the word "macro"?) page tells me how to assign a macro
to a new button, but not how to change an assignment. Did the designers
really forget that this might be needed?
-
Peter
--
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
[libreoffice-users] Reviewing GS6002-SettingUpLibreOffice -OH.odt
Hi Olivier and all: I already uploaded a reviewing of GS6002-SettingUpLibreOffice-OH.odt <https://www.odfauthors.org/author/jrodriguez%20%28Modified%20GS6002-SettingUpLibreOffice-OH.odt%29> document and setGS6002-SettingUpLibreOffice-OH-Last reviewing-JR.odt <https://www.odfauthors.org/libreoffice/english/getting-started/feedback-lo-6.0/GS6002-SettingUpLibreOffice-OH-Last%20reviewing-JR.odt/view>. I added some paragraphs for clearing several topics or added something about performances of LibreOffice. I made more comments in the usually ODFAuthors web site. I used LO, Version: 6.0.1.1 Regards, Jorge Rodríguez -- 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: Software Exception error on Windows 7 with Libreoffice 6.0.2
Hi all: As I commented in a e-mail before, I'm updating document Getting Start 6.0 Chart 2 Setting Up. I requested information about Quickstarter because I didn't know how it function. Some answer clearing my dudes and help me my job. But now, with the information posted in the e-mail below, I'm confused again. Is true this information ? Is QuickStarter hasn't included on this document or only note that in Window 7 doesn't make any change or keep included as I already did ? Regards, Jorge Rodríguez El 02/03/2018 a las 09:30, V Stuart Foote escribió: Tanstaafl wrote ... The only option currently is to not run the Quickstarter. I'm wondering now just how much faster it allows Libreoffice to start and if it worth it to continue enabling it at all. Not only not worth enabling, but best to perform a custom installation and to not install it. It has been removed from the Linux builds a LibreOffice 6.0 Microsoft dropped OSA at 2003 build of its Office products, and at Windows 7 they introduced the whole Jump List infrastructure with Jump List pinning to Start Menu and Taskbar--elminating any advantage to enabling the Quickstarter instance (and of pre loading a soffice.bin). In reality LibreOffice has had no need of it for Windows 7 onward--and as you've experienced it can cause issues. This reminded me to go ahead and poke the UX community with tdf#116142 -- Remove Quickstarter from Windows builds <https://bugs.documentfoundation.org/show_bug.cgi?id=116142> which would finally see this "anti-feature" go away. -- 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] Limit on resizing windows in LO 6
Hi all: You can modify the size of the icons of toolbars: Menu-Tools-Options-View-User Interface-Toolbar Icon Size (Automatic -default-, Small, Large and Extra Large). Beside, you can customize what icon function keep in the toolbars, and reduce it size if you eliminate some icons: Menu-Tools-Customize-Toolbars-"Standar bar" and "Formatting bar". There it is necessary to uncheck the functions icons that you don't want to keep in the toolbars. I hope this help, Jorge Rodríguez El 27/02/2018 a las 09:27, Virgil Arrington escribió: On 02/27/2018 09:50 AM, waterbeare...@gmx.com wrote: On Thursday, 22 February 2018 11:51:30 GMT waterbeare...@gmx.com wrote: I am not sure if this is a bug or there is some adjustment I have missed. However, running LO6 in Mageia Linux, LO limits the minimum screen width. I cannot reduce Writer to less than about 60% of the screen width, while Calc will go down to a bit under half. I feel a little silly, but I finally figured out what was happening. On my machine with 6.0 I added the Anaphareus extension which appears as an option on the main bar -- and the length of the bar determines the minimum width of the window. I haven't followed every post on this thread, but is this behavior new to LO 6? I find that, with my very old 5.1.6 on Linux Mint 18, I can reduce the window size to anything I want and the toolbars just collapse to fit my bidding. Virgil -- 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: [libreoffice-documentation] LibreOffice Quickstarter Option
Hi Zahra and all:
Thank you for the information, ... about Linux Quickstartert option
is still available on Linux LO 6.0 Version.
Regards,
Jorge Rodríguez
El 23/02/2018 a las 06:25, zahra a escribió:
hello.
hear you are from whats new of version 6.0
• The Linux Quickstarter is removed.
• Internal file pickers removed (access is still possible via Tools ▸
Options ▸ LibreOffice ▸ Advanced ▸ Expert configuration ▸
org.openoffice.Office.Common.Misc ▸ UseSystemFileDialog)
https://bugs.documentfoundation.org/show_bug.cgi?id=114484
so, i think the support for windows should be remain in this case.
On 2/23/18, jorge Rodríguez <jrodriguez1...@gmail.com> wrote:
Hi Martin and all:
Thanks for your comments to try to clear it, but I still keep
my dude about this issue.
Regards,
Jorge Rodríguez
El 22/02/2018 a las 16:20, Martin Srebotnjak escribió:
AFAIK, this was doomed to be removed from Linux versions in 6.0, but
somehow remained there (I have this knowledge from translating release
notes - first there was the note that it was removed in 6.0 from Linux
versions, then this note was removed from release notes). However I do
not know if this is accurate and true for 6.0 on Linux ...
Lp, m.
2018-02-22 23:15 GMT+01:00 jorge Rodríguez <jrodriguez1...@gmail.com
<mailto:jrodriguez1...@gmail.com>>:
Hi all:
I'm reviewing the document draft Getting Start LibreOffice
6.0 Chapter 2 -Setting up.
I find in LO 6.0, in Menu-Tools -Options-General, the
option LibreOffice Quickstarter. As I understand this option is
able only in the version of LibreOffice for Windows. Is it correct
? Would you please confirm ?
I'm using LO 6.0 in Ubuntu 17.10.
Regards,
Jorge Rodríguez
--
To unsubscribe e-mail to:
documentation+unsubscr...@global.libreoffice.org
<mailto:documentation%2bunsubscr...@global.libreoffice.org>
Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
<https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more:
https://wiki.documentfoundation.org/Netiquette
<https://wiki.documentfoundation.org/Netiquette>
List archive:
https://listarchives.libreoffice.org/global/documentation/
<https://listarchives.libreoffice.org/global/documentation/>
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 cannot be deleted
[libreoffice-users] Re: [libreoffice-documentation] LibreOffice Quickstarter Option
Hi Martin and all: Thanks for your comments to try to clear it, but I still keep my dude about this issue. Regards, Jorge Rodríguez El 22/02/2018 a las 16:20, Martin Srebotnjak escribió: AFAIK, this was doomed to be removed from Linux versions in 6.0, but somehow remained there (I have this knowledge from translating release notes - first there was the note that it was removed in 6.0 from Linux versions, then this note was removed from release notes). However I do not know if this is accurate and true for 6.0 on Linux ... Lp, m. 2018-02-22 23:15 GMT+01:00 jorge Rodríguez <jrodriguez1...@gmail.com <mailto:jrodriguez1...@gmail.com>>: Hi all: I'm reviewing the document draft Getting Start LibreOffice 6.0 Chapter 2 -Setting up. I find in LO 6.0, in Menu-Tools -Options-General, the option LibreOffice Quickstarter. As I understand this option is able only in the version of LibreOffice for Windows. Is it correct ? Would you please confirm ? I'm using LO 6.0 in Ubuntu 17.10. Regards, Jorge Rodríguez -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org <mailto:documentation%2bunsubscr...@global.libreoffice.org> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ <https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette <https://wiki.documentfoundation.org/Netiquette> List archive: https://listarchives.libreoffice.org/global/documentation/ <https://listarchives.libreoffice.org/global/documentation/> 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
[libreoffice-users] LibreOffice Quickstarter Option
Hi all: I'm reviewing the document draft Getting Start LibreOffice 6.0 Chapter 2 -Setting up. I find in LO 6.0, in Menu-Tools -Options-General, the option LibreOffice Quickstarter. As I understand this option is able only in the version of LibreOffice for Windows. Is it correct ? Would you please confirm ? I'm using LO 6.0 in Ubuntu 17.10. Regards, Jorge Rodríguez -- 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] LO not finding my scanner
Hi Tim and all: I'm not an expert on computer science, ... but sometimes, it is possible to keep install both version of a program. Why not probe to install "scangearmp" in parallel to "scangearmp2" ? It would solve your problem. Regards, Jorge Rodríguez El 11/02/2018 a las 10:59, Tim-L escribió: Just to throw more issues - LO 5.4.x still does not find my Canon printer's scanning service. So, it could be the Scanner drivers for Ubuntu. The "scangearmp2" package does not have all of the options as the "version 1" did. To bad. Now I have to do all of the cropping, etc., via GIMP instead at the scanning level. On 02/11/2018 11:30 AM, Tim-L wrote: To be honest, I had never tried to use my scanning option with 5.4 or earlier. I was just going through the different drop-down menus after I installed 6.0.0.3. I see 6.0.1.x is online for download. I will install it within a few days. 2 of my 3 laptops have both Windows 10 and Ubuntu Mate 16.04 installed. The newest laptop is a Ubuntu Mate only box. Right now, the second oldest laptop is my default one and is the only one running 6.0.x.x. I will look into the uses of the scanning options with one of those other laptops to see if it scanning works. On 02/10/2018 08:04 AM, Dave Barton wrote: This appears not to be a Linux specific issue. I can't speak for macOS users, but it is definitely a problem with LO 6.0.1.1 on all of my WIN 7 and Linux boxes, where I have zero scanning issues using LO 5.4 or other office software. Has anyone entered a bug report yet? Dave On 08.02.2018 16:45, Tim-L wrote: Yes, I tried Insert > Media > Select Source. It does not show my print/scan/copy - Canon TS9020. Canon's Linux driver for scanning does not work with xsane. They call their interface "scangearmp2". This has hardly and options compared to "scangearmp" which was use for the previous printer/scanners I have had [all dead now]. Yes, I have 64-bit Ubuntu Mate, LibreOffice, and Canon drivers. On a side note: This is the first Canon printer that I bought that has Linux drivers in their USA web site. I always had to go to the UK site to get the drivers. At least Canon is starting to get the picture that a lot of people in the USA are Linux users. On 02/07/2018 07:32 PM, Dave Howorth wrote: On Wed, 7 Feb 2018 15:27:33 -0800 Girvin Herr <ghe...@fastmail.com> wrote: Another datapoint: I tried it with LO 5.3.4.2 under xfce and Slackware 14.2 Linux with my Epson 1660 Photo USB scanner and it worked fine with Insert > Media > Scan > Select Source. Girvin Herr And another datapoint: I tried with LO 5.4.4.2 under LXDE on openSUSE Leap 42.3 with an Epson Stylus Photo RX620 and got a 'Due to an unexpected error, LibreOffice crashed.' (It's one of those annoyingly unhelpful error dialogs that won't let you copy the text. GRR!) After restarting LO, it scanned fine. I'll still prefer to use xsane. On 02/07/2018 03:12 PM, Dave Barton wrote: After seeing Tim's post I checked and Insert > Media > Scan > Select Source... opens an empty dialog and Insert > Media > Scan > Request... silently fails. Version: 6.0.0.3 (x64) Build ID: 64a0f66915f38c6217de274f0aa8e15618924765 CPU threads: 8; OS: Windows 6.1; UI render: GL; No issues with scan in either AOO or MS Office on the same machine. Dave On 07.02.2018 22:50, Joe Conner wrote: Did you use the menu tree INSERT -> MEDIA -> SCAN? On 02/07/2018 02:25 PM, Tim-L wrote: I just installed 6.0.0.3 64-bit DEB for Ubuntu MATE 16.04LTS. I was looking at some things and I went to "Insert/Media/Scan/Select Source". LO could not find my Canon TS9020 printer/scanner. I even opened the printer's scan utility and still LO could not find the scanner. This is the first time I looked into using a scanner withing LO, so I do not know if it is a 6.0.0 issue or 5.4.4 or earlier issue. Any ideas? -- 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: Conditional formatting in Calc: how to find it?
Hi Peter and all: When you create a Conditional Formatting you can use a formatting existing or create a new of it. In whatever option you select, you can see the style done in the Style Option Menu because it is Style. I hope this help, Jorge Rodríguez El 12/01/2018 a las 06:59, Regina Henschel escribió: Hi Peter, ptoye schrieb am 12.01.2018 um 12:19: The LO version is 5.3.7.2 (x64) which I think is the latest stable version. The bug is at https://bugs.documentfoundation.org/show_bug.cgi?id=114909 The LO staff think it isn't a bug because it's OK in later unstable versions. There isn't a Format > Conditional Formatting menu item in my version of Calc. That's the problem. See the screenshot. <http://nabble.documentfoundation.org/file/t474865/Format.png> It seems, you are using an older user profile, because the order of items is different and the sub-menu "Sheet" is missing. Please rename the entire user folder and then start LibreOffice again. Do you see the missing items then? And please compare the menu with your screenshot. Do you see differences? Kind regards Regina -- 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] Calc Improvements Statistics
Hi Olivier and all: After to classified the improvements make into Calc or LibreOffice related with Calc, from LibreOffice 4.2 to LibreOffice 5.4, this are the statistics about Calc: Introducing Calc : //_/19 Improvements/_ Entering, Editing, and Formatting Data: _/14 Improvements/_ Using Charts and Graphs: _/6 Improvements/_ Using Styles and Templates: _/2 Improvements/_ Using Graphics in Calc: _/2 Improvements/_ Printing, Exporting, & E-mailing: _/8 Improvements/_ Formulas and Functions: _/27 Improvements/_ Using Pivot Tables: _4 Improvements_ Data Analysis: _/1 Improvement/_ Setting Up & Customizing Calc: _/5 Improvements/_ Out of Topics: _/23 Improvements/_ Total Improvements : 111 Those improvements commented not include Macro because I don't understand them very well. In Out of Topic, we can find some about Color Pallet, Math and others improvements like that. I'm going to classified the 6.0 improvements and then I will communicate the results. You can see a details of the classified made in : https://wiki.documentfoundation.org/Documentation/Development/Calc/6.x Those classified were made to try to update in next time the Calc Book 6.0. If someone want to join to us to contribute to do it , you are welcome. Regards, Jorge Rodríguez -- 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] Database corruption since LO 5.7.3 installed
Hi Ptoye and all: You say that sometimes the data file open well. When it happen, I suggest you to save the file with a new name (Other file). I would solve your problems. Regards, Jorge Rodríguez El 07/01/2018 a las 06:23, ptoye escribió: Since upgrading to LO 5.7.3 a database of mine keeps getting corrupted. When I try to open it it opens in Writer with the text Ó×r6ÒÒ#v If I try opening it in a Zip file reader I'm told it's not a valid Zip file. It's not consistent though; sometimes it opens OK. It's an embedded HSQLD database and I'm running Windows 7. Has anyone else here seen this? It doesn't seem to be in Bugzillla. - Peter -- 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] A wish to improve
Hi Jean-Baptiste and all: Thank you, I already put the wish . Regards, Jorge Rodríguez El 02/01/2018 a las 11:07, Jean-Baptiste Faure escribió: Le 02/01/2018 à 15:35, jorge Rodríguez a écrit : Hi everybody and happy new year !: I've used LibreOffice in much ways. One of them is Statistic options. In there Regression offer do it using two set of data of two variables; but in many situations is necessary make a regression between some variables (Multiple Regression). Where do I put my wish to be considered with the programmers of LibreOffice ? https://www.libreoffice.org/get-help/feedback/ Best regards. JBF -- 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] A wish to improve
Hi everybody and happy new year !: I've used LibreOffice in much ways. One of them is Statistic options. In there Regression offer do it using two set of data of two variables; but in many situations is necessary make a regression between some variables (Multiple Regression). Where do I put my wish to be considered with the programmers of LibreOffice ? Regards, Jorge Rodríguez -- 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
Hi Peter and all: I suggest to run LibreOffice Base from Terminal (of Ubuntu), and run the report that you want to do. When it crash, looks the Terminal and usually there you can see what happen. I hope this help, Jorge Rodríguez El 28/11/2017 a las 14:54, Robert Großkopf escribió: Hi Peter, Definitly a hard crash. When restarted it goes into a recovery process. If I install Open Office will it work with the Lire Base data bases or would I need to export the data and recreate new data bases? If you are using the internal HSQLDB (and not Firebird!) it will be no problem to change between LO and AOO. Hope you haven't made something with macros, specially dates and reading values from listboxes - this will be a problem. Also it could be a problem to read reports with charts ... But before changing to AOO: You use the packages from Ubuntu at tis moment. In lifetime of LO very old packages, together with Base and Report-Builder Ubuntu isn't very user-friendly during the installation. Try the packages, which are original supported by LO: http://downloadarchive.documentfoundation.org/libreoffice/old/5.3.7.2/deb/ (or if you prefer newer versions you could search this path upper way: /old/5.4.3.2/deb/) Regards 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] Create scan button?
Hi James and all: I suggest to use a Macro. If you don't know what it is, is a feature that LibreOffice has to automate the process. It usually run well but sometimes crash. To able you can follow this steps: 1) Menu-Tools-Options-Advanced: There Check box "Enable_Macro Recording" 2) Menu-Tools-Macros-Record Macro: There click and appear a "little box" that meaning that almost all that you do from this time in LibreOffice is recording. 3) After step 2), select Menu-Insert-Image-Scan-Request. Until this you did record those steps to scan. Now click Stop Recording button from "little box" 4) Now appear a windows dialog where you can record the macro with those step you were recording: Select My Macros --> Standard --> New Module--> Named as Scan --> Save --> and click accept to overwrite the main option there. 5) Now Menu-Tools-Macros-Organize Macros-LibreOffice: Appear a Dialog Window where you can see the Macros Library: There select My Macro-Standar and find the macro called "Scan" that you save before. 6) Select Scan Module and then select at right : Assign button 7) Appear new Dialog Window: Here, keep "Standard toolbar", and select Button Add 8) There appear a new dialog window where you can look again : My Macros - Standard. Select "Scan" macro and click Add button 9) Now you can see the "main" item in the list at top. With the arrows you can move to top or down the "main" item (This main item represent your macro where you record the steps. 10) Select "main" item and select Modify Button. There select Rename and input Scan. Accept and now in the same place you can select an icon or let as is with the name "Scan" 11) Close the window dialog and the icon-Scan appear in the tool bar at top at left if you didn't move with arrow. If you move ... you can find along tool bar. I hope this help, Regards, Jorge Rodríguez El 19/11/2017 a las 10:08, James Knott escribió: I occasionally scan documents into LibreOffice with a single sheet scanner. This means for each page I have to click on Insert>Media>Scan>Request. Is it possible to create an icon to run those steps? tnx jk -- 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] ttf-mscorefonts-installer
Hi Joe and all: In Ubuntu there is a program in their Repositories, called Ubuntu Restricted Extras. This contained programs for music, dvd and more as I know. One program that it installs as I could see is ttf-mscorefonts ( And request agree with license). I don't know if it is possible to install ttf-mscorefonts alone. Regards, Jorge Rodríguez El 10/11/2017 a las 12:31, Tim-L escribió: On 11/10/2017 10:20 AM, Robert Großkopf wrote: Hi Joe, ttf-mscorefonts-installer Never heard LO will install ttf-mscorefonts. On my system (OpenSUSE) is a special script to download ttf-mscorefonts. It has nothing to do with LO. Could be there is the same script for Ubuntu. So start this script with your installer. Regards Robert I have seen this font installer outside LO. It was in my Ubuntu 16.04 repository. BUT, it will not install since it seems to require getting the package from an off-repository site. Since these fonts are from MS, and the installer seems to be a .exe file, it is not available-maybe. -- 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] LO 5.4 unusable with large document including comments
Hi Jack and all: Why not probe increasing memory to LibreOffice Writer: Menu--> Tools --> Options --> Memory I hope this help, Jorge Rodríguez El 30/10/2017 a las 07:41, Jack Wallen escribió: I'm an author. I've been using LO for a very long time. However, recently I changed editors to one who does all of her editing within comments. Yesterday I opened the file she'd just edited, to find it unusable. Trying to scroll through the document was painfully slow. I saved the file to .docx format, opened in Apple Pages, and it had no problems. I did a bit of searching to find this a common issue with LO (documents with hundreds or thousands of comments becoming unusable). Thing is, I could not find a work-around. Is this going to be the deal breaker, or is there a solution for this issue? Thank you so much for any input anyone might have. Jack -- 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: Calculating the Nth weekday of a month.
Thank you Michael, I already download your files, Regards, Jorge Rodríguez El 16/10/2017 a las 14:25, Michael D. Setzer II escribió: Dropbox didn't seem to work. Put the files there, but then sent a link to my other email account, and it worked for that, but seems to be specific to users. Looked, and it says the just changed the public folders, and they are no longer available?? Also, looked at google drive, and it seems to be the same way. So, just make a directory, on my ftp server, and placed the files there. This is my home machine, so files are there. The files are like 20K and 10K, so are tiny. Did modify the nthweekday.ods a little. Added conditional formating for the second part where formula is a single cell process. Top part has formula over a couple cells. If one selects 5th week, some of the days will not have a 5th one in the month, so those are conditioned with the error color scheme. ftp://setzco.dyndns.org/libreoffice/nthweekday.ods ftp://setzco.dyndns.org/libreoffice/simplenth.ods -- 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: Calculating the Nth weekday of a month.
Hi Michael: I tried to download your files but it request a permission. As you say you are new in Dropbox I would give you some suggestion: 1) When you tried to share a file, put it in the public folder. 2) There generate a share link into it folder specific the file you want to share. 3) Copy the link generated and paste into the e-mails as you did now. I hope this help, Regards, Jorge Rodríguez El 16/10/2017 a las 10:52, Michael D. Setzer II escribió: New to dropbox, so hopefully, the links below will work. nthweekday.odson Dropbox. https://www.dropbox.com/l/scl/AACOvRvGCKENXdOpjwXoA40M4DZwc1YhAew simplenth.odson Dropbox. https://www.dropbox.com/l/scl/AADOenugbyhmi8kSNxM2l_sT5kuBFhpWNxI -- 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] Opening .cwk file question
Hi Dennis and all: I suggest you to open the old Mac works file with LibreOffice and save then the spreadsheet as Calc format (.ods) and look if this new spreadsheet keeps show more columns than an usual Calc spreadsheet. Remember that all Calc spreadsheets has a 1024 columns (At least in my version of LibreOffice 4.2.8.2 Ubuntu 14.04 LTS. Newer versions of LibreOffice would have more or less quantity of columns, someone would confirm this issue) Regards, Jorge Rodríguez El 11/10/2017 a las 12:45, romad escribió: I have some old Mac AppleWorks/ClarisWorks files that I wanted to update using LibreOffice Calc. They opened fine but the Calc document has what seems to be an infinite number of columns as no matter how many unwanted columns I delete, they reappear! How do I get Calc to just open the old files without adding empty columns and/or rows? Also, is there a way to limit NEW Calc documents to say, 1 sheet of 10 columns and 100 rows then allow me to delete/add as needed? - Sincerely, Dennis B. Swaney -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- 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] word count in impress
Hi all: I really don't know how count the words the programs that do it ... but to be sense, a word has to be a "character or group of characters that has meaning by it self" As this, a number has meaning by it self, the special character has meaning by it self, a ";" doesn't have a meaning by it self because it is a grammar character to input to reader takes a breath and change a little about the topic is going on in the paragraph. And so on. But if the program take for example ";" as a word because it is a character, it is wrong to consider a literal translation but in the context the translator it would be taken because he has to build the translation using it to make a meaning of the translate. I think, to clear this topic, it is necessary that the translator think how to take some characters like ";", and investigate with the programmers of each program like Writer and Gedit, how they make the algorithm to count to be sure that he is taken the right quantity when is using those programs to his job. I hope this help, Regards, Jorge Rodríguez El 03/10/2017 a las 11:38, Toki escribió: On 10/02/2017 04:13 PM, Thomas Blasejewicz wrote: (A similar question posted on the net somewhere was "closed, because it is irrelevant" ???) I'll hazard an explanation, without looking at the specific question so closed. a) There are four different ways to count the number of words in a text. Without knowing which definition was used for the term " count the number of words", any formula that is used is going to provide the wrong answer. b) For presentations, regardless of how "word" is defined, words are not fundamental to the final product. What matters is the aesthetics of each frame, and the number of frames within the presentation. As such, words are irrelevant; c) There reason 10-20-30 is a law, is why frames should not contain words; jonathon -- 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] word count in impress
Hi Thomas: I think that I have a solution using GNU / Linux Ubuntu, or maybe the solution it would be able with other program similar that you can find: 1) Install the program: gpdftext (GTK+ text editor for ebook PDF files, gpdftext opens a simple text-based PDF file, typically intended for reading on an ebook reader and loads the text into a text editor window, autoformatting the text for long lines and paragraph breaks. gpdftext is useful when the downloaded PDF uses a small font or wastes a lot of space in the margins so that a plain text file would display in a more comfortable font. gpdftext supports spell checking and editor font selection and can save ASCII content as PDF.) Web site: https://sourceforge.net/directory/os:linux/?q=gpdftext 2) Save the Impress Presentation in .pdf format 3) Open the Impress Presentation with gpdftext 4) gpdftext convert the .pdf document in simple format text 5) Save the document as .txt 6) Open the document with Writer an use the tool that it has: Menu-> Word Count I hope this help, Regards, Jorge Rodríguez El 02/10/2017 a las 10:13, Thomas Blasejewicz escribió: Good evening It happens once in a while .. I have to work (translate) PPT files for which I use Impress and then need to know the number of words. In the entire file. So far I could not figure out, whether there is a way to count all words in an Impress file. (A similar question posted on the net somewhere was "closed, because it is irrelevant" ???) Today I found, that one can get a word count in the real PPT by looking at properties. Is there such a trick for Impress? Thank you. Thomas -- 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] Recalculate doesn't work
Hi CFranz: Would you please tell us what version of LibreOffice use you ?, it is because some issues are correlations with specific versions. I don't know in this case but usually is necessary to know the version if it is a cause of a bug. Regards, Jorge Rodríguez El 27/09/2017 a las 09:02, cfranz escribió: Hallo. I have a problem with recalculate in a file. I have imported some data from Börse Frankfurt and I have made a spreadsheet with some formulas. The calculate from row 5 to row 10 are correct, but from row 11 to row 13 not. I tried to recalculate but without success. I have noticed that the format of columns of "bind" and "Ask" (columns M and N) was text, not numbers. After I have changed these (with regular expressions), the spreadsheet has become correct. But I don't understand why before,despite the format of columns M and N was in incorrect format, only half of rows was correct. The file is: https://mega.nz/#!nZBn2CLa!WJTJgahHFAMFg5oTN3LeCyVNjqijJhRodUNEale4PQk Can somebody help me to understand why? Thanks Cri -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- 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] printing envelopes
Thank John for your feedback, it would be useful for me in the future, Regards, Jorge Rodríguez El 23/09/2017 a las 06:17, John R. Sowden escribió: A few months ago, I asked about printing envelopes. All I got was explaining how LO does it. Finally someone said LO only prints one envelope for one document, not 100 envelopes with a custom return address. well, i found the solution, in a program that I have been running for about 2 years with great success, glabels. instead of a label, there is an option for a #10 envelope. glabels works great. I have been using it to print large mailing labels on 9x12 document envelopes. hope this helps someone else, john -- 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] To make a graph
Thank you Brain, I could do it now well and got the same result : 9126 Regards, Jorge Rodríguez El 30/08/2017 a las 11:05, Brian Barker escribió: At 10:18 30/08/2017 -0600, Jorge Rodríguez wrote: As I said to Regina, thank you very much for your explanation. No probs! I could reproduce the graph as you instructed to me. I found both graph clear and making what I need. Good-oh! Yes, I need the graph and the coordinates of the interception both lines too. I follow your equation to find U, and I reproduced it well with the same result. But I tried to do the same with A coordinate interception: 14000 * ( 1 - U / 1.31 ) and I got : 5813 not 9126. As you said, 9126 is the correct point where intercept but I couldn't get in my calculation. Would you please, tell me what would I do wrong ? You seem to have calculated 14000 * ( 1 - U ) / 1.31 instead of 14000 * ( 1 - U / 1.31 ) - which means 14000 * ( 1 - ( U / 1.31 ) ), of course. 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] To make a graph
Hi Brian: As I said to Regina, thank you very much for your explanation. I could reproduce the graph as you instructed to me. I found both graph clear and making what I need. Yes, I need the graph and the coordinates of the interception both lines too. I follow your equation to find U, and I reproduced it well with the same result. But I tried to do the same with A coordinate interception: 14000 * ( 1 - U / 1.31 ) and I got : 5813 not 9126. As you said, 9126 is the correct point where intercept but I couldn't get in my calculation. Would you please, tell me what would I do wrong ? Regards, Jorge Rodríguez El 29/08/2017 a las 11:31, Brian Barker escribió: At 09:45 29/08/2017 -0600, Jorge Rodríguez wrote: Below you can find a link to access a file were I draw manually the graph that I need to do: https://www.dropbox.com/s/7oqptiz8e6r9gxi/Graph.pdf?dl=0 So your data set is actually: A U1 U2 0 1.371.31 13680 0 14000 0 (with some missing values). You will have seen Regina Henschel's recipe for a graph. Here is another: o Select the data block as above and click the Chart button. o Select "X-Y (Scatter)" and leave all other options as default. o Select the chart (grey border, not coloured handles). o Right-click a point and select Insert Trend Line... and OK. o Repeat for a point on the other line. But do you really want to see the graph, or perhaps just find the coordinates of the point of intersection, as was perhaps hinted at by your original request? Application of similar triangles shows that the U coordinate of the point of intersection is given by 1.31 * 1.37 * (14000 - 13680) / (1.37 * 14000 - 13680 * 1.31) and that the A coordinate is 14000 * ( 1 - U / 1.31) - where U is the U coordinate calculated above. You will see that these give the intersection point as A=9126, U=0.456. 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] To make a graph
Hi Regina and Brian: Thanks for your answer. Excuse me because I haven't been clear with my explanation. Below you can find a link to access a file were I draw manually the graph that I need to do: https://www.dropbox.com/s/7oqptiz8e6r9gxi/Graph.pdf?dl=0 Regards, Jorge Rodríguez El 28/08/2017 a las 17:40, Brian Barker escribió: At 17:05 28/08/2017 -0600, Jorge Rodríguez wrote: I have this set of data: UA 1.3713680 1.3114000 I've tried to graph these data that show two lines, first 1.37 with 13680 and 1.31 with 14000, in the same graph. Sorry, but this makes no sense. Each pair of value here defines a point, not a line. There are an infinity of lines that you can draw through any point, having all possible gradients.You need at least two points to define a line, and then only on the assumption that the line is straight. I want that the graph show where the lines intersect. The infinity of possible lines through each of your two points intersect in a infinity of places. The question is not well enough defined to be answered. From your knowledge if the quantities that you are plotting, could you assume that both graphs go through the origin, (0,0)? If so, you could include these points and create two lines. But the answer to your query would then be trivial: the lines cross at (0,0)! And I prefer that A go in X axis and U in Y axis. That's easy: just reverse the order of your columns of data. It is very easy to move or copy data. I couldn't do it yet. I put the data in some orders but I can get the graph. That's because - with only one point in each set of data - there is no graph to get. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] To make a graph
Hi all: Would you please help me with this problem: I have this set of data: UA 1.3713680 1.3114000 I've tried to graph these data that show two lines, first 1.37 with 13680 and 1.31 with 14000, in the same graph. I want that the graph show where the lines intersect. And I prefer that A go in X axis and U in Y axis. I couldn't do it yet. I put the data in some orders but I can get the graph. Thanks in advance, Regards, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Simple way to draw graphs ?
Hi all: As I understand, there is a way to use some information from other authors: Put quotation marks to the information that we need to reference and put a footer where we have to put the information of the authors and more. When we use a graph, we can do similar. And I think it doesn't break the copyright. I hope this help, Jorge Rodríguez El 15/08/2017 a las 04:43, Brian Barker escribió: At 12:14 15/08/2017 +0200, Wiebe van der Worp wrote: Please also be aware of the fact that data itself is not copyrighted. In other words, copying data to Calc and use it to create a graph and an accompanying table should never be a problem - if my memory serves me well. This may be true in the USA (is it?), but a few seconds of web searching shows this certainly not to be so in all jurisdictions. (The text on the original chart was in French and the original enquirer wrote from a French e-mail address.) 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] Draw problem
Hi: I can't help you with your problem but usually to someone can help you, it is necesary to know your Operative System, and the version of LibreOffice that you are using (Where you get the problem with Draw) Regards, Jorge Rodríguez El 31/07/2017 a las 23:35, Art escribió: Greetings, I’m having a problem when trying to use Draw, the other Libre Office programs run great, and it’s been months since I had an error of any kind. My system is a ThinkCenter with a second generation I5 processor, tons of ram, an ssd and I have an encrypted drive. I do not have any problems when using the spreadsheet or Writer. This has been happening for awhile, and I assumed someone had registered a bug. Today, I see that there is no bug listed. If I open a new Draw document, make a single entry and then try to save it (even if the document is empty), the vast majority of my icons immediately change to ‘grayed out’ and I get an error message stating: Error saving the document Untitled1 General Error. General input/output error.” From that point, there is nothing I can do that will allow me to continue editing the document...because most of the icons are grayed out. When the computer is restarted, and I open Draw again, I get the dialogue screen saying that I need to recover my files. However the recovery fails and I have to click on the ‘discard the files’ button. I created a video showing the problem, but a 25 second video (.avi) was 3.6GB, not sure why it was that large. I used Kazam. I removed libreoffice-draw (with the purge command) and reinstalled it (both from the command line). It still has the same problem. TY Art -- 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: Subject: Digest of users@global.libreoffice.org issue 2704 (52154-52162)
Hi: I don't know what exactly Language settings require to LO restart, but if you follow the steps that I suggested probably work because It works for me and probably for you too as you told us. Regards, Jorge Rodríguez El 29/07/2017 a las 14:05, bunk3m escribió: OK, a quick update. I continued to fiddle with the language settings. I'm not sure what I changed but LO said that the changes required a restart. So I did the restart and now it works! I can't figure out what exactly changed to cause the restart but it looks like it's OK now. 1+1.5=2.5 again! Hurrah! If you know what changes cause LO to require a restart to affect the change, I would appreciate knowing. Then if this happens again I'll know what to do. Thank you Jorge, Regina and Brian! Cheers! B. On 29.07.2017 15:57, bunk3m wrote: Hello Regina and Jorge, Thank you for your help and suggestions. I apologize for the delay as I didn't get the emails until I received the daily digest this afternoon. I have quoted both your posts in order to keep them together but this post is getting rather long. I have tried your suggestions and I'm still unable to get a basic decimal calculation to work. But now I am getting "#NAME?" for the cell containing "=1+1.5". Interestingly enough, if I put "=1+20" it does give me "21" as an answer. What it doesn't like about the decimal place I don't understand. This is very strange. I tried using a comma "," instead as a decimal separator but that didn't work either. Perhaps I should delete all the preferences and all the extensions in the Application Support folder?? Then I would have a "new" install? Thanks again and regards, B. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc - Invalid name error - help request
Hi again: I suggest to do this in the Language-Language settings: *User Interface: Select English US *Locale Settings: English (Canada) *Decimal Separator Key: uncheck *Default Currency: Default CAD (English or French) *Default Language for Documents: A English Canada or French *Ignore system input language: check I did this in my LO, and restart LO, and then LO accept " . " as decimal separator key I hope this help, Jorge Rodríguez El 28/07/2017 a las 18:14, jorge Rodríguez escribió: Hi: In LO Preference (Menu-Tools-Options-Language settings), you can find some ways to customize your settings. I hope this help, Jorge Rodríguez El 28/07/2017 a las 16:11, bunk3m escribió: Thank you Jorge. I have checked this. The Mac settings are OK. It works with Excel fine and Apple Numbers. Mac settings are to show decimal as "." I have some LO Calc sheets that were created a few years ago that are OK. It seems to be some change in the last few versions?? Would you know if there are any override settings in the LO Preferences? I can't find it if it exists. Thanks again. B. On 28.07.2017 17:46, jorge Rodríguez wrote: Hi : I don't have a Mac, I use GNU / Linux Ubuntu...but usually that kind of issues are define with the Operative System. Try to find how is it define it in you Mac. Probably is as " , " and you have to change to " . " as you use it in Canada. Regards, Jorge Rodríguez El 28/07/2017 a las 14:50, bunk3m escribió: I'm having a struggle with Calc. I trying to migrate over from Excel but have a problem. When I type [=1+1.5] into a cell, I get "Invalid Name" error. If I save the file as an xlsx and open in Excel it calculates OK and give 2.5. If I then open the xlsx in LO, it still says "Invalid Name". If I put [=1+1,5], I get ERR: 509. This makes sense since I'm in Canada and we use "." to separate decimals. If I put [=1+1] LO correctly calculates "2" with no error. I have older LO spreadsheets that calculate OK. Every new CALC spreadsheet has this problem. I'm not sure how to figure out why I get this error and why LO won't calculate such a basic equation. What should I be looking at? Mac OSX 10.10.5 LO 5.3.4 & 5.4 I'm on daily digest mode so please cc me when you reply to the list. Thank you in advance. B. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc - Invalid name error - help request
Hi: In LO Preference (Menu-Tools-Options-Language settings), you can find some ways to customize your settings. I hope this help, Jorge Rodríguez El 28/07/2017 a las 16:11, bunk3m escribió: Thank you Jorge. I have checked this. The Mac settings are OK. It works with Excel fine and Apple Numbers. Mac settings are to show decimal as "." I have some LO Calc sheets that were created a few years ago that are OK. It seems to be some change in the last few versions?? Would you know if there are any override settings in the LO Preferences? I can't find it if it exists. Thanks again. B. On 28.07.2017 17:46, jorge Rodríguez wrote: Hi : I don't have a Mac, I use GNU / Linux Ubuntu...but usually that kind of issues are define with the Operative System. Try to find how is it define it in you Mac. Probably is as " , " and you have to change to " . " as you use it in Canada. Regards, Jorge Rodríguez El 28/07/2017 a las 14:50, bunk3m escribió: I'm having a struggle with Calc. I trying to migrate over from Excel but have a problem. When I type [=1+1.5] into a cell, I get "Invalid Name" error. If I save the file as an xlsx and open in Excel it calculates OK and give 2.5. If I then open the xlsx in LO, it still says "Invalid Name". If I put [=1+1,5], I get ERR: 509. This makes sense since I'm in Canada and we use "." to separate decimals. If I put [=1+1] LO correctly calculates "2" with no error. I have older LO spreadsheets that calculate OK. Every new CALC spreadsheet has this problem. I'm not sure how to figure out why I get this error and why LO won't calculate such a basic equation. What should I be looking at? Mac OSX 10.10.5 LO 5.3.4 & 5.4 I'm on daily digest mode so please cc me when you reply to the list. Thank you in advance. B. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc - Invalid name error - help request
Hi : I don't have a Mac, I use GNU / Linux Ubuntu...but usually that kind of issues are define with the Operative System. Try to find how is it define it in you Mac. Probably is as " , " and you have to change to " . " as you use it in Canada. Regards, Jorge Rodríguez El 28/07/2017 a las 14:50, bunk3m escribió: I'm having a struggle with Calc. I trying to migrate over from Excel but have a problem. When I type [=1+1.5] into a cell, I get "Invalid Name" error. If I save the file as an xlsx and open in Excel it calculates OK and give 2.5. If I then open the xlsx in LO, it still says "Invalid Name". If I put [=1+1,5], I get ERR: 509. This makes sense since I'm in Canada and we use "." to separate decimals. If I put [=1+1] LO correctly calculates "2" with no error. I have older LO spreadsheets that calculate OK. Every new CALC spreadsheet has this problem. I'm not sure how to figure out why I get this error and why LO won't calculate such a basic equation. What should I be looking at? Mac OSX 10.10.5 LO 5.3.4 & 5.4 I'm on daily digest mode so please cc me when you reply to the list. Thank you in advance. B. -- 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] Canon USA Printer Support are using LibreOffice?
Good day Tim: Did you probe usb for boot repair disk (Burn it in a usb flash memory and would be boot there with your Bios). In GNU / Linux you can use UNetbootin, and in windows there are other similar solutions. I hope this help, Jorge Rodríguez El 27/05/2017 a las 09:05, Tim-L--Elmira-NY escribió: I have the other way around. During an upgrade for Ubuntu, the computer crashed and messes up GRUB. So now I have a 1TB drive with access to only 1/4 of it. The problem is the DVD cannot be set as a boot option. BIOS has a weird way to set devices to be bootable. My other laptop's BIOS is easier. Of course its DVD boot commands will not work with the new ASUS's BIOS. So with this problem I cannot run the repair disk, since it requires to be booted via the CD/DVD drive. The laptop had been able to boot to from the DVD, which was the way I added Ubuntu in the first place. If I cannot find the correct BIOS commands - or maybe the GRUB commands - to boot the repair disk, I would remove the hard drive and repair the drive via another Ubuntu laptop. The only problem with that, I would loose my 4 year warranty. On 05/20/2017 07:51 PM, Virgil Arrington wrote: Last year, I accidently erased Win10 in an attempt to create a dual boot with Mint 18. It was totally my fault. Now, I'm kind of glad I did it. So far I haven't missed it. Virgil Sent from my Verizon, Samsung Galaxy smartphone Original message From: Tim-L--Elmira-NY <webmas...@krackedpress.com> Date: 5/19/17 12:49 PM (GMT-05:00) To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Canon USA Printer Support are using LibreOffice? On 05/18/2017 07:24 PM, Steve Edmonds wrote: On 13/05/17 10:48, Tim-L--Elmira-NY wrote: On 05/12/2017 02:44 PM, James Knott wrote: On 05/12/2017 02:31 PM, Tim-L--Elmira-NY wrote: I would love to get it verified, but it would be a good marketing coo for LO if a big company like Canon uses LibreOffice. I used to work for a company that used OpenOffice (this was before LibreOffice was available). I suspect the only reason they did was because they were so d@mn cheap, they wouldn't pay for MS Office. ;) Well cheap or not, it is nice to have as many big companies using LibreOffice as possible. I bet there are a lot of people out there, and on these lists, that are using LO not because of being "cheap". It is nice to have a free office suite but I prefer LO over MS Office. Just like I prefer to use Linux over Win10 because of all of the viruses and other nasties that Windows have, while Linux do not have these things infect their systems. And the suggestion that the latest crypt virus may have been introduced to computers through a document macro makes me more comfortable using LO without MSO on any win PCs. Steve Well, if you look at the CNN Headline News, they have stated that MS has a patch for this virus, but wanted to charge some users for it. The on-air comment seems to say that since MS had the patch, they should have sent it out to ALL MS Windows users. Plus, it the patch was installed, most computers would not have been infected. Fro me, I use Linux so I do not have the security problems as MS Windows users. I do have Win10, but rarely use it. Most times I just go to the Win 10 partition to run the update app. -- 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
