<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - 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">116129</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc Cell Range method ClearContents does not work with com.sun.star.sheet.CellFlags.STYLES
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>BASIC
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>volker.lenhardt@uni-due.de
</td>
</tr></table>
<p>
<div>
<pre>Description:
If I try to remove cell style formatting on a Calc sheet cell range by a macro,
nothing happens:
oRange.clearContents(com.sun.star.sheet.CellFlags.STYLES)
But if I combine STYLES with HARDATTR, not only all hard formatting is set to
default, but formatting with cell styles is removed as well. This way you can
remove cell style formatting, but with the drawback of getting default formats
in the rest of the cells.
This behavior is proved for Windows 7, LO 5.3.7., Windows 10, LO 6.0.0.2 (32
bit) and for Linux openSUSE LEAP 42.2 with LO 5.3.0 and LO 6.0.1.1 (both
generic versions).
Steps to Reproduce:
1. Format a sheet cell with some cell style.
2. Take a cell range oRange containing that cell.
3. oRange.clearContents(com.sun.star.sheet.CellFlags.STYLES)
4. Nothing happens
5. oRange.clearContents(com.sun.star.sheet.CellFlags.HARDATTR Or
com.sun.star.sheet.CellFlags.STYLES)
Actual Results:
With (com.sun.star.sheet.CellFlags.STYLES) alone nothing happens.
With (com.sun.star.sheet.CellFlags.HARDATTR Or
com.sun.star.sheet.CellFlags.STYLES) all cells in the range are reset to
default formats incl. the cell with cell style.
Expected Results:
With (com.sun.star.sheet.CellFlags.STYLES) alone all cells formatted by cell
styles should be reset to default formats.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
Firefox/52.0</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>