Created attachment 103819 [details] FormatageConditionnel.ods Hi Removing conditional formatting by API no longer works Steps to reproduce: 1. Open the FormatageConditionnel.ods attached Three conditional formatting defined for C3 (see ClearCF1.png screenshot attached) 2. Launch the PysClearFormats sub PysClearFormats Dim oPlage as object Dim oFormats as object oPlage = ThisComponent.Sheets.getByName("Feuille1").GetCellRangeByName("C3") oFormats = oPlage.conditionalFormat oFormats.clear oPlage.conditionalFormat = oFormats end sub Expected result: all the conditional formatting of cell C3 deleted Actual result: a new empty conditional formatting is created (see ClearCF2.png screenshot attached) 3. Don't save and reload 4. Launch the PysClearLastFormats macro Expected result: the last conditional formatting of cell C3 deleted Actual result: a new conditional formatting is created with only 2 conditions but the original formatting is still there Reproduce (user-fr) on: -Windows XP & Version 3.6.5.2 (Build ID: 5b93205) -Windows XP & Version: 4.3.0.4 Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0 So I set status to New Last known version Ok: LibreOffice 3.5.7.2 Version ID : 3215f89-f603614-ab984f2-7348103-1225a5b This Issue is different from bug 61915 (not the same methods or the same result) Workaround : oPlage = ThisComponent.Sheets.getByName("Feuille1").GetCellRangeByName("A1:E15") oPlage.clearContents(32) Regards Pierre-Yves
Created attachment 103820 [details] ClearCF1.png screenshot 3 conditions
Created attachment 103821 [details] ClearCF2.png Screenshot empty format
Confirmed. Need to test on Linux before setting bibisectRequest whiteboard. Win 7 64-bit Version: 4.4.0.0.alpha1+ Build ID: ad6d94009cf8ea526eb70bf1a07e5c6a21320f83 TinderBox: Win-x86@51-TDF, Branch:MASTER, Time: 2014-11-04_00:06:27
Confirmed on Linux. Version: 4.3.2.2.0+ Build ID: 4.3.2.2 Arch Linux build-1
Bibisect results from 43all: 2f701cd5a012710b5a360239b7078ca3b23206ab is the first bad commit commit 2f701cd5a012710b5a360239b7078ca3b23206ab Author: Bjoern Michaelsen <bjoern.michaelsen@canonical.com> Date: Mon Dec 10 21:07:58 2012 +0000 source-hash-e9960f36675a025c0536dec30ae56c50f4adecb1 commit e9960f36675a025c0536dec30ae56c50f4adecb1 Author: Radek Doulik <rodo@novell.com> AuthorDate: Mon Oct 8 18:03:18 2012 +0200 Commit: Radek Doulik <rodo@novell.com> CommitDate: Mon Oct 8 18:06:37 2012 +0200 implement a:overrideClrMapping (fixes n#783202) Change-Id: Ib6c0fd6d9b64f2bff446f919c58027fea76a00cb # bad: [c2069a369d738078124812312d51f21ea1ce2421] source-hash-f160e4935c474a5293b3d3c11b3d538efb4767a0 # good: [cf86b7f14a98d2d81a5cd93507acb35ff6775d8b] source-hash-85c6244b85b29c1d2bb9d89b62e9512dd65378b5 git bisect start 'last41onmaster' 'last35onmaster' # good: [cd18cb7f47f7e956c6d19bd0f31a6e30d1173b29] source-hash-558476135865d9ae7b8801a82c177fd1098386ff git bisect good cd18cb7f47f7e956c6d19bd0f31a6e30d1173b29 # bad: [a7e54955e9f49e8b59dfd8c4533785a680b1796c] source-hash-5da10275a7475efdbfd9de14ea58cf8f4c6c1582 git bisect bad a7e54955e9f49e8b59dfd8c4533785a680b1796c # bad: [1f14665c5624bc7a502738aa8f4f2bd70a211e72] source-hash-d85fd8a85501547d5bb87822d2589a07aed7f2d6 git bisect bad 1f14665c5624bc7a502738aa8f4f2bd70a211e72 # bad: [2e2d1aeff80dcbe390f6c3fbc54d6c8de81b0a0e] source-hash-64ab96cd15e52da88781e720d6f031dbcd0ba902 git bisect bad 2e2d1aeff80dcbe390f6c3fbc54d6c8de81b0a0e # good: [12d0e3ae5464de93295e16f9b4d18de1aa3fca35] source-hash-ee34432562393a4549e9e77f71146e43c5d02233 git bisect good 12d0e3ae5464de93295e16f9b4d18de1aa3fca35 # good: [67a1700cf48455c8b0a2411ab01433f405866161] source-hash-d18455e24644a90cbf9f146ea8b4eed74180592b git bisect good 67a1700cf48455c8b0a2411ab01433f405866161 # bad: [91fed7198400158ba17622fa48f1c85063ba839f] source-hash-7c4d3ea6ba4d42b4dda5148a00c8c411b5d7703d git bisect bad 91fed7198400158ba17622fa48f1c85063ba839f # bad: [2f701cd5a012710b5a360239b7078ca3b23206ab] source-hash-e9960f36675a025c0536dec30ae56c50f4adecb1 git bisect bad 2f701cd5a012710b5a360239b7078ca3b23206ab # first bad commit: [2f701cd5a012710b5a360239b7078ca3b23206ab] source-hash-e9960f36675a025c0536dec30ae56c50f4adecb1
Within the range of the bibisect, it seems highly likely that one of this set of commits is responsible: commit 79b1868bf687ff105ce3bf3ccf583434946848aa Author: Markus Mohrhard <markus.mohrhard@googlemail.com> Date: Thu Oct 4 03:53:37 2012 +0200 more work on getting cell attributes and cond formats in sync Change-Id: If10059a6d2b8d2449a01fe09eb2efb9ccea55806 ... lots more similiar commits omitted ... commit ce8ac5bbe40e4cb57e1826a81b3b5c4632474789 Author: Markus Mohrhard <markus.mohrhard@googlemail.com> Date: Sat Oct 6 06:52:28 2012 +0200 prevent creating cond formats without a attached range Change-Id: Ic4c13fa3d0eae54b7db1fa5a4e5c5040582b21ed
Matúš Kukan committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=67c989adc57eb279c478f59869499439ec65665f fdo#82014: Remove old conditional formats when setting new one by UNO API It will be available in 4.5.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.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.