Created attachment 76039 [details] Simple macro illustrating wrong clearContents() behavior The API method "clearContents()" clears conditional formatting even when called with strict value cellflags (value, datetime, string...) This is obviously not the expected behavior. See attachment for an example macro. Thanks for all.
I can confirm this behavior with 4.0.1.2 release but it has since been fixed. At least in 4.1 master it is solved (built about a week ago). If 4.0.2.2 release hasn't fixed the issue yet, you'll see the problem solved definitely by 4.1 release if not sooner in 4.0.3 Thanks for reporting this, marking as WFM as we don't know what patch solved the issue but it is indeed fixed. + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link: https://wiki.documentfoundation.org/QA/BugTriage and join us on freenode at #libreoffice-qa There are also other ways to get involved including with marketing, UX, documentation, and of course developing - http://www.libreoffice.org/get-help/mailing-lists/. Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material
Solved with the 4.0.2.2 released ! Thanks to everyone... again ;-)