Number and date formats in Interactive Reporting sections are exported based on the following predicates:
Any text within Reporting and Analysis format strings is enclosed double-quotes (““).
Interactive Reporting fills the number formats for positive, negative, and zero numbers to achieve compatibility with Excel’s construction. Excel number format definition consists of the above number formats, delimited with a semi-colon.
Date/time formats are exported as is except for the am/pm format, which receives a special format.
Thousands and decimal separators are converted to Excel special symbols based on the default Reporting and Analysis locale format. When the number format is evaluated, the decimal separator converts to ".” (a period) and the thousand separator becomes “,” (a comma) in the target Excel format. Excel treats these special symbols as locale independent separators and replaces them with actual separators from the user’s locale at run-time.
A value in an Excel cell has two aspects: the value formatted for displaying and the original value. Similarly when a value is placed in a HTML table, a special attribute x:num=”<actual value>” is used to preserve the original value. The pre-formatted value is placed in a cell of the HTML table, and it can be shown in the web browser. Formulas operate with the original values. The x:str attribute is used as a global designator in an html <table> in order to tell Excel that all the values which do not have x:num attribute specified should be treated as strings. This is useful when there is mixed string and numeric data in a string type column. The third component associated with an HTML table cell is a style class. It is used to specify the custom numeric format for a cell value. Date and time values are represented as numbers. These values are saved in the x:num attribute, and the style class definition specifies the format for date.