Super User
Super User

Questions tagged [wps-spreadsheet]

For questions about WPS Spreadsheets, an application within the Kingsoft WPS Office suite.

WPS Office, previously known as Kingsoft Office, is a cross-platform office suite by Kingsoft, a Chinese software developer. It consists of three applications: Writer, Presentation, and Spreadsheets, of which the name is an acronym. It is highly compatible with the equivalent Microsoft Office applications, Word, PowerPoint, and Excel. There is a no-cost personal basic version, and a more fully featured version available for a subscription fee.

Publisher's web site: https://www.wps.com/en-US/

12 questions
11
votes
4 answers

WPS Office CSV Delimiter - Linux

I have been using LibreOffice for all my Spreadsheet and Wordprocessing requirements lately but am getting fed up with the performance issues, it has a massive lag and also constantly freezes. I have decided to give WPS Office a try and instantly…
SupGen
  • 323
  • 1
  • 3
  • 13
2
votes
2 answers

WPS and writing in arabic/persian language

I have a problem in using WPS. When I write in WPS writer everything works fine and the result is same as I want but when I work with WPS presentation and spreadsheet I can't change direction to RTL and every letter gets separated, and they are not…
athena
  • 21
2
votes
2 answers

Excel round 0.34 to 0.35

Let say A1's value is 0.34 If I use =ROUND(A1,2) formula in excel, this will produce 0.34 too. I know this is the right one. What I want to do is to change 0.34 value to 0.35
Sabrina
  • 5,743
1
vote
0 answers

Sheet Right to left in WPS Spreadsheets

I would like to know how to change sheet direction from L2R to R2L in WPS office (Spreadsheets) for Arabic language? The option is in Page Layout in MS Excel, but I can't seem to find it in WPS. Page Layout in Excel Thanks in advance.
Rachid OUABDERZAQ
  • 11
1
vote
2 answers

WPS Office 2019 cannot run on a server?

I have recently started to use WPS Office, and it runs well on my PC. However, when I try to install this on a small terminal server I cannot start any application. I know that the default install path is a user folder, so that won't work, so I…
nepdev
  • 271
  • 1
  • 2
  • 13
0
votes
0 answers

In WPS spreadsheets, I keep getting shrunken work area w/ a blank task pane or something on the right. How do I get rid of it to expand the full view?

I have created these spreadsheets with a full screen available. Randomly, some unknown task pane or something appears on the right when I reopen the file. I cannot find how to get rid of or hide that and expand the full usable screen view. It is the…
user2703774
  • 1
0
votes
0 answers

No longer able to create or modify folder/file in Ubuntu 20.04 LTS

I was making changes to an Excel file(.xlsx) in WPS in my Windows 10 partition, and tried saving it when I got the following dialog box that my file had suddenly changed to read-only mode, which is strange as earlier I could make changes to it. I…
RaphaelZero
  • 1
0
votes
1 answer

What is this blank legend icon in MS Excel column chart?

I don't seem to understand what is this blank series and/or the blue box in legends which has no text next to it. Could someone please help? Here's the image showing my problem. https://i.sstatic.net/mDpcP.png
Leandra
  • 1
0
votes
1 answer

WPS office spreadsheet scripting?

Is some additional scripting available for WPS office spreadsheets? I need to upgrade by application platform from Apple numbers, it supports formulas and very limited automation scripting which is stored outside document, to something where can I…
Radim Kolář
  • 101
0
votes
1 answer

i want to return value( eg;- sum) only if the source is not blank,other wise return blank !!not zero!! in excel, wps

see this screenshot for reference see this screenshot.. I used SUM formula in the botton cells to get sum of all values from each row , the bottom cells display TOTAL and i will assign the TOTAL cells in the form of "1" / "0"(on/off) !!( NOT TO…
Musawir_ap
  • 3
0
votes
2 answers

Function that writes name depending on two conditions

I would like to know how to implement this in an excel formula: I have a column with some names, a row with different numbers (dates), and the remaining values work as "keys". For instance: 3 10 17 24 person1 HE person2…
player1
  • 1
0
votes
1 answer

Deleting Repeated cells

I am comparing 2 columns in WPS spreadsheet using the 'Highlight Duplicates' option. Once it is highlighted, if I use remove duplicates it isn't deleting the duplicates. If i manually delete the cells, the highlighted cells, will be…
BRMBU
  • 1
  • 2
  • 7