Home / ubuntu / Questions / 889601
Accepted
Rsync
Asked: 2017-03-05 13:07:32 +0800 CST

WPS Office - Change Spreadsheets Default Fill Background Color

  • 772

I installed WPS Office for the first time. It is amazing, so much so that I wonder if there is some hidden adware that I can't remove (e.g., what is Docer).

That said, my issue is that the background on WPS Spreadsheets for all sheets is this weird brown color. I've tried changing the Page Layout > Themes and Colors. I've also tried to Format Cells. But there does not appear (or I can't find) a way to change the default background color. Is there a way?

Here is what it looks like.

enter image description here

wps-office

7 Answers

  1. Best Answer

    As an addendum to Roel Brook's answer, I found that you can actually change this setting in the binary file. To do this open terminal and enter 

    sudo $EDITOR `where et`

    Then look for:

    ${gInstallPath}/office6/${gApp} -style gtk+ ${gOptExt} ${gOpt} "$@"

    and change it to:

    ${gInstallPath}/office6/${gApp} -style motif ${gOptExt} ${gOpt} "$@"

    Then save and close. Now the changes will be persistent.

    • 6

  2. GTK theme have to be set with environment variable and parameter

    env GTK2_RC_FILES=/usr/share/themes/Adwaita/gtk-2.0/gtkrc ./et -style gtk+

    Can you show a way to input this parameter to the application to be persistent? >>I'm using KDE Neon 5.14 User Edition (Based Ubuntu 18.04)

    Thanks a Lot man

    --UPDATE--

    Knowing about this tip that intika said, a precious one by the way, I searched a little more to How to make this line as permanent. So, its very simple.

    Right Click > Edit Application > Application tab > Run or Command box-form and add "Exec="on begining.

    For exemple:

    Exec=env GTK2_RC_FILES=/usr/share/themes/Adwaita/gtk-2.0/gtkrc /usr/bin/et -style gtk+

    This solved my problem. Take care to do not put this command to run in a terminal on advanced settings, or It will open terminal together (unless you want it)

    • 3

  3. As with most QT applications, WPS accepts "-style".

    For example: et -style motif

    This will ignore the current desktop theme, and run WPS with that specific QT theme.

    • 2

  4. GTK theme have to be set with environment variable and parameter

    env GTK2_RC_FILES=/usr/share/themes/Adwaita/gtk-2.0/gtkrc ./et -style gtk+
    • 2

  5. Turns out this is caused by an interaction with the Arc Dark theme (it does not occur with Arc or Arc Darker). I posted an issue on Horst's GitHub page.

    • 1

  6. I had the same problem, but the solution above given by Dan (which seems to be the right one as it is referenced in every forum I came across) wasn't working for me. But I found another fix which DOES work, although not permanently.

    I am using a KDE neon build, and the solution below worked for me:

    WPS_NO_KDE_NATIVE_DIALOG=1 et -style gtk+

    This is for spreadsheets. For writer and presentation, substitute "et" with "wps" and "wpp" respectively.

    Solution attributed to user "raddison" on KDE Forum, under the "WPS Office not working" topic.

    • 0

  7. I fixed this problem using flatpak version:

    flatpak install com.wps.Office

    Then you need to edit Qt config file:

    nano ~/.var/app/com.wps.Office/config/Trolltech.conf

    Add this lines:

    [Qt]
style=Plastique

    You could also use other Qt styles inclueded in the default installation: CDE, Cleanlooks, GTK, Motif, Plastique, Windows

    • 0