Publish

Publish as table

Publish as table allows to show sheet as a simple html table. It significantly improves page load time, but the disadvantage is that currently only text and numerical values are allowed (all other values will be ignored).

In the ‘Publish spreadsheet’ read more >>

Publish spreadsheet

Publish Spreadsheet

Users can share their spreadsheets to the public or to the registered users only (share to the selected users is in development).

There are two properties that need to be specified before publishing:

  • Accessibility:
    • Public access for all – the spreadsheet is accessible by all visitors.
    • All registered users – the spreadsheet is accessible only by all registered users.
    • Only registered and selected users – this option is still in development, but will allow to select users for access.
    Additional options:
    • Allow spreadsheet copy – select it if you let other users to copy your spreadsheet.
    • Add to main page – after review your spreadsheet will be announced on our website.
    Mode:
    • Table – it allows to publish spreadsheet as a simple html table (only for text/number values).
    • Spreadsheet – default value – owner can allow others to manipulate the values in the cell (by changing the cell’s ‘Unprotected cell’ property), but the new values will not be saved.
    Properties:
    • Hide tabbar – useful if there is only one sheet in the spreadsheet or if the user doesn’t allow to switch betweet tabs.
    • Show grids
    • Show column header
    • Show row header

    The next step is to click ‘Publish spreadsheet’ read more >>

Charts (Sparklines)

jQuery Sparklines is a JavaScript library that can make a couple of types of sparkline charts on a website. We use this library as one of our basic charting libraries (alongside RGraph).

CHART / CHART_sparklines function

To show an RGraph chart in your spreadsheet you can use a function CHART or CHART_SPARKLINES. The syntax for both functions is similar, except that CHART_SPARKLINES doesn’t require argument library:

=CHART(xvalues, yvalues, library, type, options)

=CHART_SPARKLINES(xvalues, yvalues, type, options)

The arguments meaning:

xvalues – a sequence of numbers (1, 2, 3, 4, …) or cell addresses (A1, A2, A3, …) or a range (A1:A20) specifying labels on x-axis,

yvalues – a sequence of numbers (1, 2, 3, 4, …) or cell addresses (A1, A2, A3, …) or a range (A1:A20) specifying values on y-axis,

library – “rgraph” (with quotes, single or double) specifying library,

type – “line”, “bar”, “pie”, … (with quotes) specifying type of the chart,

options – library specific options, like thickness of the line or bar, shadow etc. Currently the full specification can be found on the library’s website. Options are not mandatory and the field can be left blank. If the value of option is set to be TRUE or FALSE, it needs to be given with quotes (“TRUE” or “true”). The same applies to the colours (“blue”).

A couple of examples:

read more >>

Charts (RGraph)

RGraph is a JavaScript library that can make a wide variety of chart types and graphs on a website. We use this library as one of our basic charting libraries (alongside jQuery Sparklines). Currently only canvas based charts can be created.

CHART / CHART_RGRAPH function

To show an RGraph chart in your spreadsheet you can use a function CHART or CHART_RGRAPH. The syntax for both functions is similar, except that CHART_RGRAPH doesn’t require argument library:

=CHART(xvalues, yvalues, library, type, options)

=CHART_RGRAPH(xvalues, yvalues, type, options)

The arguments meaning:

xvalues – a sequence of numbers (1, 2, 3, 4, …) or cell addresses (A1, A2, A3, …) or a range (A1:A20) specifying labels on x-axis,

yvalues – a sequence of numbers (1, 2, 3, 4, …) or cell addresses (A1, A2, A3, …) or a range (A1:A20) specifying values on y-axis,

library – “rgraph” (with quotes, single or double) specifying library,

type – “line”, “bar”, “pie”, … (with quotes) specifying type of the chart,

options – library specific options, like thickness of the line or bar, shadow etc. Currently the full specification can be found on the library’s website. Options are not mandatory and the field can be left blank. If the value of option is set to be TRUE or FALSE, it needs to be given with quotes (“TRUE” or “true”). The same applies to the colours (“blue”).

A couple of examples:

=CHART(['Olaf','Katy','Frank','Mary','Barbara','Lee','John'],[84,76,79,84,86,52,53],"rgraph",
read more >>

Charts

TotalSheets uses 3-rd party JavaScript libraries to show any graphical results. All visualizations are carried our for each cell individually. As for the charting libraries, currently there are two supported libraries:

RGraph

jQuery Sparklines

To add a chart to a cell, CHART function can be used. The full syntax is as follows:

=CHART(xvalues, yvalues, library, type, options)

The arguments are described below:

xvalues – a sequence of numbers (1, 2, 3, 4, …) or cell addresses (A1, A2, A3, …) or a range (A1:A20) specifying labels on x-axis,

yvalues – a sequence of numbers (1, 2, 3, 4, …) or cell addresses (A1, A2, A3, …) or a range (A1:A20) specifying values on y-axis,

library – “rgraph” or “sparklines” (with quotes, single or double) specifying library,

type – “line”, “bar”, “pie”, … (with quotes) specifying type of the chart,

options – library specific options, like thickness of the line or bar, shadow etc. Currently the full specification can be found on the library’s website. Options are not mandatory and the field can be left blank. If the value of option is set to be TRUE or FALSE, it needs to be given with quotes (“TRUE” or “true”). The same applies to the colours (“blue”).

A couple of examples:

=CHART([1,2,3,4,5,6,7,8,9,10],[12,6,21,45,32,11,35,65,43,26],"sparklines",
read more >>

Cell Format

There are a couple of cell formats that can be set for each cell.

General

This is a default setting for all cells with no specific format.

Number

Numbers with specific formatting and decimal spaces.

Currency

Display numbers as monetary values. Decimal spaces applies.

Date

Format read more >>

TotalSheets Presentation

Quick Start

What is TotalSheets and how you can use it?

TotalSheets is a platform that offers you all the tools you need to create a fully functional online spreadsheet. Similar to Google Sheets in concept, but with the intention to give a greater control to owners over the appearance of their published read more >>