Created attachment 79062 [details] viewing the lack of formulas Steps to reproduce: - Open a new spreadsheet - Enter values as shown in attached screen shot - Apply a Conditional Formatting in the range A1:A10 Icon Set - 3 Arrows Select "formula" for both thresholds and enter: =B4 in the 1st one =B5 in the 2nd Ok Ok When changing values in cells B4 and B5, arrows are properly modified, but: - only after Ctrl+Shift+F9 - when returning in CF with Manage, formulas are no more displayed (as you can see on the screen shot) and then: - leaving CF Manage by Cancel preserves the formulas - leaving CF Manage by Ok causes the loss of formulas Formulas are not lost when saving the file Version 4.0.2.2 (Build ID: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3) Version 4.0.3.3 (Build ID: 0eaa50a932c8f2199a615e1eb30f7ac74279539) Vista-32b
Hello Michel, I reproduce this behavior with LO 4.0.2.2, Windows 7 Home Premium. So i set Status to NEW. Have a nice day, Jacques Guilleron
Hello some more details... I reproduce the bug via Conditional Formatting> Manage> Edit but not if I select the range and then use Conditional Formatting> Condition Tested with Windows 7 64bits and Version 4.0.3.3 (Build ID: 0eaa50a932c8f2199a615e1eb30f7ac74279539) Regards Pierre-Yves
I don't see the problem with the missing formulas in master any more. I'll have a look at the updating problem.
Hi Markus, Indeed, this bug is still present in: Version 4.0.4.2 (Build ID: 9e9821abd0ffdbc09cd8c52eaa574fa09eb08f2) But NOT in: Version: 4.1.0.0.beta2 Build ID: 33224f4f11a05cfad2249e812fcc2975fbb61f6 Version: 4.2.0.0.alpha0+ Build ID: 7746de6e42d5957fa62fa278e2c46a0cb472dc01 all tested with Vista-32b) Regards
Managed to fix the problem that changing the value in referenced cells did not result in a direct update. This was also a problem for data bars and color scales and required me to implement a new updating mechanism for these formats.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=17cb1d6d82db56761c86ee95195689cc155901b3 allow these cond formats to be updated when formula val changes,fdo#64401 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.
Updating values based on formulas is OK with today master (master~2013-06-29): Version: 4.2.0.0.alpha0+ Build ID: 5b9bad7482a98f2d0d37c4b75a13292abe653ea3 [Vista-32b] Tests were performed on icon set, data bar and color scales Thanks
Hello WORKSFORME on Windows 7/64 with Version: 4.2.0.0.alpha0+ Build ID: cc2a405915e82c4b332dd25457f76704dc536d7f TinderBox: Win-x86@39, Branch:master, Time: 2013-10-15_15:51:52 Thank you Pierre-Yves
Closing this one as it has been confirmed to be fixed :) Sophie
(In reply to comment #9) > Closing this one as it has been confirmed to be fixed :) Sophie Please don't close my bugs. It is a reminder for me to look into backporting the patch to 4-1. There are several other open bugs from me where I need to look into back porting.
(In reply to comment #10) > (In reply to comment #9) > > Closing this one as it has been confirmed to be fixed :) Sophie > > Please don't close my bugs. It is a reminder for me to look into backporting > the patch to 4-1. There are several other open bugs from me where I need to > look into back porting. Ok, noted, sorry for that, I won't touch them. Sophie
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0efaa25ddfa84aa3fee88a357ff15f5ec50b234a tdf#64401: sc_subsequent_filters: Add unittest 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.