Excel Functionality
Steve Dalton · 2012
This chapter describes different aspects of excel functionality. Excel supports two styles of cell reference, both used for display and input. The default is the A1 style where the alphabetic part of the reference represents the column and the numeric part represents the row. The other is referred to as the R1C1 style. The main reason for spending any time discussing these is that some of the C API functions require or return range addresses in one form only. Some of Excels VBA functionality also requires R1C1 notation when setting graph source-data ranges. The formatting applied to a cell can, of course, make the appearance of a number it contains very different. A number may appear as a date, a time, a percentage, a currency amount, in scientific notation, or as a formatted fraction.