<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Calc Cell Range method ClearContents does not work with com.sun.star.sheet.CellFlags.STYLES" href="https://bugs.documentfoundation.org/show_bug.cgi?id=116129#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Calc Cell Range method ClearContents does not work with com.sun.star.sheet.CellFlags.STYLES" href="https://bugs.documentfoundation.org/show_bug.cgi?id=116129">bug 116129</a> from <a class="email" href="mailto:volker.lenhardt@uni-due.de" title="Volker Lenhardt <volker.lenhardt@uni-due.de>"> Volker Lenhardt</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=140291" name="attach_140291" title="Macros to display bugs using Calc cell range method clearContents with some CellFlags">attachment 140291</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=140291&action=edit" title="Macros to display bugs using Calc cell range method clearContents with some CellFlags">[details]</a> Macros to display bugs using Calc cell range method clearContents with some CellFlags This attachment shows a set of formatted cells, numbers, date/time, strings, B3 being formatted with a cell style, as well as two cells (B4 and C4) with text portion formatting. You can try the effect on B3 (in fact no effect at all) by calling the macro Sub ClearContentsByCellFlagsSTYLES If you call the macro Sub ClearContentsByCellFlagsHARDATTROrSTYLES then not only all cell formatting is set to default, but B3 loses the cell style, too. The file comes with an additional macro to serve as an example for <a class="bz_bug_link bz_status_NEW " title="NEW - Cell Range method ClearContents does not work with com.sun.star.sheet.CellFlags.EDITATTR" href="show_bug.cgi?id=116127">bug 116127</a> as well: Sub ClearContentsByCellFlagsEDITATTR</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>