View source for Pagedraft:Manual:Extension/Spreadsheets

{{BSVersion|bsvFrom=5.2|bsvFeature=The extension ''Spreadsheets''}}
== Overview ==
You can create spreadsheets directly in the wiki. 
[[File:sheet page in edit mode.png|alt=Page of type sheet with example sales data|center|thumb|750x750px|Wiki spreadsheet]]



'''To create a new spreadsheet:'''

# '''Select''' ''New spreadsheet'' from the "new"-menu.[[File:create spreadsheet link.png|alt="Create" menu with options|center|thumb|282x282px|Create spreadsheet]]
# '''Enter''' a name for your spreadsheet.
# '''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.[[File:fullscreen edit spreadsheet.png|alt=fullscreen page toggle |center|thumb|305x305px|enable fullscreen mode]]
# '''Click''' ''Save'' to save your spreadsheet.

{{Textbox|boxtype=note|header=Page name:|text=Each spreadsheet in the wiki has the extension .sheet as part of its pagename.|icon=yes}}

== Displaying table information ==

=== Showing a data range ===
You can include  a range of continuous data from a wiki spreadsheet on another page.
[[File:spreadsheet droplet data range.png|alt=output of the "spreadsheet data" droplet|center|thumb|300x300px|Data range from a wiki spreadsheet]]
'''To extract a data range from the spreadsheet on a page:'''

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

This inserts the tag <code><sheetdata page="Sales data.sheet" format="table" range="A1:D5" separator="," /></code> 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.
[[File:spreadsheet data gauge.png|alt=Comparison of ficticious gross sales targets of France, Germany and Mexiko as gauges.|center|thumb|350x350px|Data gauges]]

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

# '''Open''' the [[Manual:Extension/ContentDroplets|Content Droplets]] menu in visual editing mode.
# '''Search''' for ''Spreadsheet data gauge''.
# '''Insert''' the content droplet on the page.
# '''Fill in''' the information for the data gauge:
## ''Spreadsheet page:'' Name of your existing spreadsheet page
## ''Cell to gete value from:'' Cell that contains the number value you want to track
## ''Format:'' Gauge, Progress bar
## ''Minimum value:'' Starting value to calculate from
## ''Maximum value:'' End value to calculate to
## ''Display size (in px):'' Output size of the graphic.
## ''Color:'' [[wikipedia:Web_colors|Web color]] of the calculated valuel . 
This inserts the tag  <code><sheetdata:gauge page="Sales data.sheet" min="1" max="100000" format="gauge" size="100" stroke="#4caf50" cell="F4" /></code>  on the page.

== List of all spreadsheets ==
A list of all spreadsheets can be shown or hidden by administrators under the [[Manual:Extension/BlueSpiceDiscovery/Main navigation#%E2%80%8BDeactivating entrypoint links|entrypoint links in the main navigation]]. You can also manually link to the page ''Special:SpreadsheetList''.