5.14.1 Value Types

CGXStyle::SetValueType() allows you to specify the value type in a cell. Possible types are:

CGXStyle::GetValueType() returns the value type of the cell.

SetValueType() does not affect the way values are stored in CGXStyle. All values are stored as a string. SetValueType() only offers additional information about the value that is stored in the cell. For example, when you apply numeric formatting to a cell, it will only affect the cell if its value type is GX_VT_NUMERIC.

The value type information is very important when you pass style objects to the formula engine. The formula engine parses values to determine if they should be stored as strings or as numbers. It is very important for the formula engine to distinguish between numbers and strings.

// Sets the value type to GX_VT_NUMERIC SetValueRange(CGXRange(nRow, nCol), 122.22); // Sets the value type to GX_VT_STRING SetValueRange(CGXRange(nRow, nCol), "122.22"); // Sets the value type to GX_VT_STRING SetStyleRange(CGXRange(nRow, nCol), CGXStyle().SetValue ("122.22")); // Sets the value type to GX_VT_NUMERIC SetStyleRange(CGXRange(nRow, nCol), CGXStyle().SetValue (929.2)); // SetExpressionRowCol parses the string and sets the // value type to GX_VT_NUMERIC SetExpressionRowCol (nRow, nCol, "1222.22"); // SetExpressionRowCol parses the string and sets the // value type to GX_VT_STRING SetExpressionRowCol (nRow, nCol, "ABDGDDG1222.22");

5.14.2 Formatting Number Values for Static Cells

These methods let you format number values for static cells and specify the precision of the value (the number of significant digits).

Objective Grid lets you format number values for inactive cells and specify the precision when appropriate. The formatted value is only displayed for static (inactive) cells. If you start editing a cell, the original value is displayed.

For example, if you store the value 122.2345 in a cell and then set the format to be fixed with two decimals, 122.23 is displayed in the cell. When you click the cell make the cell active, the cell value changes to 122.2345. Once you leave the cell the cell is made inactive again, the display text reverts to 122.23.

When you apply numeric formatting to a cell, it only affects the cell if the value type is GX_VT_NUMERIC.

Table 8: Format Types

Use CGXStyle::SetFormat() to apply number formatting to cells.

SetExpressionRowCol(nRow, 1, _T("General")); SetExpressionRowCol(nRow+1, 1, _T("7777.77")); SetStyleRange(CGXRange(nRow+1, 1), CGXStyle().SetFormat(GX_FMT_GEN).SetPlaces(15)); SetExpressionRowCol(nRow, 2, _T("Fixed")); SetExpressionRowCol(nRow+1, 2, _T("7777.77")); SetStyleRange(CGXRange(nRow+1, 2), CGXStyle().SetFormat(GX_FMT_FIXED).SetPlaces(4)); SetExpressionRowCol(nRow, 3, _T("Scientific")); SetExpressionRowCol(nRow+1, 3, _T("7777.77")); SetStyleRange(CGXRange(nRow+1, 3), CGXStyle().SetFormat(GX_FMT_FLOAT).SetPlaces(4)); SetExpressionRowCol(nRow, 4, _T("Dollars")); SetExpressionRowCol(nRow+1, 4, _T("7777.77")); SetStyleRange(CGXRange(nRow+1, 4), CGXStyle().SetFormat(GX_FMT_DOLLARS).SetPlaces(2)); SetExpressionRowCol(nRow, 5, _T("Comma")); SetExpressionRowCol(nRow+1, 5, _T("7777.77")); SetStyleRange(CGXRange(nRow+1, 5), CGXStyle().SetFormat(GX_FMT_COMMA).SetPlaces(2)); SetExpressionRowCol(nRow, 6, _T("Percent")); SetExpressionRowCol(nRow+1, 6, _T(".77")); SetStyleRange(CGXRange(nRow+1, 6), CGXStyle().SetFormat(GX_FMT_PERCENT).SetPlaces(2));

5.14.3 Recognizing Locale Settings in Static Formatting

---

This applies only to non formula grids.

---

By default, Objective Grid does not use regional settings when you choose to format numbers. So, it cannot understand that 1.345,13 is a number, and format it properly, even if your system's regional settings are set so that period is the thousands separator and comma is the decimal separator. To get Objective Grid to use your regional settings, add a call to CGXGridCore:: EnableLocaleNumbers() in your grid's Initialize() or OnInitialUpdate() call. After that, any cell using a CGXEditControl that has been formatted using one of the codes listed below will use the numeric locale settings. In addition, with this setting enabled, Objective Grid will recognize values typed into numeric formatted cells as being numerical values.

No matter what the locale settings, the actual numerical values stored in the grid's data object use a period as the decimal separator and do not contain any thousands separator. This convention makes the grid's serialization locale independent. Numbers serialized from a grid using Italian settings can be read into a grid using English settings without losing the numerical values.

Also, for historical reasons, Objective Grid catches system changes through handling the WM_WININICHANGE message. If your code implements a handler for the newer WM_SETTINGCHANGE message, make sure you return a FALSE in your message handler so the grid's handler will also be called.

To customize this behavior, derive your control from CGXEditControl and override one of these three virtual CGXEditControl methods.

virtual BOOL StripSeparatorFromValue(CString& sValue, const CGXStyle* pStyle, double& d); // called from Store & ConvertControlTextToValue (handles Paste) // to strip group separator from the value before it is stored virtual BOOL PutDecInValue(CString& sValue, const CGXStyle* pStyle); //called from Init to put correct dec sep in windowtext virtual BOOL AcceptCommasInNumbers(const CGXStyle* pStyle); // returns whether strings with thousands separator should be // treated as a number. Default behavior checks for one of these // number formats: // GX_FMT_FIXED // GX_FMT_COMMA // GX_FMT_DOLLARS // GX_FMT_FLOAT // GX_FMT_GEN // GX_FMT_FIXED_PARENS // GX_FMT_NUMLOCALE

By default in a non-formula grid, the code below will display 1234.5555 as 1,234.56 no matter what your regional settings are. But if you add a call to EnableLocaleNumbers() in your initialization code, the formatting will reflect your regional settings. For example, using Italian locale settings would display the value 1234.5555 as 1.234,56.

SetStyleRange(CGXRange(1,1,1,2), CGXStyle() .SetFormat(GX_FMT_COMMA) .SetValueType(GX_VT_NUMERIC) .SetPlaces(2) .SetValue((double) 1234.5555) );