Create a Websheet
Access
This feature is available to [Engagement] Team Members and Engagement Managers. A Websheet is a control that allows you to display and edit an Excel file completely within OneTeam. You may have the ability to create a Websheet or to Edit a Websheet directly from the Data Repository, or you may be able to create Requests or Action Items that use WebSheets.
Important information about creating a Websheet
-
Websheets originate as Excel files. Only use a ".xlsx" file to be a websheet.
-
Whilst the Websheet control mimics Excel in functionality there are some differences for you to be aware of.
Supported Cell Formats
Alignment: Horizontal
Border: Bottom: Line Colour
Border: Bottom: Line Style
Border: Left: Line Colour
Border: Left: Line Style
Border: Right: Line Colour
Border: Right: Line Style
Border: Top: Line Colour
Border: Top: Line Style
Date: Short Date Excel Type=d/m/yy
Date: Long Date Excel Type=[$-x-sysdate]dddd, mmmm dd, yyyy
To learn more about about how to enter dates correctly, go to: Editing Dates in a WebSheet
Fill: Background Colour
Merged Cells
Number: Accounting Excel Type=_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)
Number: Currency Excel Type=$#,##0.00
Number: General Excel Type=0.00
Number: Percentage Excel Type=0%
Number: Percentage + Decimal Places Excel Type=0.00% (where DP=2).
Text: Bold
Text: Colour
Text: Font
Text: Italic
Text: Size
Locked
Text Wrap
Supported Sheet formats
Hidden sheets
Protected sheets
Column(s) Width
Row(s) Height