[Libreoffice-bugs] [Bug 132191] New: FORMATTING: Refreshing a range deletes background color even with "keep formatting" option enabled.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 132191
           Summary: FORMATTING: Refreshing a range deletes background
                    color even with "keep formatting" option enabled.
           Product: LibreOffice
           Version: 6.4.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: krisux at kapsi.fi

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.

-- 
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/20200417/b587bb46/attachment.htm>