Bug 150009 - FORMATTING: Cells do not display background colors in GTK3 downloaded LO
Summary: FORMATTING: Cells do not display background colors in GTK3 downloaded LO
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.0.0 beta1+
Hardware: All Linux (All)
: lowest minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: GTK3
  Show dependency treegraph
 
Reported: 2022-07-15 19:25 UTC by derek_upham
Modified: 2022-08-14 17:21 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description derek_upham 2022-07-15 19:25:28 UTC
Run Libreoffice 7.4.0.1 and open an empty spreadsheet.

% libreoffice7.4 --calc

The current cell will be position "A1".  Click on the "Background Color" toolbar icon.

We expect cell "A1" to change, to show a yellow background, but the background remains white.

Start editing the contents of "A1".  The cell background switches from white to the expected yellow, but only for as long as we are editing the cell contents.  (It doesn't matter whether we edit directly in the cell, or move focus to the input line above.)

This is on Debian, with the LibreOffice_7.4.0.1_Linux_x86-64_deb download.  The LibreOffice_7.3.4.2_Linux_x86-64_deb download does not have this bug.
Comment 1 m_a_riosv 2022-07-15 21:20:05 UTC
Works fine for me with
Version: 7.4.0.1 (x64) / LibreOffice Community
Build ID: 43e5fcfbbadd18fccee5a6f42ddd533e40151bcf
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL

Please test with a clean profile, Menu/Help/Restart in Safe Mode
Comment 2 derek_upham 2022-07-15 23:47:20 UTC
I archived ~/.config/libreoffice/4/user into libreoffice-profile.zip, and blew away the contents of the directory:

% rm -rf GraphicsRenderTests.log SafeMode/ autotext/ basic/ config/ database/ extensions/ gallery/ psprint/ registrymodifications.xcu uno_packages/
% libreoffice7.4 --calc

Version 7.4 still shows the problem.
Comment 3 Rafael Lima 2022-07-20 14:47:23 UTC
Not repro

Version: 7.4.0.1.0+ / LibreOffice Community
Build ID: 78335f5ba9bae4f1b429bebd56ff5991192e8650
CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: kf5 (cairo+xcb)
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Calc: threaded

The background is yellow as expected.
Comment 4 Timur 2022-07-20 15:04:34 UTC Comment hidden (obsolete)
Comment 5 derek_upham 2022-07-20 20:13:50 UTC
Version: 7.4.0.1 / LibreOffice Community
Build ID: 43e5fcfbbadd18fccee5a6f42ddd533e40151bcf
CPU threads: 4; OS: Linux 5.16; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 6 derek_upham 2022-07-20 20:25:36 UTC
% ldd /opt/libreoffice7.4/program/libvclplug_*.so | grep 'not found'
        libKF5CoreAddons.so.5 => not found
        libKF5I18n.so.5 => not found
        libKF5ConfigCore.so.5 => not found
        libKF5WindowSystem.so.5 => not found
        libKF5KIOCore.so.5 => not found
        libKF5KIOWidgets.so.5 => not found
        libKF5KIOFileWidgets.so.5 => not found
        libKF5CoreAddons.so.5 => not found
        libKF5I18n.so.5 => not found
        libKF5ConfigCore.so.5 => not found
        libKF5WindowSystem.so.5 => not found
        libKF5KIOCore.so.5 => not found
        libKF5KIOWidgets.so.5 => not found
        libKF5KIOFileWidgets.so.5 => not found

If I install those libraries, how could I configure soffice to run with a "kf5" VCF, to match your test case?
Comment 7 QA Administrators 2022-07-21 03:34:31 UTC Comment hidden (obsolete)
Comment 8 Timur 2022-07-21 13:45:12 UTC Comment hidden (me-too)
Comment 9 Timur 2022-07-21 13:46:23 UTC
Also no repro for GTK3, kf5 in Ubuntu 18.04. 
So it seems some local issue. 

LO will pick kf5 with: SAL_USE_VCLPLUGIN=kf5 path-to/soffice
Also: SAL_USE_VCLPLUGIN=qt5 path-to/soffice

I think I used this before:
apt-get install qtbase5-dev qtchooser qt5-qmake qtbase5-dev-tools qt5-style-plugins
Comment 10 derek_upham 2022-07-21 15:18:31 UTC
% sudo apt install libkf5i18n5 libkf5coreaddons5 libkf5configcore5 libkf5kiocore5 libkf5windowsystem5 libkf5kiowidgets5 libkf5kiofilewidgets5
[...lots of lines skipped...]
% ldd /opt/libreoffice7.4/program/libvclplug_*.so | grep 'not found'
% env SAL_USE_VCLPLUGIN=kf5 /opt/libreoffice7.4/program/soffice --calc
% env SAL_USE_VCLPLUGIN=qt5 /opt/libreoffice7.4/program/soffice --calc
% env SAL_USE_VCLPLUGIN=gtk3 /opt/libreoffice7.4/program/soffice --calc

The kf5 and qt5 VCLs do not have the bug; clicking on the background highlight tool has normal behavior.  The gtk3 VCL in the third run does have the bug.
Comment 11 QA Administrators 2022-07-22 03:44:49 UTC Comment hidden (obsolete)
Comment 12 Timur 2022-07-22 09:32:13 UTC
So someone needs to confirm or explain.
Comment 13 Caolán McNamara 2022-07-22 19:23:31 UTC
my local 7-4 gtk3 libreoffice doesn't reproduce so not sure what is causing this.
Comment 14 Timur 2022-07-25 10:48:40 UTC
Since 4 testers couldn't confirm, I set Needinfo to reporter to find out what's specific for you to cause it.
Comment 15 derek_upham 2022-07-25 15:02:58 UTC
Can you point me to the git commits that correspond to LibreOffice_7.4.0.1_Linux_x86-64_deb and LibreOffice_7.3.4.2_Linux_x86-64_deb?  And to the docs for building the deb packages?

Then we can close this (we can reopen as necessary) while I try to narrow down to precisely where the bug appears.
Comment 16 Timur 2022-07-25 17:23:21 UTC
I guess Xisco will know about building. deb. 
I add See also, please test and comment.
Comment 17 Xisco Faulí 2022-07-26 14:09:21 UTC
(In reply to derek_upham from comment #15)
> Can you point me to the git commits that correspond to
> LibreOffice_7.4.0.1_Linux_x86-64_deb and
> LibreOffice_7.3.4.2_Linux_x86-64_deb?  And to the docs for building the deb
> packages?

Just use git show libreoffice-7.4.0.1 to see it

See https://wiki.documentfoundation.org/Development/BuildingOnLinux#Build_DEB_and.2For_RPM_Packages
Comment 18 derek_upham 2022-08-14 17:21:25 UTC
As a follow-up:

The build in Debian "testing" no longer has the bug.  That corresponds to this Debian version:

Package: libreoffice
Version: 1:7.4.0~rc2-3

The build information, from the "About" dialog:

Version: 7.4.0.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 4; OS: Linux 5.16; UI render: default; VCL: x11
Locale: en-US (en_US.UTF-8); UI: en-US
Debian package version: 1:7.4.0~rc2-3
Calc: threaded