private int AddNumericGroupItems(ExcelPivotTableFieldNumericGroup group, double start, double end, double interval)
{
if (interval < 0)
{
throw (new Exception("The interval must be a positiv"));
}
if (start > end)
{
throw(new Exception("Then End number must be larger than the Start number"));
}
XmlElement groupItems = group.TopNode.SelectSingleNode("d:fieldGroup/d:groupItems", group.NameSpaceManager) as XmlElement;
int items = 2;
//First date
double index = start;
double nextIndex = start + interval;
AddGroupItem(groupItems, "<" + start.ToString(CultureInfo.InvariantCulture));
while (index < end)
{
AddGroupItem(groupItems, string.Format("{0}-{1}", index.ToString(CultureInfo.InvariantCulture), nextIndex.ToString(CultureInfo.InvariantCulture)));
index = nextIndex;
nextIndex += interval;
items++;
}
AddGroupItem(groupItems, ">" + nextIndex.ToString(CultureInfo.InvariantCulture));
return(items);
}
internal ExcelPivotTableFieldNumericGroup SetNumericGroup(double start, double end, double interval)
{
ExcelPivotTableFieldNumericGroup group;
group = new ExcelPivotTableFieldNumericGroup(NameSpaceManager, _cacheFieldHelper.TopNode);
_cacheFieldHelper.SetXmlNodeBool("d:sharedItems/@containsNumber", true);
_cacheFieldHelper.SetXmlNodeBool("d:sharedItems/@containsInteger", true);
_cacheFieldHelper.SetXmlNodeBool("d:sharedItems/@containsSemiMixedTypes", false);
_cacheFieldHelper.SetXmlNodeBool("d:sharedItems/@containsString", false);
group.TopNode.InnerXml += string.Format("<fieldGroup base=\"{0}\"><rangePr autoStart=\"0\" autoEnd=\"0\" startNum=\"{1}\" endNum=\"{2}\" groupInterval=\"{3}\"/><groupItems /></fieldGroup>", BaseIndex, start.ToString(CultureInfo.InvariantCulture), end.ToString(CultureInfo.InvariantCulture), interval.ToString(CultureInfo.InvariantCulture));
int items = AddNumericGroupItems(group, start, end, interval);
AddFieldItems(items);
_grouping = group;
return(group);
}
private int AddNumericGroupItems(ExcelPivotTableFieldNumericGroup group, double start, double end, double interval)
{
if (interval < 0)
{
throw (new Exception("The interval must be a positiv"));
}
if (start > end)
{
throw(new Exception("Then End number must be larger than the Start number"));
}
XmlElement groupItems = group.TopNode.SelectSingleNode("d:fieldGroup/d:groupItems", group.NameSpaceManager) as XmlElement;
int items = 2;
//First date
double index=start;
double nextIndex=start+interval;
AddGroupItem(groupItems, "<" + start.ToString(CultureInfo.InvariantCulture));
while (index < end)
{
AddGroupItem(groupItems, string.Format("{0}-{1}", index.ToString(CultureInfo.InvariantCulture), nextIndex.ToString(CultureInfo.InvariantCulture)));
index=nextIndex;
nextIndex+=interval;
items++;
}
AddGroupItem(groupItems, ">" + nextIndex.ToString(CultureInfo.InvariantCulture));
return items;
}
internal ExcelPivotTableFieldNumericGroup SetNumericGroup(double start, double end, double interval)
{
ExcelPivotTableFieldNumericGroup group;
group = new ExcelPivotTableFieldNumericGroup(NameSpaceManager, _cacheFieldHelper.TopNode);
_cacheFieldHelper.SetXmlNodeBool("d:sharedItems/@containsNumber", true);
_cacheFieldHelper.SetXmlNodeBool("d:sharedItems/@containsInteger", true);
_cacheFieldHelper.SetXmlNodeBool("d:sharedItems/@containsSemiMixedTypes", false);
_cacheFieldHelper.SetXmlNodeBool("d:sharedItems/@containsString", false);
group.TopNode.InnerXml += string.Format("<fieldGroup base=\"{0}\"><rangePr autoStart=\"0\" autoEnd=\"0\" startNum=\"{1}\" endNum=\"{2}\" groupInterval=\"{3}\"/><groupItems /></fieldGroup>", BaseIndex, start.ToString(CultureInfo.InvariantCulture), end.ToString(CultureInfo.InvariantCulture), interval.ToString(CultureInfo.InvariantCulture));
int items = AddNumericGroupItems(group, start, end, interval);
AddFieldItems(items);
_grouping = group;
return group;
}
