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.
OpenGL is *NOT* enabled.
(In reply to Kristian Slavov from comment #0) > The data source is fetched via libreoffice base using ODBC connection to a > local sqlite3 database file. Please attach an example Base file + sqlite db file so we can quickly and conveniently test. Please attach an example document. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the files.
Created attachment 164667 [details] Simple test db
Created attachment 164668 [details] Base file
Created attachment 164670 [details] Actual sheet file
Attached sqlite3 db, Libreoffice Base file and the sheet. All the data in the sheet is directly from the Base/db. I'm importing headers + data rows from a query, and I'm using the keep formatting option for the range. I noticed something new. The first data row's background color is copied to all the other rows. So the bug should be renamed to: Refreshing a range applies the first data row's background color to all the other data rows. To reproduce the bug, change background color of the first data row and select refresh range.
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 :)
Dear Kristian Slavov, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
The extended tooltip of the option "Keep formatting" is, "Applies the existing cell format of headers and first data row to the whole database range." The property belongs to the attribute table:on-update-keep-styles of the <table:database-range> element in file format (section 19.687, part 3, ODF 1.4) And that specifies, "The table:on-update-keep-styles attribute specifies the behavior if the database range is updated. If the attribute value is true, the cell styles that are assigned to the cells in the first non-label row of the database range are used for all rows with in the database range. If the attribute value is false, all cells in the database range are assigned the default cell style of the document assigned." So I think, that LibreOffice behaves conform to the specification.