AppSuite:Spreadsheet Installation Guide: Difference between revisions

From Open-Xchange
No edit summary
No edit summary
Line 1: Line 1:
= Download & Installation OX Spreadsheet (Beta) =
= Download & Installation OX Spreadsheet =


== General Information ==
== General Information ==
Line 24: Line 24:
== Installation ==
== Installation ==


The OX Spreadsheet (Beta) deployment consists of the packages <tt>open-xchange-documents-backend</tt>,<tt>open-xchange-documents-ui</tt> and <tt>open-xchange-documents-ui-static</tt>
The OX Spreadsheet deployment consists of the packages <tt>open-xchange-documents-backend</tt>,<tt>open-xchange-documents-ui</tt> and <tt>open-xchange-documents-ui-static</tt>


=== Redhat Enterprise Linux 6 or CentOS 6 ===
=== Redhat Enterprise Linux 6 or CentOS 6 ===
Line 30: Line 30:
Add the following repositories to your Open-Xchange yum configuration:
Add the following repositories to your Open-Xchange yum configuration:


  {{for loop||call=YUMBetaRepo|pv=reponame|pc1n=path|pc1v=components|pc2n=betapath|pc2v=beta/7.4.2/|pc3n=rhelname|pc3v=RHEL6|pc4n=ldbaccount|office|office-web}}
  {{for loop||call=YUMRepo|pv=reponame|pc1n=path|pc1v=products/appsuite/stable|pc2n=rhelname|pc2v=RHEL6|office|office-web}}




Line 39: Line 39:
Add the following repositories to your Open-Xchange apt configuration:
Add the following repositories to your Open-Xchange apt configuration:


  {{for loop||call=APTBetaRepo|pv=reponame|pc1n=path|pc1v=components|pc2n=betapath|pc2v=beta/7.4.2/|pc3n=debianname|pc3v=DebianSqueeze|pc4n=ldbaccount|office|office-web}}
  {{for loop||call=APTRepo|pv=reponame|pc1n=path|pc1v=products/appsuite/stable|pc2n=debianname|pc2v=DebianSqueeze|office|office-web}}


  $ apt-get update
  $ apt-get update
Line 48: Line 48:
Add the following repositories to your Open-Xchange apt configuration:
Add the following repositories to your Open-Xchange apt configuration:


  {{for loop||call=APTBetaRepo|pv=reponame|pc1n=path|pc1v=components|pc2n=betapath|pc2v=beta/7.4.2/|pc3n=debianname|pc3v=DebianWheezy|pc4n=ldbaccount|office|office-web}}
  {{for loop||call=APTRepo|pv=reponame|pc1n=path|pc1v=products/appsuite/stable|pc2n=debianname|pc2v=DebianWheezy|office|office-web}}


  $ apt-get update
  $ apt-get update
Line 55: Line 55:
=== SUSE Linux Enterprise Server 11 ===
=== SUSE Linux Enterprise Server 11 ===


  {{for loop||call=SUSEBetaRepo|pv=reponame|pc1n=path|pc1v=components|pc2n=betapath|pc2v=beta/7.4.2/|pc3n=susename|pc3v=SLES11|pc4n=ldbaccount|office|office-web}}
  {{for loop||call=SUSERepo|pv=reponame|pc1n=path|pc1v=products/appsuite/stable|pc3n=susename|pc3v=SLES11|office|office-web}}


  $ zypper ref
  $ zypper ref
Line 62: Line 62:
== Printing and .xls Editing ==
== Printing and .xls Editing ==


For .XLS and/or printing support from OX Spreadsheet (Beta) the Document Converter and readerengine components have to be installed separately (license key required)
For .XLS and/or printing support from OX Spreadsheet the Document Converter and readerengine components have to be installed separately (license key required)


* See [[AppSuite:DocumentConverterInstall|Document converter / readerengine installation instructions]]
* See [[AppSuite:DocumentConverterInstall|Document converter / readerengine installation instructions]]
Line 70: Line 70:
=== Permissions ===
=== Permissions ===


To enable OX Spreadsheet (Beta) for OX Drive the associated permission has to be set.
To enable OX Spreadsheet for OX Drive the associated permission has to be set.


The default setting for all users is changed in the file '''permissions.properties''' in the directory ''/opt/open-xchange/etc''.
The default setting for all users is changed in the file '''permissions.properties''' in the directory ''/opt/open-xchange/etc''.

Revision as of 15:10, 31 March 2014

Download & Installation OX Spreadsheet

General Information

OX Spreadsheet is a browser based, cloud ready, spreadsheet product that can work with Microsoft Excel documents in a lossless way. And you can also collaborate with other people to edit shared spreadsheets on various devices.

Learn more about the highlights of OX Spreadsheet here: http://software.open-xchange.com/products/appsuite/doc/OX_Spreadsheet_Product_Guide.pdf

Requirements

See the Open-Xchange software requirements page for details.

OX Spreadsheet (Beta) needs to be installed in an OX App Suite configuration with a backend based on Grizzly.

For compatibility with XLS files (not XLSX) and for printing functionality in OX Spreadsheet (Beta) the document converter components (incl. readerengine) are required. These are not available in the Community Version of OX AppSuite.

Mandatory Modules

Additional functional modules need to be installed separately:

Installation

The OX Spreadsheet deployment consists of the packages open-xchange-documents-backend,open-xchange-documents-ui and open-xchange-documents-ui-static

Redhat Enterprise Linux 6 or CentOS 6

Add the following repositories to your Open-Xchange yum configuration:

 [open-xchange-office]
name=Open-Xchange-office
baseurl=https://software.open-xchange.com/products/appsuite/stable/office/RHEL6/
gpgkey=https://software.open-xchange.com/oxbuildkey.pub
enabled=1
gpgcheck=1
metadata_expire=0m

[open-xchange-office-web] name=Open-Xchange-office-web baseurl=https://software.open-xchange.com/products/appsuite/stable/office-web/RHEL6/ gpgkey=https://software.open-xchange.com/oxbuildkey.pub enabled=1 gpgcheck=1 metadata_expire=0m


$ yum install open-xchange-documents-backend open-xchange-documents-ui open-xchange-documents-ui-static

Debian GNU/Linux 6.0

Add the following repositories to your Open-Xchange apt configuration:

deb https://software.open-xchange.com/products/appsuite/stable/office/DebianSqueeze /
deb https://software.open-xchange.com/products/appsuite/stable/office-web/DebianSqueeze /
$ apt-get update
$ apt-get install open-xchange-documents-backend open-xchange-documents-ui open-xchange-documents-ui-static

Debian GNU/Linux 7.0

Add the following repositories to your Open-Xchange apt configuration:

deb https://software.open-xchange.com/products/appsuite/stable/office/DebianWheezy /
deb https://software.open-xchange.com/products/appsuite/stable/office-web/DebianWheezy /
$ apt-get update
$ apt-get install open-xchange-documents-backend open-xchange-documents-ui open-xchange-documents-ui-static

SUSE Linux Enterprise Server 11

$ zypper ar https://software.open-xchange.com/products/appsuite/stable/office/SLES11 office
$ zypper ar https://software.open-xchange.com/products/appsuite/stable/office-web/SLES11 office-web
$ zypper ref
$ zypper install open-xchange-documents-backend open-xchange-documents-ui open-xchange-documents-ui-static

Printing and .xls Editing

For .XLS and/or printing support from OX Spreadsheet the Document Converter and readerengine components have to be installed separately (license key required)

Configuration

Permissions

To enable OX Spreadsheet for OX Drive the associated permission has to be set.

The default setting for all users is changed in the file permissions.properties in the directory /opt/open-xchange/etc.

After installation the functionality is disabled:

# Default permissions for all users
permissions=

The following line enables the functionality:

# Default permissions for all users
permissions=spreadsheet

If there are already some permissions in this file, add spreadsheet separated with a comma.

calcengine

The calcengine has to be configured in the file /opt/open-xchange/etc/calcengine.properties.

# -----------------------------------------------------------------------------
# define the mode the calc engine will use at runtime
#
# possible values :
#
# - local
#       a set of worker processes are used at localhost;
#       One worker = one calc engine process.
#       JNI is used within worker process - not within main process.
#
# - http
#       calc engine client will connect to a remote server
#       where a calc engine server is running.
#       Every calc engine server will host a set of worker processes.
#       Communication protocol between client<->server<->worker is HTTP.
#
calcengine.mode=local

# -----------------------------------------------------------------------------
# timeout to detect hanging calc engine request
#
# unit    = [ms]
# default = 20s

calcengine.request.timeout=20000

# -----------------------------------------------------------------------------
# define the max. value for memory reserved for one worker instance.
#
# Each worker will use that value separately.
# So the memory consumption for the whole pool of worker instances
# will be : pool-size * worker.memory.
#
# unit=[MB]
#
# default = 2048

calcengine.worker.memory.max-mb=2048

# -----------------------------------------------------------------------------
# configure restart of one worker in case more then X documents was opened
# within those process.
#
# Note:
#
# - A value of 0 means -> these restart trigger is disabled
#   ... where might other restart trigger can be active.
#
# - Don't forget to configure reserve count value too
#   if you configure these restart trigger.
#
# default = 50

calcengine.worker.restart.trigger.max-doc-count=50

# -----------------------------------------------------------------------------
# timeout to detect non starting worker process
#
# unit    = [ms]
# default = 20s

calcengine.worker.init.timeout=20000

# -----------------------------------------------------------------------------
# define the range of ports to be used for a pool of worker processes.
#
# Of course MIN and MAX values needs to be in right (ascending) order.
# If not - an error is shown and calc engine environment wont work.
#
# MIN and MAX port are included in range. So pool size is MAX-MIN+1.
#
# default = 5001 ... 5003

calcengine.worker.port_range.min=5001
calcengine.worker.port_range.max=5003