WPS Office for Linux – Community Edition

wpsOffice

WPS Office (an acronym for Writer, Presentation and Spreadsheets, previously known as Kingsoft Office) is an office suite for Microsoft Windows, Linux, iOS and Android OS, developed by Zhuhai-based Chinese software developer Kingsoft. WPS Office is a suite of software which is made up of three primary components: WPS Writer, WPS Presentation, and WPS Spreadsheet.wps

The personal basic version is free to use, but a watermark is printed on all printed output after the 30 day trial ends. A fully featured professional-grade version is also available for a subscription fee. The current version of WPS Office is WPS Office 10.

The product has had a long history of development and success in China under the name “WPS” and “WPS Office”. For a time, Kingsoft branded the suite under the “KSOffice” brand in an attempt to gain a foothold in international markets, but has since returned to “WPS Office”. Since WPS Office 2005, the user interface is similar to that of Microsoft Office products, and supports Microsoft document formats besides native Kingsoft formats.

wps-excel

Download Link–> http://wps-community.org/download.html

How To Install Apache2, MySQL, PHP5 on Ubuntu

apach2php5mysql

Apache is the most commonly used Web server on Linux systems. To install apache, open terminal and type in this command:

sudo apt-get install apache2

then
sudo nano /etc/apache2/apache2.conf
add this at the bottom of page –>  ServerName localhost

To install MySQL, open terminal and type in this command:
sudo apt-get install mysql-server php5-mysql

To install PHP, open terminal and type in this command:
sudo apt-get install php5 libapache2-mod-php5 php5-mcrypt

It may also be useful to add php to the directory index, to serve the relevant php index files:
sudo nano /etc/apache2/mods-enabled/dir.conf

Change this section as like below one.
<IfModule mod_dir.c>
DirectoryIndex index.html index.cgi index.pl index.php index.xhtml index.htm
</IfModule>

<IfModule mod_dir.c>
DirectoryIndex index.php index.html index.cgi index.pl index.xhtml index.htm
</IfModule>
You can run PHP5 scripts from command line. To run PHP5 scripts from command line you should install php5-cli package with this command: sudo apt-get install php5-cli

Restart apache so that all of the changes take effect:

sudo service apache2 restart

create a new file with this command :

sudo nano /var/www/index.php

and this lines:

<?php

phpinfo();

?>

save it with Ctrl + X and Y.

Then type localhost on your browser.

Allow ports on Firewall on Linux

On Ubuntu firewall comes disabled. Because Ubuntu does not have any open network services (except for basic network infrastructure) in the default installation.

To turn on type:

sudo ufw enable

to turn it off :

sudo ufw disable

To allow ports  on X port:

sudo ufw allow X

or

sudo ufw allow ssh

sudo ufw allow http

and to block the ports on X port:

sudo ufw block X

or

sudo ufw block ssh

sudo ufw block http

 

If you are using Red Hat / Fedora / Centos based OS, you can type for X port:

sudo firewall-cmd –permanent –add-port=X/tcp

Example : sudo firewall-cmd –permanent –add-port=8080/tcp

and to reload the firewall:

sudo firewall-cmd –reload

Oracle Java for Ubuntu and setting JDK for Netbeans

For those who want to install Oracle Java JDK to develop Java programs and applications (the Oracle Java JRE is also included in the Oracle JDK) use this method:

Open your terminal and type:

sudo apt-add-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java8-installer

Setting as default JDK

sudo apt-get install oracle-java8-set-default

Setting the path globally:

type : sudo nano /etc/bash.bashrc  and add this line at the end of page.

export JAVA_HOME=/usr/lib/jvm/java-8-oracle

loading bash.bash.bashrc

source /etc/bash.bashrc

Now you have to configure Netbeans to use this JDK or run Netbeans with

cd /usr/local/netbeans-8.1/etc or /usr/share/netbeans/8.1/etc (this is for version 8.1)

sudo nano netbeans.conf and change the line netbeans_jdkhome=”/usr” as below

netbeans_jdkhome=”/usr/lib/jvm/java-8-oracle/”