Re: [libreoffice-users] User Profile Question
I use Ubuntu Linux 12.04LTS as my default OS, but I also use Win7 on dual-booting laptops. I never had Linux run hotter than Windows when it is installed onto the drive. I also do not use the thin laptops, but the thicker ones that have more fan space and size to remove the heat better. Tell me, what do you use to see the CPU temps in Linux? What do you use for Windows? I use Speedfan for Windows and have not found much to really see actually temps in Linux, but by feeling the heat from the surface of the laptops, it never gets as hot as Windows. Both laptops are dual core and the main desktop is a quad with the others dual and single cores. As for the User Profile issue, I would get it setup as you want it to be and then make a backup of it. That way you do not have to start from scratch. I do not customize as much as you do, just add a dictionary [or two] and add a larger color choice option for backgrounds, borders, text, etc.. I really think that getting your setup into a backup and using it when you crash due to a corrupted file would be most helpful. As for the compatibility of the Windows profile/config to Linux, well I do not know much about what each file does either. For Win7 to Win7 systems, I think it taking a specific set of file in the user profile and copying it over to a new system would work. Which are the needed files, I do not know. Maybe using the whole User folder would work transfered over to the new systems. Question: What type of [and how many] screen colors and keyboard assignments/modifications do you set up for your system? What are you using them for? We always like to know what LO is being used for and what our users are doing with it to make their workflow flow better. I know of a SciFi-Fantacy writer who switched to Linux and now LO to write his 1 to 3 book a year [being now in his 70's it is down from 4+ paper-back books a year]. He uses many macros and keyboard assignments [and a non standard keyboard] for many years. So, knowing what you change your profile to/with might help our developers make it easier for our users to do their work. On 03/02/2014 07:57 AM, Virgil Arrington wrote: Thanks, Scot. That seems to be what I was looking for. Just a quick glance showed me a lot of settings that I have customized. I'll dig further to see if all of them are in there. You mention that you're on Linux. Are you running on a laptop? I've tried several different Linux distros on my Sony Vaio laptop, in many different forms (live CD/USB Flash, Wubi, true dual boot), etc. and every one of them seems to make my CPU run really hot, much hotter than my Windows setup. Have you (or any others) experienced similar problems? Various Linux forums online seem to indicate this is not uncommon. I've been *really* trying to give Linux a fair try, but it keeps hitting me with roadblocks. I know many of you are Linux enthusiasts, but I can't get past the heat and sound of a frantically whirring fan. Virgil -Original Message- From: Scott Castaline Sent: Saturday, March 01, 2014 9:59 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] User Profile Question I run on Linux so I'm not sure if you have it on Win7. There's a file called registrymodifications.xcu under libreoffice/4/user. It's in some Markup format somewhat similar to html or xml. It can be kind of cryptic but I have edited that file directly with some success. I don't know if that contains everything within user options or not, but I have saved it in the past before trying something that would cause the app to barf and then restored that file and everything was fine again. Scott C. On 03/01/2014 04:40 PM, Carol-Virgil Arrington wrote: I’ve got a question about the User Profile. I’m using LO 4.1.5 on Windows 7. I understand that my user profile consists of a bunch of folders and files in my AppData\Roaming\LibreOffice\4\User folder. But, beyond that, I can’t make sense of any of it (other than my Templates). For example, I’ve made several customizations to my copy of LO, such as: 1. Screen colors 2. Keyboard assignments. I have many of my favorite paragraph styles assigned to Ctrl-key combinations, etc. Where are these types of information kept? With other programs, I could find it in a file called *something*.ini, but in LO’s user profile, I can’t find anything that resembles any type of configuration file, and I’ve stepped my way through each and every file in each and every folder in the User file tree. My computer recently crashed resulting in a corrupt User Profile. I was able to rename it and start over, but it would have been nice to be able to pinpoint the one or two corrupt files and correct them without necessarily starting from scratch. Also, I use LO on many different computers, and I’d like to just copy the pertinent configuration files from one computer to another without necessarily
Re: [libreoffice-users] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
On 2/28/2014 9:37 AM, Tom Davies tomc...@gmail.com wrote: Hi:) I just tried out the various options (Ctrl, Alt, Shift combos) in Excel 2010 and there really doesn't seem to be a way of dragging a column into a new position. It seems you have to cut or copy first. Glad you were wrong - being able to drag-n-drop is so much easier, and now I can do it in both Libre and Excel... :) -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Chart legends
Heinrich Stoellinger wrote: Hello, I inserted a chart from a Calc table in LO 4.2.1, running Linux-Mint-16. Now I find that I cannot change the text displayed within the legend. It simply displays Row 1, Row 2, Row 3...). As far as I can see, one can only change the position of the legend. How do I define an arbitrary legend. 1. Double-click the chart to start editing it, if not already in that mode. 2. From the menu: Format Data Ranges... 3. Open the Data Series tab. 4. In the Data Series (left-hand) list, click the series for which you want to set the name. 5. In the Data ranges (right-hand) list, click Name 6. In the Range for Name (below that list), type the name you want to appear for the selected series, enclosed in double-quotes. 7. Repeat steps 4-6 for each series. 8. Click OK. Is there maybe a way to somehow connect the various data rows of a chart with (e.g.) a row/column in the Calc table on which the chart is based? Yes. At step 6 above instead of typing the literal text (in quotes), enter a cell reference (without quotes). This needs to include the sheet name as well, e.g.: $Sheet1.$A$3 You can also click the icon to the right of the Range for Name box (it looks like a window with an up-pointing arrow), then click the cell in the spreadsheet, and Calc will automatically fill in the reference for you. From the same dialog, you can also change the cells used for the series data (by selecting y-Values from the Data ranges list) and add new series to an existing chart. Useful if you add more data to the sheet beyond the range the chart was set up to use. Regards H. Stoellinger I hope that helps. Mark. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Chart legends
Thanks, Mark, I did actually manage to find out how to do this in the meantime... In my opinion the procedure is not really self-evident. I tried doing it starting with Legend, but there one cannot change the text... Thanks again... Regards Heinrich On Sun, 02 Mar 2014 17:26:25 +0100, Mark Bourne libreoffice-ml.mbou...@spamgourmet.com wrote: Heinrich Stoellinger wrote: Hello, I inserted a chart from a Calc table in LO 4.2.1, running Linux-Mint-16. Now I find that I cannot change the text displayed within the legend. It simply displays Row 1, Row 2, Row 3...). As far as I can see, one can only change the position of the legend. How do I define an arbitrary legend. 1. Double-click the chart to start editing it, if not already in that mode. 2. From the menu: Format Data Ranges... 3. Open the Data Series tab. 4. In the Data Series (left-hand) list, click the series for which you want to set the name. 5. In the Data ranges (right-hand) list, click Name 6. In the Range for Name (below that list), type the name you want to appear for the selected series, enclosed in double-quotes. 7. Repeat steps 4-6 for each series. 8. Click OK. Is there maybe a way to somehow connect the various data rows of a chart with (e.g.) a row/column in the Calc table on which the chart is based? Yes. At step 6 above instead of typing the literal text (in quotes), enter a cell reference (without quotes). This needs to include the sheet name as well, e.g.: $Sheet1.$A$3 You can also click the icon to the right of the Range for Name box (it looks like a window with an up-pointing arrow), then click the cell in the spreadsheet, and Calc will automatically fill in the reference for you. From the same dialog, you can also change the cells used for the series data (by selecting y-Values from the Data ranges list) and add new series to an existing chart. Useful if you add more data to the sheet beyond the range the chart was set up to use. Regards H. Stoellinger I hope that helps. Mark. -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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 4 corrupting Calc files
2014-03-02 7:00 GMT+01:00 J. Van Brimmer jerry...@gmail.com: Hello, I'm new to the list, so if this is an inappropriate subject, please let me know. I am using Libreoffice on Manjaro Linux. Over the last several months the version has been regularly updated. The currently installed version is: Version: 4.1.5.3 Build ID: 4.1.5.3 Arch Linux build-1. I have been using Manjaro for about six months. Over this time I have been using Libreoffice to update some Calc spreadsheets that I created to keep track of my finances. There is only one of those files that occasionally gets corrupted. It's always the same file, and only this one file that gets corrupted. I keep the files on a USB drive. I always save the file, close Libreoffice, and unmount the drive before removing it from the computer. I have no forewarning that the file is corrupt until the next time I open it. When I open the file when its corrupted, I get this window: Screenshot https://www.dropbox.com/s/aak5y545qsmhe30/Screenshot_TextImport_2014-03-01.png . Nothing I try can get Libreoffice to open or repair the file. But , if I open the file with Libreoffice 3 on my Debian system, I am offered a window that asks me if I want Libreoffice to repair the file. If I click on 'Yes' Libreoffice 3 completes the repair and I see the spreadsheet. The only strange thing that I notice about the repaired file is that the last chart I had created is only a placeholder. I then delete the placeholder and recreate the chart. If I then save an d close the file, and reopen it in Libreoffice 4, it opens fine until the next time it gets corrupted. I don't know how to cause the problem, other that to keep opening the file until it happens. Has anyone seen this problem? Is there anything I should try? I have seen a problem that seems to be similar, but that was an earlier version of LibreOffice, I think 3.7.something. It corrupted a spreadsheet for me and I couldn't repair it with LibreOffice, so I installed Apache OpenOffice and opened it. Apache OpenOffice repaired the file for me and I have been using it ever since, and since then the spreadsheet never got corrupted again. That's probably not the solution you are looking for, I just wanted to say that you are probably not the only one who had this problem, but I'm not 100% sure it's the same bug. Johnny Rosenberg -- Jerry Van Brimmer -- 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] Calc - Button clic saves and sends email
Hi :) Please use Reply to all when replying to mails from this mailing list. That way everyone gets to see what is going on so far and might be able to add the next bit to build up the complete answer or provide a different approach. Does anyone know how to make a button and give it the functionality that exists within the menus? Does anyone know how to take that further and modify the button's functionality? Is this something to do with macros? If so then these guides might be useful. Ch12 of the Getting Started guide https://wiki.documentfoundation.org/Documentation/Publications and Andrew Pitonyak's book https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers Regards from Tom :) On 2 March 2014 00:22, Jérémie Jacquand jeremie.jacqu...@gmail.com wrote: Thank you for your answer. The filename changes dynamically according to the user and date and needs to be in a very specific format. The users of this spreadsheet are not going to follow these simple steps and need a one click button solution. Le 2 mars 2014 01:17, Tom Davies tomc...@gmail.com a écrit : Hi :) There is a single button in the default tool-bar that converts to Pdf. it's beside the printer cons. It doesn't put it straight into an email though. Alternatively there is a menu option; File - Send - As Pdf but that is 3 clicks. Regards from Tom :) On 1 March 2014 13:45, Jay jeremie.jacqu...@gmail.com wrote: Hello ! I have a calc document and wish to create a button which does the following: - Saves the spreadsheet in PDF in a predetermined path using a cell content as filename - Sends an email containing the PDF I don't care if the program uses python code, libroffice basic, java... as long as the code is inside the spreadsheet and that anyone who has the file can execute the button click without installing additional software except libreoffice. I don't have enough knowledge to program this :-/ hope you can help me on this. Thanks for your help :) -- View this message in context: http://nabble.documentfoundation.org/Calc-Button-clic-saves-and-sends-email-tp4099645.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
Fwd: [libreoffice-users] User Profile Question
Hi :) I think that is better as a separate thread so i have use this post to break it off the thread that is now solved. I've had big problems with Sony Vaio in the past and wouldn't touch them with a barge pole now. It was just 1 product-line and subsequent ones don't seem to have the combination of catastrophes that led to the problem but even so the appalling way customer services handled it makes me wary of buying anything from sony, particularly laptops and especially the infamous Vaios. If you are looking for a light-weight or low energy distro then there are a few specialist ones. Alternatively it might be good to go with something like Slackware (personally i wouldn't especially for a 'first' foray into Linux-land) where you have complete control over exactly what is running in the background and only switch things on in the boot-process that you are certain you want to have running. Gateway distros such as Ubuntu, Mageia, Fedora, openSuSR are configurable up to a point but they are all designed to compete with Windows so they have thing running in the background that you probably never need. For example my machine has no Blue-tooth capability but both Windows and Ubuntu wanted to have it running in the background. In Ubuntu i was able to stop it from starting up during the boot process. By a 'first' foray i mean until after you have been running something simple for a few years and have become familiar with how smoothly things can run. Then when you try building something from scratch, like Slackware, Gentoo, Arch (actually Arch might be a good compromise because they have excellent documentation) then you have got a yard-stick to measure your successes and failures against. Generally such scratch built systems will have significantly better performance but it might not be worth the agro (at least not for most people such as me). Regards from Tom :) -- Forwarded message -- From: Virgil Arrington cuyfa...@hotmail.com Date: 2 March 2014 12:57 Subject: Re: [libreoffice-users] User Profile Question To: users@global.libreoffice.org Thanks, Scot. That seems to be what I was looking for. Just a quick glance showed me a lot of settings that I have customized. I'll dig further to see if all of them are in there. You mention that you're on Linux. Are you running on a laptop? I've tried several different Linux distros on my Sony Vaio laptop, in many different forms (live CD/USB Flash, Wubi, true dual boot), etc. and every one of them seems to make my CPU run really hot, much hotter than my Windows setup. Have you (or any others) experienced similar problems? Various Linux forums online seem to indicate this is not uncommon. I've been *really* trying to give Linux a fair try, but it keeps hitting me with roadblocks. I know many of you are Linux enthusiasts, but I can't get past the heat and sound of a frantically whirring fan. Virgil -Original Message- From: Scott Castaline Sent: Saturday, March 01, 2014 9:59 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] User Profile Question I run on Linux so I'm not sure if you have it on Win7. There's a file called registrymodifications.xcu under libreoffice/4/user. It's in some Markup format somewhat similar to html or xml. It can be kind of cryptic but I have edited that file directly with some success. I don't know if that contains everything within user options or not, but I have saved it in the past before trying something that would cause the app to barf and then restored that file and everything was fine again. Scott C. On 03/01/2014 04:40 PM, Carol-Virgil Arrington wrote: I've got a question about the User Profile. I'm using LO 4.1.5 on Windows 7. I understand that my user profile consists of a bunch of folders and files in my AppData\Roaming\LibreOffice\4\User folder. But, beyond that, I can't make sense of any of it (other than my Templates). For example, I've made several customizations to my copy of LO, such as: 1. Screen colors 2. Keyboard assignments. I have many of my favorite paragraph styles assigned to Ctrl-key combinations, etc. Where are these types of information kept? With other programs, I could find it in a file called *something*.ini, but in LO's user profile, I can't find anything that resembles any type of configuration file, and I've stepped my way through each and every file in each and every folder in the User file tree. My computer recently crashed resulting in a corrupt User Profile. I was able to rename it and start over, but it would have been nice to be able to pinpoint the one or two corrupt files and correct them without necessarily starting from scratch. Also, I use LO on many different computers, and I'd like to just copy the pertinent configuration files from one computer to another without necessarily copying the entire user profile. Virgil -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?
[libreoffice-users] Re: LO 4.2.1 printing problem (landscape)
Hi, It seems to be https://bugs.freedesktop.org/show_bug.cgi?id=75540, so it should be fixed in 4.2.3 Julien -- View this message in context: http://nabble.documentfoundation.org/LO-4-2-1-printing-problem-landscape-tp4099475p4099729.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: [libreoffice-marketing] Re: The Document Foundation's response to Her Majesty's Government consultation on document formats
HI :) +1 I can't believe i hadn't said that earlier!! It was a great press release :)) Almost all the comments, around 80-90% were extremely pro-ODF and almost all of those were also anti-OOXML. The 10-20% pro-OOXML comments almost entirely conceded that ODF should be used but that OOXML should be included, in some cases just for a restricted period to allow a smoother migration. ALL such comments were met with replies that covered; 1. pointed out that MS Office itself and almost all other office suites and programs can easily produce or convert to ODF 2. that having 2 standards made the proposal pointless and a complete waste of time 3. that OOXML failed to achieve many of the stated aims of the proposal especially the aim of allowing everyone to open government documents without having to pay to buy/rent new versions of software to do so. or at least 2 out of 3 of those in some combination or other. Most times that was done already by someone other than me but i covered the few comments that seemed to have been missed by other people. One common bit of FUD that kept appearing was that people seem to think each different office suite or program has it's own different format. That got dealt with quite neatly each time. A few comments pointed out that Google-docs doesn't use ODF. However Google themselves posted there own statement saying that they support this proposal to use ODF. Some stats that i found interesting; Microsoft's statement had 11,000 words and didn't go against using ODF, just demanded that OOXML got added as a 2nd format. 1st reply was quite swift and very critical. None of the replies supported MS despite their call to arms posted to their partners. There were a few fresh posts that quoted and supported them but not many. Mostly when it got quoted it was to criticise MS. TDF's statement had under 900 words Redhat's had around 500 (i think) [There were press release type comments from other organisations almost entirely in support of ODF but those were the only 2 that i really noticed and still remember.] Google's statement had around 80 words but it was more a response to other comments rather than the type of press release made by the others. Most pro-ODF press releases had replies supporting them and were quoted elsewhere, particularly the TDF statement which seemed to be very well received. (I might be a tad biased there but i was trying to be objective) As was pointed out several times the OOXML ISO format's spec ran to 7,000 pages. The ODF's ISO spec was variously quote as 1,200 or 800 pages. Either way at least 6 times smaller! Also it was quite often pointed out that OOXML's promise of interoperability never seems to have worked in reality and that even MS Office doesn't seem to use the ISO version of the spec and makes excuses such as 2007 and 2010 using different transitional versions. That by contrast the ODF formats have been in use by many for quite a few years. Some comments pointed out that the strict OOXML in 2013 was not the default and still didn't appear to be the same as the ISO version. 1 or 2 pointed out that OOXML contains proprietary blobs and that's why no-one except MS can implement it. So, i learned TONS from reading other people's comments. Most of which i kinda trust because they often explained problems that people have brought to the Users List or seen or experienced elsewhere (transitional vs strict for example) and also why it's such a problem for non-MS suites and programs to implement OOXML reliably. Of course i'd still need to confirm much of that through external reading but it gave me a LOT of good starting points to research such issues. Also a few posts gave great links to external resources. All VERY interesting! Annoyingly the final post of the whole consultation postulated that if the proposal IS accepted and IF anyone attempted to implement it that the Uk government might then find itself involved in protracted court-cases brought on by one of the most powerful companies on the planet, Microsoft. My personal opinions on that and the rest ... So, now we just wait and see if the Uk does dare to accept the proposal or if the government turns out to be weak and ineffectual. Based on past performance my guess is that it will crumble and just go along with supporting MS's apparently (but rarely recognised) extortionate prices. However, even if the Uk government does feel to weak to challenge MS at least we have seen a first attempt by them and maybe in 10 years time (which is apparently the soonest time they can reassess again) then it might finally be able to break free then (assuming MS is still around then). Hopefully other governments will be able to see that the attempt was made and that through failure ensured that the Uk continues to pay far more than any other European Government on IT and has the lowest performance as a result. Meanwhile other governments that HAVE ALREADY broken free or that DO break
Re: [libreoffice-users] Auto-Monthly Donation?
Hi :) That option i not yet available. I'm fairly sure it's just because no-one has even thought about it before. I've certainly not seen anyone suggest it in all the discussions i saw about the donations page. Perhaps just suggest it to the marketing mailing list and see if they like the idea. Regards from Tom :) On 1 March 2014 23:27, C. Reis amade...@cox.net wrote: Hello Libre Support, I really like Libre Office. I use it on my Windows, Linux and OS X Boxen. I wish to contribute, but I can't seem to find an option that allows me to make a donation in a set monthly amount. I guess I'm looking for something like how WikiPedia is setup (i.e. I can choose to donate a one time gift or a set monthly amount). I see the options for the one-time donation, but I don't see any options for a monthly one. Am I missing something, or is that option not available? Thank you, -Cephas -- 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] Libreoffice 4 corrupting Calc files
Hi :) I found that some files went a bit weird if they had originally been created in Word as DocX (maybe as (Doc too but i haven't had enough cases to really notice) and then just used Save As to convert to Odt. Similarly with some files created in 3.3.x and used in more recent versions - and again with ones in 3.4.x. Ones in 3.5.x and onwards don't seem to have the same problems at all. However, a lot of that could be due to user-error. I had been using OpenOffice a little bit over the years under Sun but only started using it seriously when it became LibreOffice. During most of the 3.3.x and 3.4.x branch i had a tendency to set the file defaults as MS ones instead of using ODF. It was only by the 3.5.x branch that i committed to using ODF for originals and since then i've had no problems. Starting afresh solved the problems for me. I'd start by opening a blank fresh new document using the latest release of LibreOffice. Then copypaste(special) in as unformatted text. Finally apply styles and drag in images. Granted, it is a LOT easier with most word-processed letters and other fairly small documents. Spreadsheets are going to be a tad more complicated because there's a tendency to have a lot of worksheets and each sheet would need to be done separately. On the other hand it might be easier to do using just remove direct formatting without starting afresh in a fresh new document. Then it might be just a couple of clicks per sheet. Ctrl A = Select All Ctrl c = copy Ctrl Shift v = paste special Ctrl m = remove direct formatting (it's the top item in the Format menu) Regards from Tom :) On 2 March 2014 11:48, Cley Faye cleyf...@gmail.com wrote: 2014-03-02 7:00 GMT+01:00 J. Van Brimmer jerry...@gmail.com: Hello, I'm new to the list, so if this is an inappropriate subject, please let me know. I am using Libreoffice on Manjaro Linux. Over the last several months the version has been regularly updated. The currently installed version is: Version: 4.1.5.3 Build ID: 4.1.5.3 Arch Linux build-1. I have been using Manjaro for about six months. Over this time I have been using Libreoffice to update some Calc spreadsheets that I created to keep track of my finances. There is only one of those files that occasionally gets corrupted. It's always the same file, and only this one file that gets corrupted. I keep the files on a USB drive. I always save the file, close Libreoffice, and unmount the drive before removing it from the computer. I have no forewarning that the file is corrupt until the next time I open it. When I open the file when its corrupted, I get this window: Screenshot https://www.dropbox.com/s/aak5y545qsmhe30/Screenshot_TextImport_2014-03-01.png . Nothing I try can get Libreoffice to open or repair the file. But , if I open the file with Libreoffice 3 on my Debian system, I am offered a window that asks me if I want Libreoffice to repair the file. If I click on 'Yes' Libreoffice 3 completes the repair and I see the spreadsheet. The only strange thing that I notice about the repaired file is that the last chart I had created is only a placeholder. I then delete the placeholder and recreate the chart. If I then save an d close the file, and reopen it in Libreoffice 4, it opens fine until the next time it gets corrupted. I don't know how to cause the problem, other that to keep opening the file until it happens. Has anyone seen this problem? Is there anything I should try? You could always try getting the latest version (4.2.1) and see if it still happen. I vaguely recall having a similar issue in Impress, that vanished by updating. Other than that, it would be useful to see the file when it is corrupted, but that might not be possible if it contain sensitive data. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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: User Profile Question
About profile, here is an url which may help: https://wiki.documentfoundation.org/UserProfile About Linux, I've got a laptop on Debian and I've got the same problem. I think the culprit is ACPI implementation (see http://en.wikipedia.org/wiki/Advanced_Configuration_and_Power_Interface). Short story: ACPI part is built with MS compiler which lets warnings or errors + some parts are defined for Windows only. If only Bios manufacturers would use the Intel compiler (which is more strict), it would help a lot. But we're off topic here so I'll stop there. Julien -- View this message in context: http://nabble.documentfoundation.org/User-Profile-Question-tp4099688p4099727.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] new release of a larger color list than the standard one - over 2300 colors
On Saturday, March 01, 2014 07:16:14 AM Kracked_P_P---webmaster wrote: /Quote So far, the current list has been edited to over 2,300 colors, instead of the basic ones that came with the default install of LibreOffice. https://owncloud.documentfoundation.org/Common/QA/New-Colors/standard. soc---March-01-2014--released.txt For those who want to use this list of colors, you need to search the LO config folders for standard.soc. Rename it as the standard.soc--original-one.txt and rename the new one as standard.soc. /Quote I ust downloaded from the above link. I am using your early list (2000 colors) but don't remember it downloading as a text file. (old age). If I am correct I rename the txt file to .soc and then do waht you show but to your older file. i still have backup up original. Am I correct. I appreciate all the work your doing. Russ So let me know what you think. Be kind with your remarks, please. I am doing this between bouts of heavy pain and health issues. I am spending most of my usable computer time supporting LO and doing things like making a better color list for the LO users. -- openSUSE 13.1(Linux 3.11.10-7-desktop x86_64| Intel(R) Quad Core(TM) i5-4440 CPU @ 3.10GHz|8GB DDR3| GeForce 8400GS (NVIDIA-Linux-x86_64-331.49)|KDE 4.12.2 -- 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
Reply-To? (was: Re: [libreoffice-users] Calc - Button clic saves and sends email)
On Sun, 2 Mar 2014 15:34:59 + Tom Davies tomc...@gmail.com wrote: Hi :) Please use Reply to all when replying to mails from this mailing list. That way everyone gets to see what is going on so far and might be able to add the next bit to build up the complete answer or provide a different approach. [snip] That runs directly counter to what I'd wish. If people Reply to all to this post, I'll get two copies. I don't need two copies, being as I actually read the mailing list. In fact: Because some people, for some reason, feel the need to set Reply-to to their own email address: I've a procmail rule that resets those to the mailing list. In general terms, on this mailing list or any other, I almost *never* Reply to all. Regards, Jim -- Note: My mail server employs *very* aggressive anti-spam filtering. If you reply to this email and your email is rejected, please accept my apologies and let me know via my web form at http://jimsun.LinxNet.com/contact/scform.php. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc - Button clic saves and sends email
On 2-3-2014 16:34, Tom Davies wrote: Hi :) Please use Reply to all when replying to mails from this mailing list. That way everyone gets to see what is going on so far and might be able to add the next bit to build up the complete answer or provide a different approach. Does anyone know how to make a button and give it the functionality that exists within the menus? Tools/Customize Choose tab 'Toolbars' Click 'Add' Under 'Category' choose 'Documents', under 'Commands' choose 'E-mail as PDF' Click 'Add' Does anyone know how to take that further and modify the button's functionality? It should be possible to add your own macro to a toolbar (see steps above, but slightly different ;) Therefore it is not a needed functionality to modify the button's functionality. One should change the macro-code to change the functionality. -- 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] Connect Base to External HSQLDB
On 02/06/14 00:59, Jean-Francois Nifenecker wrote: Le 06/02/2014 05:50, Mark LaPierre a écrit : Hey all, I have HSQLDB installed here: /home/database/back/hsqldb/lib/hsqldb.jar I want the Base front end here: /home/database/recipe/recipe.odb On the LibreOffice Database Wizard: 1. Select Database I select the radio button: [Connect to an existing database] I select [JDBC] in the section box and then click [Next] 2. Set up JDBC connection I fill in [data source URL]: jdbc:[../back/hsqldb/lib/hsqldb.jar] What do I put in the [JDBC driver class] box? The HSQLDB documentation suggests that there is a JDBC driver in the hsqldb.jar file but that doesn't work. I assume that the HSQLDB package contains a driver.jar somewhere. What should I put in for the JDBC driver class path? (some terms below freely translated from my FR environment) -- data source (URL) hsqldb:file:path to the .odb;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false In path to the .odb above do not specify the .odb extension. Sset the defaults above as you prefer; these work for me. -- JDBC driver class org.hsqldb.jdbcDriver -- A question: did you set the class path and configuration for Java? If not, go to Tools/Options, LibreOffice / Java. Check that Use a Java setup is checked, then add the Java environment setup on the PC. Once this is set, click Class path In the new dialog: (1) Add an archive Point to the hsqldb.jar on your PC (mine is C:\Program Files\hsqldb-2.2.8.\lib) (2) Add a file Point to the above \lib subdir You should be up and running. HTH, I've had a lot of distractions, Olympics and Income Tax return, to get through so I'm working on this again. On the Set up a connection to a JDBC database page I have: Datasource URL jdbc:[/home/database/back/hsqldb/lib/hsqldb.jar] JDBC driver class [org.hsqldb.jdbcDriver] When I click on the [Test Class] button I get a dialog box that says the JDBC driver was loaded successfully. Jumped through the first hoop. On the Set up the user authentication page I have: User Name [mlapier] with the Password required check box selected. When I click the [Test Connection] button I get a dialog box asking for my password. I type in my password and click the [OK] button. I get a message box: Connection Test The connection could not be established. Without the password check box I get the same result. Does anyone see where I have gone astray? -- _ °v° /(_)\ ^ ^ Mark LaPierre Registered Linux user No #267004 https://linuxcounter.net/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: Reply-To? (was: Re: [libreoffice-users] Calc - Button clic saves and sends email)
Hi :) Not everyone has that level of technical skill nor that level of control over their emailing systems. For the rest of us we have to use Reply to all otherwise the mailing list doesn't see the responses at all. It does mean some people get 2 copies of the same email but when that happens to me i just press the delete key a 2nd time and i find that quite quick and easy to do. It's always possible to write to the postmaster for this mailing list and request that the default behaviour for the mailing list gets changed but a few of us tried that a long old time ago and i can't really imagine it ever getting changed now. Regards from Tom :) On 2 March 2014 18:53, Jim Seymour jseym...@linxnet.com wrote: On Sun, 2 Mar 2014 15:34:59 + Tom Davies tomc...@gmail.com wrote: Hi :) Please use Reply to all when replying to mails from this mailing list. That way everyone gets to see what is going on so far and might be able to add the next bit to build up the complete answer or provide a different approach. [snip] That runs directly counter to what I'd wish. If people Reply to all to this post, I'll get two copies. I don't need two copies, being as I actually read the mailing list. In fact: Because some people, for some reason, feel the need to set Reply-to to their own email address: I've a procmail rule that resets those to the mailing list. In general terms, on this mailing list or any other, I almost *never* Reply to all. Regards, Jim -- Note: My mail server employs *very* aggressive anti-spam filtering. If you reply to this email and your email is rejected, please accept my apologies and let me know via my web form at http://jimsun.LinxNet.com/contact/scform.php. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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: [libreoffice-documentation] Getting Started, Chapters 1 through 5
Hi :) The documentation team have a specific task that almost anyone can help with. Their mailing list is very low traffic, especially compared against this one! If you think you have the patience and the skills for working in documentation, or if you just want to see if you can score on some of the low-hanging fruit they have to deal with, then this task might be a good way in or just be a good experience. Regards from Tom :) On 2 March 2014 19:51, Jean Weber jeanwe...@gmail.com wrote: I have gone through Chapters 1 through 5 of the Getting Started guide for LO v4.2, which have been reviewed and updated by other people. IMO Chapters 1, 2 and 3 are ready to publish. However, it would be good if someone else would go through the latest iteration of Chapters 4 and 5, reviewing against the software. All files are in this folder: http://www.odfauthors.org/libreoffice/english/getting-started/feedback-lo4.2 --Jean -- To unsubscribe e-mail to: documentation+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/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? 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 - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Hi :) I'm usually glad when i'm wrong because i learn something and usually find an easier way of doing whatever it was. I've not tried the Excel edges one yet. Even if it does work i think the LibreOffice one is easier and more forgiving but maybe i'm biased. Regards from Tom :) On 2 March 2014 16:13, Tanstaafl tansta...@libertytrek.org wrote: On 2/28/2014 9:37 AM, Tom Davies tomc...@gmail.com wrote: Hi:) I just tried out the various options (Ctrl, Alt, Shift combos) in Excel 2010 and there really doesn't seem to be a way of dragging a column into a new position. It seems you have to cut or copy first. Glad you were wrong - being able to drag-n-drop is so much easier, and now I can do it in both Libre and Excel... :) -- 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] Weird situation with LO Writer
Hi :) It might be good to post this as a bug-report to see what comments the devs make, or use their mailing list or irc or whatever. I'm not having the same issue at all and can't replicate the problem at all. On my machines jpgs stay as jpgs and pngs as pngs. I just drag and drop my images in. Not sure if that makes a difference. Regards from Tom :) On 1 March 2014 13:57, Ra ravi...@gmail.com wrote: Yeah, it's not that either. I can't make sense of this either. Just as an example, one of the original JPEGs is 568x426 and 75kB in size, as a PNG it has the same dimensions but is 374kB in size. On Sat, Mar 1, 2014 at 2:33 PM, Mark Bourne libreoffice-ml.mbou...@spamgourmet.com wrote: OK. In that case it doesn't look like what I thought. The only other thing I can think is that perhaps some of those JPEGs do come out smaller when saved as PNG and LO is doing that to reduce the file size. But that seems unlikely for photos, as you originally said. Maybe someone else here has some ideas... Mark. Ra wrote: I never insert images as pictures. The JPEG images are only ever used as backgrounds for frames. I also never open the JPEGs in any picture editing application and copypaste from there, the images are only ever used as files from disk. What I'm doing is precisely this: File Insert Frame... OK Then [right click on the frame created] Frame... Background As: Graphic Browse... [select the JPEG file from disk] Type: Area OK And then repeat, many times, always selecting a different JPEG for the background. On Sat, Mar 1, 2014 at 2:04 PM, Mark Bourne libreoffice-ml.mbou...@spamgourmet.com wrote: Sure, but how did you then get those images into LibreOffice? If you use Insert Picture From file, LO knows that the file is a JPEG and probably even copies the file as-is into the ODF file. If you open the JPEG file in another application (such as an image editor), then copy from there and paste into LO, in this case LO will only have the bitmap data copied from the image editor. It will not know about the original image file nor what type it was, and probably uses its default format, i.e. PNG, to save that image data within the ODF file. My suspicion is that, although you saved all the source images as JPEGs, those which appear as JPEG in the ODF file were inserted by Insert Picture From file, while those which appear as PNG in the ODF file were opened in another application and copied and pasted into LO Writer. Mark. Ra wrote: Good guess but sadly no. All the images are first stored as JPEGs. That's how I know they in fact *are* JPEGs. ;-) Ra wrote: Hello, I have noticed some unexpected (and possibly inconsistent) behavior of documents producet with LO Writer. Here's my scenario: I have several frames in the document and each of them has a JPEG photo as the background. Each frame has a different image as a background. There are no other graphics in the document, just some text. The resulting document ends up being considerably larger than the sum of all the images and all the text content put together. Knowing that ODFs are really just ZIP archives, I decided to dig a little deeper. Having opened an ODF file with an archiver I noticed most (but not all, surprisingly!) of my JPEGs got converted to PNGs before getting stored. I don't know much about this but up until now I believed LO stores all external images as direct file copies, or at the very least in the original format, so this striked me as odd. Just a guess, but if you copy and paste an image from another file, LO won't know what format it was in originally (all it has is bitmap data pasted from the clipboard), so will probably use PNG since it is a lossless format. Maybe those in JPEG format were inserted by Insert Picture From file (or similar), while those in PNG format were opened in another application, copied from there, and then pasted into LO? I've been told the ODF specification recommends using PNGs for bitmaps and SVG for vector graphics. This makes sense generally but is also quite inefficient for photos as PNG photos tend to be much larger than JPEGs. It is also weird that only some of my images got converted. Anybody know and can explain the logic behind this? My document currently contains about 100 such images, the JPEGs are all together about ~15MB in size, the rest of the document is mostly plain text with some formatting, and yet my document ends up at about ~47MB. I would like to optimize and reduce this if possible. In case it matters, the document was produced over several weeks in LO 4.x or newer on Windows (XP/x86 and 7/x64) and Linux (x86). Thank you. -- 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
Re: [libreoffice-users] User Profile Question
Kracked, Have you looked at lm-sensors for Linux? http://lm-sensors.org/ Girvin Herr On 03/02/2014 07:09 AM, Kracked_P_P---webmaster wrote: I use Ubuntu Linux 12.04LTS as my default OS, but I also use Win7 on dual-booting laptops. I never had Linux run hotter than Windows when it is installed onto the drive. I also do not use the thin laptops, but the thicker ones that have more fan space and size to remove the heat better. Tell me, what do you use to see the CPU temps in Linux? What do you use for Windows? I use Speedfan for Windows and have not found much to really see actually temps in Linux, but by feeling the heat from the surface of the laptops, it never gets as hot as Windows. Both laptops are dual core and the main desktop is a quad with the others dual and single cores. As for the User Profile issue, I would get it setup as you want it to be and then make a backup of it. That way you do not have to start from scratch. I do not customize as much as you do, just add a dictionary [or two] and add a larger color choice option for backgrounds, borders, text, etc.. I really think that getting your setup into a backup and using it when you crash due to a corrupted file would be most helpful. As for the compatibility of the Windows profile/config to Linux, well I do not know much about what each file does either. For Win7 to Win7 systems, I think it taking a specific set of file in the user profile and copying it over to a new system would work. Which are the needed files, I do not know. Maybe using the whole User folder would work transfered over to the new systems. Question: What type of [and how many] screen colors and keyboard assignments/modifications do you set up for your system? What are you using them for? We always like to know what LO is being used for and what our users are doing with it to make their workflow flow better. I know of a SciFi-Fantacy writer who switched to Linux and now LO to write his 1 to 3 book a year [being now in his 70's it is down from 4+ paper-back books a year]. He uses many macros and keyboard assignments [and a non standard keyboard] for many years. So, knowing what you change your profile to/with might help our developers make it easier for our users to do their work. On 03/02/2014 07:57 AM, Virgil Arrington wrote: Thanks, Scot. That seems to be what I was looking for. Just a quick glance showed me a lot of settings that I have customized. I'll dig further to see if all of them are in there. You mention that you're on Linux. Are you running on a laptop? I've tried several different Linux distros on my Sony Vaio laptop, in many different forms (live CD/USB Flash, Wubi, true dual boot), etc. and every one of them seems to make my CPU run really hot, much hotter than my Windows setup. Have you (or any others) experienced similar problems? Various Linux forums online seem to indicate this is not uncommon. I've been *really* trying to give Linux a fair try, but it keeps hitting me with roadblocks. I know many of you are Linux enthusiasts, but I can't get past the heat and sound of a frantically whirring fan. Virgil -Original Message- From: Scott Castaline Sent: Saturday, March 01, 2014 9:59 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] User Profile Question I run on Linux so I'm not sure if you have it on Win7. There's a file called registrymodifications.xcu under libreoffice/4/user. It's in some Markup format somewhat similar to html or xml. It can be kind of cryptic but I have edited that file directly with some success. I don't know if that contains everything within user options or not, but I have saved it in the past before trying something that would cause the app to barf and then restored that file and everything was fine again. Scott C. On 03/01/2014 04:40 PM, Carol-Virgil Arrington wrote: I’ve got a question about the User Profile. I’m using LO 4.1.5 on Windows 7. I understand that my user profile consists of a bunch of folders and files in my AppData\Roaming\LibreOffice\4\User folder. But, beyond that, I can’t make sense of any of it (other than my Templates). For example, I’ve made several customizations to my copy of LO, such as: 1. Screen colors 2. Keyboard assignments. I have many of my favorite paragraph styles assigned to Ctrl-key combinations, etc. Where are these types of information kept? With other programs, I could find it in a file called *something*.ini, but in LO’s user profile, I can’t find anything that resembles any type of configuration file, and I’ve stepped my way through each and every file in each and every folder in the User file tree. My computer recently crashed resulting in a corrupt User Profile. I was able to rename it and start over, but it would have been nice to be able to pinpoint the one or two corrupt files and correct them without necessarily starting from scratch. Also, I use LO
Re: [libreoffice-users] Weird situation with LO Writer
Hi Ra, Ra schrieb: I never insert images as pictures. The JPEG images are only ever used as backgrounds for frames. I also never open the JPEGs in any picture editing application and copypaste from there, the images are only ever used as files from disk. What I'm doing is precisely this: File Insert Frame... OK Then [right click on the frame created] Frame... Background As: Graphic Browse... [select the JPEG file from disk] Type: Area OK I think, that is the point. You do not insert the image directly, but use it as background image. If you insert the image directly, it should stay in JPEG format. Have you tried, whether other ways to make it a background (e.g. extending the palette) results in png too? Why do you try to make it a background of the frame? Kind regards Regina -- 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 4 corrupting Calc files
On Sun, Mar 2, 2014 at 9:54 AM, Johnny Rosenberg gurus.knu...@gmail.comwrote: 2014-03-02 7:00 GMT+01:00 J. Van Brimmer jerry...@gmail.com: Hello, I'm new to the list, so if this is an inappropriate subject, please let me know. I am using Libreoffice on Manjaro Linux. Over the last several months the version has been regularly updated. The currently installed version is: Version: 4.1.5.3 Build ID: 4.1.5.3 Arch Linux build-1. I have been using Manjaro for about six months. Over this time I have been using Libreoffice to update some Calc spreadsheets that I created to keep track of my finances. There is only one of those files that occasionally gets corrupted. It's always the same file, and only this one file that gets corrupted. I keep the files on a USB drive. I always save the file, close Libreoffice, and unmount the drive before removing it from the computer. I have no forewarning that the file is corrupt until the next time I open it. When I open the file when its corrupted, I get this window: Screenshot https://www.dropbox.com/s/aak5y545qsmhe30/Screenshot_TextImport_2014-03-01.png . Nothing I try can get Libreoffice to open or repair the file. But , if I open the file with Libreoffice 3 on my Debian system, I am offered a window that asks me if I want Libreoffice to repair the file. If I click on 'Yes' Libreoffice 3 completes the repair and I see the spreadsheet. The only strange thing that I notice about the repaired file is that the last chart I had created is only a placeholder. I then delete the placeholder and recreate the chart. If I then save an d close the file, and reopen it in Libreoffice 4, it opens fine until the next time it gets corrupted. I don't know how to cause the problem, other that to keep opening the file until it happens. Has anyone seen this problem? Is there anything I should try? I have seen a problem that seems to be similar, but that was an earlier version of LibreOffice, I think 3.7.something. It corrupted a spreadsheet for me and I couldn't repair it with LibreOffice, so I installed Apache OpenOffice and opened it. Apache OpenOffice repaired the file for me and I have been using it ever since, and since then the spreadsheet never got corrupted again. That's probably not the solution you are looking for, I just wanted to say that you are probably not the only one who had this problem, but I'm not 100% sure it's the same bug. Johnny Rosenberg Thanks for that info Johnny. Gives me something to think about. -- Jerry Van Brimmer -- 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 4 corrupting Calc files
On Sun, Mar 2, 2014 at 4:39 AM, Tom Davies tomc...@gmail.com wrote: Hi :) I found that some files went a bit weird if they had originally been created in Word as DocX (maybe as (Doc too but i haven't had enough cases to really notice) and then just used Save As to convert to Odt. Similarly with some files created in 3.3.x and used in more recent versions - and again with ones in 3.4.x. Ones in 3.5.x and onwards don't seem to have the same problems at all. However, a lot of that could be due to user-error. I had been using OpenOffice a little bit over the years under Sun but only started using it seriously when it became LibreOffice. During most of the 3.3.x and 3.4.x branch i had a tendency to set the file defaults as MS ones instead of using ODF. It was only by the 3.5.x branch that i committed to using ODF for originals and since then i've had no problems. Starting afresh solved the problems for me. I'd start by opening a blank fresh new document using the latest release of LibreOffice. Then copypaste(special) in as unformatted text. Finally apply styles and drag in images. Granted, it is a LOT easier with most word-processed letters and other fairly small documents. Spreadsheets are going to be a tad more complicated because there's a tendency to have a lot of worksheets and each sheet would need to be done separately. On the other hand it might be easier to do using just remove direct formatting without starting afresh in a fresh new document. Then it might be just a couple of clicks per sheet. Ctrl A = Select All Ctrl c = copy Ctrl Shift v = paste special Ctrl m = remove direct formatting (it's the top item in the Format menu) Regards from Tom :) Thanks for the tip Tom. I was hoping it wouldn't come to that, but maybe I'll have to create a new, fresh spreadsheet. That would be a LOT of work though. On 2 March 2014 11:48, Cley Faye cleyf...@gmail.com wrote: 2014-03-02 7:00 GMT+01:00 J. Van Brimmer jerry...@gmail.com: Hello, I'm new to the list, so if this is an inappropriate subject, please let me know. I am using Libreoffice on Manjaro Linux. Over the last several months the version has been regularly updated. The currently installed version is: Version: 4.1.5.3 Build ID: 4.1.5.3 Arch Linux build-1. I have been using Manjaro for about six months. Over this time I have been using Libreoffice to update some Calc spreadsheets that I created to keep track of my finances. There is only one of those files that occasionally gets corrupted. It's always the same file, and only this one file that gets corrupted. I keep the files on a USB drive. I always save the file, close Libreoffice, and unmount the drive before removing it from the computer. I have no forewarning that the file is corrupt until the next time I open it. When I open the file when its corrupted, I get this window: Screenshot https://www.dropbox.com/s/aak5y545qsmhe30/Screenshot_TextImport_2014-03-01.png . Nothing I try can get Libreoffice to open or repair the file. But , if I open the file with Libreoffice 3 on my Debian system, I am offered a window that asks me if I want Libreoffice to repair the file. If I click on 'Yes' Libreoffice 3 completes the repair and I see the spreadsheet. The only strange thing that I notice about the repaired file is that the last chart I had created is only a placeholder. I then delete the placeholder and recreate the chart. If I then save an d close the file, and reopen it in Libreoffice 4, it opens fine until the next time it gets corrupted. I don't know how to cause the problem, other that to keep opening the file until it happens. Has anyone seen this problem? Is there anything I should try? You could always try getting the latest version (4.2.1) and see if it still happen. I vaguely recall having a similar issue in Impress, that vanished by updating. Other than that, it would be useful to see the file when it is corrupted, but that might not be possible if it contain sensitive data. -- Jerry Van Brimmer -- 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: Reply-To? (was: Re: [libreoffice-users] Calc - Button clic saves and sends email)
I'm sorry, if that was me. I'm new to the list, and using Gmail. I just now realized what I had done this morning. From now on I will hit Reply-All and then edit out individuals email addresses. [?] On Sun, Mar 2, 2014 at 10:53 AM, Jim Seymour jseym...@linxnet.com wrote: On Sun, 2 Mar 2014 15:34:59 + Tom Davies tomc...@gmail.com wrote: Hi :) Please use Reply to all when replying to mails from this mailing list. That way everyone gets to see what is going on so far and might be able to add the next bit to build up the complete answer or provide a different approach. [snip] That runs directly counter to what I'd wish. If people Reply to all to this post, I'll get two copies. I don't need two copies, being as I actually read the mailing list. In fact: Because some people, for some reason, feel the need to set Reply-to to their own email address: I've a procmail rule that resets those to the mailing list. In general terms, on this mailing list or any other, I almost *never* Reply to all. Regards, Jim -- Note: My mail server employs *very* aggressive anti-spam filtering. If you reply to this email and your email is rejected, please accept my apologies and let me know via my web form at http://jimsun.LinxNet.com/contact/scform.php. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Jerry Van Brimmer -- 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] Weird situation with LO Writer
Hello, True, I don't insert the images as pictures like you would expect, but I didn't think that would make a difference since all the images are still coming from a local disk, so therefore LO knows the format very well and should be able to preserve it. Why am I using frames with images as backgrounds instead of pictures? I don't know really. I needed an image to accompany a chunk of text, this seemed like a good idea at the time. It's kinda too late to change it now, there are already over a hundred such frames... I might try to change it at some later point but for now I'd like to stick with what I have. I did not try inserting images any other way so I don't know how it would behave. (I also don't understand what do you mean by extending the palette.) I did however do a little experiment. Since ODTs are just ZIP archives, I opened my document with an archiver tool and extracted the contents to a temporary directory. Then I converted all the PNGs to JPGs with the same name, updated the relevant index files accordingly (content.xml, META-INF/manifest.xml), and archived it back as ZIP. Then I renamed the ZIP to ODT and tried opening it in Writer, and voila, it worked! All the images are still there and visible, I didn't see any problems. I then saved it under a different name and checked the resulting ODT, all the stored images were still in JPEG format. So I guess this kinda solves my problem for now, although I would still like to know how and why it happened to begin with. I need to do more editing on the document which means a lot more saving, so I'll keep an eye on what LO does with these JPEGs in the future. On Sun, Mar 2, 2014 at 10:55 PM, Regina Henschel rb.hensc...@t-online.dewrote: Hi Ra, Ra schrieb: I never insert images as pictures. The JPEG images are only ever used as backgrounds for frames. I also never open the JPEGs in any picture editing application and copypaste from there, the images are only ever used as files from disk. What I'm doing is precisely this: File Insert Frame... OK Then [right click on the frame created] Frame... Background As: Graphic Browse... [select the JPEG file from disk] Type: Area OK I think, that is the point. You do not insert the image directly, but use it as background image. If you insert the image directly, it should stay in JPEG format. Have you tried, whether other ways to make it a background (e.g. extending the palette) results in png too? Why do you try to make it a background of the frame? Kind regards Regina -- 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] Compress images
On 28/02/2014 9:14 pm, Tom Davies wrote: Hi :) How about as an add-on/Extension for Draw? Sounds clunky. Do we really need more bloat in Writer to make it into yet another image editor? Most of the functionality already exists in Writer, and we are not talking about image editing in the literal sense, only about resizing and cropping. It need not contribute significantly to bloat if well written. Have you ever looked at IrfanView (a very capable and well regarded Windows image manipulation program) that is only 2.0 MB (installed size) with capabilities that go way beyond anything we are talking about. I'm happier using dedicated programs and thus making the images available for use elsewhere and in other programs. Of all the images that I have processed for use in Writer, I have never used the same processed image elsewhere. Your usage may be different. Just because Word does something bad doesn't mean we have to follow. FUD? Who said anything about *that* functionality being bad? Regards, Dale. Part of the extra advantage of LibreOffice is that it works on low spec systems that MS Office can't cope with. Regards from Tom :) On 28 February 2014 02:48, Dale Rebgetz dale.rebg...@setec.com.au wrote: On 28/02/2014 12:16 pm, Cley Faye wrote: I don't know how often this feature is requested for odt files. I know that for pdf you can set parameters for the image compression, and it make sense since the resulting file is unlikely to undergo future changes, but it's less obvious for file formats that are not at the end of the editing line. It's probably better to work with the highest resolution needed, and produce smaller files as needed. Fair point. However most documents reach a finished state, at which point they do not need to stay bloated. Email from setec.com.au does not necessarily represent the official policy of SETEC Pty Ltd. See http://www.setec.com.au/emaildisclaimer20060629.html for details. -- 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 4 corrupting Calc files
I have 14 sheets in the offending .ods file. I can't remember if it's always the same sheet. That would take some time fiddling and testing. For now, I think I'm just going to stay with LO 3.x.x on my Debian system. I like the stability of Debian much more than Arch based OSes. I might try installing AOO, just to try it out. On Sun, Mar 2, 2014 at 4:44 PM, Tom Davies tomc...@gmail.com wrote: Hi :) I prefer Johnny's route! Maybe worth trying Gnumeric as a dedicated spreadsheet program too. All 3 options there are in the same eco-system so if you do end up using AOO or Gnumeric you're still on the same team really. Before doing the fresh new spreadsheet route i would try just removing the direct formatting. It might be worth trying a rename of the User Profile too jic either of those ideas do work. Regards from Tom :) On 2 March 2014 22:08, J. Van Brimmer jerry...@gmail.com wrote: On Sun, Mar 2, 2014 at 4:39 AM, Tom Davies tomc...@gmail.com wrote: Hi :) I found that some files went a bit weird if they had originally been created in Word as DocX (maybe as (Doc too but i haven't had enough cases to really notice) and then just used Save As to convert to Odt. Similarly with some files created in 3.3.x and used in more recent versions - and again with ones in 3.4.x. Ones in 3.5.x and onwards don't seem to have the same problems at all. However, a lot of that could be due to user-error. I had been using OpenOffice a little bit over the years under Sun but only started using it seriously when it became LibreOffice. During most of the 3.3.x and 3.4.x branch i had a tendency to set the file defaults as MS ones instead of using ODF. It was only by the 3.5.x branch that i committed to using ODF for originals and since then i've had no problems. Starting afresh solved the problems for me. I'd start by opening a blank fresh new document using the latest release of LibreOffice. Then copypaste(special) in as unformatted text. Finally apply styles and drag in images. Granted, it is a LOT easier with most word-processed letters and other fairly small documents. Spreadsheets are going to be a tad more complicated because there's a tendency to have a lot of worksheets and each sheet would need to be done separately. On the other hand it might be easier to do using just remove direct formatting without starting afresh in a fresh new document. Then it might be just a couple of clicks per sheet. Ctrl A = Select All Ctrl c = copy Ctrl Shift v = paste special Ctrl m = remove direct formatting (it's the top item in the Format menu) Regards from Tom :) Thanks for the tip Tom. I was hoping it wouldn't come to that, but maybe I'll have to create a new, fresh spreadsheet. That would be a LOT of work though. On 2 March 2014 11:48, Cley Faye cleyf...@gmail.com wrote: 2014-03-02 7:00 GMT+01:00 J. Van Brimmer jerry...@gmail.com: Hello, I'm new to the list, so if this is an inappropriate subject, please let me know. I am using Libreoffice on Manjaro Linux. Over the last several months the version has been regularly updated. The currently installed version is: Version: 4.1.5.3 Build ID: 4.1.5.3 Arch Linux build-1. I have been using Manjaro for about six months. Over this time I have been using Libreoffice to update some Calc spreadsheets that I created to keep track of my finances. There is only one of those files that occasionally gets corrupted. It's always the same file, and only this one file that gets corrupted. I keep the files on a USB drive. I always save the file, close Libreoffice, and unmount the drive before removing it from the computer. I have no forewarning that the file is corrupt until the next time I open it. When I open the file when its corrupted, I get this window: Screenshot https://www.dropbox.com/s/aak5y545qsmhe30/Screenshot_TextImport_2014-03-01.png . Nothing I try can get Libreoffice to open or repair the file. But , if I open the file with Libreoffice 3 on my Debian system, I am offered a window that asks me if I want Libreoffice to repair the file. If I click on 'Yes' Libreoffice 3 completes the repair and I see the spreadsheet. The only strange thing that I notice about the repaired file is that the last chart I had created is only a placeholder. I then delete the placeholder and recreate the chart. If I then save an d close the file, and reopen it in Libreoffice 4, it opens fine until the next time it gets corrupted. I don't know how to cause the problem, other that to keep opening the file until it happens. Has anyone seen this problem? Is there anything I should try? You could always try getting the latest version (4.2.1) and see if it still happen. I vaguely recall having a similar issue
Re: [libreoffice-users] Re: [libreoffice-marketing] Re: The Document Foundation's response to Her Majesty's Government consultation on document formats
I can't believe i hadn't said that earlier!! It was a great press release :)) totally agree A few comments pointed out that Google-docs doesn't use ODF. However Google themselves posted there own statement saying that they support this proposal to use ODF. actually that is partial truth and not the whole truth. users were right, google does not support ODF totally. gmail has a very nice feature - when an email has an attachment, you could simply click on it and a preview will be open. you could go through the preview and decide if you want to download it or not. this preview feature is supported for .docx,.xlsx, .doc. .pdf but not for .odt,.ods. so from this you could come to a conclusion that google does not support ODFs. however, if you save the file into google drive and then try to convert it, it is possible to do so even with ODFs. so, google drive does support ODF. as i was saying, both were partially correct. Hopefully other governments will be able to see that the attempt was made and that through failure ensured that the Uk continues to pay far more than any other European Government on IT and has the lowest performance as a result. Meanwhile other governments that HAVE ALREADY broken free or that DO break freak free continue to find huge cost-savings, plummeting costs and rapidly as a result. amen to that! regards, som -- 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