Re: [libreoffice-users] Compute difference
Thanks Tom Dear Dave It does work - you have to format the input cells as stated. b4 is formatted to Date, 31/Dec c4 is text to d4 is formatted to Date, 31/dec then in E4 =days360(b4,d4,3) then input your 2 dates into b4 and d4 as in just type:- 01/07/2011 and 22/07/2011 and the answer in E4 is 21 you might want to add +1 to the E4 formula depending on if you decide the answer in E4 should be 22 I note that 1/7/2011 is the same as 01/07/2011, as is just 1/7 (as it auto inputs this year) regards John B -- On 22/07/2011 20:41, Tom Davies wrote: Hi :) I think John's answer was mostly so you could copypaste into the right places! To do the formatting in the first part of his answer click on the cell and then look up at the menus at the top of the LibreOffice window. The menus should be something like File .. View ... Edit ... (err i can't remember) ... Format ... (more i can't remember) ... Window ... Help So, click on the Format menu, choose Cell and a pop-up box should appear with lots of tabs at the top. Choose the first one, General (or something). Somewhere on the left should be an option for Date which then gives you various sub-options. Hope this helps but there is a guide with screen-shots somewhere that might help so don't worry if it's not obvious. See Chapter 5 http://www.libreoffice.org/get-help/documentation/ Regards from Tom :) From: Dave Douglasddougl...@farmersagent.com To: users@global.libreoffice.org Sent: Fri, 22 July, 2011 20:06:33 Subject: Re: [libreoffice-users] Compute difference Thanks, but I am not a programmer. I have troubles being understood in English. Is there a way of doing it through the menus? Feeling unworthy, Dave -Original Message- From: John B Sent: Friday, July 22, 2011 12:00 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Compute difference Try this b4 is formatted to Date, 31/Dec c4 is text to d4 is formatted to Date, 31/dec E4 = ((-B4+D4)/7 +(1/7) f4= Trunc(e4) g4= (+e4-F4)*7 then type in your 2 dates into b4 and d4 as in 01/07/2011 and 22/07/2011 regards John B On 22/07/2011 15:15, Jérôme Fenal wrote: Hi all, I need to do a difference in days between two dates, _without_ taking into account leap years (e.g. considering all years are 365 days long). The right way to do that would be to use function DAYS360(date1;date2;method) using method = 3 as in other financial functions, but it does seems to be implemented (only 0 non 0 are meaningful for this function currently). Does anybody know how to still do this without ressorting to a procedural language ? Regards, J. PS: I'll be digging into BZ to see if there is already a request for such an enhancement to DAYS360(). No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3779 - Release Date: 07/21/11 16:13:00 -- Unsubscribe instructions: E-mail to users+h...@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 Introducing the Farmers Value Program - Big Discounts on Business Services Visit us on the web at http://www.farmersbusinessinsurance.com/farmers-value-program.html -- Unsubscribe instructions: E-mail to users+h...@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 -- Unsubscribe instructions: E-mail to users+h...@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] Given up spellchecking?
Hi Both (all in fact) This seems to be the crux of it. On my system Ubuntu/Pinguy 11.04, LO 3.4.1) the spell checker is Hundspell. Hunspell isn't appearing in the list of Available language modules, whereas it does on my Windoze setup. It looks like it's been vaped. But how do I get it back? I've been wandering around the filesystem looking for something that sounds like spelling, but I can't find it. The edit option on that dialogue edits the available modules. Those are the ones that insist in being in English (US) even when I change them to English (UK). ? Regards Mark Stanton One small step for mankind... -- Unsubscribe instructions: E-mail to users+h...@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] How to import a txt file into an existing Calc sheet?
Hello: I have a currently existing Excel 2007 sheet that I can do a (In Excel) Refresh All for \\APOLLO\e\WeatherLink\JACW3\download.txt which is a test file in the format of: Temp HiLow Out WindWind Hi Hi Wind Heat THSWRain Solar Solar Hi Solar UVHi HeatCoolIn InIn In In In Air Soil 1 SoilLeaf Wind WindISS Arc. DateTime Out Temp Temp HumDew Speed Dir Run Speed Dir Chill IndexTHW Index BarRain Rate Rad. EnergyRad.UV Dose UV D-D D-DTemp HumDew HeatEMC Density ET Moist. Temp 1 Wet 1 Samp Tx Recept Int. -- 7/22/11 0:01 75.6 75.6 75.669 64.7 1.0 WNW 0.02 1.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 0 0.0 0.00 0.0 0.000 0.007 79.546 56.9 79.3 8.46 .07220.00015369.0 15 91 39.1 1 7/22/11 0:02 75.6 75.6 75.669 64.7 2.0 WNW 0.03 3.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 0 0.0 0.00 0.0 0.000 0.007 79.547 57.5 79.3 8.66 .07220.00015369.0 15 201 87.0 1 7/22/11 0:03 75.6 75.6 75.669 64.7 1.0 WNW 0.02 2.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 0 0.0 0.00 0.0 0.000 0.007 79.547 57.5 79.3 8.66 .07220.00015369.0 15 221 95.7 1 7/22/11 0:04 75.6 75.6 75.669 64.7 1.0 WNW 0.02 3.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 0 0.0 0.00 0.0 0.000 0.007 79.548 58.1 79.4 8.86 .07210.00015369.0 15 211 91.3 1 7/22/11 0:05 75.6 75.6 75.669 64.7 1.0 WNW 0.02 3.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 0 0.0 0.00 0.0 0.000 0.007 79.548 58.1 79.4 8.86 .07210.00015369.0 15 211 91.3 1 and is properly formatted automatically by a Text-To Colums setup already in the MS Excel sheet so all I need to do each day is Refresh All and select the filename and it pulls in the data in the proper column. For the life of me I cannot see how to do this in Calc...and opening the existing sheet gets the right format, but I'm at a loss of how to get new data into it without redoing the whole text to columns every time (not an option due to time constraints here each day when this has to happen...data is available at 59 past the hour and needs to jut come in to be used by 15 past the next hour. Can anyone help with this? As of right now its the one thing keeping me from dumping the Office 2007 suite. -- ===[George R. Kasica]===+1 262 677 0766 President +1 206 374 6482 FAX Netwrx Consulting Inc. Jackson, WI USA http://www.netwrx1.com geor...@netwrx1.com ICQ #12862186 -- Unsubscribe instructions: E-mail to users+h...@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 import a txt file into an existing Calc sheet?
At 07:48 23/07/2011 -0500, George R. Kasica wrote: I have a currently existing Excel 2007 sheet that I can do a (In Excel) Refresh All for \\APOLLO\e\WeatherLink\JACW3\download.txt ... So that's a file available to your system? ... which is a te[x]t file in the format of: [...] and is properly formatted automatically by a Text-To-Columns setup already in the MS Excel sheet so all I need to do each day is Refresh All and select the filename and it pulls in the data in the proper column. For the life of me I cannot see how to do this in Calc...and opening the existing sheet gets the right format, but I'm at a loss of how to get new data into it without redoing the whole text to columns every time ... Try this: o Go to Insert | Sheet From File..., browse to your .txt file, and click Insert. o In the Text Import dialogue, under Separator options, select Separated by, Space, and Merge delimiters. o Click OK. o In the Insert Sheet dialogue, select the position of your new sheet and - crucially - tick Link. o Click OK. Each time you open this spreadsheet, you will have the option to update this new sheet; alternatively, you can go to Edit | Links... and click Update. Note that, since the entire sheet is updated, any calculations you perform on that sheet will be lost - so you will have to move your calculations to other sheets. If this data is downloaded from the web, you may prefer instead to use Insert | Link to External Data... and import directly from the web page. ... (not an option due to time constraints here each day when this has to happen...data is available at 59 past the hour and needs to just come in to be used by 15 past the next hour. You can do a lot in sixteen minutes! I trust this helps. Brian Barker -- Unsubscribe instructions: E-mail to users+h...@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] help recovering?
On 7/22/2011 8:26 PM, planas wrote: Sorry about the problem. One idea I have is make copy of the file and change the extension to txt. My idea is that the formatting data would then be ignored when you open the copy. If it works you may get some formatting gibberish included with the text. -- Jay Lozier odt files are zip archives. Changing the extension to txt is almost guaranteed to get you nowhere. If you make a copy and change the extension to .zip, and if you succeed in unzipping it, you will find interesting things in there. The file Content.xml contains your text with xml stuff, but if you work at it you may be able to extract your data. There may be extractor programs that will do this for you. The downside in all this is that if the odt file is damaged, the zip archiver may not be able to open it. I wish you all the luck in the world. David Teague -- nil significat nisi oscillat -- Unsubscribe instructions: E-mail to users+h...@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: help recovering?
Thanks for making a stab at this Tom. Here is the file. Was saved as a common text file originally with Kwrite so it had no file extension. Subsequently I got more complex with it and started edit it in LibreOffice. So I have to assume it saved as an .odt file, but the extension was never shown. Steve (aka JeepNut) On 07/22/2011 02:00 PM, Tom Davies [via Document Foundation Mail Archive] wrote: Hi :) If it's saved in odt or docX then you could try opening the file with an archive manager. I might be able to have a look in Ubuntu using LibreOffice 3.3.2 if you send me the attachment off-list. Regards from Tom :) From: John B [hidden email] /user/SendEmail.jtp?type=nodenode=3192084i=0 To: [hidden email] /user/SendEmail.jtp?type=nodenode=3192084i=1 Sent: Fri, 22 July, 2011 18:37:22 Subject: Re: [libreoffice-users] help recovering? I do not know if this will help, but viewers can be more forgiving than editors. Try http://www.officeviewers.com/ or http://visioo-writer.tuxfamily.org/EN/index_3.html if it does - you will have to copy paste back into LO again you might have to google a few more until you find one that works. regards John B -- On 22/07/2011 17:42, JeepNut wrote: Hoping for some good news here. Am using the openSuSE branded version of LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.3.1 on openSuSE 11.3 and KDE 4.4.4-1.5. Was editing a document that is pretty important (to me at least) and during the process had tried to add a footnote. I was editing the text in the footnote and almost immediately there was some flashing of the screen and LibreOffice crashed, locking up the entire PC. No mouse control, no keyboard control, nothing. So I had to reset the PC. Now the document is fubar. When I try to open it, LibreOffice attempts to recover but fails. Then it tries to repair the file but opens only a blank page. I've tried to open it without an extension and get a list of a variety of application types to attempt any modicum of recovery, but no matter what I try to open it with it either fails, or opens in a file of unreadable gibberish. I'd be THRILLED if someone would be able to actually recover this document for me. Nothing secret in it, I'd be happy to email it to anyone who'd like to give it a try. Even just to get back the text out of it so that I could rebuild would be fabulous. Any chance at all to recover? -- View this message in context: http://nabble.documentfoundation.org/help-recovering-tp3191906p3191906.html Sent from the Users mailing list archive at Nabble.com. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3781 - Release Date: 07/22/11 10:32:00 -- Unsubscribe instructions: E-mail to [hidden email] /user/SendEmail.jtp?type=nodenode=3192084i=2 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 -- Unsubscribe instructions: E-mail to [hidden email] /user/SendEmail.jtp?type=nodenode=3192084i=3 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 If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/help-recovering-tp3191906p3192084.html To unsubscribe from help recovering?, click here http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=3191906code=SmVlcE51dEB6b2hvLmNvbXwzMTkxOTA2fC0yNzQwMDg1ODg=. -- View this message in context: http://nabble.documentfoundation.org/help-recovering-tp3191906p3194526.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@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: help recovering?
Oh wait, I have a bad feeling about this. You don't still have the Kwrite file? You took the Kwrite file into LibreOffice and started to edit it? Did it ever get save as a different file, or did you save it atop the Kwrite file, with the original no-file-extension name? I'd like to see that too. The list won't transfer attachments. But you can send it as an attachment to me directly. I am very curious what beast that is. - Dennis -Original Message- From: JeepNut [mailto:jeep...@zoho.com] Sent: Saturday, July 23, 2011 18:21 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: help recovering? Thanks for making a stab at this Tom. Here is the file. Was saved as a common text file originally with Kwrite so it had no file extension. Subsequently I got more complex with it and started edit it in LibreOffice. So I have to assume it saved as an .odt file, but the extension was never shown. Steve (aka JeepNut) On 07/22/2011 02:00 PM, Tom Davies [via Document Foundation Mail Archive] wrote: Hi :) If it's saved in odt or docX then you could try opening the file with an archive manager. I might be able to have a look in Ubuntu using LibreOffice 3.3.2 if you send me the attachment off-list. Regards from Tom :) From: John B [hidden email] /user/SendEmail.jtp?type=nodenode=3192084i=0 To: [hidden email] /user/SendEmail.jtp?type=nodenode=3192084i=1 Sent: Fri, 22 July, 2011 18:37:22 Subject: Re: [libreoffice-users] help recovering? I do not know if this will help, but viewers can be more forgiving than editors. Try http://www.officeviewers.com/ or http://visioo-writer.tuxfamily.org/EN/index_3.html if it does - you will have to copy paste back into LO again you might have to google a few more until you find one that works. regards John B -- On 22/07/2011 17:42, JeepNut wrote: Hoping for some good news here. Am using the openSuSE branded version of LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.3.1 on openSuSE 11.3 and KDE 4.4.4-1.5. Was editing a document that is pretty important (to me at least) and during the process had tried to add a footnote. I was editing the text in the footnote and almost immediately there was some flashing of the screen and LibreOffice crashed, locking up the entire PC. No mouse control, no keyboard control, nothing. So I had to reset the PC. Now the document is fubar. When I try to open it, LibreOffice attempts to recover but fails. Then it tries to repair the file but opens only a blank page. I've tried to open it without an extension and get a list of a variety of application types to attempt any modicum of recovery, but no matter what I try to open it with it either fails, or opens in a file of unreadable gibberish. I'd be THRILLED if someone would be able to actually recover this document for me. Nothing secret in it, I'd be happy to email it to anyone who'd like to give it a try. Even just to get back the text out of it so that I could rebuild would be fabulous. Any chance at all to recover? -- View this message in context: http://nabble.documentfoundation.org/help-recovering-tp3191906p3191906.html Sent from the Users mailing list archive at Nabble.com. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3781 - Release Date: 07/22/11 10:32:00 -- Unsubscribe instructions: E-mail to [hidden email] /user/SendEmail.jtp?type=nodenode=3192084i=2 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 -- Unsubscribe instructions: E-mail to [hidden email] /user/SendEmail.jtp?type=nodenode=3192084i=3 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 If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/help-recovering-tp3191906p3192084.html To unsubscribe from help recovering?, click here http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=3191906code=SmVlcE51dEB6b2hvLmNvbXwzMTkxOTA2fC0yNzQwMDg1ODg=. -- View this message in context: http://nabble.documentfoundation.org/help-recovering-tp3191906p3194526.html Sent from the Users mailing
RE: [libreoffice-users] Re: help recovering?
There should be a system log some place that provides any error codes and information that led to a spontaneous reboot. Perhaps even for a freeze, but less likely. I have the screen flash reboot from time to time and in my case it appears to be either USB faults (related to the Bluetooth keyboard and mouse, I think) or a PCI error which I am pretty sure is related to my graphics card (ATI HD 5900 series). Those have become rare, so my system seems to have stabilized (fingers-crossed). You should see if there is a GeForce diagnostic test for the 6800 GS. - Dennis -Original Message- From: JeepNut [mailto:jeep...@zoho.com] Sent: Saturday, July 23, 2011 18:13 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: help recovering? Thanks Tom. I understand and that's part of the mystery here. The longer story is that I've been having problems with the system spontaneously resetting or just freezing up like this for several months. At first, like many, I cried to myself in my personal system log about the upgrade to 11.3 being the problem, then about KDE being the problem, then about LibreOffice being the problem, but started to finally realize it cannot be that all the software suddenly became buggy. I kind of have to do that. I log my gripes rather than take them to a forum. After I've read and re-read my inane whining, I come to other conclusions. wink One of them was the perhaps a memory had failed. So I bought 2 new sticks about a month ago. Problems with Firefox have disappeared, it no longer crashes constantly and the same for several other unstable apps I had trouble with. Big improvement, but I still have trouble keeping specifically LibreOffice running for some reason and still have this freezing of the machine. Although the spontaneous reboots have not recurred. So I am intrigued with the idea that maybe the video card causes this. I'm going to pull the box open and try reseating it and see what happens afterward. Of course to know if that works will take some time. And it won't fix the immediate issue with this specific file, but maybe no further problems afterward. I haven't had luck with it so I'll send that along to you off list and hope for the best. BTW the cautions you give are well taken. But I'm an intermediate level hack w/ the PC. Been a PC hardware/software junkie since Kaypro 486 days and DOS 2.2. But that was before I saw the light and jumped on the Linux wagon. I've built several PC's over the years, this PC from scratch about 4 or 5 years ago and it's been very reliable and worked great until just recently. The graphics card in this one is XFX GEForce 6800 GS 256Mb and isn't very old. Maybe one year or less. I keep the dust off things internally about 2 or 3 times a year as the PC is in a clear arcylic case so it's easy to see when she's dirtied up. So the card fan can be observed functional and not terribly dusty at this time but it may benefit from being reseated. I'll do that and see what happens going forward. Thanks for that suggestion. Tom Davies wrote: Hi :) It's also not likely that a single app would crash the whole machine like that. One of the top 3 priorities of GnuLinux is that individual processes can fail without affecting the rest of the system. Hence no Bsods. Is your machine overheating severly? Are you using a laptop or something with inadequate cooling? Is your graphics card not pushed in properly or getting extremely hot? Ram-sticks or cpu? My money would be on the graphics chips over-heating or wobbly graphics card. If it is a desktop machine are you confident enough about opening the case and getting rid of some of the dust without touching any of the components or the mbord or anything? Which country are you in? In England the normal 3 pin mains earths the case so even though you would still need to turn off the machine at the back and at the wall you could remove static from your hands at that point by touching the case. In the US it could be dangerous to touch the case even with the power off. The static on your fingers and the oily grease even on carefully washed hands is enough to damage some components inside the machine so take care! Regards from Tom :) From: JeepNut lt;jeep...@zoho.comgt; To: users@global.libreoffice.org Sent: Fri, 22 July, 2011 17:42:36 Subject: [libreoffice-users] help recovering? Hoping for some good news here. Am using the openSuSE branded version of LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.3.1 on openSuSE 11.3 and KDE 4.4.4-1.5. Was editing a document that is pretty important (to me at least) and during the process had tried to add a footnote. I was editing the text in the footnote and almost immediately there was some flashing of the screen and LibreOffice crashed, locking up the entire PC. No mouse control, no keyboard
Re: [libreoffice-users] Re: help recovering?
Hi :) Hmmm. If the graphics card has been there for about a year then that's probably not the issue. If it was older then maybe it's fan might have stopped working and the machine shuts down when the gpu overheats. If the crashes had been happening ever since putting the new card in then wobbly card might make sense. Reseating the card might fix the issue but it's not as likely to be the problem as i first thought given that it's about a year or so since you put the card in. When you boot into openSUSE do you get a boot menu with choices such as mem-test and recovery mode. Recovery mode has a few house-keeping type clean-up tools such as clearing temp folders and caches and checking dependencies. Mem-test keeps running if given a chance but just 1 or 2 tests and a single pass should be enough. Press Esc to reboot rather than let it run too long. I don't think those are the problems but it's probably worth checking. I think the best chance is to use something like GPartEd to check the partitions and to create a new partition large enough to put a fresh install of openSUSE or another distro on. Then see if the new fresh install has the same problem with crashing. Regards from Tom :) From: JeepNut jeep...@zoho.com To: users@global.libreoffice.org Sent: Sun, 24 July, 2011 2:12:39 Subject: [libreoffice-users] Re: help recovering? Thanks Tom. I understand and that's part of the mystery here. The longer story is that I've been having problems with the system spontaneously resetting or just freezing up like this for several months. At first, like many, I cried to myself in my personal system log about the upgrade to 11.3 being the problem, then about KDE being the problem, then about LibreOffice being the problem, but started to finally realize it cannot be that all the software suddenly became buggy. I kind of have to do that. I log my gripes rather than take them to a forum. After I've read and re-read my inane whining, I come to other conclusions. wink One of them was the perhaps a memory had failed. So I bought 2 new sticks about a month ago. Problems with Firefox have disappeared, it no longer crashes constantly and the same for several other unstable apps I had trouble with. Big improvement, but I still have trouble keeping specifically LibreOffice running for some reason and still have this freezing of the machine. Although the spontaneous reboots have not recurred. So I am intrigued with the idea that maybe the video card causes this. I'm going to pull the box open and try reseating it and see what happens afterward. Of course to know if that works will take some time. And it won't fix the immediate issue with this specific file, but maybe no further problems afterward. I haven't had luck with it so I'll send that along to you off list and hope for the best. BTW the cautions you give are well taken. But I'm an intermediate level hack w/ the PC. Been a PC hardware/software junkie since Kaypro 486 days and DOS 2.2. But that was before I saw the light and jumped on the Linux wagon. I've built several PC's over the years, this PC from scratch about 4 or 5 years ago and it's been very reliable and worked great until just recently. The graphics card in this one is XFX GEForce 6800 GS 256Mb and isn't very old. Maybe one year or less. I keep the dust off things internally about 2 or 3 times a year as the PC is in a clear arcylic case so it's easy to see when she's dirtied up. So the card fan can be observed functional and not terribly dusty at this time but it may benefit from being reseated. I'll do that and see what happens going forward. Thanks for that suggestion. Tom Davies wrote: Hi :) It's also not likely that a single app would crash the whole machine like that. One of the top 3 priorities of GnuLinux is that individual processes can fail without affecting the rest of the system. Hence no Bsods. Is your machine overheating severly? Are you using a laptop or something with inadequate cooling? Is your graphics card not pushed in properly or getting extremely hot? Ram-sticks or cpu? My money would be on the graphics chips over-heating or wobbly graphics card. If it is a desktop machine are you confident enough about opening the case and getting rid of some of the dust without touching any of the components or the mbord or anything? Which country are you in? In England the normal 3 pin mains earths the case so even though you would still need to turn off the machine at the back and at the wall you could remove static from your hands at that point by touching the case. In the US it could be dangerous to touch the case even with the power off. The static on your fingers and the oily grease even on carefully washed hands is enough to damage some components inside the machine so take care! Regards from Tom :)
RE: [libreoffice-users] Re: help recovering?
Thanks for sending me the file. WinZip confirmed that the file is damaged and not usable. I looked at it in a hex editor and confirmed that it is indeed an ODF Text (.odt) file. The initial part of the Zip is there, and then suddenly the data is all zeros starting in the middle of a PNG image that is part of the document. The file is completely 00 bytes until nearly the end, where a part of the file entry for META-INF/manifest.xml appears. Even that appears to be damaged and the end of the file may have been truncated or not produced yet. There is no recoverable information of any value whatsoever in the file. Sorry, - Dennis -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Saturday, July 23, 2011 18:57 To: users@global.libreoffice.org Cc: 'JeepNut' Subject: RE: [libreoffice-users] Re: help recovering? Oh wait, I have a bad feeling about this. You don't still have the Kwrite file? You took the Kwrite file into LibreOffice and started to edit it? Did it ever get save as a different file, or did you save it atop the Kwrite file, with the original no-file-extension name? I'd like to see that too. The list won't transfer attachments. But you can send it as an attachment to me directly. I am very curious what beast that is. - Dennis -Original Message- From: JeepNut [mailto:jeep...@zoho.com] Sent: Saturday, July 23, 2011 18:21 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: help recovering? Thanks for making a stab at this Tom. Here is the file. Was saved as a common text file originally with Kwrite so it had no file extension. Subsequently I got more complex with it and started edit it in LibreOffice. So I have to assume it saved as an .odt file, but the extension was never shown. Steve (aka JeepNut) On 07/22/2011 02:00 PM, Tom Davies [via Document Foundation Mail Archive] wrote: Hi :) If it's saved in odt or docX then you could try opening the file with an archive manager. I might be able to have a look in Ubuntu using LibreOffice 3.3.2 if you send me the attachment off-list. Regards from Tom :) From: John B [hidden email] /user/SendEmail.jtp?type=nodenode=3192084i=0 To: [hidden email] /user/SendEmail.jtp?type=nodenode=3192084i=1 Sent: Fri, 22 July, 2011 18:37:22 Subject: Re: [libreoffice-users] help recovering? I do not know if this will help, but viewers can be more forgiving than editors. Try http://www.officeviewers.com/ or http://visioo-writer.tuxfamily.org/EN/index_3.html if it does - you will have to copy paste back into LO again you might have to google a few more until you find one that works. regards John B -- On 22/07/2011 17:42, JeepNut wrote: Hoping for some good news here. Am using the openSuSE branded version of LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.3.1 on openSuSE 11.3 and KDE 4.4.4-1.5. Was editing a document that is pretty important (to me at least) and during the process had tried to add a footnote. I was editing the text in the footnote and almost immediately there was some flashing of the screen and LibreOffice crashed, locking up the entire PC. No mouse control, no keyboard control, nothing. So I had to reset the PC. Now the document is fubar. When I try to open it, LibreOffice attempts to recover but fails. Then it tries to repair the file but opens only a blank page. I've tried to open it without an extension and get a list of a variety of application types to attempt any modicum of recovery, but no matter what I try to open it with it either fails, or opens in a file of unreadable gibberish. I'd be THRILLED if someone would be able to actually recover this document for me. Nothing secret in it, I'd be happy to email it to anyone who'd like to give it a try. Even just to get back the text out of it so that I could rebuild would be fabulous. Any chance at all to recover? -- View this message in context: http://nabble.documentfoundation.org/help-recovering-tp3191906p3191906.html Sent from the Users mailing list archive at Nabble.com. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3781 - Release Date: 07/22/11 10:32:00 -- Unsubscribe instructions: E-mail to [hidden email] /user/SendEmail.jtp?type=nodenode=3192084i=2 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 -- Unsubscribe instructions: E-mail to [hidden email] /user/SendEmail.jtp?type=nodenode=3192084i=3 Problems?