User Tools

Site Tools


Supported Excel functionality for an in-browser EASAP

An in-browser EASAP supports many features found within an Excel spreadsheet.

In general an in-browser EASAP may,

  • Read a value from a spreadsheet cell
  • Write a value into a cell
  • Set the Number Format for a cell
  • Clear a value from a cell
  • Extract a charts and display it as an image in a browser
  • Screen capture a range of cells and display it as an image
  • Run a macros

Below is a list of supported Excel features for an in-browser EASAP.

To enable features that are not supported for an in-browser EASAP, EASA 6.0 support a native Excel Client interface which serves a temporary, running Excel spreadsheet instance with full functionality to a User (See Excel Client vs. in-browser EASAP)

Excel FeatureSupportedAlternative / Notes
Read Cell ValueY
Write Value to CellY
Read Formula in CellY
Write Formula to Cell-Possible by running a macro written for this purpose
Clear Value in CellY
Apply Number Format to CellN
Run MacrosYNote: See Macro-Related Issues for compatibility notes
Display Conditional Formatting-Similar behavior can be added manually into EASA application if used for highlighting or visibility
Modify Charts-Possible by running a macro written for this purpose
Replicate Data ValidationY
Reference Cells by NameY
Insert Rows or Columns-Possible by running a macro written for this purpose
Create Worksheet-Possible by running a macro written for this purpose
Insert PictureN
Apply Data FilterN
Pivot Tables Control-Possible by running a macro written for this purpose
Linked FilesYNote: Linked files will need to be manually placed in correct locations on Excel Server
Data SourcesY
View ZoomN
Calculate Sheet Now (F9)Y
FormsYMust be re-implemented using a FORM
Form ControlsYButton's are supported by the Excel Range Wizard other controls may be implemented in the Builder
ActiveX ControlsYButton's are supported by the Excel Range Wizard other controls may be implemented in the Builder
Add-insY

Page Tools