LibreOffice Version: 7.0.3.1 and Ubuntu 20.10. Reference file: http://bergheat.ingalsuo.fi/Bergheat46.ods Try changing the value of cell $BERGHEAT.H22 from its drop-down menu. No dice. Has been successful in the past. $BERGHEAT.H22 cell selection affects many Bergheat46 cells. The same problem has occurred in the $BERGHEAT.G35 cell. This cell also has an effect on many other cells. For other menu cells that affect only a few cells, there is no problem.
confirm 100% CPU load, memory leak over 2 Gb and LO hangs when I just select H22 cell on BERGHEAT sheet in Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 9d8accf03984a64a4105826e55b221962628eb93 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL and in LO 5.0 32 bit I got Bad allocation error but no problem in LO 4.4.7 => regression
Created attachment 170446 [details] File from link in description
Created attachment 170455 [details] perf flamegraph Here's a Flamegraph on pc Debian x86-64 with master sources updated today.
Noel/Eike: anything in the Flamegraph which would explain the hang?
This isn't a perf issue, something is generating an insanely long chunk of text as a validation string, and then something else is taking a very very long time to display that insanely long string.
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/924733c65902d0b17764aded56c88c99d4b9a568 tdf#140986 hang in validity message It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I've made it so the display doesn't lock up the UI, but someone else will need to fix the validity message issue.
I gave a new try with the patch, it still hangs. Also, this only 1MB file takes quite some time (about 40s) to open (Ryzen 5 with 32GB) with gen rendering (so no accessibility part that we can see with gtk3), it's another pb but quite annoying for just testing some behavior.
Noel Grandin committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/b6e705ec690b9911ce44f3e6cb1273737449f186 tdf#140986 hang in validity message It will be available in 7.1.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I have now edited by LibreOffice file Bergheat46.ods data validation message text lines shorter, and the problem seems to have disappeared. New edited version: http://bergheat.ingalsuo.fi/Bergheat46.ods Would it be appropriate for the admin to add here [https://help.libreoffice.org/latest/ka/text/scalc/guide/validity.html] information about the allowed validation text format? Thanks for help!
Attached is the file (Bergheat46_114_BUG.ods) where the error occurs. To view the front page of the file (BERGHEAT), select the contents of cell E128 by selecting: Data / Validity / Input Help Appears: ¤¤¤ choose [On] tai [Ei] If you select [On], enter in the adjacent box distance in meters now in sizing from the existing mine. ¤¤¤ Originally it looked like this: ¤¤¤ choose [On] or [No] If you select [On], enter in the adjacent box distance in meters now in sizing from the existing well. ¤¤¤ Why is changing. The change occurs when you save the file and then reopen it. There are more invisible characters between these ( [On] or [No] ), why? If you save that file and again open it, it will be more invisible characters between ( [On] or [No] ). LibreCalc generates invisible characters by itself.!
Created attachment 171381 [details] Bug in this file..
(In reply to Paavo Ingalsuo from comment #12) > Attached is the file (Bergheat46_114_bug140986.ods) where the error occurs. > To view the front page of the file (BERGHEAT), select the contents of cell > E128 by selecting: Data / Validity / Input Help > Appears: > ¤¤¤ > choose > [On] tai [Ei] > > If you select [On], > enter in the adjacent box > distance in meters > now in sizing > from the existing mine. > ¤¤¤ > Originally it looked like this: > ¤¤¤ > choose > [On] or [No] > > If you select [On], > enter in the adjacent box > distance in meters > now in sizing > from the existing well. > ¤¤¤ > Why is changing. > The change occurs when you save the file and then reopen it. > There are more invisible characters between these ( [On] or [No] ), why? > If you save that file and again open it, it will be more invisible > characters between ( [On] or [No] ). > LibreCalc generates invisible characters by itself.!
The drop down is working well in Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: 54387d1d35cb79a30be208052831de74efd8b2f2 CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded About cell E128, if you select that cell and go to Data - Validity - Criteria and change from Ei/On to On/No, you will have what you need it.
(In reply to Paavo Ingalsuo from comment #12) > Attached is the file (Bergheat46_114_BUG.ods) where the error occurs. > To view the front page of the file (BERGHEAT), select the contents of cell > E128 by selecting: Data / Validity / Input Help > Appears: > ¤¤¤ > choose > [On] tai [Ei] > > If you select [On], > enter in the adjacent box > distance in meters > now in sizing > from the existing mine. > ¤¤¤ > Originally it looked like this: > ¤¤¤ > choose > [On] or [No] > > If you select [On], > enter in the adjacent box > distance in meters > now in sizing > from the existing well. > ¤¤¤ > Why is changing. > The change occurs when you save the file and then reopen it. > There are more invisible characters between these ( [On] or [No] ), why? > If you save that file and again open it, it will be more invisible > characters between ( [On] or [No] ). > LibreCalc generates invisible characters by itself.! That is bug 137945 - please try upgrading to 7.0.6 or 7.1.
Created attachment 173268 [details] Minimized example file With the commits above I was able to copy-paste the offending cell to a new file. When you try to open the Data - Validity - Input help tab, Calc still freezes. This happens ever since 4.2, in 4.1 the Input Help tab opened, but without contents in the Input help box. Looking at the xml of the file, the Input help is not extensively huge (it's like 8 paragraphs including some empty ones) but contains some formatting markup which is kinda odd, given that this dialog does not offer formatting options for the Input help text.
Still freeze in Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 14844d835cc5d6dfde499a0b1074aea5dcff4fc7 CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded