Bug 144895 - very sluggish leaving a cell
Summary: very sluggish leaving a cell
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.1.2 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-10-03 15:49 UTC by Kristine
Modified: 2022-10-13 11:56 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
settings screen shot (70.35 KB, application/vnd.oasis.opendocument.text)
2021-10-04 15:10 UTC, Kristine
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Kristine 2021-10-03 15:49:43 UTC
It is taking 20 seconds to leave a cell after entering data and getting a "not responding".  I recreated my profile, I updated my version and it still happens.  When I deleted many columns with LOOKUPS on this sheet, it now is quicker, but I need those columns on the local sheet.  The spreadsheet is only 1.7MB and there are only 27 columns on the local sheet.  It happens on other sheets as well.  Any suggestions would be greatly appreciated.
Comment 1 m_a_riosv 2021-10-04 08:01:55 UTC
Please test if:
Menu/Tools/Options/LibreOffce calc/Calculate - Search criteria = and <> must apply to the whole cell.
Menu/Tools/Options/LibreOffce calc/Calculate - CPU threading setting is enable.
Menu/Tools/Options/LibreOffce/OpenCL is enabled.
Comment 2 Kristine 2021-10-04 15:10:20 UTC
Created attachment 175509 [details]
settings screen shot
Comment 3 QA Administrators 2021-10-05 04:19:41 UTC Comment hidden (obsolete)
Comment 4 Telesto 2021-10-09 18:06:40 UTC
It might be the user profile:

1. Start LibreOffice and select Help ▸ Restart in Safe Mode
2. In the Enter Safe Mode dialog select Restart
3. LibreOffice will restart and display the Safe Mode dialog
4. Select Continue in Safe Mode
5. Test and see if the problem is gone.

If the problem persists, you can exit the safe mode because the user profile was not the cause of the problem.
If the problem is solved, something is wrong with your configuration. Start LibreOffice in safe mode again to see the safe mode dialog. You can now try to disable Hardware acceleration or to restore/reset your user profile.

https://wiki.documentfoundation.org/UserProfile
Comment 5 Kristine 2021-10-09 20:23:44 UTC
Thank you.  In my original description I stated that I already recreated my profile and that did not solve the issue.  We should close this bug because I completely recreated my spreadsheet from scratch, then copied all of the RAW DATA into it and it is working great.  I don't know why that worked but I was desperate to fix it.  Thanks for trying.