[libreoffice-users] Libre Office Calc version 7.3 issues
Salutations for all. At first I had installed the Libre Office version x64 7.3 on my Windows 10. I usually use the "calc" part. It works wisely, but have some issue as follow: 1) In the main Libre Office window, if we issue to open one previous spreadsheet, the process may last for over one minute, and soon we can see the message (is not responding). My version is brazilian portuguese; 2) On Graphics, if we try to edit one axis, the edit window may last one minute to open. 3) I had tried to switch on and off the JRE; 4) The above problem turns worse if we Switch ON the ICL (we almost lost access to Libre Office; 5) Then, I uninstall the Libre Office x64 and installed the x32 which seems to work properly, but have other issues on Graphics: a) It "pretends" to buld the Graphics, but the Graphics function does not work; b) When we select one column, e.g., colum "B" for any plotting or function, the selection, different from the x64 version, select ALL the CALC column; and not only the "valid content". Anyway, for "functions" the CALC works, but not plot graphics. 6) I will try to install older versions. Does anyone have the same issues as me on Windows 10? Should I configure anything on my Windows 10, or Libre Office, in order to it to work properly? Regards, -- 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] 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] saving as csv newline inserted
Hi Uwe and all: I suggest: a) Open the file as is: csv b) Mark the column that content all the information c) Use: Menu, Edit, Search and Replace ... click there d) In the window opened: In the first row for input what to search, input and "space" with spacebar e) In the second row for input what to replace, keep without input f) Apply the option Replace All g) Now if all is good, you are eliminate the space after "name" field h) Save the file again as csv i) Now you can close the file and open again or use the option: Menu, Data, Text to Column to split the fields in the column I hope this help, -- Atentamente, Jorge Rodríguez El mié, 21-06-2017 a las 12:52 +, Uwe Brauer escribió: > Hi > > I have an excel (xls) file which I open with scalc (5.3) > and save it as csv > > Unfortunately it looks like > > Field1,Field2,Field3,Field4,Field5 > "Name","05329954A >",0.55,0.75,1.3 > > Instead of > > Field1,Field2,Field3,Field4,Field5 > "Name","05329954A ",0.55,0.75,1.3 > > > The reason is that in the first column there is a after name a space > which is translated to a newline when exporting. > > How can I get rid of this unwanted newline? > I tried to format the cells but it seemed not to have worked. > Thanks > > Uwe Brauer > > -- 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
Re: [libreoffice-users] Base Subsection reporting
Hi Pieter and all: As first answer but not necesary the best, BASE has it own report way, but before you can filter or use query or mix tables data to make consultation (Option below Tables at left). Then, after you make it, you can go to Form option (The last option at left). In both options you can use Wizzards or make by your self. I suggest you to use Wizzards to probe how is going on and if you like the results. If not, try by your self, but this need to know better the program performance. As I remember, Base generate a Report in Writer program that you can edit after. I hope this help, -- Atentamente, Jorge Rodríguez El vie, 26-05-2017 a las 21:25 +0200, Pieter van der Burg escribió: > Hi, > I need a printed (paper or PDF) report from a small selection of my DB. I > am puzzled what is the best way to achieve that. > Filter? > Query? > other? > I am new to Base (but no PC dummy!) > > Greetings ftN > -- 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] Impress can't print to Postscript
Hi Tedc: I did the similar process with a document with my printer HP-3050, and it work well. At least in my printer I have some levels of Postscript to select. The problem would be in your printer driver capacities. I use Ubuntu 14.04 LTS with Cups and HPlip (Both in the repositories of Ubuntu) Process that I did: Select Print in LibreOffice, then there select Properties, there you can find Divice Option, and there you can select Type of language of printer: Select Postscript. Then select Print to File Option in Option Topic out of Properties ( In the main window ). I hope this help, -- Atentamente, Jorge Rodríguez El lun, 22-05-2017 a las 09:34 -0700, tedc escribió: > Using LibreOffice 5.0.6.2 under CentOS 7.x. Impress can only print to a > printer or to a PDF. Even though I specify printing to a Postscript file > via > File / Print / Options / Print to file > then > General / Properties / Device / Printer language type / Postscript (level > from driver) > then specify the file name as > foo.ps > the result is always a PDF. This is a big fail. > > > > -- > View this message in context: > http://nabble.documentfoundation.org/Impress-can-t-print-to-Postscript-tp4215005.html > Sent from the Users mailing list archive at Nabble.com. > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Frequency Distribution
Hi Brian: I've searched information in the web but usually it is more complex than my knowledge can evaluate. For example, in Wikipedia found https://en.wikipedia.org/wiki/Beta_distribution, but it so deep for me, but show some graph with different values of Beta and Alpha that could help me. I found some others like this, easier to understand the information: https://stats.stackexchange.com/questions/47771/what-is-the-intuition-behind-beta-distribution And found a program named "SciDavies" that could help me too. But the major problem to me is my knowledge in statistics. It is not to deep, although I already found some books that could help me too. In general, when I made my question about it, I was trying to find a way to make the process easier and fast to me. Thank you very much because you try to help me, and clear me that LibreOffice can't help with its formulas to solve my problem directly. Regards, -- Atentamente, Jorge Rodríguez El mar, 09-05-2017 a las 16:25 +0100, Brian Barker escribió: > At 08:08 08/05/2017 -0600, Jorge Rodríguez wrote: > >Hi Brian, well, thank you for your answer > > My point, of course, was that it was sufficient - > indeed, better - to explain that you had a table > with consecutive integers in one column and real > values in the other, rather than listing > eighty-two values and asking readers to make that observation themselves. > > At 14:10 07/05/2017 -0600, Jorge Rodríguez wrote: > >If I have a number of data about some topic, how > >can I get the type of distribution using the > >LibreOffice's formula ? How can I know if it is > >normal, gamma, etc. ? There is a way ? > > The simple answer is that your data will > certainly match none of those distributions - at least, not precisely. > > Think of a straight line: this can be defined > exactly by two points. If you have three points, > they will not - except by an impossible > coincidence - lie on a straight line. But if you > believe that your data should lie on a straight > line, there are techniques that determine the > straight line which probably misses all of your > points but is in some sense the "best fit" to them. > > Similarly, your analytic distributions will be > definable by a small number of points - certainly > a lot less than your forty-one. So the best you > can do is to attempt to fit various distributions > to your data and also to discover how good the > fit is in each case. That might help you to see > which distribution the data fits best. But a > better logic would be to decide from the nature > of your data - what it represents - which > distribution is likely, and then to fit the data > to such a distribution (if that is necessary). > > In any case, Calc does not appear to have any > functionality that would help you here, but you > will certainly be able to build formulae to > achieve what you want in Calc once you have > unearthed the relevant mathematics. That will surely be out there on the web. > > 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] Survey Results about LibreOffice
Hi all: With this link you can access to the results of the survey about LibreOffice. I hope you find interesting and enjoy it: https://es.surveymonkey.com/results/SM-W5V9KW7H/ The first question, in the last option, Others, has button named "Respuestas" that meaning "answers" and if you click there you can find details about this answers. In the second question, at the end you can find a button named "comentarios", that meaning "comments" and if you click there you can find detail of comments of this answers. Regards, -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Frequency Distribution
Hi Brian, well, thank you for your answer Regards, -- Atentamente, Jorge Rodríguez El lun, 08-05-2017 a las 05:05 +0100, Brian Barker escribió: > At 14:10 07/05/2017 -0600, Jorge Rodríguez wrote: > >If I have a number of data about some topic, how > >can I get the type of distribution using the > >LibreOffice's formula ? How can I know if it is > >normal, gamma, etc. ? There is a way ? For example: > > Year Inflation of CR > >19775,24971553 > >19788,11274841 > >197913,15353384 > >198017,78618715 > >198165,09133166 > >198281,75212345 > >198310,70142566 > >198417,34945384 > >198510,9251405 > >198615,42534076 > >198716,42746458 > >198825,33576785 > >19899,95444378 > >199027,25437251 > >199125,31611285 > >199216,96883188 > >19939,04288357 > >199419,85608235 > >199522,56778373 > >199613,88867535 > >199711,20231467 > >199812,35570391 > >199910,11290162 > >200010,24738868 > >200110,95604456 > >20029,68294967 > >20039,86787054 > >200413,12895123 > >200514,07496016 > >20069,43371564 > >200710,80552431 > >200813,90233262 > >20094,04704133 > >20105,82431576 > >20114,73574866 > >20124,55053048 > >20133,67954067 > >20145,12718527 > >2015-0,80758134 > >20160,7651911 > >20171,08546538 > > I thought I had an answer to this, but I'm afraid > it works only if the 2000 figure ends "8878", not "8868". > > Sorry. > > 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] Frecuency Distribution
Hi all: Would you please help me with this ? If I have a number of data about some topic, how can I get the type of distribution using the LibreOffice's formula ? How can I know if it is normal, gamma, etc. ? There is a way ? For example: YearInflation of CR 19775,24971553 19788,11274841 197913,15353384 198017,78618715 198165,09133166 198281,75212345 198310,70142566 198417,34945384 198510,9251405 198615,42534076 198716,42746458 198825,33576785 19899,95444378 199027,25437251 199125,31611285 199216,96883188 19939,04288357 199419,85608235 199522,56778373 199613,88867535 199711,20231467 199812,35570391 199910,11290162 200010,24738868 200110,95604456 20029,68294967 20039,86787054 200413,12895123 200514,07496016 20069,43371564 200710,80552431 200813,90233262 20094,04704133 20105,82431576 20114,73574866 20124,55053048 20133,67954067 20145,12718527 2015-0,80758134 20160,7651911 20171,08546538 Thanks and regards, -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Survey about LibreOffice
Hi Anne: About: (1) Yes, I'm not an english native language, but because this list and much more in the world are in english language, I tried to do it in english but It's so hard to do as you ! I understand that usually the sentences talk us by itself and we don't need the symbols as questions mark, but I tried to do well forgotten for example that in english you only use the last question mark. (2) When I made the survey, I couldn't catch the problem about the last button because I'm a spanish language (I found it natural for the end of the survey). The button "Listo" meaning something like "ready" (Conclude). When you haven't filled the question one or two or both and click to "Listo" button, the process send you again the survey to complete it with a message in spanish (I'm sorry). The message is this at the biginnins of each questions: "! Esta pregunta requiere una respuesta" in red color. The meaning is something like this: "This question require an answer." But if you conclude to fill both questions the button "Listo" end the process of the survey. (3) In the question one, the categories list some usually organizations that we would find in the world. Before the end of the list show the "Others" option that can select to individual business, or used by group of individuals associated. In the list you can find other kind of organizations (Profit and non profit), that you can select. In the last option of the first question, you can describe the name and the type of the persons, group, organization and more that you know that use LibreOffice. About the size of the organizations, I really didn't think in that ! It is a good and interesting data that we would have gotten. I'm sorry if these kind of issues affected you and others to do the survey. I hope this explanation clear this topics. Regards, -- Atentamente, Jorge Rodríguez El mié, 03-05-2017 a las 07:53 -0500, anne-ology escribió: >I too tried - > > >(1) I'm assuming your attempt at placing this into English is > due to a limited knowledge of our complicated language; > the beginning question marks & other symbols throughout > are superfluous. > > >(2) the button at the end - containing more symbols - I assumed > would go to the next page, but merely circled back to the start; > is that what you intended? > > >(3) the categories also don't list whether used by individual > for business and/or personal use; used by group of individuals; used > by some sort & size of a for-profit or non-profit organization. > > > > > > > > > From: John R. Sowden <jsow...@americansentry.net> > Date: Fri, Apr 28, 2017 at 10:34 AM > Subject: Re: [libreoffice-users] Re: Survey about LibreOffice > To: users@global.libreoffice.org > > > I tried: > 1) What is googleapis, a script that was attempted to be run? Sounds > rather googleish to me. > 2) In your categories of types of organizations, "Small Businesse" was > not included. (knowing who the users are will help in improving the > product to meet the need of the users). > 3) On the following screen, the language changed from American English > (Ubuntu's default in my case) to Spanish. Although I took a couple of > years of French in high school 50 years ago, it didn't help. > > John > > > > On 04/28/2017 07:48 AM, jorge wrote: > > Hi all: > > I want to remember you the survey ... would you please > answer it to > this link if you haven't done ? > > https://es.surveymonkey.com/r/L7QT923 > > Regards, > > > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Survey about LibreOffice
Hi John: I'm sorry ... I can't understand your problem with googleish because when I did the survey and when I filled it I haven't this kind of problem. I don't know why google is into the process's survey. About "Small Business", you are right ... it's better to know that, but I didn't think on that when I made the survey. It was my fault. I can't understand why the surveymonkey site changed the language. Thanks for your feedback. I try to do better the next time, Regards, -- Atentamente, Jorge Rodríguez El vie, 28-04-2017 a las 08:34 -0700, John R. Sowden escribió: > I tried: > 1) What is googleapis, a script that was attempted to be run? Sounds > rather googleish to me. > 2) In your categories of types of organizations, "Small Businesse" was > not included. (knowing who the users are will help in improving the > product to meet the need of the users). > 3) On the following screen, the language changed from American English > (Ubuntu's default in my case) to Spanish. Although I took a couple of > years of French in high school 50 years ago, it didn't help. > > John > > > On 04/28/2017 07:48 AM, jorge wrote: > > Hi all: > > > > I want to remember you the survey ... would you please answer it to > > this link if you haven't done ? > > > > https://es.surveymonkey.com/r/L7QT923 > > > > Regards, > > > > > -- 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: Survey about LibreOffice
Hi all: I want to remember you the survey ... would you please answer it to this link if you haven't done ? https://es.surveymonkey.com/r/L7QT923 Regards, -- Atentamente, Jorge Rodríguez El vie, 07-04-2017 a las 09:28 -0600, jorge escribió: > Hi all: > > I make a form to get a survey about the organizations that you or > others know that use LibreOffice. > > It is becouse I think it is important and interesting to know how many > organizations > use LibreOffice in the world not only how many download it! > > The link of the survey is this and you can share with more people > from others e-mail lists or sites: > > https://es.surveymonkey.com/r/L7QT923 > > The survey will end the next 7/05/2017 (included) > > Regards, > -- > Atentamente, > > Jorge Rodríguez > > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Survey about LibreOffice
Hi all: I make a form to get a survey about the organizations that you or others know that use LibreOffice. It is becouse I think it is important and interesting to know how many organizations use LibreOffice in the world not only how many download it! The link of the survey is this and you can share with more people from others e-mail lists or sites: https://es.surveymonkey.com/r/L7QT923 The survey will end the next 7/05/2017 (included) Regards, -- Atentamente, Jorge Rodríguez -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO won't open - claims Default.ott is corrupt
Hi John: Why not open the document in Abiword and select all document, then copy (to clipboard), and open new document on Libre Office and copy there all ? I hope this help, -- Atentamente, Jorge Rodríguez El vie, 31-03-2017 a las 00:27 -0700, John Jason Jordan escribió: > On Fri, 31 Mar 2017 00:11:10 -0700 > John Jason Jordan <joh...@gmx.com> dijo: > > >On Thu, 30 Mar 2017 23:05:44 -0700 > >John Jason Jordan <joh...@gmx.com> dijo: > > > >OK, I didn't go to bed yet and tried a couple more things. > > One more thing, and then I'm really going to bed. > > With Writer open (ignoring the missing Default.ott file warning on > opening it), I opened the .abw Abiword file and then went to save it as > a normal .odt file. This produced the error message: > > "Error saving the document : Write Error. > Error in writing sub-document content.xml. > > I hope by tomorrow morning this will all become clear and a solution > will be at hand. :) > -- 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] Linux User Groups
Hi all: Other program that you could install for same use is "Kazam" that you can find in the Ubuntu repositories. I've used it and always work well. Regards, -- Atentamente, Jorge Rodríguez El vie, 03-03-2017 a las 17:04 -0500, Tim---Kracked_P_P---webmaster escribió: > A few years ago I asked a question to one of those user groups, and I > received no answer. Do not remember the issue, so I must have worked > around the problem[s] myself. > > Hopefully, whichever group I looked into, will be more responsive to > "newbie" questions, or those that are from a "regular" user with no > experience with the issues/problems I had. > > Personally, I never heard of "RecordMyDesktop", by name, before. Though > I remember seeing a few weeks ago some other package name that does that > type of function. So, do you have to use that package or can you use > some other one? > > I run Ubuntu as my default desktop OS since version 9.04 or 9.10. That > desktop is currently running 14.04LTS, while my laptops [3 now] run > 16.04LTS. All 3 laptops dual boot to Win10 [currently] Since I rarely > turn on the desktop anymore, I use the newest laptop [17.3 inch display > with 1TB drive] as my default system. [desktop has a 22 inch monitor > with 6.25TB of internal drives] > > > > On 03/03/2017 04:19 PM, Bruce Hohl wrote: > > Lots of good stuff here: https://ubuntuforums.org/ > > > > On Fri, Mar 3, 2017 at 4:13 PM, MR ZenWiz <mrzen...@gmail.com> wrote: > > > >> I can't speak for Knoppix, but Ubuntu has a users' group and email > >> list at "Ubuntu user technical support, not for general discussions" > >> <ubuntu-us...@lists.ubuntu.com>. > >> > >> They do not like top-posts (like this one), so be aware. > >> > >> MR > >> > >> > >> On Fri, Mar 3, 2017 at 12:48 PM, charles meyer <reachmepl...@gmail.com> > >> wrote: > >>> Hi esteemed mates, > >>> > >>> Pardon my off-topic post, but has anyone found a good Linux forum to > >>> discuss Ubuntu and/or Knoppix issues? > >>> > >>> I'm trying to make RecordMyDesktop work on a Knoppix Live distribution > >> on a > >>> flash drive. > >>> > >>> I emailed Klaus Knopper (Knoppix creator) but I just got a robo > >>> response that he can't respond to emails. > >>> > >>> Thanks so much. > >>> > >>> Charles. > >>> > >>> -- > >>> 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 > >> > > -- 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] no spell checking taking place in Version: 5.1.4.2
Hi Dave: You can find it here: -Menu-Tools-Options-Languaje Settings-Writing assistance Regards, -- Atentamente, Jorge Rodríguez El sáb, 28-01-2017 a las 18:05 -0800, Dave Stevens escribió: > On Sat, 28 Jan 2017 20:47:50 -0500 > Remy Gauthier <remygauth...@yahoo.com> wrote: > > > Hi, > > > > When you go on the Font panel and look at the available languages, is > > there a mark indicating the dictionary has been installed for the > > language you are using (something like a green checkmark with ABC next > > to it)? > > I don't see a Font panel. I can pull down the Tools menu and then under > Language is For all text, which has choices: > > English Canada > English USA > None (Do not check spelling) > Reset to default Language > More... > > none checked and none responding to my clicks > > > d > > > > > > Rémy. > > Le samedi 28 janvier 2017 à 16:01 -0800, Dave Stevens a écrit : > > > Hi, > > > > > > I'm using Libre Office, mostly Writer, version: 5.1.4.2 with Linux > > > > Mint. I would like to have check as I go spell checking. In the > > > > past > > I > > > haven't done anything special to make this happen, it seems to have > > > been the default behaviour. > > > > > > I'm not sure what information would help diagnose this. I can use > > > shift-F7 in an attempt to turn on auto checking but no joy. Ideas? > > > > > > Dave > > > > > > -- > > > Reporter to Mahatma Ghandi after his tour of east London > > > "What do you think of western civilization, Mr. Ghandi?" > > > Ghandi - "I think it would be an excellent idea!" > > > > > > > > > > > > -- > Reporter to Mahatma Ghandi after his tour of east London > "What do you think of western civilization, Mr. Ghandi?" > Ghandi - "I think it would be an excellent idea!" > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Where to download Read-text extension.
Hi Eric: Here you can find External Project Page link: https://extensions.libreoffice.org/extensions/read-text if you click it (Right top of web site), you come here: https://sites.google.com/site/readtextextension/ There, where it says "GET IT", click it and you come to Apache OpenOffice web Site: http://extensions.services.openoffice.org/en/project/read-text There at right of the web site page you can find "Download Extension" link: http://extensions.services.openoffice.org/en/download/18413 where you can download it. The LibreOffice links are break...I don't know why...somebody knows ? I don't know too if this extension work in LibreOffice ! But it is only that I found, Regards, -- Atentamente, Jorge Rodríguez El jue, 12-01-2017 a las 19:28 -0500, Eric Beversluis escribió: > I keep ending up on this page: > > https://extensions.libreoffice.org/extensions/read-text/0.8.30 > > but I can't find any link to actually download the extension. At one > point I ended up on an open office page, but that extension didn't want > to work with LO. > > What am I missing? > > > -- > Eric Beversluis > www.ericbeversluis.com <http://www.ericbeversluis.com> > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Fwd: Problems with libre office
Hi José: This list not accept files attached because would be a lot of them ... insted of, upload your file to the cloud like Dropbox and the generate a link, send a new email with that link pasted to able the users of this list see the content on your file and to try to help you Regards, Jorge Rodríguez El lun, 05-12-2016 a las 18:06 -0200, José Carlos escribió: > -- Forwarded message -- > From: José Carlos <jcar...@sercomtel.com.br> > Date: 2016-12-05 18:01 GMT-02:00 > Subject: Problems with libre office > To: users@global.libreoffice.org > > > Good Morning, > > When I try to open any file indexed to the free office directly from the > network a window appears informing that the file does not exist. > > Attachment print of the screen. > > [image: Imagem inline 1] > Carlos > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base not starting
Hi: I suggest this: 1) Load the menu Office-Base. 2) Drag and Drop the Icon-Menu Base to the desktop 3) Right click on icon Base desktop, find properties and then click there 4) Look there the Order statement 5) Copy the statement order 6) Open a terminal (Console) 7) Paste the statement order Copied before (Right click on the terminal) 8) Type Enter 9) If Base not run ... look the message that appearer in terminal 10) Copy that message and paste in a e-mail to here and probably someone know to help you Regards, Jorge Rodríguez - Original Message - From: "Robert Großkopf" <rob...@familiegrosskopf.de> To: users@global.libreoffice.org Sent: Saturday, November 19, 2016 5:55:54 AM Subject: Re: [libreoffice-users] Base not starting -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Dave, > When I click on Base, nothing happens. Also, there is no File/Base > or File/Database. What gives? > > Dave, Ubuntu 16.10 mate LO 5.2.2 Where did you get LO from? Ubuntu repositories? Could be the standard-installation doesen't install the packages for Base. Another problem could be there isn't a JRE installed. Regards Robert - -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -BEGIN PGP SIGNATURE- Version: GnuPG v2 iQIcBAEBAgAGBQJYMD3KAAoJELDKYwaoS9AIRYAP/20EsxDa4mJBQojdpWcj8KJp VlIpoXMorF8KCiWhETgbpmOzSY8pgQcnWSUPHJfC/QwbT1qj4ogBp2+hfjspQGJk WKDK5K6Cc8ZwQL1eRU35gBWNbRQy3fRxl50+ya32r7ITc9qtvt+3mJRzEtLW+o66 7f7LxxpXDjuamm1IwfNsN+4WYhFQO1S+6LHFHH3WbcxusaF+4M/k6cfZnznhuvn7 mFGN/+4MV+jmfinLfIsBNJZshh/xR4UOxR67iVd2b4q7ZvI8+5pM4+n0bxAyYAa5 vpPeBDSA/Et4kzc2B7rEImtcVJNllEeY29YcfQKnM4Cx/zAd3RSQmq5pZr4x5ql/ vPS+1jC3Yrk4+4zz20yM78fzgzDeUGBzJ5b6fQxHG8go+b5/kF5wkxT4oSD3qjYL fN33fNhVxlsRkwPi+ZcIxUhY7xMR4kgK2UzUFktIXcKJKcadETIpfYD1zwqoaIHo WGDXNyXm5CdJ4lYHQTtgSydnti/A+kZ7P0onwfsGyAadz2l88AzyV4ReuH/a2vHN Pk9ZXJNHZ6ss6YdX2fMQxOQ/9qNAPDQ7HyPRTWLNqHYVb5hVnGuB9T0zGmm0y5BP 3RSOdM0p1GzRtk7cFWi3KC1BFxUFtGd8zpwcO4EwBNKSYXj1F0ZiqoO6AeRgFsu/ 8Fnn4A6IUqp9SBFE7iw9 =O2kI -END PGP SIGNATURE- -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Problem in opening an odt file
Hi Manoj: What kind of system you use in your job: GNU / Linux or ms ? It would be important to someone to find your problem. Regards, Jorge Rodríguez - Original Message - From: "Manoj Rathee" <mk.rathee...@gmail.com> To: users@global.libreoffice.org Sent: Tuesday, October 25, 2016 9:37:31 AM Subject: [libreoffice-users] Problem in opening an odt file R/sir I am using Ubuntu 12.0 version and libre office 3. I was doing work in office and suddenly power has gone and in pendrive I was doing my work so when I again started my computer and inserted pendrive then going to open the odt file, the file did not open and an error came that is general input opuput error. So please solve my problem and please can u repair my file it's very very urgent. I am from Judiciary department. Its request you to please make some solution for this. Please reply. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Windows 10 Anniversary Update found LibreOffice as malware
Hi: I suggest you to unable window defender (I don't think it is a bug). Then download LibreOffice, install it and then activate again wd. Regards, Jorge Rodriguez - Original Message - From: "dam4rus" <rfrostkal...@gmail.com> To: users@global.libreoffice.org Sent: Thursday, October 20, 2016 1:44:03 AM Subject: [libreoffice-users] Windows 10 Anniversary Update found LibreOffice as malware So, i have Windows 10 with Anniversary Update and today Windows Defender quarantined soffice.bin, because it thinks it's a Trojan. Is this a known issue? Should i report it as a bug? I haven't found anything about this with google search. -- View this message in context: http://nabble.documentfoundation.org/Windows-10-Anniversary-Update-found-LibreOffice-as-malware-tp4197678.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Cannot edit a template ott file
Hi Ken and all: It would be because the template is only for read, not for edit. In this case you have to save with other name and then edit. I hope this help, Regards, Jorge Rodríguez El mié, 05-10-2016 a las 11:40 -0400, Ken Heard escribió: > In my Debian Jessie box I wanted to edit an ott template file. After > however selecting the one I wanted to edit, clicking on the edit > button did not open it. This fault I encountered only after upgrading > on 2016-06-30 to LibreOffice 1:5.1.4-rc2-2~bpo8+1 from 1:5.1.2-3~bpo8+1 > . -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: How to fill in "Read filter criteria from"
Hi Bruce and all: Thank you because I didn't remember that way Regards, Jorge Rodríguez El lun, 26-09-2016 a las 15:41 -0400, Bruce Hohl escribió: > > Is there some other way to get a check range? > Yes, to 'AND' setup your Advanced filter range like this: > date | check no | check no | > | >=1000 | <=1100 | > > If you install the LO help there is good explanation and example of using > Advanced Filters. > > On Mon, Sep 26, 2016 at 8:53 AM, Larry Evans <cppljev...@suddenlink.net> > wrote: > > > On 09/25/2016 10:21 AM, Larry Evans wrote: > > > >> On 09/25/2016 09:39 AM, Larry Evans wrote: > >> > >>> > >>> On 09/24/2016 07:28 AM, jorge wrote: > >>> > >>>> I'm sorry, ... it looks worst > >>>> > >>>> Jorge Rodríguez > >>>> > >>>> > >>>> > >>>> > >>>> El sáb, 24-09-2016 a las 12:20 +, jorge escribió: > >>>> > >>>> Hi again: > >>>>> > >>>>> I hope in this way you can see better my last e-mail: > >>>>> > >>>>> At first you have to copy the headers of your table at you side of you > >>>>> > >>>> Ok. Did that. Those are shown in attached in E2:G2 > >>> > >> OOPS. I should have read: > >> > >> https://wiki.documentfoundation.org/Netiquette#Avoid_Attachments > >> > >> The .png file showing this, as well as the actual .odf file, > >> can be found at these links: > >> > >> https://www.dropbox.com/s/5uosutupnclnxrg/find_transaction. > >> advanced_filter.png?dl=0 > >> > >> > >> https://www.dropbox.com/s/da11qtifkes1q01/find_transactions.ods?dl=0 > >> > >> Hope this makes things clearer. > >> > >> [snip] > >> > > > > Googling for "libreoffice advanced filter" lead me to: > > > > https://help.libreoffice.org/Calc/Filter:_Applying_Advanced_Filters > > > > which was *much* more helpful than the help I got from pressing > > the help button on the "Advanced Filter" dialog, which, as mentioned > > in my OP, sent me here: > > > > https://help.libreoffice.org/index.php?title=5.1/Calc/Advanc > > ed_Filter=en-US=UNIX=5.1#bm_id3151113 > > > > OOPS. I see on that page, there's a link to "Applying Filters" > > and from there, a link to: > > > > https://help.libreoffice.org/5.1/Calc/Filter:_Applying_Advanced_Filters > > > > I should have persisted in reading the document :( > > > > Anyway, apparently there's no way to select a range of check numbers > > because the vertical conditions are OR'd together instead of AND'd > > together. I've tried using the AND(>=1000,<=1200); however, > > that results in 0 selected rows. Is there some other way to get > > a check range? > > > > I've uploaded a screen shot to: > > > > https://www.dropbox.com/s/piiuz5z1u7s14ch/find_transactions. > > advanced_filter.NoVerticalAnd.png?dl=0 > > > > -regards, > > Larry > > > > > > > > > > > > -- > > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns > > ubscribe/ > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > > List archive: http://listarchives.libreoffice.org/global/users/ > > All messages sent to this list will be publicly archived and cannot be > > deleted > > > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to fill in "Read filter criteria from"
I'm sorry, ... it looks worst Jorge Rodríguez El sáb, 24-09-2016 a las 12:20 +, jorge escribió: > Hi again: > > I hope in this way you can see better my last e-mail: > > At first you have to copy the headers of your table at you side of you > > > table for example or at the end if it isn't big. > > > > Then you have to add the filter that you need and put bellow of the > > header that you want to filter. > > > > Then run the wizard : Advanced Filter (Before select the table that you > > want to filter) and in options you can select where to put the datas > > filtereds. > > > > Example: > > > > > > Province > > Sells > > Costs > > Profits > > Alajuela > >10 > > 2 > > 8 > >Puntarenas > >20 > > 1 > >19 > > Limón > >20 > > 4 > >16 > > Heredia > >10 > > 7 > > 3 > > San José > >20 > > 5 > >15 > > Alajuela > >10 > > 8 > > 2 > > Heredia > >40 > > 9 > >31 > > Puntarenas > >50 > >12 > >38 > > Advanced Filter:(Read Filter Criteria From) > > Province > > Sells > > Costs > > Profits > > > > > > > > > 20 > > > > > > > > > > > > > > Results of Advance data Filtereds: > > Province > > Sells > > Costs > > Profits > > Heredia > >40 > > 9 > >31 > > Puntarenas > >50 > >12 > >38 > > In this case, we filtered the column Sells to show only Province that > > have sells higher than 20 > > > > > Regards, > > Jorge Rodríguez > > > > El sáb, 24-09-2016 a las 11:59 +, jorge escribió: > > > Hi Larry and all: > > > > At first you have to copy the headers of your table at you side of you > > table for example or at the end if it isn't big. > > > > Then you have to add the filter that you need and put bellow of the > > header that you want to filter. > > > > Then run the wizard : Advanced Filter (Before select the table that you > > want to filter) and in options you can select where to put the datas > > filtereds. > > > > Example: > > > > Table > > > > Province Sells Costs Profits > > Alajuela 10 2 8 > > Puntarenas 20 1 19 > > Limón 20 4 16 > > Heredia 10 7 3 > > San José 20 5 15 > > Alajuela 10 8 2 > > Heredia 40 9 31 > > Puntarenas 50 12 38 > > > > Advanced Filter:(Read Filter Criteria From) > > > > Province Sells Costs Profits > > > 20 > > > > Results of Advance data Filtereds: > > > > Province Sells Costs Profits > > Heredia 40 9 31 > > Puntarenas 50 12 38 > > > > In this case, we filtered the column Sells to show only Province that > > have sells higher than 20 > > > > I hope this help, > > > > Jorge Rodríguez > > > > > > > > El sáb, 24-09-2016 a las 16:49 -0500, Larry Evans escribió: > > > I selected Data>Filter>Advanced Filter; however, > > > I had no idea what to do next. I selected Help button, > > > which sent my browser to: > > > > > > > > > https://help.libreoffice.org/index.php?title=5.1/Calc/Advanced_Filter=en-US=UNIX=5.1#bm_id3151113 > > > > > > which was, again, no help. > > > > > > How do I fill out the "Advanced Filter" dialog? > > > > > > -regards, > > > Larry > > > > > > > > -- > Atentamente, > > Jorge Rodríguez > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to fill in "Read filter criteria from"
Hi again: I hope in this way you can see better my last e-mail: At first you have to copy the headers of your table at you side of you > table for example or at the end if it isn't big. > > Then you have to add the filter that you need and put bellow of the > header that you want to filter. > > Then run the wizard : Advanced Filter (Before select the table that you > want to filter) and in options you can select where to put the datas > filtereds. > > Example: > > > Province > Sells > Costs > Profits > Alajuela >10 > 2 > 8 >Puntarenas >20 > 1 >19 > Limón >20 > 4 >16 > Heredia >10 > 7 > 3 > San José >20 > 5 >15 > Alajuela >10 > 8 > 2 > Heredia >40 > 9 >31 > Puntarenas >50 >12 >38 > Advanced Filter:(Read Filter Criteria From) > Province > Sells > Costs > Profits > > > > > 20 > > > > > > > Results of Advance data Filtereds: > Province > Sells > Costs > Profits > Heredia >40 > 9 >31 > Puntarenas > 50 >12 >38 > In this case, we filtered the column Sells to show only Province that > have sells higher than 20 Regards, Jorge Rodríguez El sáb, 24-09-2016 a las 11:59 +, jorge escribió: > Hi Larry and all: > > At first you have to copy the headers of your table at you side of you > table for example or at the end if it isn't big. > > Then you have to add the filter that you need and put bellow of the > header that you want to filter. > > Then run the wizard : Advanced Filter (Before select the table that you > want to filter) and in options you can select where to put the datas > filtereds. > > Example: > > Table > > Province Sells Costs Profits > Alajuela 10 2 8 > Puntarenas 20 1 19 > Limón 20 4 16 > Heredia 10 7 3 > San José 20 5 15 > Alajuela 10 8 2 > Heredia 40 9 31 > Puntarenas 50 12 38 > > Advanced Filter:(Read Filter Criteria From) > > Province Sells Costs Profits > > 20 > > Results of Advance data Filtereds: > > Province Sells Costs Profits > Heredia 40 9 31 > Puntarenas 50 12 38 > > In this case, we filtered the column Sells to show only Province that > have sells higher than 20 > > I hope this help, > > Jorge Rodríguez > > > > El sáb, 24-09-2016 a las 16:49 -0500, Larry Evans escribió: > > I selected Data>Filter>Advanced Filter; however, > > I had no idea what to do next. I selected Help button, > > which sent my browser to: > > > > > > https://help.libreoffice.org/index.php?title=5.1/Calc/Advanced_Filter=en-US=UNIX=5.1#bm_id3151113 > > > > which was, again, no help. > > > > How do I fill out the "Advanced Filter" dialog? > > > > -regards, > > Larry > > > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to fill in "Read filter criteria from"
Hi Larry and all: At first you have to copy the headers of your table at you side of you table for example or at the end if it isn't big. Then you have to add the filter that you need and put bellow of the header that you want to filter. Then run the wizard : Advanced Filter (Before select the table that you want to filter) and in options you can select where to put the datas filtereds. Example: Table Province Sells Costs Profits Alajuela 10 2 8 Puntarenas 20 1 19 Limón 20 4 16 Heredia 10 7 3 San José 20 5 15 Alajuela 10 8 2 Heredia 40 9 31 Puntarenas 50 12 38 Advanced Filter:(Read Filter Criteria From) Province Sells Costs Profits > 20 Results of Advance data Filtereds: Province Sells Costs Profits Heredia 40 9 31 Puntarenas 50 12 38 In this case, we filtered the column Sells to show only Province that have sells higher than 20 I hope this help, Jorge Rodríguez El sáb, 24-09-2016 a las 16:49 -0500, Larry Evans escribió: > I selected Data>Filter>Advanced Filter; however, > I had no idea what to do next. I selected Help button, > which sent my browser to: > > > https://help.libreoffice.org/index.php?title=5.1/Calc/Advanced_Filter=en-US=UNIX=5.1#bm_id3151113 > > which was, again, no help. > > How do I fill out the "Advanced Filter" dialog? > > -regards, > Larry > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Save button
Hi Henry and all: I think that style «Automatic (Human)» is the most basic style (default for LO), and doesn't have much particular characteristic as have the other styles. Regards, Jorge Rodríguez El dom, 28-08-2016 a las 19:58 +0200, M Henri Day escribió: > 2016-08-28 4:42 GMT+02:00 jorge <jrodrigue...@cpcecr.com>: > Hi: > > As I understand, it depends of the Theme and Icon Style that > you have > installed in your LO: > > Menu-> Tools-> Options-> View-> User Interface-> Theme and > Icon Style > > For example: > > In my Ubuntu 16.04 LTS->LibreOffice 5.1.4.2-> Style Oxygen-> > Icon is a > Diskete with Asterisk white with Border green. > > In my Ubuntu 16.04 LTS->LibreOffice 5.1.4.2-> Style Galaxy-> > Icon is a > Diskete with a little Asterisk white with Border orange. > > In my Ubuntu 16.04 LTS->LibreOffice 5.1.4.2-> Style Human-> > Icon is a > Hard Disk with an arrow pointing down but when something is > changed in > the spreadsheet, it turns to Diskete with Asterisk white with > Border > green. Then, after save, it change again to Hard Disk. > > I hope this help, > > Regards, > > Jorge Rodríguez > > > El sáb, 27-08-2016 a las 15:00 -0400, Virgil Arrington > escribió: > > > > On 8/27/2016 1:50 PM, M Henri Day wrote: > > > Om my 64-bit Linux Mint 18 system with the Cinnamon > desktop, when > > > running LO Version: 5.2.1.1, I don't observe any changes > to the save > > > button after a document has been saved. But perhaps I'm > looking in > > > the wrong place ?... Henri > > > > I wonder how much of this is the result of the operating > system. On my > > Windows 10 system with LO 5.1.4.2, I get a white star on a > green circle > > green starburst on the save button, which is an icon of an > old floppy > > disk on my toolbar. So, I've seen three different results as > follows: > > > > Windows 10, LO 5.1.4.2 -- White star on green circle on the > floppy disk > > save icon > > Ubuntu 16.04 LTS, Unity Desktop, LO 5.1.5.2 -- A small red > dot on the > > floppy disk save icon (the Unity floppy disk icon is more of > a line > > drawing than a full color icon) > > Ubuntu 16.04 LTS, Gnome Desktop, LO 5.1.5.2 -- A yellow > starburst on the > > floppy disk save icon > > > > Regardless of my system setup, I'm getting a distinguishing > mark on a > > file once I've changed it from the version previously saved. > > > > Virgil > > Jorge, on the machine I described above, running the 5.2.1.1 version > of LO, with the icon style chosen to be «Automatic (Human)», the > «Save» icon in, e g, Writer, appears as a sheet of paper with a > downward arrow to the right and does not change its appearance no > matter whether the document open is modified or saved..., > > > Henri -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Trying to make a macro
Hi Felipe:
I interested in make a macro like this because I've had in past jobs to
work with files generated with other system in .txt format. They are a
lot and I had to open and got their data to paste on a spreadsheat for
working with them. Those files generated each month with the same
structure but different information. I could make a macro where I put
the generic name of each file for getting that information. I could
change the name of files generated each month with a program to allow
change names of file in group (To put the generic name that I input in
the macro).
This is why I want to know how make this macro,
Regards,
Jorge Rodríguez
El dom, 28-08-2016 a las 14:08 +0200, Felipe T. Dorado escribió:
> Hola jorge : )
>
> On Sat, 27 Aug 2016 05:47:09 +0000, jorge escribió:
>
> J> Good evening:
>
> ' Afternoon.
> I'm also interested in importing .txt files into a spreadsheet adequately.
>
> J> I try to make a macro in Calc to insert a sheet from a file in .txt
> J> format or .csv using the LO process: Record macro.
>
> Mm. A question: are you trying to make a macro because you plan to be
> importing a file regularly or is it just a one-time import?
>
> Or are you trying to import it as an exercise on how to make macros?
>
> J> I did it but the macro run and stop in the directory where the file is,
> J> but not record the select and not open the sheet although I did when I
> J> recorded the macro.
>
> I notice that you call your .csv file a "sheet" and I think it is not
> a sheet, yet, but a text file.
>
> J> The code that the process wrotten is this, would you please guide me to
> J> finish:
>
> I'm afraid I am not that familiar yet with macros, but it seems to me that
> at some point the macro will ask you to select which file to import, right?
> That is, a dilague window will appear to let you choose the kind of import
> (separators, ...) ...Wait, I cannot find an "Import" option in
> menus. : ! ?
>
> Let's see:
>
> J> REM * BASIC *
> J>
> J> sub Main
> J> rem
> J> --
> J> rem define variables
> J> dim document as object
> J> dim dispatcher as object
> J> rem
> J> --
> J> rem get access to the document
> J> document = ThisComponent.CurrentController.Frame
> J> dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
> J>
> J> rem
> J> --
> J> rem dispatcher.executeDispatch(document, ".uno:InsertSheetFromFile", "",
> J> 0, Array())
> J>
> J> end sub
>
> There, at the end you have a ".uno:InsertSheetFromFile"
>
> ¿How did you manage to "import" a file into your worksheet? I've only
> managed it _opening_ a new file which is a .cvs file. And then the import
> dialogue appears, I choose the options and the .csv file is correctly
> imported into a worksheet.
>
> As I say I'm not familiar with macros and don't know how that is done. But
> It seems to me that perhaps you have to open a file instead of trying to
> import it : ?
>
> I hope someone who already does what you want illustrates us on what is to
> be done and how.
>
> J> I use LibreOffice version 4.2.8.2 on Ubuntu 14.04 LTS
>
> I'm using LO Versión: 4.3.3.2 on Debian GNU/Linux 8.5.
>
> Felipe : )
>
--
Atentamente,
Jorge Rodríguez
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Save button
Hi: As I understand, it depends of the Theme and Icon Style that you have installed in your LO: Menu-> Tools-> Options-> View-> User Interface-> Theme and Icon Style For example: In my Ubuntu 16.04 LTS->LibreOffice 5.1.4.2-> Style Oxygen-> Icon is a Diskete with Asterisk white with Border green. In my Ubuntu 16.04 LTS->LibreOffice 5.1.4.2-> Style Galaxy-> Icon is a Diskete with a little Asterisk white with Border orange. In my Ubuntu 16.04 LTS->LibreOffice 5.1.4.2-> Style Human-> Icon is a Hard Disk with an arrow pointing down but when something is changed in the spreadsheet, it turns to Diskete with Asterisk white with Border green. Then, after save, it change again to Hard Disk. I hope this help, Regards, Jorge Rodríguez El sáb, 27-08-2016 a las 15:00 -0400, Virgil Arrington escribió: > > On 8/27/2016 1:50 PM, M Henri Day wrote: > > Om my 64-bit Linux Mint 18 system with the Cinnamon desktop, when > > running LO Version: 5.2.1.1, I don't observe any changes to the save > > button after a document has been saved. But perhaps I'm looking in > > the wrong place ?... Henri > > I wonder how much of this is the result of the operating system. On my > Windows 10 system with LO 5.1.4.2, I get a white star on a green circle > green starburst on the save button, which is an icon of an old floppy > disk on my toolbar. So, I've seen three different results as follows: > > Windows 10, LO 5.1.4.2 -- White star on green circle on the floppy disk > save icon > Ubuntu 16.04 LTS, Unity Desktop, LO 5.1.5.2 -- A small red dot on the > floppy disk save icon (the Unity floppy disk icon is more of a line > drawing than a full color icon) > Ubuntu 16.04 LTS, Gnome Desktop, LO 5.1.5.2 -- A yellow starburst on the > floppy disk save icon > > Regardless of my system setup, I'm getting a distinguishing mark on a > file once I've changed it from the version previously saved. > > Virgil > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Trying to make a macro
Good evening:
I try to make a macro in Calc to insert a sheet from a file in .txt
format or .csv using the LO process: Record macro.
I did it but the macro run and stop in the directory where the file is,
but not record the select and not open the sheet although I did when I
recorded the macro.
The code that the process wrotten is this, would you please guide me to
finish:
REM * BASIC *
sub Main
rem
--
rem define variables
dim document as object
dim dispatcher as object
rem
--
rem get access to the document
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
rem
--
rem dispatcher.executeDispatch(document, ".uno:InsertSheetFromFile", "",
0, Array())
end sub
I use LibreOffice version 4.2.8.2 on Ubuntu 14.04 LTS
Thanks and Regards,
--
Atentamente,
Jorge Rodríguez
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LibreOffice on a Chromebook?
Hi all: I got this link and suggestion from other e-mail of this users list. It would be a good solution: "There is another option: get a free account at https://open365.io/ and use LibreOffice 5.1.0.3 within your browser." Regards, Jorge Rodríguez El jue, 25-08-2016 a las 20:31 +0200, Cley Faye escribió: > 2016-08-25 20:07 GMT+02:00 Kevin O'Brien <zwiln...@gmail.com>: > > > I have been thinking about getting a Chromebook, but the one thing > > holding me back is that I need to be able to run LibreOffice. Is that > > something I can do now? And if so, how well does it run? > > > > Unfortunately, I can't speak exactly about how LibreOffice behave on a > chromebook, but it is possible to have LibreOffice run on it through > various mean. In my opinion, a good way to do so is by using "crouton", > which allow running a full Linux on top of ChromeOS (at the same time, not > in a dual-boot setting). Obviously this can be leveraged to run LibreOffice. > > One thing to keep in mind is that some chromebook have very limited disk > space available, so you may want to change that. > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] XML document
Hi Tom: The e-mail users@global.libreoffice.org not accept attachment. To share your document with us you can upload it to other sites like Dropbox, and then send an email to this list with the link of the document on that site and we can download to analize. Regards, Jorge El mié, 17-08-2016 a las 13:52 +0100, Tom Morton escribió: > Hello, > > I was writing my dissertation yesterday using Libre Office Writer. I > accidentally saved it as 2003 XML document. > > I had written 3000+ words and now I can not get the words back. > > However, when I open the document in Libre Office Writer, It comes up > saying that there is 3000+ words in the word count and 6 pages in the > properties but I can only see headers, some footnotes and two small > paragraphs. My hand in is on monday and I'm having a nightmare right now. > > > > you can see in this image that there is 3362 words however only showing two > pages of around 300-400 words. > > This second picture shows the 6 pages that it says it has. > > > > if i open the document in anything other than Libre Office Writer, it only > appears in formula or code. > > I am going to attach the document now. > > Thanks for your help in advance. > > Tom > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: LibreOffice Writer Individual Page Background Colour
Hi: You can set the background color with: Menu->Format>Page>Background>Color>Select the color you wish>enter I hope this help you, Regards, Jorge Rodríguez El lun, 15-08-2016 a las 20:23 -0700, jrw escribió: > Insert Rectangle > Click on Rectangle > Position and Size > Anchor: To page; > Size: Width: max; Height: max; Position > Horizontal: Left; Vertical: Top. > > Right mouse click on rectangle > Arrange > To Background. > > Right mouse click > Area > Fill: you choose. > > This needs to be on the pages you want using Copy/Paste and altering colour > as needed. > > > > -- > View this message in context: > http://nabble.documentfoundation.org/LibreOffice-Writer-Individual-Page-Background-Colour-tp4190690p4190938.html > Sent from the Users mailing list archive at Nabble.com. > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] FYI: Writer watermarks template
Thank you Dave, It is a good job. Regards, Jorge Rodríguez El lun, 15-08-2016 a las 11:44 +1200, Dave Koelmeyer escribió: > Hi, > > For those wanting an instant solution for LibreOffice Writer watermarks, > I've created a template which can be freely downloaded and used from here: > > * http://www.apertura.co.nz/libreofficewatermarks > > > The watermarks are SVG-format (small file size, 100 percent quality). > I'll be updating this with additional watermark page styles now and then. > > Hope this helps. > > Cheers, > Dave > > -- > Dave Koelmeyer > http://blog.davekoelmeyer.co.nz > GPG Key ID: 0x238BFF87 > > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Compatibility of LO Base with Access databases
Hi all: For collections, there are two programs on GNU / Linux Ubuntu and usually on others Distributions: 1) GCStar 2) Tellico Both have multiple options to import and export information. By the way, my little knowledge can't permit to me to share with you what kind of data base use them or if when have a lot data, they will come slowly, but this are my 1 cent to this topic. Regards, Jorge Rodríguez El mar, 02-08-2016 a las 10:39 -0600, Ken Springer escribió: > On 8/1/16 12:13 PM, Girvin Herr wrote: > > On 07/31/2016 07:36 PM, Ken Springer wrote: > > > >> I understand the concept of Front End/Back End, but never have dealt > >> with it. Nor have I ever used MySQL, Mariadb, or others. Access and > >> a bit of dBase is all I've ever used, and in general, even then that's > >> more power than I've ever needed. > >> > > Ken, > > Actually, IIRC, Access has both a client and server built in. The user > > isn't normally aware of it. In my experience with Access 1.1, the > > server is called the "Jet" server. Today's Access may no longer use the > > Jet server, but I am sure something like it is still in there > > somewhere. I must admit the Access bundled concept is addictive. As a > > newbie to databases back in the 90s, I liked it and it was a shock and a > > learning experience to wean myself off of it and go with the industry > > standard forms of client/server architecture and the SQL language. > > You've just mentioned the big "roadblock" for the average person to make > use of databases. They are too complex to learn and use for most > people. That's where the "all-in-one" solution is a better answer. > It's a lot easier for the average user to wrap their heads around and > then use it. > > What happens? The average person fills up spreadsheet after spreadsheet > of flat file data. My brother-in-law is a perfect example. Years ago, > he was putting their music collection into a spreadsheet. When the > sheet got to large for RAM and his computer crashed, he started > splitting into multiple spreadsheets. But that made their goal of > printing their entire collections of songs, alphabetized, impossible. I > took the spreadsheets and combined them into Access 97, created an input > form and reports, and everyone was happy. > > Even getting people to use a flat file database like Database Oasis > would be better than a spreadsheet. > > > Since then I have learned a lot and find the latter concept very > > powerful. In your case, if Access and dBase had/have more power than > > you ever needed and that power is all that you will ever need, then the > > LO internal HSQLDB engine is probably a good choice for your application. > > It may be, if this was a single user issue. But we need to be > compatible with MS Office without having enough Windows systems, where > as I can lay my hands on 3 other Linux systems that are being unused. > > > Now that you mentioned dBase, you may, or may not, be aware that LO has > > a dBase option. But a limitation to it that I found is that older > > versions of dBase files are not supported. I have some old dBase 1.x > > files with dbase programs that will not load into LO, let alone run. > > I didn't know this, but must admit dBase is probably not the best answer. > > > Girvin > > > > > > > > > -- > Ken > Mac OS X 10.8.5 > Firefox 44.0 > Thunderbird 38.0.1 > "My brain is like lightning, a quick flash > and it's gone!" > > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Compatibility of LO Base with Access databases
Hi: On GNU / Linux / Ubuntu, and of course in other distributions, there are to program that you would probe because could help you to export Access DB to open document: 1) MDBtools (View and export MSAccess db) 2) Kexi of Caligra Suite that say it is able to read MS Access db I hope this help, Regards, Jorge Rodríguez El sáb, 30-07-2016 a las 16:40 +0200, Harvey Nimmo escribió: > On Fri, 2016-07-29 at 20:53 -0600, Ken Springer wrote: > > The subject says it all, how successful is Base in importing Access > > Databases? > > > > LO 5.0.x > > > > -- > > Ken > > Mac OS X 10.8.5 > > Firefox 44.0 > > Thunderbird 38.0.1 > > "My brain is like lightning, a quick flash > > and it's gone!" > > > > > Unfortunately, MS Access users were spoilt with the 'complete' database > package supporting tables, queries, forms, reports and modules/macros. > Although its 'openness' or performance or compatibility with the rest > of the MS Office suite leave much to be desired (in my humble opinion) > the MSaccess package is a (more or less) complete solution. LibreOffice > on the other hand cannot match the user comfort (yet!). > > There is a tool, access2sql that to allows you to generate the sql > needed to build all your 'tables' again (including their data) and > 'queries'. But for the 'forms' and 'reports' you will have to start > from scratch in LOBase and, as I say, the user comfort for that is not > as mature as in MSAccess. In LOBase you can also write modules/macros > in Visual Basic. I have no experience of that either, but it does > suggest that VBA macros might with reservation be portable and > modifiable. > > In other words, i blieve it is not hopelessly impossible and > I am sure that the experts can add their 'two penn'orth' > > Cheers > Harvey > > > > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: about libreoffice 5.2
And if you have enought space in your hard disk, you can install Xubuntu or Linux Mint on the same hard disk, with dual boot and keep your xp system if you already need it. Regards, Jorge Rodríguez El jue, 30-06-2016 a las 18:39 +, Paolo Debortoli escribió: > > On Thursday, June 30, 2016 6:59 PM, nasrin khaksar <nasrinkhaks...@gmail.com> > wrote: > > and also linux is suitable for programmers or at least for proffessional > users. > > your opinion, but I wouldn't say that, after my 10 years experience... I > am using it every day for everything > Changing may, however, give specific issues, that's also true... > > Paolo > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] change user interface
Hi Jinesh: We understand that you are accustomed to use office from microsoft. It is normal to have to use a new program some days to get use to it. It is like to use a new car or a new house. Enjoy LibreOffice as is because it offers you almost feature that you can find in office. Please don't ask to van Gogh to paint like Miró because they are diferents, only enjoy theirs pictures. Regards, Jorge Rodríguez El mié, 29-06-2016 a las 19:02 +0530, jinesh escribió: > Hello, > > > > I'm using Libreoffice 5.1 its the best alternative for Microsoft office. > > > > I have a doubt please help me, > > > > How can i change the user interface in Libreoffice 5.1 current user > interface look like old office 2003.I need to change the look like office > 2007 or higher. > > > > > > > > Regards, > > > > Jinesh > > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Embedded Base on Windows Share?
Hi Christopher: I'm not an expertise on this kind of problem but at first, usually, is necesary that you share this: 1) LibreOffice version on GNU / Linux 2) LibreOffice version on windows 3) Your GNU / Linux S.O. 4) Your windows S.O. Regards, Jorge Rodríguez El mar, 07-06-2016 a las 10:11 -0800, Christopher Howard escribió: > Hi, I want to create a small embedded Base db for 3 or 4 users. It is a > mix of Gnu/Linux and Windows desktops. I can create a Base db just fine > on my person Debian laptop, but if I try to create it on our Windows > share, or copy it there and then use it, I get an error that Base cannot > communicate with the database. I can read/write to the share fine with a > file manager or text editor... so I am thinking this has something to do > with the nuances of NTFS, or file locks, or something like that. Does > anyone have any insight on that, and related work arounds? > > -- > Christopher Howard, Computer Assistant > Alaska Satellite Internet > 3239 La Ree Way, Fairbanks, AK 99709 > 907-451-0088 or 888-396-5623 (toll free) > fax: 888-260-3584 > mailto:christop...@alaskasi.com > http://www.alaskasatelliteinternet.com > > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base-Conect an external spreadsheet data
Hi all: Using Google I found some web sites where I could learn my first lessons about SQL. With this I could solve my problem to Group my data in BASE. But then, I found that the file Spreadsheet that I've using was locked (user permissions). Well I made a copy of the file with my permissions and then make the db with Base conection and I could group with Wizard of BASE. Thank so much to all that thought to help me but not had time. P.D.: Web site I used: https://www.1keydata.com/es/sql/ Regards, Jorge Rodríguez El dom, 08-05-2016 a las 21:54 -0600, jorge escribió: > Good night, hi all: > > I have two options when I conect to a external spreadsheet data with > BASE: > > 1) Conect with the third option when start the wizard selecting: > spreadsheet. > > In this case we can import the structure and data from it. > > The first options is keep the conections with the original spreadsheet, > in other words, we can't modifie the structure import and use functions > when make a Consult for example (At least with my little knowledge). > > Depend what you are going to do with data, is enough as is. > > 2) The second option is when we conect to external data because we need > to work we them with all options that usually offer BASE when we create > a new data base. In this situations we need import data but then split > conection with original data and make an independent data base. > > At least I can't do this with BASE. > > Would you please answer this: > > a) With SQL options we can use the function "group" or other funtions > when make a Consult to solve my problem ? or with a Macro ? > > b) If not (Point a)), where I can expose this situation that would be > improbe BASE in the future ? > > -- > Atentamente, > > Jorge Rodríguez > > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Base-Conect an external spreadsheet data
Good night, hi all: I have two options when I conect to a external spreadsheet data with BASE: 1) Conect with the third option when start the wizard selecting: spreadsheet. In this case we can import the structure and data from it. The first options is keep the conections with the original spreadsheet, in other words, we can't modifie the structure import and use functions when make a Consult for example (At least with my little knowledge). Depend what you are going to do with data, is enough as is. 2) The second option is when we conect to external data because we need to work we them with all options that usually offer BASE when we create a new data base. In this situations we need import data but then split conection with original data and make an independent data base. At least I can't do this with BASE. Would you please answer this: a) With SQL options we can use the function "group" or other funtions when make a Consult to solve my problem ? or with a Macro ? b) If not (Point a)), where I can expose this situation that would be improbe BASE in the future ? -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Libre Office for Androids
Hi Charles and all: Until I know, LO for Android is in progress but at this moment as a viewer only and Alpha or begining Beta version (not stable) for LO as we use in GNU / Linux and windows. There is an other version that could help you and your friend: This is Aoo (Android OpenOffice). It is a version of OpenOffice for Android. I've used it and it works good (In general as I probed: Writer, and Calc). It is the nearest of LO at this moment that I know. As I read, Aoo is based on OpenOffice but is not part of Apache Fundation. I suggest to your friend that use keyboard and mouse with your tablet too. Regards, Jorge Rodríguez El jue, 05-05-2016 a las 20:52 -0400, charles meyer escribió: > Hi All, > > I Googled for Libre Office for Androids to help a friend use LO on her > Android tablet. > > I found this... > > https://www.libreoffice.org/download/android-viewer/ > > Anyone on the list using LO for Androids? > > Does it come bundled with Libre Writer and Calc? > > Thank you, > > Charles. > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Impress Congratulations
Hi all: In my actuals labors I haven't used frecuently Impress to make a presentation, ... but I run Impress 5.1.2.2 on Ubuntu Beta 16.04 to know how is at this momment and find that the people (Specially programmers) has made (Has or have made ?) a great and finest job to improve it. I really grateful with them, thank you so much ! -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Double Underline in Calc
Hi Jim and all: I use Versión: 4.2.8.2 Id. de compilación: 420m0(Build:2) on Ubuntu 14.04.4 LTS, and I get a good double underline following the same process. Regards, Jorge Rodríguez El lun, 28-03-2016 a las 19:24 -0500, Jim Byrnes escribió: > Using LO vers 4.2.8.2 on Ubuntu 14.04 > > If I go Format Cells--> Line Styles --> double underline all I see in > the cells I am trying to format is a thick dark line. > > Is there a way to fix this? > > Regards, Jim > > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO spreadsheet format row
Hi Helen: I think that you can do this: If you can lock Row A a)Select, the rest of the sheet A2 to AMJ1048576, then go to b)Menu-Format-Cell-Protect Cell-uncheck protect box, then go to c)Menu-Tools-Protect Document-Document d)There, asign a password if you want, and keep check both boxes there. Now you can work in whatever cell except in all cells of row A. You can do this in whatever cell or cells that you want to lock. I hope this help, Regards, Jorge Rodríguez El lun, 28-03-2016 a las 11:32 -0400, Helen escribió: > Is there a way, in L.O. spreadsheet, to lock the rows so that a row cannot > take > more than one line? So that all rows have the same height. Freeze doens't > seem to do that. > Thank you, > > -- > Helen Etters > using Linux, suse12.3 > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Calc as a Flat File Database
Hi Alexander and all: Thank you for your clear explanation. If I understood you well, this happen when we predefined the table in Base that we think that we will need. But when I have needed do it, I didn't make the table, I only use connect option (when start BASE), with a .db (spreadsheet -.ods-) that I have in my file directory. I think that in this way BASE create the table with the characteristic of the origin (.ods file). Regards, Jorge Rodríguez El jue, 17-03-2016 a las 16:35 +0100, Alexander Thurgood escribió: > Le 17/03/2016 16:08, jorge a écrit : > > > Hi Jorge, > > > I suggest to you to open the .CSV file with CALC. Then save it as .ODS. > > Finally, import from BASE the .ODS file. > > > > The import wizard from Calc to Base is not perfect, so unless one is > absolutely sure that the data in your CSV or Calc file exactly matches > the definition of the fields in the table, then one should expect either > import errors or failure. Particular things to watch out for : > > - date / time / datetime representations > - text values over integers > - null fields > - values intended to be used in an autoincrement field > - boolean values > - memo fields > - unsigned INT field values > - zero-fill values > > etc, etc > > > Alex > > > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Calc as a Flat File Database
Hi Ian and all: Excuse me if I understood bad your problem. I understood that you need import a .CSV file to BASE with BASE. And You can't do it. I suggest to you to open the .CSV file with CALC. Then save it as .ODS. Finally, import from BASE the .ODS file. I hope this help. Regards, Jorge Rodríguez El mié, 16-03-2016 a las 22:19 +0200, Ian "Witty" Whitfield escribió: > Thanks all - appreciated!! > > My background is 30 years in the Computer Business - Training, > installations, support etc etc. > Since retiring I left Windows behind and changed to Linux. > What I'm not is a Programmer - except with BASIC about 20 years ago!!! > > My needs are to have a SOLID, RELIABLE simple Members Database that does > not crash all the time and take the data with it as well. > I don't even need a RDB as I have one table, one Form and a few queries, > it is single user on a single machine. My Form only uses Text Boxes, > Drop-Down Boxes, Check Boxes and Photos and Graphics. End of story!! i > don't want to become a DB expert just a basic layout person and every > day user. > > I did not think this would be a big problem in Linux - how wrong I was. > I have battled with Base for several years and after my last crash in > January, (Data lost, as is common, even with MySQL. The file is still > there but it can not be accessed). > > I thank Jarasow for his help with Kexi but after 10 crashes in 2 weeks > and some missing features and no help to try and get Drop-boxes to work > I had to give up on it. It does look very promising but has a way to go > yet I fear. > > So Alexander has told me how to save my Form (that helps a lot) and I > decided to get back into Base as it seems to be the only way to go for > me. But MySQL is giving me up-hill. It does not seem to want to save an > empty Table for me to import my CSV into and gives me this error ... > > "#1064 - You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use > near 'varchar(10), `NULL` varchar(10), `NULL` varchar(10), `NULL` > varchar(21), `NULL` ' at line 1" > > I seem to remember this from when I first set it up last year. It's not > MY SQL - this is what the program did!! Also my first line of the CSV is > the column names only and it works OK with Calc and did so as well with > Kexi!! So where is the problem??!! > So I'm unable to populate the DB in MySQL for Base to link to it!! > > Thanks all. > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Survey - What do you expect from Libreoffice Draw in the future?
Ok thank you, I am going to see it. Regards, Jorge Rodríguez El dom, 28-02-2016 a las 07:41 -0700, V Stuart Foote escribió: > jorge-2 wrote > > Thank you very much to share the results ... and what about of the last > > question (It is interesting to know too) ? > > Of course, it is all interesting... will be finished when it is finished, > but for the impatient the raw survey results are here as CSV (with a ";" > separator). > > https://drive.google.com/open?id=0ByWdNpQKVjM8bF91TGJCUXlFUk0 > > You are most welcome to review and form your own conclusions. > > Stuart > > > > -- > View this message in context: > http://nabble.documentfoundation.org/Survey-What-do-you-expect-from-Libreoffice-Draw-in-the-future-tp4175347p4176854.html > Sent from the Users mailing list archive at Nabble.com. > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Survey - What do you expect from Libreoffice Draw in the future?
Hi V Stuart Foote and all: Thank you very much to share the results ... and what about of the last question (It is interesting to know too) ? Regards, Jorge Rodríguez El vie, 26-02-2016 a las 13:52 -0700, V Stuart Foote escribió: > Preliminary survey results are available on TDF Wiki here: > > https://wiki.documentfoundation.org/Design/Whiteboards/DrawFuture > > Thank you to all who participated, some very useful perspectives we are > still sorting through. > > Stuart & Heiko > > > > > -- > View this message in context: > http://nabble.documentfoundation.org/Survey-What-do-you-expect-from-Libreoffice-Draw-in-the-future-tp4175347p4176715.html > Sent from the Users mailing list archive at Nabble.com. > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] a question about libreoffice and txt files:
Hi all: I don't know if this solve the problem but could be: Menu-Tools-Options-Languages Settings-Language-Language pre-settings for documents-Complex text Language (CTL). There you can find Persa languaje. I hope this help Regards, Jorge Rodríguez El sáb, 09-01-2016 a las 13:19 +0100, Cley Faye escribió: > It is not a permanent solution, but you can open txt files through the > File->Open menu of LibreOffice itself. > In the Open dialog, manually select the file type "Text - Choose encoding". > It will let you choose the file encoding. > > ...if anyone know how to permanently set LibreOffice to open .txt as UTF-8, > I'm all ears ;) > > -- > Cley Faye > http://cleyfaye.net > > 2016-01-09 12:52 GMT+01:00 nasrin khaksar <nasrinkhaks...@gmail.com>: > > > hi every one. > > i tried both libreoffice and open office. > > fortunately libreoffice recognizes the incoding of the txt files and > > open them without asking about which incoding should is use, and also > > about phont and language. > > its a very great feature that even microsoft office has not and its > > realy unique for libreoffice! > > but in some cases when i want to open a persian txt file with > > libreoffice, unfortunately libreoffice does not recognize the incoding > > and does not open my txt in utf-8 incoding!!! > > as the result, libreoffice desplays this kind of files like chinese or > > japanese characters and its becomes completely unreadible! > > the persian txt files characters are not display correctly in persian > > and becomes unreadible! > > > > in these cases, is it possible to make change in libreoffice settings > > to libreoffice recognizes unicode and utf-8 correctly or at least > > libreoffice asks to which incoding should it use? > > as i mentioned, only the cases that libreoffice does not recognize the > > incoding correctly, i want libreoffice to asks like open office. > > but if it becomes possible to show unicode and persian files always > > correctly, its a very great and unique feature that recognizes without > > asking any questions! > > thanks for your help and god bless you all. > > > > -- > > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > > Problems? > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > > List archive: http://listarchives.libreoffice.org/global/users/ > > All messages sent to this list will be publicly archived and cannot be > > deleted > > > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
