Exemple #1
0
        public void SubsetIsInvalidSubsetTest()
        {
            Range containerRange = Range.Parse("$A$1:$K$5");
            Range subsetRange = new Range();

            Assert.IsFalse(subsetRange.IsSubset(containerRange));
        }
		public static ChartSerie CreateChartSerie(ExcelChart chart, bool isPivot, Range seriesAddress, Range xSeriesAddress)
		{
			ChartSerie result = null ;
			switch (chart.ChartType)
			{
				case ExcelChartType.XYScatter:
				case ExcelChartType.XYScatterLines:
				case ExcelChartType.XYScatterLinesNoMarkers:
				case ExcelChartType.XYScatterSmooth:
				case ExcelChartType.XYScatterSmoothNoMarkers:
					result = new ScatterChartSerie(chart, isPivot);
					break;
				case ExcelChartType.Pie:
				case ExcelChartType.Pie3D:
				case ExcelChartType.PieExploded:
				case ExcelChartType.PieExploded3D:
				case ExcelChartType.PieOfPie:
				case ExcelChartType.Doughnut:
				case ExcelChartType.DoughnutExploded:
				case ExcelChartType.BarOfPie:
					result = new PieChartSerie(chart, isPivot);
					break;
				case ExcelChartType.Line:
				case ExcelChartType.LineMarkers:
				case ExcelChartType.LineMarkersStacked:
				case ExcelChartType.LineMarkersStacked100:
				case ExcelChartType.LineStacked:
				case ExcelChartType.LineStacked100:
					result = new LineChartSerie(chart, isPivot);
					if (chart.ChartType == ExcelChartType.LineMarkers ||
						chart.ChartType == ExcelChartType.LineMarkersStacked ||
						chart.ChartType == ExcelChartType.LineMarkersStacked100)
					{
						((LineChartSerie)result).Marker = ExcelMarkerStyle.Square;
					}
					((LineChartSerie)result).Smooth = ((ExcelLineChart)chart).Smooth;
					break;

				default:
					result = new ChartSerie(chart, isPivot);
					break;
			}
			result.Series = seriesAddress;
			result.XSeries = xSeriesAddress;

			return result;
		}
Exemple #3
0
 private static bool SelfCompare(Range r1, Range r2)
 {
     return ((r1.EndRow == r2.EndRow) && (r1.EndColumn == r2.EndColumn) && (r1.StartColumn == r2.StartColumn) && (r1.StartRow == r2.StartRow) && (r1.StartRow > 0) && (r1.StartColumn > 0) && (r2.EndRow > 0) && (r1.EndColumn > 0));
 }
Exemple #4
0
        /// <summary>
        /// 是否是某个Range的子集或者相等
        /// </summary>
        /// <param name="containerRange"></param>
        /// <returns></returns>
        public bool IsSubsetOrEqual(Range containerRange)
        {
            bool result = false;

            if (containerRange != null)
            {
                if (this.IsValidRange() && containerRange.IsValidRange())
                {
                    result = containerRange.StartRow <= this.StartRow && containerRange.EndRow >= this.EndRow &&
                            containerRange.StartColumn <= this.StartColumn && containerRange.EndColumn >= this.EndColumn;
                }
            }

            return result;
        }
Exemple #5
0
 public Table(WorkSheet workSheet, string name, CellAddress beginAddress)
     : this(workSheet, name, Range.Parse(workSheet, beginAddress.ColumnIndex, beginAddress.RowIndex, beginAddress.ColumnIndex, beginAddress.RowIndex))
 {
 }