Tips and examples
Posted 09 August 2007 - 08:57 AM
You'll see how to convert a long and complex formula into a simple custom
function that can be used anywhere in any spreadsheet. You'll also create
a useful text parsing function that Excel should have shipped with, but
doesn't. And you'll see how to simplify one of the complex built-in
functions that Excel does ship with.
Posted 09 August 2007 - 09:05 AM
The tip covers using newly created functions inside Excel to make it
a snap to build tables (which are easier to use and run much quicker than
Excel's tables), and also creating bullet-proof functions just like the
pros do, with error checks, return values like #NA and even allowing for
default values for missing inputs.
Posted 09 August 2007 - 09:06 AM
These tips cover connecting to a database inside your new function, and
then processing the results. We also dive a bit into VBA (if you don't
know it, don't worry), showing you how handle one of the few drawbacks
of working with spreadsheets: looping. We also demonstrate how to call
into Calc4Web generated functions inside VBA (it's just as easy to call
the new functions from C, C++, standalone VB and any other high-level
While VBA is hardly necessary to get a lot of value from Calc4Web, it's
nice to know how to make a great product even better.
Posted 09 August 2007 - 09:07 AM
The tips show you how you can handle calculations based on ranges of
unlimited size (break through the 65,536 row and 256 column limit without
Excel 2007), and also how to quickly diagnose what's going on if a
function doesn't work as expected (we don't mean Calc4Web made a mistake,
it's when the spreadsheet had an error in a formula. This is called
debugging in programmer-speak, and with Calc4Web it's a whole lot easier
than in a language like C or VBA).
Reply to this topic
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users