Databases Reference
In-Depth Information
FIGURE 11.2
Cell properties.
.
If a
CELL PROPERTIES
clause is present in a query, only the properties you specified
in the clause are returned in the result.
This means that if you have included a
CELL PROPERTIES
clause, the
VALUE
property
won't be returned unless you explicitly specify it in the
CELL PROPERTIES
clause.
Most cell properties are used to enable client applications to provide “smart” formatting
and coloring of the cell display. For example,
FORMAT_STRING
and
FORMATTED_VALUE
are
intended to enable custom formatting of values, such as putting a dollar sign ($) before a
value that represents currency. This formatting is controlled by rules defined by the OLE
DB for OLAP specification.
NOTE
On the MSDN website, you can find various documentation about how the formatting
works, at
http://msdn.microsoft.com/en-us/library/aa262745.aspx.
You can find out
how formatting works in the OLE DB for OLAP specification (content of
FORMAT_STRING
The
FORE_COLOR
and
BACK_COLOR
properties were designed to enable the client application
to draw the attention of the user to particular patterns in the data. For example, you could
enable the application to display profits in green and losses in red in a financial report.
Search WWH ::
Custom Search