[WPS office][Archlinux] How to install WPS office in archlinux

Edit pacman configuration file
/etc/pacman.conf


[archlinuxcn]
SigLevel = Optional TrustedOnly
Server = http://repo.archlinuxcn.org/$arch


Update pacman database
pacman -Syy


Install wps-office package
pacman -S wps-office


Reference:

• Arch Linux 中文社区仓库 / 镜像加速源

Read More

[LibreOffice] Delete entire row if text contains specific string

• Select a cell in Column M.
• Select all cells in the spreadsheet with Ctrl-A.
• Open the Data->Filter->Standard Filter menu.
• Set the first row of the filter so that Field Name is “Column M”, Condition is “Not Equals” and Value is “on”.
• Click OK to apply the filter to the spreadsheet.
• Select all rows in the spreadsheet with Ctrl-A. To unselect any column header cells, hold Ctrl and click the appropriate row.
• [Delete Row] Right-click on any of the row numbers and select Delete Rows.
  
  
  Reference:
• OpenOffice: Delete rows based on cell value

Read More

[openoffice] move row to column

1.Select the cell range that you want to transpose.


2.Choose Edit - Cut.


3.Click the cell that is to be the top left cell in the result.


4.Choose Edit - Paste Special.


5.In the dialog, mark Paste all and Transpose. 



howto: move row to column ?

Read More