Blog

3G Business Excel Like Spreadsheets

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.