Sunday, June 08, 2008

Installing Wikicalc: the most beautiful OpenSource spreadsheets

As I indicated in my last post: WikiCalc is a collaborative spreadsheet operating on the principle of wiki. It is completely written in Perl. To install Wikicalc, nothing more simple, just start by installing the necessary tools for your good old Debian:
apt-get install apache2 libapache2-mod-perl2
Then download sources: wikicalc-1-0.tar.gz. Then can begin the installation process itself:
cd /var/www
tar xvzf wikicalc-1-0.tar.gz
ln -s wikicalc-1-0 wikicalc

Now you have to let the Wikicalc engine to be accessible from your Web server: compared to the configuration by default, you just need to add these few lines :



NameVirtualHost *

ServerAdmin webmaster@localhost

DocumentRoot /var/www/wikicalc/

Options FollowSymLinks
AllowOverride None


Options Indexes FollowSymLinks MultiViews ExecCGI
AddHandler cgi-script .cgi .pl
AllowOverride None
Order allow,deny
allow from all





Load Perl module:
a2enmod perl
restart /etc/init.d/apache2

To finish the installation, go to http://wikicalc.monsite.com/wikicalccgi.pl and follow the instructions ....

Now you can play with this imressive spreedsheat