| private SetRepeatingRowsAndColumns ( int sheetIndex, int startColumn, int endColumn, int startRow, int endRow ) : void | ||
| sheetIndex | int | |
| startColumn | int | |
| endColumn | int | |
| startRow | int | |
| endRow | int | |
| return | void | |
public void TestRepeatingRowsAndColums()
{
// First Test that Setting RR&C for same sheet more than once only Creates a
// single Print_Titles built-in record
XSSFWorkbook wb = new XSSFWorkbook();
wb.CreateSheet("First Sheet");
wb.SetRepeatingRowsAndColumns(0, -1, -1, -1, -1);
// Set repeating rows and columns twice for the first sheet
for (int i = 0; i < 2; i++)
{
wb.SetRepeatingRowsAndColumns(0, 0, 0, 0, 3);
//sheet.CreateFreezePane(0, 3);
}
Assert.AreEqual(1, wb.NumberOfNames);
IName nr1 = wb.GetNameAt(0);
Assert.AreEqual(XSSFName.BUILTIN_PRINT_TITLE, nr1.NameName);
Assert.AreEqual("'First Sheet'!$A:$A,'First Sheet'!$1:$4", nr1.RefersToFormula);
//remove the columns part
wb.SetRepeatingRowsAndColumns(0, -1, -1, 0, 3);
Assert.AreEqual("'First Sheet'!$1:$4", nr1.RefersToFormula);
//revert
wb.SetRepeatingRowsAndColumns(0, 0, 0, 0, 3);
//remove the rows part
wb.SetRepeatingRowsAndColumns(0, 0, 0, -1, -1);
Assert.AreEqual("'First Sheet'!$A:$A", nr1.RefersToFormula);
//revert
wb.SetRepeatingRowsAndColumns(0, 0, 0, 0, 3);
// Save and re-open
IWorkbook nwb = XSSFTestDataSamples.WriteOutAndReadBack(wb);
Assert.AreEqual(1, nwb.NumberOfNames);
nr1 = nwb.GetNameAt(0);
Assert.AreEqual(XSSFName.BUILTIN_PRINT_TITLE, nr1.NameName);
Assert.AreEqual("'First Sheet'!$A:$A,'First Sheet'!$1:$4", nr1.RefersToFormula);
// check that Setting RR&C on a second sheet causes a new Print_Titles built-in
// name to be Created
nwb.CreateSheet("SecondSheet");
nwb.SetRepeatingRowsAndColumns(1, 1, 2, 0, 0);
Assert.AreEqual(2, nwb.NumberOfNames);
IName nr2 = nwb.GetNameAt(1);
Assert.AreEqual(XSSFName.BUILTIN_PRINT_TITLE, nr2.NameName);
Assert.AreEqual("SecondSheet!$B:$C,SecondSheet!$1:$1", nr2.RefersToFormula);
nwb.SetRepeatingRowsAndColumns(1, -1, -1, -1, -1);
}
public void TestRepeatingRowsAndColums()
{
// First Test that Setting RR&C for same sheet more than once only Creates a
// single Print_Titles built-in record
XSSFWorkbook wb = new XSSFWorkbook();
wb.CreateSheet("First Sheet");
wb.SetRepeatingRowsAndColumns(0, -1, -1, -1, -1);
// Set repeating rows and columns twice for the first sheet
for (int i = 0; i < 2; i++)
{
wb.SetRepeatingRowsAndColumns(0, 0, 0, 0, 3);
//sheet.CreateFreezePane(0, 3);
}
Assert.AreEqual(1, wb.NumberOfNames);
IName nr1 = wb.GetNameAt(0);
Assert.AreEqual(XSSFName.BUILTIN_PRINT_TITLE, nr1.NameName);
Assert.AreEqual("'First Sheet'!$A:$A,'First Sheet'!$1:$4", nr1.RefersToFormula);
//remove the columns part
wb.SetRepeatingRowsAndColumns(0, -1, -1, 0, 3);
Assert.AreEqual("'First Sheet'!$1:$4", nr1.RefersToFormula);
//revert
wb.SetRepeatingRowsAndColumns(0, 0, 0, 0, 3);
//remove the rows part
wb.SetRepeatingRowsAndColumns(0, 0, 0, -1, -1);
Assert.AreEqual("'First Sheet'!$A:$A", nr1.RefersToFormula);
//revert
wb.SetRepeatingRowsAndColumns(0, 0, 0, 0, 3);
// Save and re-open
IWorkbook nwb = XSSFTestDataSamples.WriteOutAndReadBack(wb);
Assert.AreEqual(1, nwb.NumberOfNames);
nr1 = nwb.GetNameAt(0);
Assert.AreEqual(XSSFName.BUILTIN_PRINT_TITLE, nr1.NameName);
Assert.AreEqual("'First Sheet'!$A:$A,'First Sheet'!$1:$4", nr1.RefersToFormula);
// check that Setting RR&C on a second sheet causes a new Print_Titles built-in
// name to be Created
nwb.CreateSheet("SecondSheet");
nwb.SetRepeatingRowsAndColumns(1, 1, 2, 0, 0);
Assert.AreEqual(2, nwb.NumberOfNames);
IName nr2 = nwb.GetNameAt(1);
Assert.AreEqual(XSSFName.BUILTIN_PRINT_TITLE, nr2.NameName);
Assert.AreEqual("SecondSheet!$B:$C,SecondSheet!$1:$1", nr2.RefersToFormula);
nwb.SetRepeatingRowsAndColumns(1, -1, -1, -1, -1);
}
static void Main(string[] args)
{
IWorkbook wb = new XSSFWorkbook();
ISheet sheet1 = wb.CreateSheet("new sheet");
ISheet sheet2 = wb.CreateSheet("second sheet");
// Set the columns to repeat from column 0 to 2 on the first sheet
IRow row1 = sheet1.CreateRow(0);
row1.CreateCell(0).SetCellValue(1);
row1.CreateCell(1).SetCellValue(2);
row1.CreateCell(2).SetCellValue(3);
IRow row2 = sheet1.CreateRow(1);
row2.CreateCell(1).SetCellValue(4);
row2.CreateCell(2).SetCellValue(5);
IRow row3 = sheet2.CreateRow(1);
row3.CreateCell(0).SetCellValue(2.1);
row3.CreateCell(4).SetCellValue(2.2);
row3.CreateCell(5).SetCellValue(2.3);
IRow row4 = sheet2.CreateRow(2);
row4.CreateCell(4).SetCellValue(2.4);
row4.CreateCell(5).SetCellValue(2.5);
// Set the columns to repeat from column 0 to 2 on the first sheet
wb.SetRepeatingRowsAndColumns(0, 0, 2, -1, -1);
// Set the the repeating rows and columns on the second sheet.
wb.SetRepeatingRowsAndColumns(1, 4, 5, 1, 2);
//set the print area for the first sheet
wb.SetPrintArea(0, 1, 2, 0, 3);
FileStream sw = File.Create("test.xlsx");
wb.Write(sw);
sw.Close();
}
public void Test49253()
{
XSSFWorkbook wb1 = new XSSFWorkbook();
XSSFWorkbook wb2 = new XSSFWorkbook();
// No print Settings before repeating
XSSFSheet s1 = wb1.CreateSheet() as XSSFSheet;
Assert.AreEqual(false, s1.GetCTWorksheet().IsSetPageSetup());
Assert.AreEqual(true, s1.GetCTWorksheet().IsSetPageMargins());
wb1.SetRepeatingRowsAndColumns(0, 2, 3, 1, 2);
Assert.AreEqual(true, s1.GetCTWorksheet().IsSetPageSetup());
Assert.AreEqual(true, s1.GetCTWorksheet().IsSetPageMargins());
XSSFPrintSetup ps1 = s1.PrintSetup as XSSFPrintSetup;
Assert.AreEqual(false, ps1.ValidSettings);
Assert.AreEqual(false, ps1.Landscape);
// Had valid print Settings before repeating
XSSFSheet s2 = wb2.CreateSheet() as XSSFSheet;
XSSFPrintSetup ps2 = s2.PrintSetup as XSSFPrintSetup;
Assert.AreEqual(true, s2.GetCTWorksheet().IsSetPageSetup());
Assert.AreEqual(true, s2.GetCTWorksheet().IsSetPageMargins());
ps2.Landscape=(false);
Assert.AreEqual(true, ps2.ValidSettings);
Assert.AreEqual(false, ps2.Landscape);
wb2.SetRepeatingRowsAndColumns(0, 2, 3, 1, 2);
ps2 = s2.PrintSetup as XSSFPrintSetup;
Assert.AreEqual(true, s2.GetCTWorksheet().IsSetPageSetup());
Assert.AreEqual(true, s2.GetCTWorksheet().IsSetPageMargins());
Assert.AreEqual(true, ps2.ValidSettings);
Assert.AreEqual(false, ps2.Landscape);
}
