[Libreoffice-bugs] [Bug 132191] Refreshing a range applies the first data row's background color to all the other data rows

[bugzilla-daemon at bugs.documentfoundation.org]

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

Buovjaga <ilmari.lauhakangas at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|FORMATTING: Refreshing a    |Refreshing a range applies
                   |range deletes background    |the first data row's
                   |color even with "keep       |background color to all the
                   |formatting" option enabled. |other data rows
         Whiteboard| QA:needsComment            |
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1
             Blocks|                            |115775

--- Comment #7 from Buovjaga <ilmari.lauhakangas at libreoffice.org> ---
Notes for reproduction on Arch Linux:

I had sqlite3 package already installed.

I installed sqliteodbc package from AUR per
https://wiki.archlinux.org/index.php/Open_Database_Connectivity#SQLite

/etc/odbcinst.ini contents were amended by the installation as shown in the
article.

In /etc/odbc.ini I added

[SQLite3]
Description=SQLite3
Driver=SQLite3
Database=/home/user/libobugs/vboxshare/odbc/mydb.sqlite
Timeout=100000
StepAPI=No
ShortNames=No
FKSupport=Yes
SyncPragma=Normal
JournalMode=Delete
BigInt=No

In lo_test.odb I did Edit - Database - Properties, Browse and selected SQLite3.
Test Connection went fine. I saved the file.

In Tools - Options - LibO Base - Databases I added the lo_test.odb file.

Now I was able to look into test_sheet.ods.

1. Changed the background colour of cells B4:C4
2. Data - Refresh range

I confirm the colour was applied to the rest of the data cells.

A wild ride, but I learned something new :)


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=115775
[Bug 115775] [META] Data range and consolidate bugs and enhancements
-- 
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/20200825/a6d305f0/attachment.htm>