LibreOffice Calc goes grey takes lots of CPU cycles
When working on the Calc (spreadsheet) many time the screen goes grey and CPU cycle shoots up to 100% for a very long time and the app is not responsive. Also slows down other open apps etc due to CPU being at 100%. Is there anyway this can be avoided?
The file size doesn't really matter as it happens with having only one sheet with simple data as well as file with several sheets and calculations. Running Ubuntu 11.10 on a Dell Inspiron 1300 with 2 GB ram and Intel Celeron 1.5 GHz CPU. Long time sometimes over 2 mins. I haven't used Top but can give it a try if I knew what it is
- Changing the Graphic cache user for liberoffice did not really change anything.
libreoffice
add a comment |
When working on the Calc (spreadsheet) many time the screen goes grey and CPU cycle shoots up to 100% for a very long time and the app is not responsive. Also slows down other open apps etc due to CPU being at 100%. Is there anyway this can be avoided?
The file size doesn't really matter as it happens with having only one sheet with simple data as well as file with several sheets and calculations. Running Ubuntu 11.10 on a Dell Inspiron 1300 with 2 GB ram and Intel Celeron 1.5 GHz CPU. Long time sometimes over 2 mins. I haven't used Top but can give it a try if I knew what it is
- Changing the Graphic cache user for liberoffice did not really change anything.
libreoffice
1
Insufficient data - how big is the file? Is the sheet calculation-intensive? Are you using a low-end CPU or low on RAM? How long is a 'very long' time? Are you running macros or scripts on the sheet? What other applications do you have open at the time? Have you used 'top' to check for other resource hogs?
– user535733
Mar 3 '12 at 23:11
The file size doesn't really matter as it happens with having only one sheet with simple data as well as file with several sheets and calculations. Running Ubuntu 11.10 on a Dell Inspiron 1300 with 2 GB ram and Intel Celeron 1.5 GHz CPU. Long time sometimes over 2 mins. I haven't used Top but can give it a try if I knew what it is :-)
– user35021
Mar 6 '12 at 2:43
Could it be that there's a formula that's faulty? Is there a formula common to all your problematic sheets or files? And you can use theman
command to see whattop
does. You would typeman top
in a terminal.Top
is present by default on your Ubuntu.
– user25656
Mar 8 '12 at 3:30
I have the same problem with Calc. Just scrolling through big spreadsheet selecting rows. Tried the Anti-aliasing and graphics cache below, with no effect. Where should we log this kind of problem ?
– Pieter
Sep 18 '15 at 10:52
add a comment |
When working on the Calc (spreadsheet) many time the screen goes grey and CPU cycle shoots up to 100% for a very long time and the app is not responsive. Also slows down other open apps etc due to CPU being at 100%. Is there anyway this can be avoided?
The file size doesn't really matter as it happens with having only one sheet with simple data as well as file with several sheets and calculations. Running Ubuntu 11.10 on a Dell Inspiron 1300 with 2 GB ram and Intel Celeron 1.5 GHz CPU. Long time sometimes over 2 mins. I haven't used Top but can give it a try if I knew what it is
- Changing the Graphic cache user for liberoffice did not really change anything.
libreoffice
When working on the Calc (spreadsheet) many time the screen goes grey and CPU cycle shoots up to 100% for a very long time and the app is not responsive. Also slows down other open apps etc due to CPU being at 100%. Is there anyway this can be avoided?
The file size doesn't really matter as it happens with having only one sheet with simple data as well as file with several sheets and calculations. Running Ubuntu 11.10 on a Dell Inspiron 1300 with 2 GB ram and Intel Celeron 1.5 GHz CPU. Long time sometimes over 2 mins. I haven't used Top but can give it a try if I knew what it is
- Changing the Graphic cache user for liberoffice did not really change anything.
libreoffice
libreoffice
edited Mar 8 '12 at 1:39
Jorge Castro
36.4k105422617
36.4k105422617
asked Mar 3 '12 at 22:49
user35021user35021
2112
2112
1
Insufficient data - how big is the file? Is the sheet calculation-intensive? Are you using a low-end CPU or low on RAM? How long is a 'very long' time? Are you running macros or scripts on the sheet? What other applications do you have open at the time? Have you used 'top' to check for other resource hogs?
– user535733
Mar 3 '12 at 23:11
The file size doesn't really matter as it happens with having only one sheet with simple data as well as file with several sheets and calculations. Running Ubuntu 11.10 on a Dell Inspiron 1300 with 2 GB ram and Intel Celeron 1.5 GHz CPU. Long time sometimes over 2 mins. I haven't used Top but can give it a try if I knew what it is :-)
– user35021
Mar 6 '12 at 2:43
Could it be that there's a formula that's faulty? Is there a formula common to all your problematic sheets or files? And you can use theman
command to see whattop
does. You would typeman top
in a terminal.Top
is present by default on your Ubuntu.
– user25656
Mar 8 '12 at 3:30
I have the same problem with Calc. Just scrolling through big spreadsheet selecting rows. Tried the Anti-aliasing and graphics cache below, with no effect. Where should we log this kind of problem ?
– Pieter
Sep 18 '15 at 10:52
add a comment |
1
Insufficient data - how big is the file? Is the sheet calculation-intensive? Are you using a low-end CPU or low on RAM? How long is a 'very long' time? Are you running macros or scripts on the sheet? What other applications do you have open at the time? Have you used 'top' to check for other resource hogs?
– user535733
Mar 3 '12 at 23:11
The file size doesn't really matter as it happens with having only one sheet with simple data as well as file with several sheets and calculations. Running Ubuntu 11.10 on a Dell Inspiron 1300 with 2 GB ram and Intel Celeron 1.5 GHz CPU. Long time sometimes over 2 mins. I haven't used Top but can give it a try if I knew what it is :-)
– user35021
Mar 6 '12 at 2:43
Could it be that there's a formula that's faulty? Is there a formula common to all your problematic sheets or files? And you can use theman
command to see whattop
does. You would typeman top
in a terminal.Top
is present by default on your Ubuntu.
– user25656
Mar 8 '12 at 3:30
I have the same problem with Calc. Just scrolling through big spreadsheet selecting rows. Tried the Anti-aliasing and graphics cache below, with no effect. Where should we log this kind of problem ?
– Pieter
Sep 18 '15 at 10:52
1
1
Insufficient data - how big is the file? Is the sheet calculation-intensive? Are you using a low-end CPU or low on RAM? How long is a 'very long' time? Are you running macros or scripts on the sheet? What other applications do you have open at the time? Have you used 'top' to check for other resource hogs?
– user535733
Mar 3 '12 at 23:11
Insufficient data - how big is the file? Is the sheet calculation-intensive? Are you using a low-end CPU or low on RAM? How long is a 'very long' time? Are you running macros or scripts on the sheet? What other applications do you have open at the time? Have you used 'top' to check for other resource hogs?
– user535733
Mar 3 '12 at 23:11
The file size doesn't really matter as it happens with having only one sheet with simple data as well as file with several sheets and calculations. Running Ubuntu 11.10 on a Dell Inspiron 1300 with 2 GB ram and Intel Celeron 1.5 GHz CPU. Long time sometimes over 2 mins. I haven't used Top but can give it a try if I knew what it is :-)
– user35021
Mar 6 '12 at 2:43
The file size doesn't really matter as it happens with having only one sheet with simple data as well as file with several sheets and calculations. Running Ubuntu 11.10 on a Dell Inspiron 1300 with 2 GB ram and Intel Celeron 1.5 GHz CPU. Long time sometimes over 2 mins. I haven't used Top but can give it a try if I knew what it is :-)
– user35021
Mar 6 '12 at 2:43
Could it be that there's a formula that's faulty? Is there a formula common to all your problematic sheets or files? And you can use the
man
command to see what top
does. You would type man top
in a terminal. Top
is present by default on your Ubuntu.– user25656
Mar 8 '12 at 3:30
Could it be that there's a formula that's faulty? Is there a formula common to all your problematic sheets or files? And you can use the
man
command to see what top
does. You would type man top
in a terminal. Top
is present by default on your Ubuntu.– user25656
Mar 8 '12 at 3:30
I have the same problem with Calc. Just scrolling through big spreadsheet selecting rows. Tried the Anti-aliasing and graphics cache below, with no effect. Where should we log this kind of problem ?
– Pieter
Sep 18 '15 at 10:52
I have the same problem with Calc. Just scrolling through big spreadsheet selecting rows. Tried the Anti-aliasing and graphics cache below, with no effect. Where should we log this kind of problem ?
– Pieter
Sep 18 '15 at 10:52
add a comment |
3 Answers
3
active
oldest
votes
Open any LibreOffice application. In the Tool-bar under "Tools" use the drop-down and open "options" look for "memory". This setting as well as others will help limit CPU cycles and decrease lag time.
I'm just wondering whether reducing theUse for LibreOffice
inGraphics cache
will help or have the opposite effect. I've sometimes encountered problems similar to what OP has reported, but then mostly withWriter
and rarely withCalc
. The settings are as shown in the graphic above. The OS is 11.10 (Unity 3D) on a Dell Inspiron 1545 laptop with 4 GB RAM. I don't do too many things at one time ... maybe listen to music (Totem), have a few tabs open in Firefox and LibreOffice. My non-technical opinion is that there are some situations that cause LibreOffice to go crazy.
– user25656
Mar 4 '12 at 4:59
Changing the Graphic cache user for liberoffice did not really change anything.
– user35021
Mar 6 '12 at 5:48
add a comment |
I've found workaround: go to "Tools/Options/View" and uncheck "Graphics output: Anti-aliasing". Works for me. I've posted bug report here. Maybe it's your case too.
add a comment |
November 17, 2018
Ubuntu 16.04.5 Libreoffice Version: 6.0.5.2 Memory 7.1 GiB,
Processor: AMD A8-5600K APU with Radeon(tm) HD Graphics × 4 , 64 bit
Graphics: AMD ARUBA (DRM 2.50.0 / 4.15.0-39-generic, LLVM 6.0.0)
Libreoffice setting: "Tools/Options/View" and uncheck "Graphics output: Anti-aliasing".
Works for me; went from pathetic to super speed instantaneously.
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f109772%2flibreoffice-calc-goes-grey-takes-lots-of-cpu-cycles%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
Open any LibreOffice application. In the Tool-bar under "Tools" use the drop-down and open "options" look for "memory". This setting as well as others will help limit CPU cycles and decrease lag time.
I'm just wondering whether reducing theUse for LibreOffice
inGraphics cache
will help or have the opposite effect. I've sometimes encountered problems similar to what OP has reported, but then mostly withWriter
and rarely withCalc
. The settings are as shown in the graphic above. The OS is 11.10 (Unity 3D) on a Dell Inspiron 1545 laptop with 4 GB RAM. I don't do too many things at one time ... maybe listen to music (Totem), have a few tabs open in Firefox and LibreOffice. My non-technical opinion is that there are some situations that cause LibreOffice to go crazy.
– user25656
Mar 4 '12 at 4:59
Changing the Graphic cache user for liberoffice did not really change anything.
– user35021
Mar 6 '12 at 5:48
add a comment |
Open any LibreOffice application. In the Tool-bar under "Tools" use the drop-down and open "options" look for "memory". This setting as well as others will help limit CPU cycles and decrease lag time.
I'm just wondering whether reducing theUse for LibreOffice
inGraphics cache
will help or have the opposite effect. I've sometimes encountered problems similar to what OP has reported, but then mostly withWriter
and rarely withCalc
. The settings are as shown in the graphic above. The OS is 11.10 (Unity 3D) on a Dell Inspiron 1545 laptop with 4 GB RAM. I don't do too many things at one time ... maybe listen to music (Totem), have a few tabs open in Firefox and LibreOffice. My non-technical opinion is that there are some situations that cause LibreOffice to go crazy.
– user25656
Mar 4 '12 at 4:59
Changing the Graphic cache user for liberoffice did not really change anything.
– user35021
Mar 6 '12 at 5:48
add a comment |
Open any LibreOffice application. In the Tool-bar under "Tools" use the drop-down and open "options" look for "memory". This setting as well as others will help limit CPU cycles and decrease lag time.
Open any LibreOffice application. In the Tool-bar under "Tools" use the drop-down and open "options" look for "memory". This setting as well as others will help limit CPU cycles and decrease lag time.
answered Mar 4 '12 at 0:07
RingtailRingtail
13.5k1249176
13.5k1249176
I'm just wondering whether reducing theUse for LibreOffice
inGraphics cache
will help or have the opposite effect. I've sometimes encountered problems similar to what OP has reported, but then mostly withWriter
and rarely withCalc
. The settings are as shown in the graphic above. The OS is 11.10 (Unity 3D) on a Dell Inspiron 1545 laptop with 4 GB RAM. I don't do too many things at one time ... maybe listen to music (Totem), have a few tabs open in Firefox and LibreOffice. My non-technical opinion is that there are some situations that cause LibreOffice to go crazy.
– user25656
Mar 4 '12 at 4:59
Changing the Graphic cache user for liberoffice did not really change anything.
– user35021
Mar 6 '12 at 5:48
add a comment |
I'm just wondering whether reducing theUse for LibreOffice
inGraphics cache
will help or have the opposite effect. I've sometimes encountered problems similar to what OP has reported, but then mostly withWriter
and rarely withCalc
. The settings are as shown in the graphic above. The OS is 11.10 (Unity 3D) on a Dell Inspiron 1545 laptop with 4 GB RAM. I don't do too many things at one time ... maybe listen to music (Totem), have a few tabs open in Firefox and LibreOffice. My non-technical opinion is that there are some situations that cause LibreOffice to go crazy.
– user25656
Mar 4 '12 at 4:59
Changing the Graphic cache user for liberoffice did not really change anything.
– user35021
Mar 6 '12 at 5:48
I'm just wondering whether reducing the
Use for LibreOffice
in Graphics cache
will help or have the opposite effect. I've sometimes encountered problems similar to what OP has reported, but then mostly with Writer
and rarely with Calc
. The settings are as shown in the graphic above. The OS is 11.10 (Unity 3D) on a Dell Inspiron 1545 laptop with 4 GB RAM. I don't do too many things at one time ... maybe listen to music (Totem), have a few tabs open in Firefox and LibreOffice. My non-technical opinion is that there are some situations that cause LibreOffice to go crazy.– user25656
Mar 4 '12 at 4:59
I'm just wondering whether reducing the
Use for LibreOffice
in Graphics cache
will help or have the opposite effect. I've sometimes encountered problems similar to what OP has reported, but then mostly with Writer
and rarely with Calc
. The settings are as shown in the graphic above. The OS is 11.10 (Unity 3D) on a Dell Inspiron 1545 laptop with 4 GB RAM. I don't do too many things at one time ... maybe listen to music (Totem), have a few tabs open in Firefox and LibreOffice. My non-technical opinion is that there are some situations that cause LibreOffice to go crazy.– user25656
Mar 4 '12 at 4:59
Changing the Graphic cache user for liberoffice did not really change anything.
– user35021
Mar 6 '12 at 5:48
Changing the Graphic cache user for liberoffice did not really change anything.
– user35021
Mar 6 '12 at 5:48
add a comment |
I've found workaround: go to "Tools/Options/View" and uncheck "Graphics output: Anti-aliasing". Works for me. I've posted bug report here. Maybe it's your case too.
add a comment |
I've found workaround: go to "Tools/Options/View" and uncheck "Graphics output: Anti-aliasing". Works for me. I've posted bug report here. Maybe it's your case too.
add a comment |
I've found workaround: go to "Tools/Options/View" and uncheck "Graphics output: Anti-aliasing". Works for me. I've posted bug report here. Maybe it's your case too.
I've found workaround: go to "Tools/Options/View" and uncheck "Graphics output: Anti-aliasing". Works for me. I've posted bug report here. Maybe it's your case too.
answered Mar 6 '12 at 10:46
AlexanderAlexander
1
1
add a comment |
add a comment |
November 17, 2018
Ubuntu 16.04.5 Libreoffice Version: 6.0.5.2 Memory 7.1 GiB,
Processor: AMD A8-5600K APU with Radeon(tm) HD Graphics × 4 , 64 bit
Graphics: AMD ARUBA (DRM 2.50.0 / 4.15.0-39-generic, LLVM 6.0.0)
Libreoffice setting: "Tools/Options/View" and uncheck "Graphics output: Anti-aliasing".
Works for me; went from pathetic to super speed instantaneously.
add a comment |
November 17, 2018
Ubuntu 16.04.5 Libreoffice Version: 6.0.5.2 Memory 7.1 GiB,
Processor: AMD A8-5600K APU with Radeon(tm) HD Graphics × 4 , 64 bit
Graphics: AMD ARUBA (DRM 2.50.0 / 4.15.0-39-generic, LLVM 6.0.0)
Libreoffice setting: "Tools/Options/View" and uncheck "Graphics output: Anti-aliasing".
Works for me; went from pathetic to super speed instantaneously.
add a comment |
November 17, 2018
Ubuntu 16.04.5 Libreoffice Version: 6.0.5.2 Memory 7.1 GiB,
Processor: AMD A8-5600K APU with Radeon(tm) HD Graphics × 4 , 64 bit
Graphics: AMD ARUBA (DRM 2.50.0 / 4.15.0-39-generic, LLVM 6.0.0)
Libreoffice setting: "Tools/Options/View" and uncheck "Graphics output: Anti-aliasing".
Works for me; went from pathetic to super speed instantaneously.
November 17, 2018
Ubuntu 16.04.5 Libreoffice Version: 6.0.5.2 Memory 7.1 GiB,
Processor: AMD A8-5600K APU with Radeon(tm) HD Graphics × 4 , 64 bit
Graphics: AMD ARUBA (DRM 2.50.0 / 4.15.0-39-generic, LLVM 6.0.0)
Libreoffice setting: "Tools/Options/View" and uncheck "Graphics output: Anti-aliasing".
Works for me; went from pathetic to super speed instantaneously.
answered Nov 17 '18 at 20:23
RaleightomRaleightom
12
12
add a comment |
add a comment |
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f109772%2flibreoffice-calc-goes-grey-takes-lots-of-cpu-cycles%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Insufficient data - how big is the file? Is the sheet calculation-intensive? Are you using a low-end CPU or low on RAM? How long is a 'very long' time? Are you running macros or scripts on the sheet? What other applications do you have open at the time? Have you used 'top' to check for other resource hogs?
– user535733
Mar 3 '12 at 23:11
The file size doesn't really matter as it happens with having only one sheet with simple data as well as file with several sheets and calculations. Running Ubuntu 11.10 on a Dell Inspiron 1300 with 2 GB ram and Intel Celeron 1.5 GHz CPU. Long time sometimes over 2 mins. I haven't used Top but can give it a try if I knew what it is :-)
– user35021
Mar 6 '12 at 2:43
Could it be that there's a formula that's faulty? Is there a formula common to all your problematic sheets or files? And you can use the
man
command to see whattop
does. You would typeman top
in a terminal.Top
is present by default on your Ubuntu.– user25656
Mar 8 '12 at 3:30
I have the same problem with Calc. Just scrolling through big spreadsheet selecting rows. Tried the Anti-aliasing and graphics cache below, with no effect. Where should we log this kind of problem ?
– Pieter
Sep 18 '15 at 10:52