How to install ethercalc in Ubuntu

To install ethercalc in Ubuntu

Ethercalc is a web based Spreadsheet application to create excelsheet documents. It supports collaborative editing which permits multiple users to work on the same file. In this article we will learn how to install Ethercalc. It is usually installed on the centralized server for managing document, whereas the clients are connected to a network with server. The clients can access the document any time for editing using the URL of the document file. It will saves the data automatically.

To install the dependencies

Run the following command to install the essential packages to download the ethercalc.

root@linuxhelp ~ # apt-get install build-essential git perl python -y 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
python is already the newest version.
The following extra packages will be installed:
  cpp-4.8 dpkg-dev g++ g++-4.8 gcc-4.8 gcc-4.8-base gcc-4.8-base:i386 git-man
  libasan0 libatomic1 libc-dev-bin libc6 libc6:i386 libc6-dbg libc6-dev
  libdpkg-perl liberror-perl libgcc-4.8-dev libgfortran3 libgomp1 libitm1
  libperl5.18 libquadmath0 libstdc++-4.8-dev libstdc++6 libstdc++6:i386
  libtsan0 perl-base perl-modules
.
.
.
Setting up perl-modules (5.18.2-2ubuntu1.1) ...
Setting up perl (5.18.2-2ubuntu1.1) ...
Setting up libdpkg-perl (1.17.5ubuntu5.7) ...
Setting up dpkg-dev (1.17.5ubuntu5.7) ...
Setting up build-essential (11.6ubuntu6) ...
Setting up liberror-perl (0.17-1.1) ...
Setting up git (1:1.9.1-1ubuntu0.3) ...
Processing triggers for libc-bin (2.19-0ubuntu6.6) ...

To install nodejs

Before nodejs, install python-software-properties by utilizing the following command.

root@linuxhelp ~ # apt-get install python-software-properties -y  
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following NEW packages will be installed:
  python-software-properties
0 upgraded, 1 newly installed, 0 to remove and 349 not upgraded.
Need to get 4,512 B of archives.
After this operation, 28.7 kB of additional disk space will be used.
Get:1 http://packages.linuxmint.com/ rosa/upstream python-software-properties all 1.5.2 [4,512 B]
Fetched 4,512 B in 0s (6,480 B/s)               
Selecting previously unselected package python-software-properties.
(Reading database ... 172870 files and directories currently installed.)
Preparing to unpack .../python-software-properties_1.5.2_all.deb ...
Unpacking python-software-properties (1.5.2) ...
Setting up python-software-properties (1.5.2) ...

Next add the ppa repository for nodejs and update your system repository for the better performance of the system.

root@linuxhelp ~ # apt-add-repository ppa:chris-lea/node.js 
You are about to add the following PPA to your system:
 Evented I/O for V8 javascript. Node' s goal is to provide an easy way to build scalable network programs
 More info: https://launchpad.net/~chris-lea/+archive/ubuntu/node.js
Press [ENTER] to continue or ctrl-c to cancel adding it

Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --homedir /tmp/tmp.HCya3qjnXT --no-auto-check-trustdb --trust-model always --keyring /etc/apt/trusted.gpg --primary-keyring /etc/apt/trusted.gpg --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys C7917B12
gpg: requesting key C7917B12 from hkp server keyserver.ubuntu.com
gpg: key C7917B12: public key " Launchpad chrislea"  imported
gpg: Total number processed: 1
gpg:               imported: 1  (RSA: 1)

root@linuxhelp ~ # apt-get update 
Ign http://archive.canonical.com trusty InRelease
Ign http://ppa.launchpad.net trusty InRelease                                  
Hit http://security.ubuntu.com trusty-security InRelease                       
Ign http://archive.ubuntu.com trusty InRelease                                 
Ign http://packages.linuxmint.com rosa InRelease                               
Hit http://archive.canonical.com trusty Release.gpg                            
Ign http://extra.linuxmint.com rosa InRelease
.
.
.
Ign http://archive.ubuntu.com trusty/universe Translation-en_IN                
Ign http://packages.linuxmint.com rosa/import Translation-en_IN                
Ign http://packages.linuxmint.com rosa/import Translation-en                   
Ign http://packages.linuxmint.com rosa/main Translation-en_IN                  
Ign http://packages.linuxmint.com rosa/main Translation-en                     
Ign http://packages.linuxmint.com rosa/upstream Translation-en_IN              
Ign http://packages.linuxmint.com rosa/upstream Translation-en                 
Fetched 18.3 kB in 16s (1,132 B/s)                                             
Reading package lists... Done

Then use the below command to install nodejs.

root@linuxhelp ~ # apt-get install nodejs -y 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  rlwrap
The following NEW packages will be installed:
  nodejs rlwrap
0 upgraded, 2 newly installed, 0 to remove and 349 not upgraded.
Need to get 4,483 kB of archives.
After this operation, 18.4 MB of additional disk space will be used.
Get:1 http://ppa.launchpad.net/chris-lea/node.js/ubuntu/ trusty/main nodejs amd64 0.10.37-1chl1~trusty1 [4,410 kB]
Get:2 http://archive.ubuntu.com/ubuntu/ trusty/universe rlwrap amd64 0.37-5 [73.4 kB]
.
.
.
Unpacking nodejs (0.10.37-1chl1~trusty1) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Setting up rlwrap (0.37-5) ...
update-alternatives: using /usr/bin/rlwrap to provide /usr/bin/readline-editor (readline-editor) in auto mode
Setting up nodejs (0.10.37-1chl1~trusty1) ...

To install redis

Utilize the following command to add the ppa repository and update the system repository.

root@linuxhelp ~ # add-apt-repository ppa:rwky/redis 
You are about to add the following PPA to your system:
 This ppa is no longer maintained. Please consider https://launchpad.net/~chris-lea/+archive/ubuntu/redis-server instead
 More info: https://launchpad.net/~rwky/+archive/ubuntu/redis
Press [ENTER] to continue or ctrl-c to cancel adding it

Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --homedir /tmp/tmp.wHPDnqH0ti --no-auto-check-trustdb --trust-model always --keyring /etc/apt/trusted.gpg --primary-keyring /etc/apt/trusted.gpg --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 5862E31D
gpg: requesting key 5862E31D from hkp server keyserver.ubuntu.com
gpg: key 5862E31D: public key " Launchpad PPA for Rowan"  imported
gpg: Total number processed: 1
gpg:               imported: 1  (RSA: 1)
linuxhelp ~ # apt-get update
Ign http://archive.canonical.com trusty InRelease
Ign http://archive.ubuntu.com trusty InRelease                                 
Get:1 http://security.ubuntu.com trusty-security InRelease [65.9 kB]           
.
.
.
Hit http://archive.ubuntu.com trusty/restricted Translation-en                 
Hit http://archive.ubuntu.com trusty/universe Translation-en                   
Ign http://archive.ubuntu.com trusty/main Translation-en_IN                    
Ign http://archive.ubuntu.com trusty/multiverse Translation-en_IN              
Ign http://archive.ubuntu.com trusty/restricted Translation-en_IN              
Ign http://archive.ubuntu.com trusty/universe Translation-en_IN                
Fetched 3,969 kB in 19s (204 kB/s)                                             
Reading package lists... Done

Now install redis server by running the following command.

root@linuxhelp ~ # apt-get install redis-server -y 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Suggested packages:
  redis-doc
The following NEW packages will be installed:
  redis-server
0 upgraded, 1 newly installed, 0 to remove and 349 not upgraded.
Need to get 508 kB of archives.
.
.
.
Unpacking redis-server (2:3.0.6-rwky1~trusty) ...
Processing triggers for ureadahead (0.100.0-16) ...
ureadahead will be reprofiled on next reboot
Setting up redis-server (2:3.0.6-rwky1~trusty) ...
redis-server start/running, process 10657
Processing triggers for ureadahead (0.100.0-16) ...

To check redis server is running use the below command.

root@linuxhelp ~ # redis-cli ping 
PONG

To install ethercalc

Download and install ethercalc by cloning it from the github as shown below.

root@linuxhelp ~ # git clonehttps://github.com/audreyt/ethercalc.git 
Cloning into ' ethercalc' ...
remote: Counting objects: 7023, done.
remote: Total 7023 (delta 0), reused 0 (delta 0), pack-reused 7023
Receiving objects: 100% (7023/7023), 9.33 MiB | 214.00 KiB/s, done.
Resolving deltas: 100% (4029/4029), done.
Checking connectivity... done.

Now install the ethercalc by using the following command.

root@linuxhelp ~ # npm install -g ethercalc 
-
>  webworker-threads@0.7.8 install /usr/lib/node_modules/ethercalc/node_modules/webworker-threads
>  node-gyp rebuild

gyp WARN EACCES user " root"  does not have permission to access the dev dir " /home/user1/.node-gyp/0.10.37" 
gyp WARN EACCES attempting to reinstall using temporary dev dir " /usr/lib/node_modules/ethercalc/node_modules/webworker-threads/.node-gyp" 
make: Entering directory `/usr/lib/node_modules/ethercalc/node_modules/webworker-threads/build' 
  CXX(target) Release/obj.target/WebWorkerThreads/src/WebWorkerThreads.o
  SOLINK_MODULE(target) Release/obj.target/WebWorkerThreads.node
  SOLINK_MODULE(target) Release/obj.target/WebWorkerThreads.node: Finished
.
.
.
/usr/bin/ethercalc ->  /usr/lib/node_modules/ethercalc/bin/ethercalc
ethercalc@0.20160612.0 /usr/lib/node_modules/ethercalc
??? uuid-pure@1.0.10
??? xoauth2@1.2.0
??? redis@0.12.1
??? csv-parse@0.0.6
??? cors@2.7.1 (vary@1.1.0)
??? iconv-lite@0.4.13
??? optimist@0.6.1 (wordwrap@0.0.3, minimist@0.0.10)
??? minimatch@3.0.3 (brace-expansion@1.1.6)
??? livescript@1.4.0 (prelude-ls@1.1.2, optionator@0.6.0, source-map@0.3.0)
??? nodemailer@2.5.0 (nodemailer-shared@1.0.5, libmime@2.0.3, socks@1.1.9, mailcomposer@3.10.0, nodemailer-smtp-transport@2.6.0, nodemailer-direct-transport@3.2.0, nodemailer-smtp-pool@2.7.0)
??? socialcalc@2.2.0
??? j@0.4.3 (commander@2.9.0, concat-stream@1.5.1, harb@0.0.7, xlsjs@0.7.5, xlsx@0.7.12)
??? webworker-threads@0.7.8 (bindings@1.2.1, nan@2.4.0)
??? zappajs@0.5.0 (methods@1.1.0, node-uuid@1.4.1, coffee-css@0.0.5, uglify-js@2.4.15, express@3.16.9, coffeecup@0.3.21, socket.io@1.0.6

To launch ethercalc

To start the ethercalc service run the following command.

root@linuxhelp ~ # ethercalc 
Please connect to: http://linuxhelp:8000/
Starting backend using webworker-threads
Express server listening on port 8000 in development mode
Zappa 0.5.0 " You can' t do that on stage anymore"  orchestrating the show
Connected to Redis Server: localhost:6379
After starting the ethercalc service you open your web browser to access the ethercalc web interface by pointing to the URL link http://localhost:8000

Open the browser and type the URL https://localhost:8000

To Create New Spreadsheet, click create spreadsheet.

To create new document, type the URL http://localhost:/doc1

Tag : Ethercalc

FAQ

How to uninstall the Ethercalc on Ubuntu?

For uninstalling the Ethercalc on Ubuntu, use the following command as given below "apt-get remove ethercalc"

what is the official site for the ethercalc?

For accessing the Ethercalc, use the following link as given below "https://ethercalc.net/"

How to get the help from github repository for the ethercalc?

"For accessing the help session from the github repository, use the following link as given below "https://github.com/audreyt/ethercalc"

What are the anyalternatives for the ethercalc?

Here I have to give some of the alternative for the ethercalc,
LibreOffice - Calc,
ONLYOFFICE,
Google Drive - Sheets

How to access the Google Drive - Sheets?

For accessing the Google Drive-sheets, use the following link as given below "https://ethercalc.org/"