Manual:Extension/Spreadsheets

bsvFeature::The extension ''Spreadsheets'' is available from BlueSpice bsvFrom::5.2.

Overview

You can create spreadsheets directly in the wiki.

Wiki spreadsheet

To create a new spreadsheet:

1. Select New spreadsheet from the "new"-menu.

   

   Create spreadsheet

2. Enter a name for your spreadsheet.
3. Click Create. The spreadsheet opens in edit mode. The spreadsheet opens in edit mode. You can switch to Fullscreen view if you want to add many columns.

   

   enable fullscreen mode

4. Click Save to save your spreadsheet.

Page name:Each spreadsheet in the wiki has the extension .sheet as part of its pagename.

Displaying table information

Showing a data range

You can include a range of continuous data from a wiki spreadsheet on another page.

Data range from a wiki spreadsheet

To extract a data range from the spreadsheet on a page:

1. Open the Content Droplets menu in visual editing mode.
2. Search for Spreadsheet data.
3. Insert the content droplet on the page.
4. Fill in the information for the data range:
   1. Spreadsheet page: Name of your existing spreadsheet page
   2. Range to select: A continuous range of cells to select, separated by a colon (e.g.: A1:E5)
   3. Format: Table creates a table of class "wikitable", plainlist creates a comma-separated list of values
   4. Separator:

This inserts the tag

Cannot access spreadsheet data, or invalid range specified

on the page.

Showing a data gauge

You can compare the current value of a cell to a target value and show the status in a gauge format.

Data gauges

​To display a gauge chart for a selected spreadsheet value:

1. Open the Content Droplets menu in visual editing mode.
2. Search for Spreadsheet data gauge.
3. Insert the content droplet on the page.
4. Fill in the information for the data gauge:
   1. Spreadsheet page: Name of your existing spreadsheet page
   2. Cell to gete value from: Cell that contains the number value you want to track
   3. Format: Gauge, Progress bar
   4. Minimum value: Starting value to calculate from
   5. Maximum value: End value to calculate to
   6. Display size (in px): Output size of the graphic.
   7. Color: Web color of the calculated valuel .

This inserts the tag <sheetdata:gauge page="Sales data.sheet" min="1" max="100000" format="gauge" size="100" stroke="#4caf50" cell="F4" /> on the page.

List of all spreadsheets

A list of all spreadsheets can be shown or hidden by administrators under the entrypoint links in the main navigation. You can also manually link to the page Special:SpreadsheetList.