Excel inspired UI
Read/Write XLSx, XLS, CSV and TXT Files
Microsoft Office Inspired UI
The 3G Business Spreadsheet provides the UI experience your end users have come to expect from today’s most popular office productivity suite. It includes full integration with the 3G Business Suite of Applications so you can quickly access all cloud spreadsheets without sacrificing the feature set you are use to.
Straightforward and Easy-to-Use Spreadsheet
The new 3G Business Spreadsheet is an Excel inspired control and provides you with the ability of accessing various spreadsheet file types directly within your 3GB cloud environment. It can load, convert and save workbooks to the XLS binary file format and can export and import XLSX, CSV and TXT files.
Spreadsheet Charts
You can summarise worksheet data visually and make data interpretation easier using a variety of charts. Create a simple chart and then customise its appearance for maximum effect. Apply one of the predefined chart layouts and styles or adjust chart elements manually. You are provided with the following chart types; Column Charts, Line Charts, Pie Charts, Bar Charts, Area Charts, Scatter Charts, Stock Charts, Radar Charts
Automated Formula Calculation
3G Business formula calculation results have been engineered to closely match those of Microsoft Excel. Automatic and manual calculation modes are supported. You can evaluate worksheet formulas, view help and explanations on how to use them plus much more.
Cell References
A formula can contain references to other cells or cell ranges within the same or different worksheets. The following references are supported:
- A1 and R1C1 References
- Relative, Absolute and Mixed References
- Cross-Worksheet References
- 3D References
- Structured References
The Name Manager helps end-users to manage named ranges and defined names.
Built-in Spreadsheet Functions
he 3G Business Spreadsheet Control supports a comprehensive range of functions for use within formulas. Function categories include:
- Mathematical
- Statistical
- Date & Time
- Text
- Financial
- Logical
- Lookup & Reference
- Engineering
- Information
- Database
- Web
- Real-Time Data function
3G Business is the first complete suite of business applications that delivers a whole new level of efficiency by eliminating the need for other applications, for costly and complex integration and for expensive customisation. 3G Business comes with 26+ converged apps, so there is no need for integration. You can customise them yourself so there is no need for customisation engineers.
