<%@ Page Language="VB" ResponseEncoding="utf-8" Debug="true" %> <%@ Register TagPrefix="Rico" Assembly="Rico" NameSpace="Rico" %> <%@ Register TagPrefix="My" TagName="dbLib" Src="dbConnect.ascx" %> Rico SimpleGrid-Number Formats
Base Library:

Rico: SimpleGrid

In Simple Grids, NumberFormat can be part of the SimpleStyle declaration and the format gets applied to cells of type DateTimeCell and NumberCell. This example shows how the various formats get applied to dates and numbers -- and demonstrates how they match the formats exported to Excel.

The formats generally follow the rules for Excel custom formats, with the following exceptions:

  • Months must be upper case (M, MM, MMM, MMMM)
  • Hours in 12-hour format must be lower case (h, hh) and include the "AM/PM" designator. Hours in 24-hour format must be upper case (H, HH) and must not include the "AM/PM" designator.
  • Nothing involving square brackets [] is supported (colors, ranges, etc). These formatting characters are also not supported: _ * ? @ /