I'm trying out [WPS Office](http://wps-community.org/) (version Alpha21 10.1.0.5672~a21). The first issue I'm running into is a display bug: the display is compressed horizontally (or elongated vertically, whichever). Only the document display is affected, the user interface part is fine. This isn't a font issue: I see this with every font, and with figures. In the screenshot below, the blue rectangle is in fact a 1cm×1cm square, and the PDF output is correct. On startup, WPS Office shows a “System Check” window which mentions > System DPI is asymmetric. WPS Office may have display issues. The “solution” link leads to http://community.wps.cn/wiki/dpix_not_equal_dpiy which is a broken link. If the solution exists anywhere on the web now, I can't find it (possibly because it's in Chinese only). xrandr output (that's actually 158dpi both horizontally and vertically, so whatever WPS Office is doing to determine the resolution, it's mistaken): Screen 0: minimum 320 x 200, current 1920 x 1080, maximum 32767 x 32767 eDP1 connected 1920x1080+0+0 (normal left inverted right x axis y axis) 309mm x 173mm I use Sawfish without a destkop environment. [Fouad](https://unix.stackexchange.com/users/247050/fouad) reports that he has the same issue under XFCE, but not under Cinnamon. How can I make WPS Office display document content at a correct aspect ratio?

**OS: Ubuntu 17.10** In a nut shell, WPS Office released a new Linux update **Aplha21**. I have installed it and tried to get it working by downloading the package from the site and running: **sudo dpkg --install _``_**. However, the package fails to install from a lacking dependency; "libpng12-0". How best to install this package is the greatest concern.

I am trying to decrease the size of my .ppt presentations by converting them to .odp/.wps-format, since they take several GBs memory because of - big pictures and - audio content in slides. I would like to store the presentations in smaller space without losing quality i.e. picuters and audio. WPS Office --- WPS office > Save as > jpg of every slide; which does a very good work in extracting the images; I have not found yet any terminal tool for the task of many .ppt files; the 2-month-old release is alpha but much more stable than the previous ones (> 100 Mb .ppt files) and can render much better .ppt files than LibreOffice presentation. I already contacted the company about the task with a link to this thread. I already sent a related question in their Linux Community of the application but they have not approved it yet here . LibreOffice --- I do when I have soffice in my PATH but get masi@masi:~/$ ppt2odp test.ppt > Failed to connect to /usr/lib/libreoffice/program/soffice.bin (pid=10643) in 6 seconds. > Connector : couldn't connect to socket (Success) > Error: Unable to connect or start own listener. Aborting. > masi@masi:~/$ OS: Debian 8.5 64 bit Linux kernel: 4.6 Hardware: Asus Zenbook UX303UA

I installed WPS with snap (my OS is Manjaro 20.0.3 "Lysia"), but when I run Spreadsheet the background is black, also the default font color in Spreadsheet and Writer is white color (It is a problem because the background of Writer is white). I read in the arch linux wiki that the bad integration with dark themes of KDE is usual . However, I don't know how to execute it with the command that they suggest. I also saw this , but it's the same. And I don't know how difficult things are having installed it from snap (the path to run this application is not in bin/et, /usr/bin/wps or something like that).

I am running Manjaro linux KDE and am enjoying. But opening office & zip file is a pita for me. Look the screenshot. My zip file opens by libreoffice (or WPS). And if I correct it in file properties to point it to open by ark, then office files start opening by ark. The file type seem to get added automatically. I can never open any zip or office file without right click. Weird problem. I wonder if I am the only one too suffer from it. Though, no other filetypes are in conflict like this except zip and office files. I couldn't find any settings/options to correct it. Duckduckgoing also doesn't give any post. Any help input would be well appreciated. Thanks.

I have Elementary OS Loki and it has work fine before installing Kingsoft's WPS office when I install it is working fine but when went in terminal and run the command # sudo apt-get install anyprogram and I got below errors The following packages have unmet dependencies: libpng12-0 : Breaks: libpng12-0:i386 (!= 1.2.50-2+deb8u3) but 1.2.54-1ubuntu1 is to be installed libpng12-0:i386 : Breaks: libpng12-0 (!= 1.2.54-1ubuntu1) but 1.2.50-2+deb8u3 is to be installed E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution). after that I've google this problem and found solution like to run apt-get -f install apt-get install -f but both gives this error ~# apt-get install -f Reading package lists... Done Building dependency tree Reading state information... Done Correcting dependencies... Done The following packages were automatically installed and are no longer required: gnome-system-monitor libatkmm-1.6-1v5 libavahi-client3:i386 libavahi-common-data:i386 libavahi-common3:i386 libbsd0:i386 libcairomm-1.0-1v5 libcups2:i386 libdbus-1-3:i386 libdecoration0 libdrm-amdgpu1:i386 libdrm-intel1:i386 libdrm-nouveau2:i386 libdrm-radeon1:i386 libdrm2:i386 libedit2:i386 libelf1:i386 libexpat1:i386 libffi6:i386 libfontconfig1:i386 libfreetype6:i386 libgcrypt20:i386 libgl1-mesa-dri:i386 libgl1-mesa-glx:i386 libglapi-mesa:i386 libglib2.0-0:i386 libglibmm-2.4-1v5 libglu1-mesa:i386 libgmp10:i386 libgnutls30:i386 libgssapi-krb5-2:i386 libgtkmm-3.0-1v5 libhogweed4:i386 libice6:i386 libidn11:i386 libk5crypto3:i386 libkeyutils1:i386 libkrb5-3:i386 libkrb5support0:i386 libllvm4.0:i386 libmetacity-private3a libnettle6:i386 libp11-kit0:i386 libpangomm-1.4-1v5 libpciaccess0:i386 libpng12-0:i386 libprotobuf9v5 libsensors4:i386 libsigc++-2.0-0v5 libsm6:i386 libstdc++6:i386 libsystemd0:i386 libtasn1-6:i386 libtxc-dxtn-s2tc0:i386 libx11-6:i386 libx11-xcb1:i386 libxau6:i386 libxcb-dri2-0:i386 libxcb-dri3-0:i386 libxcb-glx0:i386 libxcb-present0:i386 libxcb-sync1:i386 libxcb1:i386 libxdamage1:i386 libxdmcp6:i386 libxext6:i386 libxfixes3:i386 libxrender1:i386 libxshmfence1:i386 libxxf86vm1:i386 metacity-common session-migration Use 'sudo apt autoremove' to remove them. The following additional packages will be installed: libpng12-0 The following packages will be upgraded: libpng12-0 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 2 not fully installed or removed. Need to get 0 B/116 kB of archives. After this operation, 11.3 kB of additional disk space will be used. Do you want to continue? [Y/n] y (Reading database ... 228119 files and directories currently installed.) Preparing to unpack .../libpng12-0_1.2.54-1ubuntu1_amd64.deb ... Unpacking libpng12-0:amd64 (1.2.54-1ubuntu1) over (1.2.50-2+deb8u3) ... dpkg: error processing archive /var/cache/apt/archives/libpng12-0_1.2.54-1ubuntu1_amd64.deb (--unpack): trying to overwrite shared '/usr/share/doc/libpng12-0/ANNOUNCE', which is different from other instances of package libpng12-0:amd64 Processing triggers for libc-bin (2.23-0ubuntu9) ... Errors were encountered while processing: /var/cache/apt/archives/libpng12-0_1.2.54-1ubuntu1_amd64.deb E: Sub-process /usr/bin/dpkg returned an error code (1) and I've also googled this problem and found some solution like this sudo apt-get install --fix-broken && sudo apt-get autoremove && sudo apt-get update but it did not work I tried this also sudo dpkg --configure -a but it also did not solved the problem it gives error :~# sudo dpkg --configure -a dpkg: error processing package libpng12-0:amd64 (--configure): package libpng12-0:amd64 1.2.50-2+deb8u3 cannot be configured because libpng12-0:i386 is at a different version (1.2.54-1ubuntu1) dpkg: error processing package libpng12-0:i386 (--configure): package libpng12-0:i386 1.2.54-1ubuntu1 cannot be configured because libpng12-0:amd64 is at a different version (1.2.50-2+deb8u3) Errors were encountered while processing: libpng12-0:amd64 libpng12-0:i386 when I googled this problem it gives the solution that I've already tried first one so I am stuck with visa versa solution please solve this I have tried this solution sudo apt-get clean but it did not work some extra info : command: cat /etc/apt/sources.list output: `deb http://archive.ubuntu.com/ubuntu xenial restricted main universe multiverse ` command: cat /etc/apt/sources.list.d/* output: deb http://packages.elementary.io/appcenter xenial main deb http://packages.elementary.io/appcenter xenial main ##deb http://ppa.launchpad.net/elementary-os/stable/ubuntu xenial main deb-src http://ppa.launchpad.net/elementary-os/stable/ubuntu xenial main deb http://ppa.launchpad.net/elementary-os/stable/ubuntu xenial main deb-src http://ppa.launchpad.net/elementary-os/stable/ubuntu xenial main ### THIS FILE IS AUTOMATICALLY CONFIGURED ### # You may comment out this entry, but any other modifications may be lost. deb [arch=amd64] http://dl.google.com/linux/chrome/deb/ stable main ### THIS FILE IS AUTOMATICALLY CONFIGURED ### # You may comment out this entry, but any other modifications may be lost. deb [arch=amd64] http://dl.google.com/linux/chrome/deb/ stable main deb http://repo.mongodb.org/apt/ubuntu xenial/mongodb-org/3.2 multiverse deb http://repo.mongodb.org/apt/ubuntu xenial/mongodb-org/3.2 multiverse ##deb http://ppa.launchpad.net/mpstark/elementary-tweaks-daily/ubuntu xenial main # deb-src http://ppa.launchpad.net/mpstark/elementary-tweaks-daily/ubuntu xenial main deb http://ppa.launchpad.net/mpstark/elementary-tweaks-daily/ubuntu xenial main # deb-src http://ppa.launchpad.net/mpstark/elementary-tweaks-daily/ubuntu xenial main ##deb http://ppa.launchpad.net/elementary-os/os-patches/ubuntu xenial main deb-src http://ppa.launchpad.net/elementary-os/os-patches/ubuntu xenial main deb http://ppa.launchpad.net/elementary-os/os-patches/ubuntu xenial main deb-src http://ppa.launchpad.net/elementary-os/os-patches/ubuntu xenial main ##deb http://ppa.launchpad.net/philip.scott/elementary-tweaks/ubuntu xenial main # deb-src http://ppa.launchpad.net/philip.scott/elementary-tweaks/ubuntu xenial main deb http://ppa.launchpad.net/philip.scott/elementary-tweaks/ubuntu xenial main # deb-src http://ppa.launchpad.net/philip.scott/elementary-tweaks/ubuntu xenial main deb [arch=amd64] https://repo.skype.com/deb stable main deb [arch=amd64] https://repo.skype.com/deb stable main deb https://download.sublimetext.com/ apt/stable/ deb https://download.sublimetext.com/ apt/stable/ ##deb http://ppa.launchpad.net/versable/elementary-update/ubuntu xenial main # deb-src http://ppa.launchpad.net/versable/elementary-update/ubuntu xenial main deb http://ppa.launchpad.net/versable/elementary-update/ubuntu xenial main # deb-src http://ppa.launchpad.net/versable/elementary-update/ubuntu xenial main ### THIS FILE IS AUTOMATICALLY CONFIGURED ### # You may comment out this entry, but any other modifications may be lost. deb [arch=amd64] http://packages.microsoft.com/repos/vscode stable main ### THIS FILE IS AUTOMATICALLY CONFIGURED ### # You may comment out this entry, but any other modifications may be lost. deb [arch=amd64] http://packages.microsoft.com/repos/vscode stable main ##deb http://ppa.launchpad.net/webupd8team/java/ubuntu xenial main # deb-src http://ppa.launchpad.net/webupd8team/java/ubuntu xenial main deb http://ppa.launchpad.net/webupd8team/java/ubuntu xenial main # deb-src http://ppa.launchpad.net/webupd8team/java/ubuntu xenial main ##deb http://ppa.launchpad.net/yannubuntu/boot-repair/ubuntu xenial main # deb-src http://ppa.launchpad.net/yannubuntu/boot-repair/ubuntu xenial main deb http://ppa.launchpad.net/yannubuntu/boot-repair/ubuntu xenial main # deb-src http://ppa.launchpad.net/yannubuntu/boot-repair/ubuntu xenial main command: apt-cache policy libpng12-0 output: libpng12-0: Installed: 1.2.50-2+deb8u3 Candidate: 1.2.54-1ubuntu1 Version table: 1.2.54-1ubuntu1 500 500 http://archive.ubuntu.com/ubuntu xenial/main amd64 Packages *** 1.2.50-2+deb8u3 100 100 /var/lib/dpkg/status

There is no menu option for the default powerpoint program in Details > Default Applications in Debian Linux, in Fig. 1. A terminal command and/or GUI tool is welcome for the task. Testing Stephen's oneliner --- Commands and their outputs $ xdg-mime query filetype test.ppt application/wps-office.ppt $ xdg-mime query default $(xdg-mime query filetype test.ppt) wps-office-wpp.desktop Testing setting up by the outptus the default ppt viewer xdg-mime default wps-office-wpp.desktop \ application/wps-office.ppt Output: no effect in opening .ppt files; other lines are not needed because VND and others are not in my system OS: Debian 9.1 Linux Powerpoint: WPS Presentation, currently LibreOffice presentation as default

You have 777 .doc files where each .doc file contains a big Excel table, like one here and in Fig. 1. Here, only consider one .doc file. I want to divide the Excel table of .doc file into CSV files by any Unix programming language and/or scripting. I cannot find a way to handle Microsoft fileformats into CSV files. Pseudocode: 1. Extract Excel table from .doc file, which is expanded in the thread How to extract many .doc text + tabular elements into CSV by any Unix tool? 2. Split Excel table (maybe convert here already to CSV) into separate .CSV files by Rule: > *new bolding indicates a new table* i.e. a new CSV file. 3. Apply implicit columns *Location* (bottom/top) and *Date* (dd.mm.yyyy) in the first two lines of the .doc file on the each separate CSV file. Use *Time* column (morning/evening/night). Target files with their columns by Rule 1. Assisstants.csv - Name, Date, Location, Time 2. Other.Assistants.csv - Name, Date, Location, Time 3. General.csv - Event, Date, Location, Time Fig. 1 Example of Excel Table in .doc file OS: Linux Debian Stretch 9 and others Data: .odt file here

Assume you have the following content in clipboard Yt rauhallinen. Lorem ipsun loremp. If you paste it into a cell in any spreadsheet editor, you get the content in many cells. Expected output: the content in one cell after paste. OS: Linux Debian Stretch 9.1 Spreadsheet editor: WPS Spreadsheet