Performance Improvements in Version 6.0

Performance Improvements in Version 6.0

One of our primary undertakings for the SpreadsheetWEB 6.0 release was a major dedicated effort to improve the performance of our core spreadsheet calculation engine. The calculation engine was written in C++ and is optimized for server-side processing, focusing...
Turning Excel Hell into Excel Heaven

Turning Excel Hell into Excel Heaven

Many Excel projects start with a small assignment to solve a simple problem. The individual tasked to solve the problem puts together an Excel workbook. As its usage expands, it is distributed to more and more individuals in the company. As more individuals utilize...

Custom Application Tutorial

What is a Custom Application? Custom application feature allows user to create unique user interfaces (UI) by using the flexibility of HTML and CSS combined with power of JavaScript programming language. How to create Custom UI applications Custom applications...

How to create User Defined Functions (UDF) in SpreadsheetWEB

What is a User Defined Function (UDF)? A user-defined function (UDF) is a function provided by the user of a program or environment, in a context where the usual assumption is that functions are built into the program or environment. Although Microsoft Office Excel...
Decoupling Business Logic with Excel-based Microservices

Decoupling Business Logic with Excel-based Microservices

Most applications, albeit web-based or otherwise, incorporate some resemblance of business logic – “the part of the program that encodes the real-world business rules that determine how data can be created, displayed, stored, and changed.”[1] Not only do these rules...