https://bugs.freedesktop.org/show_bug.cgi?id=82014
Priority: medium
Bug ID: 82014
Keywords: regression
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: BASIC Removing conditional formatting by API no longer
works
Severity: normal
Classification: Unclassified
OS: All
Reporter: pierre-yves.sa...@laposte.net
Hardware: Other
Status: NEW
Version: 4.2.5.1 rc
Component: BASIC
Product: LibreOffice
Created attachment 103819
--> https://bugs.freedesktop.org/attachment.cgi?id=103819&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
