WZ XCEL is an Excel inspired window deigned to introduce spreadsheet functionality within your WZWB application. Our philosophy behind the design of WZ XCEL is one of ensuring input equals output delivering to users via UI Pop outs a user friendly ability to simply copy and paste data from any grid or window existing under WZWB to a spreadsheet. WZ XCEL is by no means a replacement of MS Excel® neither is it a copy, its an inspiration with which to offer WZWB Users the same control they have come to expect from full featured spreadsheet products such as Microsoft Excel®.
With UI Pop outs WZWB offers users a choice of data outputs by default being either XCEL the window here in or MS Excel®.
XCEL features:
-
The ability to allow Users to work natively with the popular spreadsheet document file formats in a familiar Excel style environment without resorting to external spreadsheet software.
-
The ability on Pop out selection to copy and paste multiple datasets relating to any one Master record (of e.g. Vehicle, Hauler, Customer, Product, Order, Price book, Destination, Supplier and more) into individual XCEL tabs creating a single workbook that can be saved and opened with MS Excel®.
-
Email attaching the copied (and optionally edited) spreadsheet or workbook to WZWB customers or suppliers within two clicks.
Users familiar with MS Excel® will learn some habitual changes under XCEL alas many similarities do exist:
-
Comprehensive MS Excel® style row, column, and cell management. Users can insert or delete specific cells/cell ranges, as well as insert or delete entire columns or rows, either by using the context menus, dedicated insert/delete dialogs or Pop outs.
-
MS Excel® style clipboard operations, including cell insertion/deletion.
-
Provides a friendly and familiar cell data processing environment; the XCEL window control supports over 60 keys and key combinations available in Microsoft Excel®.
-
Supports a comprehensive range of functions for use within formulas. Function categories include:
-
Math and trigonometry
-
Date & Time
-
Logical
-
Statistical
-
Financial
-
Text
-
Lookup and reference
-
Information
-
Compatibility
-
Advanced cell value formatting with custom format codes support for:
-
General
-
Number
-
Currency
-
Accounting
-
Date
-
Time
-
And more
-
Create, load, save, modify, and print workbooks;
-
List, format, arrange, process, and analyze the cell data;
-
Load, convert and save workbooks using XLSX, XLS, CSV, and binary file formats;
-
Support for the History functionality, allowing Users to easily undo and redo the actions performed within the currently opened workbook.
-
And so much more.
WZWB is about delivering User Choice, flexibility and functionality and XCEL is one component of many that we trust users will enjoy and become familiar with.