8,849
edits
Changes
→Builder
:[[Image:XMLSectionIssues.png|link=|700px]]
* CSS classes specified can either be the system defined classes, or you can create your own CSS classes and include them in the <style> tag on the Template. (See [[Adding Styles to XML Worksheets]] for instructions)
* The formula can refer to other cells within the section using the following syntax:
* <font size="2">'''[row#,column#]'''</font>
white-space: -o-pre-wrap;
word-wrap: break-word;">
If the column on which you want to apply the validation on has a 'Currency' formatting then , you will have to convert the data into a number before you perform the validation.
</pre>
white-space: -o-pre-wrap;
word-wrap: break-word;">
To check if the amount entered is always greater than 0 for a column which has a currency formatting , use the built in ssParseNum function to convert the amount to a number.
ssParseNum([this])>0
</pre>