<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 - FORMATTING: Refreshing a range deletes background color even with "keep formatting" option enabled."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132191">132191</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FORMATTING: Refreshing a range deletes background color even with "keep formatting" option enabled.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.2.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>krisux@kapsi.fi
</td>
</tr></table>
<p>
<div>
<pre>Description:
I've defined a range that imports data from libreoffice base. For that range
I've enabled "keep formatting" option.
When a range is refreshed the background color reverts to white. All other
formatting remains (font, font size, borders)
If "keep formatting" option is not used, all formatting is lost, as expected.
Steps to Reproduce:
1.Associate a data source to some cells
2.Change the background color of some of them
3.Modify the range to use "keep formatting" option (probably on by default)
4.Update the range
Actual Results:
The background color of the cells changed to white.
However other formatting such as borders, fonts, font sizes remain intact.
Expected Results:
The background color should remain as before the range update.
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 6.4.2.2
Build ID: 1:6.4.2-3
CPU threads: 4; OS: Linux 5.5; UI render: default; VCL: x11;
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
The data source is fetched via libreoffice base using ODBC connection to a
local sqlite3 database file.</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>