Exemple #1
0
        public DimensionsRecord CreateDimensions()
        {
            DimensionsRecord result = new DimensionsRecord();

            result.FirstRow = (firstrow);
            result.LastRow  = (lastrow);
            result.FirstCol = _valuesAgg.FirstCellNum;
            result.LastCol  = _valuesAgg.LastCellNum;
            return(result);
        }
Exemple #2
0
 public SeriesDataAggregate(RecordStream rs)
 {
     dimensions = (DimensionsRecord)rs.GetNext();
     while (rs.PeekNextChartSid() == SeriesIndexRecord.sid)
     {
         SeriesIndexRecord siIndex = (SeriesIndexRecord)rs.GetNext();
         int sid = rs.PeekNextChartSid();
         List<Record> dataList = new List<Record>();
         while (sid == NumberRecord.sid || sid == BoolErrRecord.sid || sid == BlankRecord.sid || sid == LabelRecord.sid)
         {
             dataList.Add(rs.GetNext());
         }
         dicData.Add(siIndex, dataList);
     }
 }
 public SeriesDataAggregate(RecordStream rs)
 {
     dimensions = (DimensionsRecord)rs.GetNext();
     while (rs.PeekNextChartSid() == SeriesIndexRecord.sid)
     {
         SeriesIndexRecord siIndex = (SeriesIndexRecord)rs.GetNext();
         int           sid         = rs.PeekNextChartSid();
         List <Record> dataList    = new List <Record>();
         while (sid == NumberRecord.sid || sid == BoolErrRecord.sid || sid == BlankRecord.sid || sid == LabelRecord.sid)
         {
             dataList.Add(rs.GetNext());
         }
         dicData.Add(siIndex, dataList);
     }
 }
Exemple #4
0
        public void TestMissingDims()
        {
            int          rowIx = 5;
            int          colIx = 6;
            NumberRecord nr    = new NumberRecord();

            nr.Row    = (rowIx);
            nr.Column = ((short)colIx);
            nr.Value  = (3.0);

            List <Record> inRecs = new List <Record>();

            inRecs.Add(BOFRecord.CreateSheetBOF());
            inRecs.Add(new RowRecord(rowIx));
            inRecs.Add(nr);
            inRecs.Add(CreateWindow2Record());
            inRecs.Add(EOFRecord.instance);
            InternalSheet sheet;

            try
            {
                sheet = CreateSheet(inRecs);
            }
            catch (Exception e)
            {
                if ("DimensionsRecord was not found".Equals(e.Message))
                {
                    throw new AssertionException("Identified bug 46206");
                }
                throw e;
            }

            RecordInspector.RecordCollector rv = new RecordInspector.RecordCollector();
            sheet.VisitContainedRecords(rv, rowIx);
            Record[] outRecs = rv.Records;
            Assert.AreEqual(8, outRecs.Length);
            DimensionsRecord dims = (DimensionsRecord)outRecs[5];

            Assert.AreEqual(rowIx, dims.FirstRow);
            Assert.AreEqual(rowIx, dims.LastRow);
            Assert.AreEqual(colIx, dims.FirstCol);
            Assert.AreEqual(colIx, dims.LastCol);
        }
Exemple #5
0
        public void TestSheetDimensions()
        {
            InternalSheet    sheet      = InternalSheet.CreateSheet();
            DimensionsRecord dimensions = (DimensionsRecord)sheet.FindFirstRecordBySid(DimensionsRecord.sid);

            Assert.AreEqual(0, dimensions.FirstCol);
            Assert.AreEqual(0, dimensions.FirstRow);
            Assert.AreEqual(1, dimensions.LastCol);  // plus pne
            Assert.AreEqual(1, dimensions.LastRow);  // plus pne

            RowRecord rr = new RowRecord(0);

            sheet.AddRow(rr);

            Assert.AreEqual(0, dimensions.FirstCol);
            Assert.AreEqual(0, dimensions.FirstRow);
            Assert.AreEqual(1, dimensions.LastCol);
            Assert.AreEqual(1, dimensions.LastRow);

            CellValueRecordInterface cvr;

            cvr        = new BlankRecord();
            cvr.Column = ((short)0);
            cvr.Row    = (0);
            sheet.AddValueRecord(0, cvr);

            Assert.AreEqual(0, dimensions.FirstCol);
            Assert.AreEqual(0, dimensions.FirstRow);
            Assert.AreEqual(1, dimensions.LastCol);
            Assert.AreEqual(1, dimensions.LastRow);

            cvr        = new BlankRecord();
            cvr.Column = ((short)1);
            cvr.Row    = (0);
            sheet.AddValueRecord(0, cvr);

            Assert.AreEqual(0, dimensions.FirstCol);
            Assert.AreEqual(0, dimensions.FirstRow);
            Assert.AreEqual(2, dimensions.LastCol);   //YK:  failed until Bugzilla 53414 was fixed
            Assert.AreEqual(1, dimensions.LastRow);
        }