[Libreoffice-bugs] [Bug 116129] Calc Cell Range method ClearContents does not work with com.sun.star.sheet.CellFlags.STYLES

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116129

--- Comment #4 from Volker Lenhardt <volker.lenhardt at uni-due.de> ---
Created attachment 140291
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140291&action=edit
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 bug 116127
as well:
Sub ClearContentsByCellFlagsEDITATTR

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180302/56a0abee/attachment.html>