Re: [libreoffice-users] Intermittent Calc Issues
Hi, remember me? Got it all fixed. Remember, I was having the problem on a 4 month old HP Probook laptop with Windows 7. The goofy highlighting problem was due to a Windows setting in the control panel, in the ease of access settings, then in my keyboard settings. The random insertion of characters was due to a Microsoft Mouse driver, that either was corrupt, had corrupted, or conflicted with memory allocations. It just didn't behave! Typical Microsoft. I do apologize thinking that it was only LibreOffice. I started noticing it in Thunderbird also. I noticed it in Windows Explorer. How did I arrive at all these conclusions? No tech help! I prayed about it. And my prayers were answered. And it all works beautifully. Greg On 8/5/2014 3:35 AM, Tom Davies wrote: Hi :) Perhaps try renaming your User Profile? Sudden change in behavior or weird wonkiness might be down to something going wonky in the User Profile; https://wiki.documentfoundation.org/UserProfile Renaming the profile means you can still get back to it if it doesn't fix things so it's a good way to get back to factory defaults. Good luck and regards from Tom :) On 5 August 2014 07:58, Brian Barker b.m.bar...@btinternet.com mailto:b.m.bar...@btinternet.com wrote: At 22:25 04/08/2014 -0500, Gregory Forster wrote: I have an inconsistent and not often issue with Calc. [...] Calc does weird things now and then. [...] Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. [...] This all started in early July. [...] I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. What, you mean that LibreOffice - in many different versions - is improperly sharing memory with other programs for you but not for anyone else? And why would that behaviour change in early July? Perhaps you should sack your tech. My questions are: Has anyone else experienced the same? I doubt it - at least, not as a problem with the software. Does my reasoning sound feasible? Nope. Any ideas? If you spend a lot of time on one project or using one application, it is very easy to blame a more general problem with your computer on the particular application. o Try draining the spilt coffee from your keyboard. o Try shaking the biscuit crumbs from your keyboard. o Try poking out the cat hairs from your keyboard. o Try running your computer manufacturer's diagnostics (especially those for the keyboard). o Try attaching an external keyboard and using for a sufficient period to test. o Does your notebook have a trackpad? Is your thumb or palm grazing the trackpad as you move your fingers about? You won't believe this is possible, so get someone else to watch as you use the system for a period. Try temporarily disabling the trackpad or reducing its sensitivity to test. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org mailto:users%2bunsubscr...@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 --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.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] Intermittent Calc Issues
Not sure; it's just a possibility to rule out. One possible explanation is that the seemingly stuck key doesn't have any effect in other applications you use. In Gnucash, Shift+Arrow keys or Shift+Click just moves the selection - the same as just pressing the arrow keys or clicking without holding Shift - so you may not notice if Shift was stuck. In LO Calc, Shift+Arrow or Shift+Click selects a range of cells rather than moving the selection, so you do notice different behaviour. In the case of the Shift key appearing stuck you'd notice it as soon as you type a letter and get upper case instead of lower case though... but perhaps you usually want to start with an upper case letter anyway so press and release shift while typing that letter - and releasing the key would likely clear the fault for the following lower case letter. Since this only seems to happen occasionally, if you're not able to change the keyboard long term perhaps just carry on as normal and next time it does start happening try pressing (and releasing) each of the Ctrl, Alt and Shift keys in turn (remember there are often two of each, so press and release both in turn). If that then clears the faulty behaviour, it sounds even more like a faulty keyboard / cable / hub - doing this sends a key down and key up message for each key, and chances are that this time the key up messages get through OK indicating to the PC that the key is no longer held down. Or it may not the problem in your case - as I said, just a possibility to rule out. I have experienced strange symptoms like you describe before which did turn out to be a faulty keyboard, USB hub or cable (can't remember exactly which bit of hardware was at fault, but the symptom was that the PC would occasionally act as if a key was held down even though it wasn't, and pressing and releasing that key would clear the fault). Mark. Gregory Forster wrote: Hi Mark, That gives me something else to try - plugging in another keyboard. This notebook computer is still under warranty and now would be the time to find out. But what still puzzles me, is why only Calc? Why doesn't it affect any other program? I extensively use Gnucash also. One thing I failed to mention, all my Gnucash files, as well as many personal LO medical and financial files are encrypted using Truecrypt. I have Truecrypt running to access Gnucash as well as many personal medical and financial files (IRA spreadsheet). But, as I told Tom, I've completed my IRA spreadshheet, so now I have to think up of some other elaborate spreadsheet. Greg On 8/6/2014 11:42 AM, Mark Bourne wrote: To rule out the keyboard possibility, perhaps try a different keyboard, plugged directly into the PC (no USB hubs or other cables in between). I've previously found that a faulty keyboard (or USB cable or hub between keyboard and PC) can act as if keys get stuck down (seems like the PC sometimes gets the key down message but not the key up message, so thinks it's still held down). A stuck character key is usually obvious as it keeps repeating, but not so obvious with Ctrl, Alt, Shift, etc. which only have an effect when you press something else - which then doesn't do what you expect. If pressing and releasing keys a few times unsticks them (PC gets the key up message this time), which it sounds like you've found with the shift key, that may well be the cause. I'm not sure if combinations of Ctrl, Alt, Shift or other keys along with those you're pressing can cause the effects you describe. Perhaps more likely if you're using the numpad arrows (rather than the separate arrow keys) as those keys can enter other characters when Alt is held down - e.g. for me Alt+822 (up, down, down) gives 6 and Alt+826 (up, down, right) gives :. Certainly Shift + Click or arrow keys selects an area rather than moving the active cell. Mark. Gregory Forster wrote: Woops, I meant to click the spell-check and not the send. That all explains well for the unexplained highlighting, but what about the random ;6 (semi-colon and the number six) at times, or the random : (colon) at times, replacing cell contents by just pressing a directional arrow key. That, I can't figure out. No, I won't sack my tech (he's my son - we work together). It ONLY happens with LO Calc, not Impress, or Writer, or Base, or any other program. In fact, I extensively use Gnucash. I am the Treasurer, Financial Accountant and do the payroll for church and also use Gnucash for personal finance records - No problems. However, you did give me ideas and reminders. I've always been very passionate about backups and keeping your hard drive clean from malware, viruses, rootkits, etc. of which we also nag our clients about.. I forgot about keeping the keyboard clean. Thank you. Greg On 8/5/2014 1:58 AM, Brian Barker wrote: At 22:25 04/08/2014 -0500, Gregory Forster wrote: I have an inconsistent and not often issue with Calc. [...] Calc does weird things
Re: [libreoffice-users] Intermittent Calc Issues
To rule out the keyboard possibility, perhaps try a different keyboard, plugged directly into the PC (no USB hubs or other cables in between). I've previously found that a faulty keyboard (or USB cable or hub between keyboard and PC) can act as if keys get stuck down (seems like the PC sometimes gets the key down message but not the key up message, so thinks it's still held down). A stuck character key is usually obvious as it keeps repeating, but not so obvious with Ctrl, Alt, Shift, etc. which only have an effect when you press something else - which then doesn't do what you expect. If pressing and releasing keys a few times unsticks them (PC gets the key up message this time), which it sounds like you've found with the shift key, that may well be the cause. I'm not sure if combinations of Ctrl, Alt, Shift or other keys along with those you're pressing can cause the effects you describe. Perhaps more likely if you're using the numpad arrows (rather than the separate arrow keys) as those keys can enter other characters when Alt is held down - e.g. for me Alt+822 (up, down, down) gives 6 and Alt+826 (up, down, right) gives :. Certainly Shift + Click or arrow keys selects an area rather than moving the active cell. Mark. Gregory Forster wrote: Woops, I meant to click the spell-check and not the send. That all explains well for the unexplained highlighting, but what about the random ;6 (semi-colon and the number six) at times, or the random : (colon) at times, replacing cell contents by just pressing a directional arrow key. That, I can't figure out. No, I won't sack my tech (he's my son - we work together). It ONLY happens with LO Calc, not Impress, or Writer, or Base, or any other program. In fact, I extensively use Gnucash. I am the Treasurer, Financial Accountant and do the payroll for church and also use Gnucash for personal finance records - No problems. However, you did give me ideas and reminders. I've always been very passionate about backups and keeping your hard drive clean from malware, viruses, rootkits, etc. of which we also nag our clients about.. I forgot about keeping the keyboard clean. Thank you. Greg On 8/5/2014 1:58 AM, Brian Barker wrote: At 22:25 04/08/2014 -0500, Gregory Forster wrote: I have an inconsistent and not often issue with Calc. [...] Calc does weird things now and then. [...] Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. [...] This all started in early July. [...] I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. What, you mean that LibreOffice - in many different versions - is improperly sharing memory with other programs for you but not for anyone else? And why would that behaviour change in early July? Perhaps you should sack your tech. My questions are: Has anyone else experienced the same? I doubt it - at least, not as a problem with the software. Does my reasoning sound feasible? Nope. Any ideas? If you spend a lot of time on one project or using one application, it is very easy to blame a more general problem with your computer on the particular application. o Try draining the spilt coffee from your keyboard. o Try shaking the biscuit crumbs from your keyboard. o Try poking out the cat hairs from your keyboard. o Try running your computer manufacturer's diagnostics (especially those for the keyboard). o Try attaching an external keyboard and using for a sufficient period to test. o Does your notebook have a trackpad? Is your thumb or palm grazing the trackpad as you move your fingers about? You won't believe this is possible, so get someone else to watch as you use the system for a period. Try temporarily disabling the trackpad or reducing its sensitivity to test. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Intermittent Calc Issues
Hi Mark, That gives me something else to try - plugging in another keyboard. This notebook computer is still under warranty and now would be the time to find out. But what still puzzles me, is why only Calc? Why doesn't it affect any other program? I extensively use Gnucash also. One thing I failed to mention, all my Gnucash files, as well as many personal LO medical and financial files are encrypted using Truecrypt. I have Truecrypt running to access Gnucash as well as many personal medical and financial files (IRA spreadsheet). But, as I told Tom, I've completed my IRA spreadshheet, so now I have to think up of some other elaborate spreadsheet. Greg On 8/6/2014 11:42 AM, Mark Bourne wrote: To rule out the keyboard possibility, perhaps try a different keyboard, plugged directly into the PC (no USB hubs or other cables in between). I've previously found that a faulty keyboard (or USB cable or hub between keyboard and PC) can act as if keys get stuck down (seems like the PC sometimes gets the key down message but not the key up message, so thinks it's still held down). A stuck character key is usually obvious as it keeps repeating, but not so obvious with Ctrl, Alt, Shift, etc. which only have an effect when you press something else - which then doesn't do what you expect. If pressing and releasing keys a few times unsticks them (PC gets the key up message this time), which it sounds like you've found with the shift key, that may well be the cause. I'm not sure if combinations of Ctrl, Alt, Shift or other keys along with those you're pressing can cause the effects you describe. Perhaps more likely if you're using the numpad arrows (rather than the separate arrow keys) as those keys can enter other characters when Alt is held down - e.g. for me Alt+822 (up, down, down) gives 6 and Alt+826 (up, down, right) gives :. Certainly Shift + Click or arrow keys selects an area rather than moving the active cell. Mark. Gregory Forster wrote: Woops, I meant to click the spell-check and not the send. That all explains well for the unexplained highlighting, but what about the random ;6 (semi-colon and the number six) at times, or the random : (colon) at times, replacing cell contents by just pressing a directional arrow key. That, I can't figure out. No, I won't sack my tech (he's my son - we work together). It ONLY happens with LO Calc, not Impress, or Writer, or Base, or any other program. In fact, I extensively use Gnucash. I am the Treasurer, Financial Accountant and do the payroll for church and also use Gnucash for personal finance records - No problems. However, you did give me ideas and reminders. I've always been very passionate about backups and keeping your hard drive clean from malware, viruses, rootkits, etc. of which we also nag our clients about.. I forgot about keeping the keyboard clean. Thank you. Greg On 8/5/2014 1:58 AM, Brian Barker wrote: At 22:25 04/08/2014 -0500, Gregory Forster wrote: I have an inconsistent and not often issue with Calc. [...] Calc does weird things now and then. [...] Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. [...] This all started in early July. [...] I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. What, you mean that LibreOffice - in many different versions - is improperly sharing memory with other programs for you but not for anyone else? And why would that behaviour change in early July? Perhaps you should sack your tech. My questions are: Has anyone else experienced the same? I doubt it - at least, not as a problem with the software. Does my reasoning sound feasible? Nope. Any ideas? If you spend a lot of time on one project or using one application, it is very easy to blame a more general problem with your computer on the particular application. o Try draining the spilt coffee from your keyboard. o Try shaking the biscuit crumbs from your keyboard. o Try poking out the cat hairs from your keyboard. o Try running your computer manufacturer's diagnostics (especially those for the keyboard). o Try attaching an external keyboard and using for a sufficient period to test. o Does your notebook have a trackpad? Is your thumb or palm grazing the trackpad as
Re: [libreoffice-users] Intermittent Calc Issues
Hi: It would be about the amount memory assigned in Calc (Menu: Tools- Options - Memory) Regards, Jorge Rodríguez El lun, 04-08-2014 a las 22:25 -0500, Gregory Forster escribió: Hi, I haven't been on this users group for over two years, primarily because everything worked great, until now. I have an inconsistent and not often issue with Calc. Well, it's more annoying than anything else, because I can easily correct it, but it shouldn't be. Calc does weird things now and then. I was creating an elaborate spreadsheet file consisting of 13 worksheets to record my wife's and mine different Roth and Traditional IRAs vested in Mutual Funds. Each worksheet shows the DATE, transaction DESCRIPTION, DEBIT, CREDIT, share PRICE, SHAREs obtained, share BALANCE, $ AMOUNT (share PRICE * share BALANCE), percentage of gain or loss both yearly and per investment, all in separate columns. Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. As I said, these issues are very inconsistent. They may not happen for days, then after a few days, they may happen several times, then intermittent, or not at all. This all started in early July. I ran anti-malware scanners, anti-virus scanners, cleaned the registry, and defragged. I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. I have installed some new software, some with start up files. Those software programs were not really all that important, so I deleted them, the registry entries, and any start up files. However, the IRA spreadsheet file is all done, and I don't know if I'll still have those issue until I start another spreadsheet project. This is all done on an HP Probook 440 G1 14 notebook with a Jan 2014 UEFI, an Intel dual core I3 2.4Ghz Haswell, 4GB DDR3L, and Windows 7 64 bit home premium purchased late last March. My questions are: Has anyone else experienced the same? Does my reasoning sound feasible? Any ideas? Greg --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Intermittent Calc Issues
At 22:25 04/08/2014 -0500, Gregory Forster wrote: I have an inconsistent and not often issue with Calc. [...] Calc does weird things now and then. [...] Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. [...] This all started in early July. [...] I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. What, you mean that LibreOffice - in many different versions - is improperly sharing memory with other programs for you but not for anyone else? And why would that behaviour change in early July? Perhaps you should sack your tech. My questions are: Has anyone else experienced the same? I doubt it - at least, not as a problem with the software. Does my reasoning sound feasible? Nope. Any ideas? If you spend a lot of time on one project or using one application, it is very easy to blame a more general problem with your computer on the particular application. o Try draining the spilt coffee from your keyboard. o Try shaking the biscuit crumbs from your keyboard. o Try poking out the cat hairs from your keyboard. o Try running your computer manufacturer's diagnostics (especially those for the keyboard). o Try attaching an external keyboard and using for a sufficient period to test. o Does your notebook have a trackpad? Is your thumb or palm grazing the trackpad as you move your fingers about? You won't believe this is possible, so get someone else to watch as you use the system for a period. Try temporarily disabling the trackpad or reducing its sensitivity to test. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Intermittent Calc Issues
Hi :) Perhaps try renaming your User Profile? Sudden change in behavior or weird wonkiness might be down to something going wonky in the User Profile; https://wiki.documentfoundation.org/UserProfile Renaming the profile means you can still get back to it if it doesn't fix things so it's a good way to get back to factory defaults. Good luck and regards from Tom :) On 5 August 2014 07:58, Brian Barker b.m.bar...@btinternet.com wrote: At 22:25 04/08/2014 -0500, Gregory Forster wrote: I have an inconsistent and not often issue with Calc. [...] Calc does weird things now and then. [...] Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. [...] This all started in early July. [...] I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. What, you mean that LibreOffice - in many different versions - is improperly sharing memory with other programs for you but not for anyone else? And why would that behaviour change in early July? Perhaps you should sack your tech. My questions are: Has anyone else experienced the same? I doubt it - at least, not as a problem with the software. Does my reasoning sound feasible? Nope. Any ideas? If you spend a lot of time on one project or using one application, it is very easy to blame a more general problem with your computer on the particular application. o Try draining the spilt coffee from your keyboard. o Try shaking the biscuit crumbs from your keyboard. o Try poking out the cat hairs from your keyboard. o Try running your computer manufacturer's diagnostics (especially those for the keyboard). o Try attaching an external keyboard and using for a sufficient period to test. o Does your notebook have a trackpad? Is your thumb or palm grazing the trackpad as you move your fingers about? You won't believe this is possible, so get someone else to watch as you use the system for a period. Try temporarily disabling the trackpad or reducing its sensitivity to test. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Intermittent Calc Issues
Thank you. Come to think of it, I can switch the touch-pad off. When cells were highlighted, I did alternately keep pressing the shift keys, That cleared that up. This notepad does have a spill resistant keyboard where there is a mylar film under the keys. On 8/5/2014 1:58 AM, Brian Barker wrote: At 22:25 04/08/2014 -0500, Gregory Forster wrote: I have an inconsistent and not often issue with Calc. [...] Calc does weird things now and then. [...] Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. [...] This all started in early July. [...] I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. What, you mean that LibreOffice - in many different versions - is improperly sharing memory with other programs for you but not for anyone else? And why would that behaviour change in early July? Perhaps you should sack your tech. My questions are: Has anyone else experienced the same? I doubt it - at least, not as a problem with the software. Does my reasoning sound feasible? Nope. Any ideas? If you spend a lot of time on one project or using one application, it is very easy to blame a more general problem with your computer on the particular application. o Try draining the spilt coffee from your keyboard. o Try shaking the biscuit crumbs from your keyboard. o Try poking out the cat hairs from your keyboard. o Try running your computer manufacturer's diagnostics (especially those for the keyboard). o Try attaching an external keyboard and using for a sufficient period to test. o Does your notebook have a trackpad? Is your thumb or palm grazing the trackpad as you move your fingers about? You won't believe this is possible, so get someone else to watch as you use the system for a period. Try temporarily disabling the trackpad or reducing its sensitivity to test. I trust this helps. Brian Barker . --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.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] Intermittent Calc Issues
I played with that also. Thank you. On 8/5/2014 1:32 AM, jorge wrote: Hi: It would be about the amount memory assigned in Calc (Menu: Tools- Options - Memory) Regards, Jorge Rodríguez El lun, 04-08-2014 a las 22:25 -0500, Gregory Forster escribió: Hi, I haven't been on this users group for over two years, primarily because everything worked great, until now. I have an inconsistent and not often issue with Calc. Well, it's more annoying than anything else, because I can easily correct it, but it shouldn't be. Calc does weird things now and then. I was creating an elaborate spreadsheet file consisting of 13 worksheets to record my wife's and mine different Roth and Traditional IRAs vested in Mutual Funds. Each worksheet shows the DATE, transaction DESCRIPTION, DEBIT, CREDIT, share PRICE, SHAREs obtained, share BALANCE, $ AMOUNT (share PRICE * share BALANCE), percentage of gain or loss both yearly and per investment, all in separate columns. Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. As I said, these issues are very inconsistent. They may not happen for days, then after a few days, they may happen several times, then intermittent, or not at all. This all started in early July. I ran anti-malware scanners, anti-virus scanners, cleaned the registry, and defragged. I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. I have installed some new software, some with start up files. Those software programs were not really all that important, so I deleted them, the registry entries, and any start up files. However, the IRA spreadsheet file is all done, and I don't know if I'll still have those issue until I start another spreadsheet project. This is all done on an HP Probook 440 G1 14 notebook with a Jan 2014 UEFI, an Intel dual core I3 2.4Ghz Haswell, 4GB DDR3L, and Windows 7 64 bit home premium purchased late last March. My questions are: Has anyone else experienced the same? Does my reasoning sound feasible? Any ideas? Greg --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.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] Intermittent Calc Issues
I do use LO on my desktop. However, I do not use it as extensively. My son also has it on his laptop, but does not use it very extensively. Greg On 8/4/2014 11:46 PM, Jean-Francois Nifenecker wrote: Hi, Le 05/08/2014 05:25, Gregory Forster a écrit : Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. As your problems seem to arise while using the keyboard (the mouse symptom seems related to the shift key being seen as pressed), I'm wondering if your laptop keyboard has no problem. Did you test LO and your spreadsheet on some other hardware? --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.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] Intermittent Calc Issues
Hi :) A Reply to all goes to the whole mailing list and can cover multiple issues. I'm glad to hear that playing with the keys did the trick! Fantastic answer! I'm not on the GnuCash mailing list. Well, i might have posted once or twice several years ago but i doubt that is remembered! Still it's good to be reminded that there LibreOffice fits neatly into a wider eco-system of office apps. Renaming the User Profile is marginally better than deleting it. It means you can easily return things to the way they were. It's a good plan to create a copy of a User Profile that does work so that if trouble strikes then you have a back-up that you can return to! (i rarely remember until after it's too late) Anyway congrats on success with the ingenious answer! Regards from Tom :) On 5 August 2014 18:02, Gregory Forster fgre...@gmail.com wrote: Thank you. Come to think of it, I can switch the touch-pad off. When cells were highlighted, I did alternately keep pressing the shift keys, That cleared that up. This notepad does have a spill resistant keyboard where there is a mylar film under the keys. On 8/5/2014 1:58 AM, Brian Barker wrote: At 22:25 04/08/2014 -0500, Gregory Forster wrote: I have an inconsistent and not often issue with Calc. [...] Calc does weird things now and then. [...] Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. [...] This all started in early July. [...] I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. What, you mean that LibreOffice - in many different versions - is improperly sharing memory with other programs for you but not for anyone else? And why would that behaviour change in early July? Perhaps you should sack your tech. My questions are: Has anyone else experienced the same? I doubt it - at least, not as a problem with the software. Does my reasoning sound feasible? Nope. Any ideas? If you spend a lot of time on one project or using one application, it is very easy to blame a more general problem with your computer on the particular application. o Try draining the spilt coffee from your keyboard. o Try shaking the biscuit crumbs from your keyboard. o Try poking out the cat hairs from your keyboard. o Try running your computer manufacturer's diagnostics (especially those for the keyboard). o Try attaching an external keyboard and using for a sufficient period to test. o Does your notebook have a trackpad? Is your thumb or palm grazing the trackpad as you move your fingers about? You won't believe this is possible, so get someone else to watch as you use the system for a period. Try temporarily disabling the trackpad or reducing its sensitivity to test. I trust this helps. Brian Barker . --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Intermittent Calc Issues
Thanks Tom, Actually, I deleted the user profile a few times and started over from scratch. BTW, are you the same that's on the Gnucash usergroup emails now and then? Greg On 8/5/2014 3:35 AM, Tom Davies wrote: Hi :) Perhaps try renaming your User Profile? Sudden change in behavior or weird wonkiness might be down to something going wonky in the User Profile; https://wiki.documentfoundation.org/UserProfile Renaming the profile means you can still get back to it if it doesn't fix things so it's a good way to get back to factory defaults. Good luck and regards from Tom :) On 5 August 2014 07:58, Brian Barker b.m.bar...@btinternet.com mailto:b.m.bar...@btinternet.com wrote: At 22:25 04/08/2014 -0500, Gregory Forster wrote: I have an inconsistent and not often issue with Calc. [...] Calc does weird things now and then. [...] Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. [...] This all started in early July. [...] I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. What, you mean that LibreOffice - in many different versions - is improperly sharing memory with other programs for you but not for anyone else? And why would that behaviour change in early July? Perhaps you should sack your tech. My questions are: Has anyone else experienced the same? I doubt it - at least, not as a problem with the software. Does my reasoning sound feasible? Nope. Any ideas? If you spend a lot of time on one project or using one application, it is very easy to blame a more general problem with your computer on the particular application. o Try draining the spilt coffee from your keyboard. o Try shaking the biscuit crumbs from your keyboard. o Try poking out the cat hairs from your keyboard. o Try running your computer manufacturer's diagnostics (especially those for the keyboard). o Try attaching an external keyboard and using for a sufficient period to test. o Does your notebook have a trackpad? Is your thumb or palm grazing the trackpad as you move your fingers about? You won't believe this is possible, so get someone else to watch as you use the system for a period. Try temporarily disabling the trackpad or reducing its sensitivity to test. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org mailto:users%2bunsubscr...@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 --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.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] Intermittent Calc Issues
Woops, I meant to click the spell-check and not the send. That all explains well for the unexplained highlighting, but what about the random ;6 (semi-colon and the number six) at times, or the random : (colon) at times, replacing cell contents by just pressing a directional arrow key. That, I can't figure out. No, I won't sack my tech (he's my son - we work together). It ONLY happens with LO Calc, not Impress, or Writer, or Base, or any other program. In fact, I extensively use Gnucash. I am the Treasurer, Financial Accountant and do the payroll for church and also use Gnucash for personal finance records - No problems. However, you did give me ideas and reminders. I've always been very passionate about backups and keeping your hard drive clean from malware, viruses, rootkits, etc. of which we also nag our clients about.. I forgot about keeping the keyboard clean. Thank you. Greg On 8/5/2014 1:58 AM, Brian Barker wrote: At 22:25 04/08/2014 -0500, Gregory Forster wrote: I have an inconsistent and not often issue with Calc. [...] Calc does weird things now and then. [...] Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. [...] This all started in early July. [...] I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. What, you mean that LibreOffice - in many different versions - is improperly sharing memory with other programs for you but not for anyone else? And why would that behaviour change in early July? Perhaps you should sack your tech. My questions are: Has anyone else experienced the same? I doubt it - at least, not as a problem with the software. Does my reasoning sound feasible? Nope. Any ideas? If you spend a lot of time on one project or using one application, it is very easy to blame a more general problem with your computer on the particular application. o Try draining the spilt coffee from your keyboard. o Try shaking the biscuit crumbs from your keyboard. o Try poking out the cat hairs from your keyboard. o Try running your computer manufacturer's diagnostics (especially those for the keyboard). o Try attaching an external keyboard and using for a sufficient period to test. o Does your notebook have a trackpad? Is your thumb or palm grazing the trackpad as you move your fingers about? You won't believe this is possible, so get someone else to watch as you use the system for a period. Try temporarily disabling the trackpad or reducing its sensitivity to test. I trust this helps. Brian Barker . --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.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] Intermittent Calc Issues
Hi Tom:) I was so sure you were on the Gnucash site, oh well. I don't know anymore weird things are still going on. My elaborate spreadsheet is complete. I'll just have to wait to do another fancy spreadsheet. However, I DID vacuum, with brush, my keyboard. Greg On 8/5/2014 5:14 PM, Tom Davies wrote: Hi :) I think the comment about sacking your tech support was meant as a joke. I think we kinda assume people who reach this mailing-list probably ARE the tech support. I'm sure everyone makes amusing blunders at times. Easier to laugh about it after recovery! Wrt keyboards i can never figure out why so many paper-clips still getting trapped in there when i haven't even used any in about 10 years. Maybe my coat-hangers regress into paper-clips as i never have enough of them. Is there still a problem with some weird things still going on? It sounded like you had solved the issues .. Regards from Tom :) On 5 August 2014 18:22, Gregory Forster fgre...@gmail.com mailto:fgre...@gmail.com wrote: Woops, I meant to click the spell-check and not the send. That all explains well for the unexplained highlighting, but what about the random ;6 (semi-colon and the number six) at times, or the random : (colon) at times, replacing cell contents by just pressing a directional arrow key. That, I can't figure out. No, I won't sack my tech (he's my son - we work together). It ONLY happens with LO Calc, not Impress, or Writer, or Base, or any other program. In fact, I extensively use Gnucash. I am the Treasurer, Financial Accountant and do the payroll for church and also use Gnucash for personal finance records - No problems. However, you did give me ideas and reminders. I've always been very passionate about backups and keeping your hard drive clean from malware, viruses, rootkits, etc. of which we also nag our clients about.. I forgot about keeping the keyboard clean. Thank you. Greg On 8/5/2014 1:58 AM, Brian Barker wrote: At 22:25 04/08/2014 -0500, Gregory Forster wrote: I have an inconsistent and not often issue with Calc. [...] Calc does weird things now and then. [...] Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. [...] This all started in early July. [...] I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. What, you mean that LibreOffice - in many different versions - is improperly sharing memory with other programs for you but not for anyone else? And why would that behaviour change in early July? Perhaps you should sack your tech. My questions are: Has anyone else experienced the same? I doubt it - at least, not as a problem with the software. Does my reasoning sound feasible? Nope. Any ideas? If you spend a lot of time on one project or using one application, it is very easy to blame a more general problem with your computer on the particular application. o Try draining the spilt coffee from your keyboard. o Try shaking the biscuit crumbs from your keyboard. o Try poking out the cat hairs from your keyboard. o Try running your computer manufacturer's diagnostics (especially those for the keyboard). o Try attaching an external keyboard and using for a sufficient period to test. o Does your notebook have a trackpad? Is your thumb or palm grazing the trackpad as you move your fingers about? You won't believe this is possible, so get someone else to watch as you use the system for a period. Try temporarily disabling the trackpad or reducing its sensitivity to test. I trust this helps. Brian Barker . --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com -- To unsubscribe e-mail to:
Re: [libreoffice-users] Intermittent Calc Issues
Hi :) I think the comment about sacking your tech support was meant as a joke. I think we kinda assume people who reach this mailing-list probably ARE the tech support. I'm sure everyone makes amusing blunders at times. Easier to laugh about it after recovery! Wrt keyboards i can never figure out why so many paper-clips still getting trapped in there when i haven't even used any in about 10 years. Maybe my coat-hangers regress into paper-clips as i never have enough of them. Is there still a problem with some weird things still going on? It sounded like you had solved the issues .. Regards from Tom :) On 5 August 2014 18:22, Gregory Forster fgre...@gmail.com wrote: Woops, I meant to click the spell-check and not the send. That all explains well for the unexplained highlighting, but what about the random ;6 (semi-colon and the number six) at times, or the random : (colon) at times, replacing cell contents by just pressing a directional arrow key. That, I can't figure out. No, I won't sack my tech (he's my son - we work together). It ONLY happens with LO Calc, not Impress, or Writer, or Base, or any other program. In fact, I extensively use Gnucash. I am the Treasurer, Financial Accountant and do the payroll for church and also use Gnucash for personal finance records - No problems. However, you did give me ideas and reminders. I've always been very passionate about backups and keeping your hard drive clean from malware, viruses, rootkits, etc. of which we also nag our clients about.. I forgot about keeping the keyboard clean. Thank you. Greg On 8/5/2014 1:58 AM, Brian Barker wrote: At 22:25 04/08/2014 -0500, Gregory Forster wrote: I have an inconsistent and not often issue with Calc. [...] Calc does weird things now and then. [...] Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. [...] This all started in early July. [...] I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. What, you mean that LibreOffice - in many different versions - is improperly sharing memory with other programs for you but not for anyone else? And why would that behaviour change in early July? Perhaps you should sack your tech. My questions are: Has anyone else experienced the same? I doubt it - at least, not as a problem with the software. Does my reasoning sound feasible? Nope. Any ideas? If you spend a lot of time on one project or using one application, it is very easy to blame a more general problem with your computer on the particular application. o Try draining the spilt coffee from your keyboard. o Try shaking the biscuit crumbs from your keyboard. o Try poking out the cat hairs from your keyboard. o Try running your computer manufacturer's diagnostics (especially those for the keyboard). o Try attaching an external keyboard and using for a sufficient period to test. o Does your notebook have a trackpad? Is your thumb or palm grazing the trackpad as you move your fingers about? You won't believe this is possible, so get someone else to watch as you use the system for a period. Try temporarily disabling the trackpad or reducing its sensitivity to test. I trust this helps. Brian Barker . --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.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
[libreoffice-users] Intermittent Calc Issues
Hi, I haven't been on this users group for over two years, primarily because everything worked great, until now. I have an inconsistent and not often issue with Calc. Well, it's more annoying than anything else, because I can easily correct it, but it shouldn't be. Calc does weird things now and then. I was creating an elaborate spreadsheet file consisting of 13 worksheets to record my wife's and mine different Roth and Traditional IRAs vested in Mutual Funds. Each worksheet shows the DATE, transaction DESCRIPTION, DEBIT, CREDIT, share PRICE, SHAREs obtained, share BALANCE, $ AMOUNT (share PRICE * share BALANCE), percentage of gain or loss both yearly and per investment, all in separate columns. Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. As I said, these issues are very inconsistent. They may not happen for days, then after a few days, they may happen several times, then intermittent, or not at all. This all started in early July. I ran anti-malware scanners, anti-virus scanners, cleaned the registry, and defragged. I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. I have installed some new software, some with start up files. Those software programs were not really all that important, so I deleted them, the registry entries, and any start up files. However, the IRA spreadsheet file is all done, and I don't know if I'll still have those issue until I start another spreadsheet project. This is all done on an HP Probook 440 G1 14 notebook with a Jan 2014 UEFI, an Intel dual core I3 2.4Ghz Haswell, 4GB DDR3L, and Windows 7 64 bit home premium purchased late last March. My questions are: Has anyone else experienced the same? Does my reasoning sound feasible? Any ideas? Greg --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.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] Intermittent Calc Issues
Hi, Le 05/08/2014 05:25, Gregory Forster a écrit : Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. As your problems seem to arise while using the keyboard (the mouse symptom seems related to the shift key being seen as pressed), I'm wondering if your laptop keyboard has no problem. Did you test LO and your spreadsheet on some other hardware? -- Jean-Francois Nifenecker, Bordeaux -- 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