User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:47.0) Gecko/20100101 Firefox/47.0 Build Identifier: LibreOffice 5.2.0.4 conditional formatting makes Calc Crash every day in my work(Dept.finance). Sorry i'm tired to give more informations. Just test it. It´s easy to prove.The conditional formatting is in a mess completely,can not maitain when you set it, varies every day if you use this sheet,till calc can not respond or crashes directly. It's sure to be a bug, all version tested since I use V4.0. I always update to the newest version, but not yet see any improvements about this. Why? Reproducible: Always Steps to Reproduce: 1.no predictions. Just crash when it likes. 2. 3. Actual Results: crashes every day. Expected Results: no crash anymore, no change conditional formating original setup(because it makes conditional formating to a mess day by day till the sheet stop respond) [Information automatically included from LibreOffice] Locale: zh-CN Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: yes Reset User Profile?Yes
Would it be possible you attach some example file? (of course you need to sanitize your file, see https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission)
(In reply to Kevin from comment #0) I tried to create a new document with conditional formatting in version 5.2.0.4 and it works fine for me. So, please provide test document, otherwise it's not possible to know what the problem is. Also you can go to the LibreOffice Chinese discussion forum so we can discuss the issue： http://www.libreofficechina.org
Just try to do more copy and paste,drag to fill...etc.
Created attachment 126713 [details] Screen capture
Your conditional formatting will start to be more and more like this(picture attached.)
Created attachment 126716 [details] example file
(In reply to Julien Nabet from comment #1) > Would it be possible you attach some example file? > (of course you need to sanitize your file, see > https://wiki.documentfoundation.org/QA/Bugzilla/ > Sanitizing_Files_Before_Submission) Yes,sample file attached.
I did many fills and copy & paste operations in many different columns, but no crash. You could try getting a backtrace: https://wiki.documentfoundation.org/How_to_get_a_backtrace_with_WinDbg It would also be good to go through this checklist: https://wiki.documentfoundation.org/QA/FirstSteps Arch Linux 64-bit, KDE Plasma 5 Version: 5.3.0.0.alpha0+ Build ID: 5d8639aaf2f60157c99c3ee3a8bfa78e4efd010a CPU Threads: 8; OS Version: Linux 4.6; UI Render: default; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on August 9th 2016 Arch Linux 64-bit, KDE Plasma 5 Version: 5.2.0.4 Build ID: 5.2.0-1 CPU Threads: 8; OS Version: Linux 4.6; UI Render: default; Locale: fi-FI (fi_FI.UTF-8)
When you do a lot of copy/paste day by day. you will find the conditional formatting more and more orderless,and the calc will respond slowlier and slowlier,then more crashes till calc stop respond nothing.
Please consider giving WinDbg a try, then.
Hi bonbon, Could you please provide a backtrace so we can investigate it on our side? Meanwhile, setting this to NEEDINFO
There's been a lot of improvements from Markus (see https://cgit.freedesktop.org/libreoffice/core/log/?qt=author&q=markus). If you've got some time, you can give a try to a master daily build (see http://dev-builds.libreoffice.org/daily/master/)
(In reply to Julien Nabet from comment #12) > There's been a lot of improvements from Markus (see > https://cgit.freedesktop.org/libreoffice/core/log/?qt=author&q=markus). > If you've got some time, you can give a try to a master daily build (see > http://dev-builds.libreoffice.org/daily/master/) Yes, but nothing for this problem just as usual as all these years.
How about trying to get a backtrace?
I can feel this user You have to avoid copy/paste any cell inside a conditional formatting (CF) range if you wanna keep your sanity After a few copy/paste you end up with hundreds of lines in CF > manage and what looks like random different ranges They are not random tho, they just subdivide the cells copied so you can modify them individually (I guess). Not sure if this is trying to copy how excel does it because I dont use excel, but its not very intuitive or what the user expect at all To reproduce the crash you probably only have to copy and paste so many times that the list is so big that the computer cant handle it. Probably helps using a computer with low memory/cpu My 2cents
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20170727
Did you get any crashreport after it crashes?
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20180129
Bonbon: This problem must have been fixed in the fix of Bug 95295 - Calc is fragmenting ranges for conditional formats without need. I see on your screenshot that the conditional formatting are duplicating each time you copy-paste. I think that is why Calc crashes (I also guess you are using a low memory PC). So the issue must have been fixed already, please try a most recent release. For finance department use I suggest you use the “Still” version (稳定版), rather than Fresh version (最新版). By saying CRASHING here, I guess you mean that Calc is getting slow till no responding, but did not self-exit, am I correct?
No further info, closing.