Created attachment 115707 [details] testcase I've got a spreadsheet containing dates with conditional formats based on how late or early these dates are, conditions like 'cell value is greater than now()'. Unfortunately there is no way to force the update of conditional formatting: F9 and shift-F9 have no effect, only after a cell of the spreadsheet - any cell, even the one not involved in conditional formatting, is actually modified formats finally change. I find it quite awkward and would like calc to update conditional formats based on volatile functions when F9 is pressed the same way the data based on volatile functions is updated. I am attaching a simple testcase wich doesn't require waiting for a certain time. Orange background is applied to cell A1 if its value (0.5) is greater than rand(). Start modifying other cells randomly - orange background starts changing on and off. Now start pressing F9 or shift-F9: nothing happens.
Hi @lvm, thanks for reporting. I think Conditional Format does their own calculations and needs the: Menu/Tools/Cells content/Autocalculate activated. Your sample file has it activated and works fine for me, any place I modify a cell and A1 background color it's update. Win7x64 Version: 4.4.3.2 Build ID: 88805f81e9fe61362df02b9941de8e38a9b5fd16
I am afraid you missed my point: in this testcase background color should change when F9 and/or shift-F9 is pressed alone, with no modification to any of the cells. Definitely when Shift-F9 is pressed. And yes, I do have tools.cell content.autocalculate checked.
F9 works (cond format is changing) with LO 4.4.3, win7
Still not working for me with 4.4.3.2 windows 7. Not even in D5 :)
version is oldest
Inputting random things to cells works, but F9 doesn't. Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+ Build ID: d8208da8576874fdb07014287e6cbc0aeba741bb TinderBox: Win-x86@39, Branch:master, Time: 2015-05-23_09:23:03 Locale: fi-FI (fi_FI)
Now I noticed, that F9 does work, but I have to switch focus to some other window! So the painting update seems broken.
That should ideally be fixed now with the listener based conditional format code.
(In reply to Markus Mohrhard from comment #8) > That should ideally be fixed now with the listener based conditional format > code. No, I still see the problem I mentioned in comment 7. Win 7 Pro 64-bit Version: 5.2.0.0.alpha0+ Build ID: b0e678c86136ef6d65cea66168a99217664c0278 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@42, Branch:master, Time: 2016-04-11_23:06:28 Locale: fi-FI (fi_FI)
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.2.7 or 5.3.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170522
still reproducible in 5.3.3.2 for win-32
Should not be too difficult to fix.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1ce2d70bc29b348f2f819d616a897e1dcb6a1a9f tdf#91385, recalc cond format formulas during hard recalc It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=be7203eca9745bd39d167777d7ec824954b3e4c0 add test for tdf#91385 It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.