Welcome to SpreadsheetWEB Blog

Creating macros in Excel can be a difficult task, especially if you’re just starting out. However, Excel thankfully has several features that are designed to help developing macros. For example, calculations automatically update after every action, the...

As one of the most versatile calculators ever created, Excel is utilized to power innumerable business operations daily; however, can it ever fail to give you the correct results? In the case of floating numbers, it can. The term floating point refers to...

One of the popular uses of Excel is in data analysis and reporting applications. However, row data often must be organized and restructured before using in reports or other calculations. For example, when capturing individual names, product IDs, or other...

Microsoft Excel features more than 400 formulas that users enjoy when creating marvelous data models, calculators, and fun tools. Microsoft keeps adding new ones every now and then, but usually also keeps the existing ones for the sake of backwards...

Why can’t I use dates before 1/1/1900? I am getting 2 different results for the same calculation, how is that even possible? You might be asking yourself these types of questions, but worry not, Excel can be quirky at times. It may not be your fault after...

We’ve introduced the designer module in 6.0 with the purpose of decoupling the user interface creation from Excel workbooks. This approach proved to be very successful with its intuitive interface and added features. In the 6.1 version, responsive...

When creating a new web application from the SpreadsheetWEB web interface, the options you will see include Web Application, Web Service, Dashboard, Custom UI Application, and Designer. In this article, we’re going to be comparing two major methods, Web...

You may have built various data models, created complex calculators, and published monthly reports, or maybe you’re just a complete beginner when it comes to spreadsheets. Either way, Excel’s plethora of formulas, tables, shortcuts, and layout make it the...

Translating spreadsheet data doesn’t need to be difficult, time-consuming, and expensive. With SpreadSheetWEB, you can quickly transform Excel spreadsheets into full-fledged web applications without breaking the bank or asking for IT assistance. But don’t...