Re: [libreoffice-users] Calc 5.0.3.2 AutoCalculate
This same behavior exists in 4.4.6.3 (Windows) Also in both cases my Conditional formatting gets turned off when I turn off AutoCalculate. Unexpected behavior. -- Jim -Original Message- From: "James E. Lang" <jim+...@lang.hm> To: LibreOffice Users <users@global.libreoffice.org> Sent: Sun, 22 Nov 2015 22:26 Subject: [libreoffice-users] Calc 5.0.3.2 AutoCalculate LO 5.0.3.2 Calc (Linux) I turned AutoCalculate off (Alt+T, N, C) but LO takes the same four minutes (plus or minus five seconds) to process a changed value in one cell as it took with AutoCalculate turned on. Does that make sense? If so, is there any other way to accelerate the entry or alteration of raw data? FWIW the spreadsheet has ~3,000 rows on each of two sheets and a total of ~300,000 formulas. -- Jim -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc 5.0.3.2 AutoCalculate
Hi: Excuse me because my words about memory weren't clear. I try to suggest: Tools-LibreOffice-Memory (I'm not sure but it would be) Regards, Jorge Rodríguez El lun, 23-11-2015 a las 10:50 -0800, James E. Lang escribió: > > > -Original Message- > From: jorge <jrodrigue...@cpcecr.com> > To: j...@lang.hm > Cc: users@global.libreoffice.org > Sent: Mon, 23 Nov 2015 7:50 > Subject: Re: [libreoffice-users] Calc 5.0.3.2 AutoCalculate > > Hi: > > I've had this kind of problem before. As I understand it is because > the spreadsheet has a lot of formulas into it. Then when you enter a > new value or formula to be calculate, it recalculate all formulas > again of the spreadsheet that you are using. > > I only can solve with uncheck autocalculate > > [Thank you Jorge but that's exactly what I reported trying in my > original message. It still takes the same four minutes after I enter > or revise a single value before it lets me do anything more _and_ the > hiding of conditional formatting when AutoCalculate is unchecked is > another _unexpected_and_undesirable_ behavior. Can anybody else > contribute a solution to my problem? -- jl] > > and continue working entering new data and when I have enough new > information, run autocalculate to update and review it. > > [Actually I intended to use F9 for this but maybe that's what you > mean. -- jl] > > I don't know if increase the memory improve the result of > autocalculate. > > [I remember recently seeing someone suggesting a memory tweak but I > don't recall what to try in that regard. The Linux version is running > on a laptop computer with a solid state disk drive and without > crowding memory. According to top, > > KiB Mem: 3072748 total, 2961416 used, 111332 free, 540732 buffers > KiB Swap: 7817776 total, 321948 used, 7495828 free, 571112 cached Men > > and for soffice.bin top reports > > VIRT 1599776 RES 385276 SHR 76000 %CPU 99.9 %MEM 12.5 > > With AutoCalculate unchecked I reentered the value 2.2 in cell AI1289 > and top recorded 3 minutes 59 seconds of CPU time consumed by > soffice.bin before that process returned to an idle state. > > My point is that AutoCalculate should not even be taking place since I > unchecked it but it obviously is. > > Once again, I am experiencing this issue in the Windows version of LO > 4.4.6.3 _and_ in the Linux version of LO 5.0.3.2. -- jl] > > I think that I had this problem before with different spreadsheet > package from different office suites. > > Regards, and hope this help, > > [Again I thank you for trying. Your suggestion obviously worked for > you but it's not working for me. -- jl] > > Jorge Rodríguez > > -- > Jim > > El dom, 22-11-2015 a las 23:32 -0800, James E Lang escribió: > > This same behavior exists in 4.4.6.3 (Windows) > > > > Also in both cases my Conditional formatting gets turned off when I > turn off AutoCalculate. Unexpected behavior. > > > > -- > > Jim > > > > -Original Message- > > From: "James E. Lang" <jim+...@lang.hm> > > To: LibreOffice Users <users@global.libreoffice.org> > > Sent: Sun, 22 Nov 2015 22:26 > > Subject: [libreoffice-users] Calc 5.0.3.2 AutoCalculate > > > > LO 5.0.3.2 Calc (Linux) > > > > I turned AutoCalculate off (Alt+T, N, C) but LO takes the same four > minutes (plus or minus five seconds) to process a changed value in one > cell as it took with AutoCalculate turned on. Does that make sense? If > so, is there any other way to accelerate the entry or alteration of > raw data? > > > > FWIW the spreadsheet has ~3,000 rows on each of two sheets and a > total of ~300,000 formulas. > > > > -- > > Jim > > > -- > Jim -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc 5.0.3.2 AutoCalculate
Hi: I've had this kind of problem before. As I understand it is because the spreadsheet has a lot of formulas into it. Then when you enter a new value or formula to be calculate, it recalcule all formulas again of the spredsheet that you are using. I only can solve with uncheck autocalculate and continue working entering new data and when I have enough new information, run autocalculate to update and review it. I don't know if increase the memory improve the result of autocalculate. I think that I had this problem before with different spreadsheet package from diferent office suites. Regards, and hope this help, Jorge Rodríguez El dom, 22-11-2015 a las 23:32 -0800, James E Lang escribió: > This same behavior exists in 4.4.6.3 (Windows) > > Also in both cases my Conditional formatting gets turned off when I turn off > AutoCalculate. Unexpected behavior. > > -- > Jim > > -Original Message- > From: "James E. Lang" <jim+...@lang.hm> > To: LibreOffice Users <users@global.libreoffice.org> > Sent: Sun, 22 Nov 2015 22:26 > Subject: [libreoffice-users] Calc 5.0.3.2 AutoCalculate > > LO 5.0.3.2 Calc (Linux) > > I turned AutoCalculate off (Alt+T, N, C) but LO takes the same four minutes > (plus or minus five seconds) to process a changed value in one cell as it > took with AutoCalculate turned on. Does that make sense? If so, is there any > other way to accelerate the entry or alteration of raw data? > > FWIW the spreadsheet has ~3,000 rows on each of two sheets and a total of > ~300,000 formulas. > > -- > Jim > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc 5.0.3.2 AutoCalculate
-Original Message- From: jorge <jrodrigue...@cpcecr.com> To: j...@lang.hm Cc: users@global.libreoffice.org Sent: Mon, 23 Nov 2015 7:50 Subject: Re: [libreoffice-users] Calc 5.0.3.2 AutoCalculate Hi: I've had this kind of problem before. As I understand it is because the spreadsheet has a lot of formulas into it. Then when you enter a new value or formula to be calculate, it recalculate all formulas again of the spreadsheet that you are using. I only can solve with uncheck autocalculate [Thank you Jorge but that's exactly what I reported trying in my original message. It still takes the same four minutes after I enter or revise a single value before it lets me do anything more _and_ the hiding of conditional formatting when AutoCalculate is unchecked is another _unexpected_and_undesirable_ behavior. Can anybody else contribute a solution to my problem? -- jl] and continue working entering new data and when I have enough new information, run autocalculate to update and review it. [Actually I intended to use F9 for this but maybe that's what you mean. -- jl] I don't know if increase the memory improve the result of autocalculate. [I remember recently seeing someone suggesting a memory tweak but I don't recall what to try in that regard. The Linux version is running on a laptop computer with a solid state disk drive and without crowding memory. According to top, KiB Mem: 3072748 total, 2961416 used, 111332 free, 540732 buffers KiB Swap: 7817776 total, 321948 used, 7495828 free, 571112 cached Men and for soffice.bin top reports VIRT 1599776 RES 385276 SHR 76000 %CPU 99.9 %MEM 12.5 With AutoCalculate unchecked I reentered the value 2.2 in cell AI1289 and top recorded 3 minutes 59 seconds of CPU time consumed by soffice.bin before that process returned to an idle state. My point is that AutoCalculate should not even be taking place since I unchecked it but it obviously is. Once again, I am experiencing this issue in the Windows version of LO 4.4.6.3 _and_ in the Linux version of LO 5.0.3.2. -- jl] I think that I had this problem before with different spreadsheet package from different office suites. Regards, and hope this help, [Again I thank you for trying. Your suggestion obviously worked for you but it's not working for me. -- jl] Jorge Rodríguez -- Jim El dom, 22-11-2015 a las 23:32 -0800, James E Lang escribió: > This same behavior exists in 4.4.6.3 (Windows) > > Also in both cases my Conditional formatting gets turned off when I turn off > AutoCalculate. Unexpected behavior. > > -- > Jim > > -Original Message- > From: "James E. Lang" <jim+...@lang.hm> > To: LibreOffice Users <users@global.libreoffice.org> > Sent: Sun, 22 Nov 2015 22:26 > Subject: [libreoffice-users] Calc 5.0.3.2 AutoCalculate > > LO 5.0.3.2 Calc (Linux) > > I turned AutoCalculate off (Alt+T, N, C) but LO takes the same four minutes > (plus or minus five seconds) to process a changed value in one cell as it > took with AutoCalculate turned on. Does that make sense? If so, is there any > other way to accelerate the entry or alteration of raw data? > > FWIW the spreadsheet has ~3,000 rows on each of two sheets and a total of > ~300,000 formulas. > > -- > Jim -- Jim -- 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] Calc 5.0.3.2 AutoCalculate
LO 5.0.3.2 Calc (Linux) I turned AutoCalculate off (Alt+T, N, C) but LO takes the same four minutes (plus or minus five seconds) to process a changed value in one cell as it took with AutoCalculate turned on. Does that make sense? If so, is there any other way to accelerate the entry or alteration of raw data? FWIW the spreadsheet has ~3,000 rows on each of two sheets and a total of ~300,000 formulas. -- Jim -- 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
