public class org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest extends java.lang.Object
{
org.apache.poi.xssf.usermodel.XSSFWorkbook workbook;
org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet;
org.apache.poi.xssf.usermodel.XSSFSheet targetSheet;
org.apache.isis.subdomains.excel.applib.util.SheetPivoter p;
public org.junit.rules.ExpectedException expectedException;
public void <init>()
{
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
org.junit.rules.ExpectedException v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
specialinvoke v.<java.lang.Object: void <init>()>();
v = staticinvoke <org.junit.rules.ExpectedException: org.junit.rules.ExpectedException none()>();
v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.junit.rules.ExpectedException expectedException> = v;
return;
}
public void setup()
{
org.apache.poi.xssf.usermodel.XSSFWorkbook v, v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
org.apache.poi.xssf.usermodel.XSSFSheet v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoter v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v = new org.apache.poi.xssf.usermodel.XSSFWorkbook;
specialinvoke v.<org.apache.poi.xssf.usermodel.XSSFWorkbook: void <init>()>();
v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFWorkbook workbook> = v;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFWorkbook workbook>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFWorkbook: org.apache.poi.xssf.usermodel.XSSFSheet createSheet()>();
v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet> = v;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFWorkbook workbook>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFWorkbook: org.apache.poi.xssf.usermodel.XSSFSheet createSheet()>();
v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet> = v;
v = new org.apache.isis.subdomains.excel.applib.util.SheetPivoter;
specialinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: void <init>()>();
v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p> = v;
return;
}
public void poi_method_lastCellNumber_yields_1_higher_than_expected()
{
org.assertj.core.api.AbstractComparableAssert v;
org.assertj.core.api.AbstractShortAssert v, v, v;
org.assertj.core.api.ObjectAssert v, v;
org.apache.poi.ss.usermodel.CellType v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
org.assertj.core.api.AbstractIntegerAssert v;
org.apache.poi.xssf.usermodel.XSSFRow v, v, v, v, v, v, v;
short v, v, v;
int v;
org.apache.poi.xssf.usermodel.XSSFSheet v, v, v, v, v, v, v, v;
org.apache.poi.xssf.usermodel.XSSFCell v, v, v, v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow createRow(int)>(0);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell createCell(int)>(0);
interfaceinvoke v.<org.apache.poi.ss.usermodel.Cell: void setBlank()>();
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(0);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: short getLastCellNum()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractShortAssert assertThat(short)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractShortAssert: org.assertj.core.api.AbstractShortAssert isEqualTo(short)>(1);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(0);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(1);
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.ObjectAssert assertThat(java.lang.Object)>(v);
virtualinvoke v.<org.assertj.core.api.ObjectAssert: org.assertj.core.api.AbstractAssert isEqualTo(java.lang.Object)>(null);
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.ObjectAssert assertThat(java.lang.Object)>(v);
virtualinvoke v.<org.assertj.core.api.ObjectAssert: org.assertj.core.api.AbstractAssert isNotNull()>();
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: int getLastRowNum()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(0);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(0);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell createCell(int)>(0);
virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: void setCellValue(java.lang.String)>("a");
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(0);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: short getLastCellNum()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractShortAssert assertThat(short)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractShortAssert: org.assertj.core.api.AbstractShortAssert isEqualTo(short)>(1);
v = interfaceinvoke v.<org.apache.poi.ss.usermodel.Cell: org.apache.poi.ss.usermodel.CellType getCellType()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractComparableAssert assertThat(java.lang.Comparable)>(v);
v = <org.apache.poi.ss.usermodel.CellType: org.apache.poi.ss.usermodel.CellType STRING>;
virtualinvoke v.<org.assertj.core.api.AbstractComparableAssert: org.assertj.core.api.AbstractAssert isEqualTo(java.lang.Object)>(v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(0);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell createCell(int)>(1);
virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: void setCellValue(java.lang.String)>("b");
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(0);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: short getLastCellNum()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractShortAssert assertThat(short)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractShortAssert: org.assertj.core.api.AbstractShortAssert isEqualTo(short)>(2);
return;
}
public void empty_value_rows_works()
{
java.util.List[] v;
java.lang.Integer v, v, v;
org.assertj.core.api.AbstractComparableAssert v, v;
org.assertj.core.api.AbstractShortAssert v;
boolean v, v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoter v, v, v, v, v;
java.util.List v, v, v, v;
java.lang.Integer[] v;
org.apache.poi.ss.usermodel.CellType v, v, v, v;
java.lang.Object[] v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
org.assertj.core.api.AbstractIntegerAssert v, v, v, v, v;
java.lang.String[] v, v, v;
org.apache.poi.xssf.usermodel.XSSFRow v, v, v, v, v;
short v;
int v, v, v, v, v;
java.lang.String v, v, v, v;
org.apache.poi.xssf.usermodel.XSSFSheet v, v, v, v, v, v, v, v;
org.apache.poi.xssf.usermodel.XSSFCell v, v, v, v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v = newarray (java.lang.String)[3];
v[0] = "row";
v[1] = "value";
v[2] = "column";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.Integer)[3];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[1] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[2] = v;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[3];
v[0] = null;
v[1] = "SUM";
v[2] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[3];
v[0] = "fn1";
v[1] = "fn2";
v[2] = "fn3";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.util.List)[0];
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void sourceSheetBuilder(java.util.List,java.util.List,java.util.List,java.util.List,java.util.List[])>(v, v, v, v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: void pivot(org.apache.poi.ss.usermodel.Sheet,org.apache.poi.ss.usermodel.Sheet)>(v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: int valueRowOffsetY>;
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(1);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: int columnLabelOffsetX>;
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(1);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: int decoRowOffsetX>;
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(1);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: int valuesStartAtRownumber>;
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(2);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: int getLastRowNum()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(2);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(1);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: short getLastCellNum()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractShortAssert assertThat(short)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractShortAssert: org.assertj.core.api.AbstractShortAssert isEqualTo(short)>(2);
v = newarray (java.lang.Object)[2];
v[0] = "fn3";
v[1] = null;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(0, v);
v = newarray (java.lang.Object)[2];
v[0] = "fn1";
v[1] = null;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(1, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(2);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(0);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: org.apache.poi.ss.usermodel.CellType getCellType()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractComparableAssert assertThat(java.lang.Comparable)>(v);
v = <org.apache.poi.ss.usermodel.CellType: org.apache.poi.ss.usermodel.CellType BLANK>;
virtualinvoke v.<org.assertj.core.api.AbstractComparableAssert: org.assertj.core.api.AbstractAssert isEqualTo(java.lang.Object)>(v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(2);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(1);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: org.apache.poi.ss.usermodel.CellType getCellType()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractComparableAssert assertThat(java.lang.Comparable)>(v);
v = <org.apache.poi.ss.usermodel.CellType: org.apache.poi.ss.usermodel.CellType FORMULA>;
virtualinvoke v.<org.assertj.core.api.AbstractComparableAssert: org.assertj.core.api.AbstractAssert isEqualTo(java.lang.Object)>(v);
v = "SUM(B3:B2)";
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(2);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(1);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: java.lang.String getCellFormula()>();
v = virtualinvoke v.<java.lang.String: boolean equals(java.lang.Object)>(v);
if v != 0 goto label;
v = "SUM(B2:B3)";
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(2);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(1);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: java.lang.String getCellFormula()>();
v = virtualinvoke v.<java.lang.String: boolean equals(java.lang.Object)>(v);
if v == 0 goto label;
label:
v = 1;
goto label;
label:
v = 0;
label:
staticinvoke <org.junit.jupiter.api.Assertions: void assertTrue(boolean)>(v);
return;
}
public void setOffsets_works()
{
java.util.List[] v, v;
java.lang.Integer v, v, v, v, v, v, v, v, v, v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoter v, v, v, v, v, v, v, v, v, v;
java.util.List v, v, v, v, v, v, v, v;
java.lang.Integer[] v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
org.assertj.core.api.AbstractIntegerAssert v, v, v, v, v, v, v, v;
java.lang.String[] v, v, v, v, v, v;
int v, v, v, v, v, v, v, v;
org.apache.poi.xssf.usermodel.XSSFSheet v, v, v, v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v = newarray (java.lang.String)[5];
v[0] = "row";
v[1] = "value";
v[2] = "value";
v[3] = "column";
v[4] = "deco";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.Integer)[5];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[1] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[3] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[4] = v;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[5];
v[0] = null;
v[1] = "SUM";
v[2] = "SUM";
v[3] = null;
v[4] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[5];
v[0] = "fn1";
v[1] = "fn2";
v[2] = "fn2a";
v[3] = "fn3";
v[4] = "fn4";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.util.List)[0];
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void sourceSheetBuilder(java.util.List,java.util.List,java.util.List,java.util.List,java.util.List[])>(v, v, v, v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: void pivot(org.apache.poi.ss.usermodel.Sheet,org.apache.poi.ss.usermodel.Sheet)>(v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: int valueRowOffsetY>;
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(1);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: int columnLabelOffsetX>;
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(2);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: int decoRowOffsetX>;
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(1);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: int valuesStartAtRownumber>;
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(2);
v = newarray (java.lang.String)[6];
v[0] = "row";
v[1] = "value";
v[2] = "value";
v[3] = "column";
v[4] = "deco";
v[5] = "column";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.Integer)[6];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[1] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[3] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[4] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[5] = v;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[6];
v[0] = null;
v[1] = "SUM";
v[2] = "SUM";
v[3] = null;
v[4] = null;
v[5] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[6];
v[0] = "fn1";
v[1] = "fn2";
v[2] = "fn2a";
v[3] = "fn3";
v[4] = "fn4";
v[5] = "fn3a";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.util.List)[0];
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void sourceSheetBuilder(java.util.List,java.util.List,java.util.List,java.util.List,java.util.List[])>(v, v, v, v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: void pivot(org.apache.poi.ss.usermodel.Sheet,org.apache.poi.ss.usermodel.Sheet)>(v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: int valueRowOffsetY>;
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(2);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: int columnLabelOffsetX>;
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(2);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: int decoRowOffsetX>;
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(1);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: int valuesStartAtRownumber>;
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(3);
return;
}
public void validateSourceData_works()
{
java.util.List[] v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
java.lang.String[] v, v, v;
java.lang.Integer v, v, v, v, v;
org.junit.rules.ExpectedException v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoter v;
java.util.List v, v, v, v, v;
org.apache.poi.xssf.usermodel.XSSFSheet v, v;
java.io.Serializable[] v;
java.lang.Integer[] v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v = newarray (java.lang.String)[4];
v[0] = "row";
v[1] = "value";
v[2] = "value";
v[3] = "column";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.Integer)[4];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[1] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[3] = v;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[4];
v[0] = null;
v[1] = "SUM";
v[2] = "SUM";
v[3] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[4];
v[0] = "fn1";
v[1] = "fn2";
v[2] = "fn2a";
v[3] = "fn3";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[4];
v[0] = "r1";
v[1] = "a";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
v[3] = "c1";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.util.List)[1];
v[0] = v;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void sourceSheetBuilder(java.util.List,java.util.List,java.util.List,java.util.List,java.util.List[])>(v, v, v, v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.junit.rules.ExpectedException expectedException>;
virtualinvoke v.<org.junit.rules.ExpectedException: void expect(java.lang.Class)>(class "Ljava/lang/IllegalArgumentException;");
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.junit.rules.ExpectedException expectedException>;
virtualinvoke v.<org.junit.rules.ExpectedException: void expectMessage(java.lang.String)>("Values other than CELL_TYPE_NUMERIC found");
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: void pivot(org.apache.poi.ss.usermodel.Sheet,org.apache.poi.ss.usermodel.Sheet)>(v, v);
return;
}
public void replaceEmptyRowAndColumns_when_validating_sourcedata_works()
{
java.util.List[] v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
java.lang.String[] v, v, v;
java.lang.Integer v, v, v, v;
org.apache.poi.xssf.usermodel.XSSFRow v, v;
org.assertj.core.api.AbstractStringAssert v, v;
java.lang.String v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoter v;
java.util.List v, v, v, v, v;
org.apache.poi.xssf.usermodel.XSSFSheet v, v, v, v;
org.apache.poi.xssf.usermodel.XSSFCell v, v;
java.lang.Integer[] v, v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v = newarray (java.lang.String)[3];
v[0] = "row";
v[1] = "value";
v[2] = "column";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.Integer)[3];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[1] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[3];
v[0] = null;
v[1] = "SUM";
v[2] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[3];
v[0] = "fn1";
v[1] = "fn2";
v[2] = "fn3";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.Integer)[3];
v[0] = null;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v[2] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.util.List)[1];
v[0] = v;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void sourceSheetBuilder(java.util.List,java.util.List,java.util.List,java.util.List,java.util.List[])>(v, v, v, v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: void pivot(org.apache.poi.ss.usermodel.Sheet,org.apache.poi.ss.usermodel.Sheet)>(v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(4);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(0);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: java.lang.String getStringCellValue()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractStringAssert assertThat(java.lang.String)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractStringAssert: org.assertj.core.api.AbstractStringAssert isEqualTo(java.lang.String)>("(empty)");
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(4);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(2);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: java.lang.String getStringCellValue()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractStringAssert assertThat(java.lang.String)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractStringAssert: org.assertj.core.api.AbstractStringAssert isEqualTo(java.lang.String)>("(empty)");
return;
}
public void headerRow_Fill_works()
{
java.util.List[] v;
java.lang.Integer v, v, v, v, v, v, v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoter v;
java.util.List v, v, v, v, v, v, v;
java.lang.Integer[] v;
java.lang.Object[] v, v, v, v, v, v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
org.assertj.core.api.AbstractIntegerAssert v;
java.lang.String[] v, v, v, v, v, v;
int v;
org.apache.poi.xssf.usermodel.XSSFSheet v, v, v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v = newarray (java.lang.String)[8];
v[0] = "row";
v[1] = "column";
v[2] = "column";
v[3] = "column";
v[4] = "value";
v[5] = "value";
v[6] = "deco";
v[7] = "deco";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.Integer)[8];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[2] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(3);
v[3] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[4] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[5] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[6] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[7] = v;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[8];
v[0] = null;
v[1] = null;
v[2] = null;
v[3] = null;
v[4] = "SUM";
v[5] = "SUM";
v[6] = null;
v[7] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[8];
v[0] = "fn-r1";
v[1] = "fn-c";
v[2] = "fn-c1";
v[3] = "fn-c2";
v[4] = "fn-v1";
v[5] = "fn-v2";
v[6] = "fn-d1";
v[7] = "fn-d2";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[8];
v[0] = "r1";
v[1] = "a";
v[2] = "c1-1";
v[3] = "c2-1";
v[4] = null;
v[5] = null;
v[6] = "r1d1";
v[7] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[8];
v[0] = "r2";
v[1] = "a";
v[2] = "c1-2";
v[3] = "c2-1";
v[4] = null;
v[5] = null;
v[6] = null;
v[7] = "r2d2";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[8];
v[0] = "r3";
v[1] = "b";
v[2] = "c1-3";
v[3] = "c2-2";
v[4] = null;
v[5] = null;
v[6] = "r3d1";
v[7] = "r3d2";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.util.List)[3];
v[0] = v;
v[1] = v;
v[2] = v;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void sourceSheetBuilder(java.util.List,java.util.List,java.util.List,java.util.List,java.util.List[])>(v, v, v, v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: void pivot(org.apache.poi.ss.usermodel.Sheet,org.apache.poi.ss.usermodel.Sheet)>(v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: int getLastRowNum()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(7);
v = newarray (java.lang.Object)[16];
v[0] = null;
v[1] = null;
v[2] = "fn-c";
v[3] = "a";
v[4] = null;
v[5] = null;
v[6] = null;
v[7] = null;
v[8] = null;
v[9] = null;
v[10] = null;
v[11] = null;
v[12] = null;
v[13] = null;
v[14] = null;
v[15] = "b";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(0, v);
v = newarray (java.lang.Object)[16];
v[0] = null;
v[1] = null;
v[2] = "fn-c1";
v[3] = "c1-1";
v[4] = null;
v[5] = null;
v[6] = null;
v[7] = "c1-2";
v[8] = null;
v[9] = null;
v[10] = null;
v[11] = "c1-3";
v[12] = null;
v[13] = null;
v[14] = null;
v[15] = "c1-1";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(1, v);
v = newarray (java.lang.Object)[16];
v[0] = null;
v[1] = null;
v[2] = "fn-c2";
v[3] = "c2-1";
v[4] = null;
v[5] = "c2-2";
v[6] = null;
v[7] = "c2-1";
v[8] = null;
v[9] = "c2-2";
v[10] = null;
v[11] = "c2-1";
v[12] = null;
v[13] = "c2-2";
v[14] = null;
v[15] = "c2-1";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(2, v);
v = newarray (java.lang.Object)[9];
v[0] = "fn-r1";
v[1] = "fn-d1";
v[2] = "fn-d2";
v[3] = "fn-v (sum)";
v[4] = "fn-v (sum)";
v[5] = "fn-v (sum)";
v[6] = "fn-v (sum)";
v[7] = "fn-v (sum)";
v[8] = "fn-v (sum)";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(3, v);
v = newarray (java.lang.Object)[3];
v[0] = "r1";
v[1] = "r1d1";
v[2] = null;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(4, v);
v = newarray (java.lang.Object)[3];
v[0] = "r2";
v[1] = null;
v[2] = "r2d2";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(5, v);
v = newarray (java.lang.Object)[3];
v[0] = "r3";
v[1] = "r3d1";
v[2] = "r3d2";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(6, v);
return;
}
public void testPivoting_works() throws java.lang.Exception
{
java.lang.Integer v, v, v, v, v, v, v, v, v, v, v, v;
org.assertj.core.api.AbstractStringAssert v, v, v, v, v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoter v;
java.io.Serializable[] v, v, v, v;
java.lang.Integer[] v;
java.lang.Object[] v, v, v, v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
java.lang.String v, v, v, v, v, v;
org.apache.poi.xssf.usermodel.XSSFSheet v, v, v, v, v, v, v, v, v;
java.util.List[] v;
java.util.List v, v, v, v, v, v, v, v;
org.assertj.core.api.AbstractIntegerAssert v;
java.lang.String[] v, v, v;
org.apache.poi.xssf.usermodel.XSSFRow v, v, v, v, v, v;
int v;
org.apache.poi.xssf.usermodel.XSSFCell v, v, v, v, v, v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v = newarray (java.lang.String)[5];
v[0] = "row";
v[1] = "value";
v[2] = "column";
v[3] = "deco";
v[4] = "deco";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.Integer)[5];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[3] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[4] = v;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[5];
v[0] = null;
v[1] = "SUM";
v[2] = null;
v[3] = null;
v[4] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[5];
v[0] = "fn1";
v[1] = "fn2";
v[2] = "fn3";
v[3] = "fn4";
v[4] = "fn5";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[5];
v[0] = "l1";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v[2] = "c1";
v[3] = "d1-f-l1";
v[4] = "d2-f-l1";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[5];
v[0] = "l2";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[1] = v;
v[2] = "c2";
v[3] = "deco for l2";
v[4] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[5];
v[0] = "l1";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(3);
v[1] = v;
v[2] = "c1";
v[3] = "other deco not used";
v[4] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[5];
v[0] = "l3";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(33);
v[1] = v;
v[2] = "c1";
v[3] = null;
v[4] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.util.List)[4];
v[0] = v;
v[1] = v;
v[2] = v;
v[3] = v;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void sourceSheetBuilder(java.util.List,java.util.List,java.util.List,java.util.List,java.util.List[])>(v, v, v, v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: void pivot(org.apache.poi.ss.usermodel.Sheet,org.apache.poi.ss.usermodel.Sheet)>(v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: int getLastRowNum()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(5);
v = newarray (java.lang.Object)[5];
v[0] = null;
v[1] = null;
v[2] = "fn3";
v[3] = "c1";
v[4] = "c2";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(0, v);
v = newarray (java.lang.Object)[5];
v[0] = "fn1";
v[1] = "fn5";
v[2] = "fn4";
v[3] = "fn (sum)";
v[4] = "fn (sum)";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(1, v);
v = newarray (java.lang.Object)[5];
v[0] = "l1";
v[1] = "d2-f-l1";
v[2] = "d1-f-l1";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(4);
v[3] = v;
v[4] = null;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(2, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(2);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(5);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: java.lang.String getCellFormula()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractStringAssert assertThat(java.lang.String)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractStringAssert: org.assertj.core.api.AbstractStringAssert isEqualTo(java.lang.String)>("SUM(D3:E3)");
v = newarray (java.lang.Object)[5];
v[0] = "l2";
v[1] = null;
v[2] = "deco for l2";
v[3] = null;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[4] = v;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(3, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(3);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(5);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: java.lang.String getCellFormula()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractStringAssert assertThat(java.lang.String)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractStringAssert: org.assertj.core.api.AbstractStringAssert isEqualTo(java.lang.String)>("SUM(D4:E4)");
v = newarray (java.lang.Object)[5];
v[0] = "l3";
v[1] = null;
v[2] = null;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(33);
v[3] = v;
v[4] = null;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(4, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(4);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(5);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: java.lang.String getCellFormula()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractStringAssert assertThat(java.lang.String)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractStringAssert: org.assertj.core.api.AbstractStringAssert isEqualTo(java.lang.String)>("SUM(D5:E5)");
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(5);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(3);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: java.lang.String getCellFormula()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractStringAssert assertThat(java.lang.String)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractStringAssert: org.assertj.core.api.AbstractStringAssert isEqualTo(java.lang.String)>("SUM(D3:D5)");
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(5);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(4);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: java.lang.String getCellFormula()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractStringAssert assertThat(java.lang.String)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractStringAssert: org.assertj.core.api.AbstractStringAssert isEqualTo(java.lang.String)>("SUM(E3:E5)");
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(5);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(5);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: java.lang.String getCellFormula()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractStringAssert assertThat(java.lang.String)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractStringAssert: org.assertj.core.api.AbstractStringAssert isEqualTo(java.lang.String)>("SUM(F3:F5)");
return;
}
public void testPivoting_WithTwoValues_works() throws java.lang.Exception
{
java.lang.Integer v, v, v, v, v, v, v, v, v, v, v, v, v, v, v, v, v, v, v;
org.assertj.core.api.AbstractStringAssert v, v, v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoter v;
java.io.Serializable[] v, v, v, v;
java.lang.Integer[] v;
java.lang.Object[] v, v, v, v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
java.lang.String v, v, v, v;
org.apache.poi.xssf.usermodel.XSSFSheet v, v, v, v, v, v, v;
java.util.List[] v;
java.util.List v, v, v, v, v, v, v, v;
org.assertj.core.api.AbstractIntegerAssert v;
java.lang.String[] v, v, v;
org.apache.poi.xssf.usermodel.XSSFRow v, v, v, v;
int v;
org.apache.poi.xssf.usermodel.XSSFCell v, v, v, v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v = newarray (java.lang.String)[6];
v[0] = "row";
v[1] = "value";
v[2] = "column";
v[3] = "deco";
v[4] = "deco";
v[5] = "value";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.Integer)[6];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[3] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[4] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[5] = v;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[6];
v[0] = null;
v[1] = "SUM";
v[2] = null;
v[3] = null;
v[4] = null;
v[5] = "COUNT";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[6];
v[0] = "fn1";
v[1] = "fn2";
v[2] = "fn3";
v[3] = "fn4";
v[4] = "fn5";
v[5] = "fn2a";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[6];
v[0] = "l1";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v[2] = "c1";
v[3] = "d1-f-l1";
v[4] = "d2-f-l1";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[5] = v;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[6];
v[0] = "l2";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[1] = v;
v[2] = "c2";
v[3] = "deco for l2";
v[4] = null;
v[5] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[6];
v[0] = "l1";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(3);
v[1] = v;
v[2] = "c1";
v[3] = "other deco not used";
v[4] = null;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[5] = v;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[6];
v[0] = "l3";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(33);
v[1] = v;
v[2] = "c1";
v[3] = null;
v[4] = null;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[5] = v;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.util.List)[4];
v[0] = v;
v[1] = v;
v[2] = v;
v[3] = v;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void sourceSheetBuilder(java.util.List,java.util.List,java.util.List,java.util.List,java.util.List[])>(v, v, v, v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: void pivot(org.apache.poi.ss.usermodel.Sheet,org.apache.poi.ss.usermodel.Sheet)>(v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: int getLastRowNum()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(5);
v = newarray (java.lang.Object)[7];
v[0] = null;
v[1] = null;
v[2] = "fn3";
v[3] = "c1";
v[4] = null;
v[5] = "c2";
v[6] = null;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(0, v);
v = newarray (java.lang.Object)[7];
v[0] = "fn1";
v[1] = "fn5";
v[2] = "fn4";
v[3] = "fn (sum)";
v[4] = "fn2a (count)";
v[5] = "fn (sum)";
v[6] = "fn2a (count)";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(1, v);
v = newarray (java.lang.Object)[7];
v[0] = "l1";
v[1] = "d2-f-l1";
v[2] = "d1-f-l1";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(4);
v[3] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[4] = v;
v[5] = null;
v[6] = null;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(2, v);
v = newarray (java.lang.Object)[7];
v[0] = "l2";
v[1] = null;
v[2] = "deco for l2";
v[3] = null;
v[4] = null;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[5] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[6] = v;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(3, v);
v = newarray (java.lang.Object)[7];
v[0] = "l3";
v[1] = null;
v[2] = null;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(33);
v[3] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[4] = v;
v[5] = null;
v[6] = null;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(4, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(5);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(3);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: java.lang.String getCellFormula()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractStringAssert assertThat(java.lang.String)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractStringAssert: org.assertj.core.api.AbstractStringAssert isEqualTo(java.lang.String)>("SUM(D3:D5)");
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(5);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(4);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: java.lang.String getCellFormula()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractStringAssert assertThat(java.lang.String)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractStringAssert: org.assertj.core.api.AbstractStringAssert isEqualTo(java.lang.String)>("SUM(E3:E5)");
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(5);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(5);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: java.lang.String getCellFormula()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractStringAssert assertThat(java.lang.String)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractStringAssert: org.assertj.core.api.AbstractStringAssert isEqualTo(java.lang.String)>("SUM(F3:F5)");
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(5);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(6);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: java.lang.String getCellFormula()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractStringAssert assertThat(java.lang.String)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractStringAssert: org.assertj.core.api.AbstractStringAssert isEqualTo(java.lang.String)>("SUM(G3:G5)");
return;
}
public void testPivoting_decovalues() throws java.lang.Exception
{
java.util.List[] v;
java.lang.Integer v, v, v, v, v, v, v, v, v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoter v;
java.util.List v, v, v, v, v, v, v;
java.io.Serializable[] v, v, v;
java.lang.Integer[] v;
java.lang.Object[] v, v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
org.assertj.core.api.AbstractIntegerAssert v;
java.lang.String[] v, v, v;
int v;
org.apache.poi.xssf.usermodel.XSSFSheet v, v, v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v = newarray (java.lang.String)[4];
v[0] = "deco";
v[1] = "row";
v[2] = "value";
v[3] = "column";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.Integer)[4];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[1] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[3] = v;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[4];
v[0] = null;
v[1] = null;
v[2] = "SUM";
v[3] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[4];
v[0] = "fn1";
v[1] = "fn2";
v[2] = "fn3";
v[3] = "fn4";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[4];
v[0] = "deco used";
v[1] = "l1";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
v[3] = "c1";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[4];
v[0] = null;
v[1] = "l1";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
v[3] = "c2";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[4];
v[0] = "deco not used";
v[1] = "l1";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
v[3] = "c3";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.util.List)[3];
v[0] = v;
v[1] = v;
v[2] = v;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void sourceSheetBuilder(java.util.List,java.util.List,java.util.List,java.util.List,java.util.List[])>(v, v, v, v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: void pivot(org.apache.poi.ss.usermodel.Sheet,org.apache.poi.ss.usermodel.Sheet)>(v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: int getLastRowNum()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(3);
v = newarray (java.lang.Object)[5];
v[0] = null;
v[1] = "fn4";
v[2] = "c1";
v[3] = "c2";
v[4] = "c3";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(0, v);
v = newarray (java.lang.Object)[5];
v[0] = "fn2";
v[1] = "fn1";
v[2] = "fn (sum)";
v[3] = "fn (sum)";
v[4] = "fn (sum)";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(1, v);
v = newarray (java.lang.Object)[5];
v[0] = "l1";
v[1] = "deco used";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[3] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[4] = v;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(2, v);
return;
}
public void testPivoting_NotSupportedValueType_Boolean() throws java.lang.Exception
{
java.util.List[] v;
java.lang.Integer v, v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoter v;
java.util.List v, v, v, v, v, v, v;
java.io.Serializable[] v, v, v;
java.lang.Integer[] v;
java.lang.Object[] v, v, v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
org.assertj.core.api.AbstractIntegerAssert v;
java.lang.String[] v, v, v;
int v;
java.lang.Boolean v, v, v;
org.apache.poi.xssf.usermodel.XSSFSheet v, v, v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v = newarray (java.lang.String)[3];
v[0] = "row";
v[1] = "value";
v[2] = "column";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.Integer)[3];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[3];
v[0] = null;
v[1] = "SUM";
v[2] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[3];
v[0] = "fn1";
v[1] = "fn2";
v[2] = "fn3";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[3];
v[0] = "l1";
v = staticinvoke <java.lang.Boolean: java.lang.Boolean valueOf(boolean)>(1);
v[1] = v;
v[2] = "c1";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[3];
v[0] = "l2";
v = staticinvoke <java.lang.Boolean: java.lang.Boolean valueOf(boolean)>(0);
v[1] = v;
v[2] = "c2";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[3];
v[0] = "l1";
v = staticinvoke <java.lang.Boolean: java.lang.Boolean valueOf(boolean)>(1);
v[1] = v;
v[2] = "c1";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.util.List)[3];
v[0] = v;
v[1] = v;
v[2] = v;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void sourceSheetBuilder(java.util.List,java.util.List,java.util.List,java.util.List,java.util.List[])>(v, v, v, v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: void pivot(org.apache.poi.ss.usermodel.Sheet,org.apache.poi.ss.usermodel.Sheet)>(v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: int getLastRowNum()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(4);
v = newarray (java.lang.Object)[3];
v[0] = "fn3";
v[1] = "c1";
v[2] = "c2";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(0, v);
v = newarray (java.lang.Object)[3];
v[0] = "fn1";
v[1] = "fn (sum)";
v[2] = "fn (sum)";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(1, v);
v = newarray (java.lang.Object)[3];
v[0] = "l1";
v[1] = null;
v[2] = null;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(2, v);
v = newarray (java.lang.Object)[3];
v[0] = "l2";
v[1] = null;
v[2] = null;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(3, v);
return;
}
public void testPivoting_Numeric_As_Rowlabel() throws java.lang.Exception
{
java.util.List[] v;
java.lang.Integer v, v, v, v, v, v, v, v, v, v, v, v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoter v;
java.util.List v, v, v, v, v, v, v;
java.io.Serializable[] v, v, v;
java.lang.Integer[] v;
java.lang.Object[] v, v, v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
org.assertj.core.api.AbstractIntegerAssert v;
java.lang.String[] v, v, v;
int v;
org.apache.poi.xssf.usermodel.XSSFSheet v, v, v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v = newarray (java.lang.String)[3];
v[0] = "row";
v[1] = "value";
v[2] = "column";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.Integer)[3];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[3];
v[0] = null;
v[1] = "SUM";
v[2] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[3];
v[0] = "fn1";
v[1] = "fn2";
v[2] = "fn3";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[3];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v[2] = "c1";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[3];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v[2] = "c2";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[3];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v[2] = "c1";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.util.List)[3];
v[0] = v;
v[1] = v;
v[2] = v;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void sourceSheetBuilder(java.util.List,java.util.List,java.util.List,java.util.List,java.util.List[])>(v, v, v, v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: void pivot(org.apache.poi.ss.usermodel.Sheet,org.apache.poi.ss.usermodel.Sheet)>(v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: int getLastRowNum()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(4);
v = newarray (java.lang.Object)[3];
v[0] = "fn3";
v[1] = "c1";
v[2] = "c2";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(0, v);
v = newarray (java.lang.Object)[3];
v[0] = "fn1";
v[1] = "fn (sum)";
v[2] = "fn (sum)";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(1, v);
v = newarray (java.lang.Object)[3];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[1] = v;
v[2] = null;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(2, v);
v = newarray (java.lang.Object)[3];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[0] = v;
v[1] = null;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(3, v);
return;
}
public void emptyRowValuesAreSupported()
{
java.lang.Object[] v, v, v;
java.util.List[] v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
org.assertj.core.api.AbstractIntegerAssert v;
java.lang.String[] v, v, v;
java.lang.Integer v, v, v, v, v, v;
int v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoter v;
java.util.List v, v, v, v, v, v;
org.apache.poi.xssf.usermodel.XSSFSheet v, v, v;
java.io.Serializable[] v, v;
java.lang.Integer[] v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v = newarray (java.lang.String)[3];
v[0] = "row";
v[1] = "value";
v[2] = "column";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.Integer)[3];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[3];
v[0] = null;
v[1] = "SUM";
v[2] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[3];
v[0] = "fn1";
v[1] = "fn2";
v[2] = "fn3";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[3];
v[0] = null;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v[2] = "c1";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[3];
v[0] = "";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v[2] = "c1";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.util.List)[2];
v[0] = v;
v[1] = v;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void sourceSheetBuilder(java.util.List,java.util.List,java.util.List,java.util.List,java.util.List[])>(v, v, v, v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: void pivot(org.apache.poi.ss.usermodel.Sheet,org.apache.poi.ss.usermodel.Sheet)>(v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: int getLastRowNum()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(3);
v = newarray (java.lang.Object)[2];
v[0] = "fn3";
v[1] = "c1";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(0, v);
v = newarray (java.lang.Object)[2];
v[0] = "fn1";
v[1] = "fn (sum)";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(1, v);
v = newarray (java.lang.Object)[2];
v[0] = "(empty)";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[1] = v;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(2, v);
return;
}
public void emptyColumnValuesAreSupported()
{
java.lang.Object[] v, v, v;
java.util.List[] v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
org.assertj.core.api.AbstractIntegerAssert v;
java.lang.String[] v, v, v;
java.lang.Integer v, v, v, v, v, v;
int v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoter v;
java.util.List v, v, v, v, v, v;
org.apache.poi.xssf.usermodel.XSSFSheet v, v, v;
java.io.Serializable[] v, v;
java.lang.Integer[] v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v = newarray (java.lang.String)[3];
v[0] = "row";
v[1] = "value";
v[2] = "column";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.Integer)[3];
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v[0] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[2] = v;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[3];
v[0] = null;
v[1] = "SUM";
v[2] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.lang.String)[3];
v[0] = "fn1";
v[1] = "fn2";
v[2] = "fn3";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[3];
v[0] = "l1";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v[2] = null;
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.io.Serializable)[3];
v[0] = "l1";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(1);
v[1] = v;
v[2] = "";
v = staticinvoke <java.util.Arrays: java.util.List asList(java.lang.Object[])>(v);
v = newarray (java.util.List)[2];
v[0] = v;
v[1] = v;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void sourceSheetBuilder(java.util.List,java.util.List,java.util.List,java.util.List,java.util.List[])>(v, v, v, v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.isis.subdomains.excel.applib.util.SheetPivoter p>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoter: void pivot(org.apache.poi.ss.usermodel.Sheet,org.apache.poi.ss.usermodel.Sheet)>(v, v);
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: int getLastRowNum()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(3);
v = newarray (java.lang.Object)[2];
v[0] = "fn3";
v[1] = "(empty)";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(0, v);
v = newarray (java.lang.Object)[2];
v[0] = "fn1";
v[1] = "fn (sum)";
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(1, v);
v = newarray (java.lang.Object)[2];
v[0] = "l1";
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(2);
v[1] = v;
virtualinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testRow(int,java.lang.Object[])>(2, v);
return;
}
public void getDistinctValuesInSourceSheetColumnTest()
{
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
org.assertj.core.api.AbstractIntegerAssert v, v;
java.lang.Integer v, v;
org.apache.poi.xssf.usermodel.XSSFRow v, v, v, v, v, v, v, v, v;
org.apache.poi.xssf.usermodel.XSSFWorkbook v;
int v, v;
java.util.List v, v;
org.apache.poi.xssf.usermodel.XSSFSheet v;
org.apache.poi.xssf.usermodel.XSSFCell v, v, v, v, v, v, v, v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v = new org.apache.poi.xssf.usermodel.XSSFWorkbook;
specialinvoke v.<org.apache.poi.xssf.usermodel.XSSFWorkbook: void <init>()>();
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFWorkbook: org.apache.poi.xssf.usermodel.XSSFSheet createSheet()>();
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow createRow(int)>(0);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell createCell(int)>(0);
virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: void setCellValue(java.lang.String)>("row");
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow createRow(int)>(1);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell createCell(int)>(0);
virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: void setCellValue(double)>(1.0);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow createRow(int)>(2);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell createCell(int)>(0);
virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: void setCellValue(java.lang.String)>("fieldname");
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v = staticinvoke <org.apache.isis.subdomains.excel.applib.util.SheetPivoter: java.util.List getDistinctValuesInSourceSheetColumn(org.apache.poi.ss.usermodel.Sheet,java.lang.Integer)>(v, v);
v = interfaceinvoke v.<java.util.List: int size()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(0);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow createRow(int)>(3);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell createCell(int)>(0);
virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: void setCellValue(java.lang.String)>("a");
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow createRow(int)>(4);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell createCell(int)>(0);
virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: void setCellValue(java.lang.String)>("a");
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow createRow(int)>(5);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell createCell(int)>(0);
virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: void setCellValue(java.lang.String)>("b");
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow createRow(int)>(6);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell createCell(int)>(0);
virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: void setCellValue(double)>(1.0);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow createRow(int)>(7);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell createCell(int)>(0);
virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: void setCellValue(java.lang.String)>("");
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow createRow(int)>(8);
virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell createCell(int)>(0);
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v = staticinvoke <org.apache.isis.subdomains.excel.applib.util.SheetPivoter: java.util.List getDistinctValuesInSourceSheetColumn(org.apache.poi.ss.usermodel.Sheet,java.lang.Integer)>(v, v);
v = interfaceinvoke v.<java.util.List: int size()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractIntegerAssert assertThat(int)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractIntegerAssert: org.assertj.core.api.AbstractIntegerAssert isEqualTo(int)>(5);
return;
}
transient void testRow(int, java.lang.Object[])
{
java.lang.Object[] v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
int v, v, v, v, v;
java.lang.Object v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v := @parameter: int;
v := @parameter: java.lang.Object[];
v = 0;
v = lengthof v;
v = 0;
label:
if v >= v goto label;
v = v[v];
v = v;
v = v + 1;
specialinvoke v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: void testCell(int,int,java.lang.Object)>(v, v, v);
v = v + 1;
goto label;
label:
return;
}
private void testCell(int, int, java.lang.Object)
{
org.apache.poi.ss.usermodel.CellType v, v;
java.lang.Double v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
java.lang.AssertionError v;
org.apache.poi.xssf.usermodel.XSSFRow v, v, v;
int v, v;
org.apache.poi.ss.usermodel.Cell v;
org.assertj.core.api.AbstractStringAssert v, v;
java.lang.String v, v, v;
boolean v;
double v, v;
org.assertj.core.api.AbstractDoubleAssert v;
org.apache.poi.xssf.usermodel.XSSFSheet v, v, v;
java.lang.Class v, v;
java.lang.Object v;
org.apache.poi.xssf.usermodel.XSSFCell v, v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v := @parameter: int;
v := @parameter: int;
v := @parameter: java.lang.Object;
if v != null goto label;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(v);
if v == null goto label;
v = interfaceinvoke v.<org.apache.poi.ss.usermodel.Row: org.apache.poi.ss.usermodel.Cell getCell(int)>(v);
if v == null goto label;
v = interfaceinvoke v.<org.apache.poi.ss.usermodel.Cell: org.apache.poi.ss.usermodel.CellType getCellType()>();
v = <org.apache.poi.ss.usermodel.CellType: org.apache.poi.ss.usermodel.CellType NUMERIC>;
if v != v goto label;
v = interfaceinvoke v.<org.apache.poi.ss.usermodel.Cell: double getNumericCellValue()>();
v = staticinvoke <java.lang.Double: boolean isFinite(double)>(v);
staticinvoke <org.junit.jupiter.api.Assertions: void assertTrue(boolean)>(v);
goto label;
label:
v = interfaceinvoke v.<org.apache.poi.ss.usermodel.Cell: java.lang.String getStringCellValue()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractStringAssert assertThat(java.lang.String)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractStringAssert: org.assertj.core.api.AbstractStringAssert isEqualTo(java.lang.String)>("");
goto label;
label:
v = virtualinvoke v.<java.lang.Object: java.lang.Class getClass()>();
if v != class "Ljava/lang/String;" goto label;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(v);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(v);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: java.lang.String getStringCellValue()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractStringAssert assertThat(java.lang.String)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractStringAssert: org.assertj.core.api.AbstractAssert isEqualTo(java.lang.Object)>(v);
goto label;
label:
v = virtualinvoke v.<java.lang.Object: java.lang.Class getClass()>();
if v != class "Ljava/lang/Integer;" goto label;
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet targetSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow getRow(int)>(v);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFRow: org.apache.poi.xssf.usermodel.XSSFCell getCell(int)>(v);
if v == null goto label;
v = virtualinvoke v.<java.lang.Object: java.lang.String toString()>();
v = staticinvoke <java.lang.Double: java.lang.Double valueOf(java.lang.String)>(v);
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFCell: double getNumericCellValue()>();
v = staticinvoke <org.assertj.core.api.Assertions: org.assertj.core.api.AbstractDoubleAssert assertThat(double)>(v);
virtualinvoke v.<org.assertj.core.api.AbstractDoubleAssert: org.assertj.core.api.AbstractDoubleAssert isEqualTo(java.lang.Double)>(v);
goto label;
label:
v = new java.lang.AssertionError;
specialinvoke v.<java.lang.AssertionError: void <init>(java.lang.Object)>("no sensible test possible");
throw v;
label:
return;
}
transient void sourceSheetBuilder(java.util.List, java.util.List, java.util.List, java.util.List, java.util.List[])
{
java.util.List[] v;
org.apache.poi.ss.usermodel.Cell v, v, v, v, v, v;
boolean v, v, v, v, v;
java.util.List v, v, v, v, v;
org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest v;
org.apache.poi.xssf.usermodel.XSSFRow v, v, v, v, v;
int v, v, v, v, v, v, v, v, v, v, v, v, v, v, v, v, v;
java.util.Iterator v, v, v, v, v;
org.apache.poi.xssf.usermodel.XSSFSheet v, v, v, v, v;
java.lang.Class v, v;
java.lang.Object v, v, v, v, v;
v := @this: org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest;
v := @parameter: java.util.List;
v := @parameter: java.util.List;
v := @parameter: java.util.List;
v := @parameter: java.util.List;
v := @parameter: java.util.List[];
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow createRow(int)>(0);
v = 0;
v = interfaceinvoke v.<java.util.List: java.util.Iterator iterator()>();
label:
v = interfaceinvoke v.<java.util.Iterator: boolean hasNext()>();
if v == 0 goto label;
v = interfaceinvoke v.<java.util.Iterator: java.lang.Object next()>();
v = v;
v = v + 1;
v = interfaceinvoke v.<org.apache.poi.ss.usermodel.Row: org.apache.poi.ss.usermodel.Cell createCell(int)>(v);
interfaceinvoke v.<org.apache.poi.ss.usermodel.Cell: void setCellValue(java.lang.String)>(v);
goto label;
label:
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow createRow(int)>(1);
if v == null goto label;
v = 0;
v = interfaceinvoke v.<java.util.List: java.util.Iterator iterator()>();
label:
v = interfaceinvoke v.<java.util.Iterator: boolean hasNext()>();
if v == 0 goto label;
v = interfaceinvoke v.<java.util.Iterator: java.lang.Object next()>();
v = virtualinvoke v.<java.lang.Integer: int intValue()>();
v = v;
v = v + 1;
v = interfaceinvoke v.<org.apache.poi.ss.usermodel.Row: org.apache.poi.ss.usermodel.Cell createCell(int)>(v);
interfaceinvoke v.<org.apache.poi.ss.usermodel.Cell: void setCellValue(double)>(v);
goto label;
label:
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow createRow(int)>(2);
if v == null goto label;
v = 0;
v = interfaceinvoke v.<java.util.List: java.util.Iterator iterator()>();
label:
v = interfaceinvoke v.<java.util.Iterator: boolean hasNext()>();
if v == 0 goto label;
v = interfaceinvoke v.<java.util.Iterator: java.lang.Object next()>();
v = v;
v = v + 1;
v = interfaceinvoke v.<org.apache.poi.ss.usermodel.Row: org.apache.poi.ss.usermodel.Cell createCell(int)>(v);
interfaceinvoke v.<org.apache.poi.ss.usermodel.Cell: void setCellValue(java.lang.String)>(v);
goto label;
label:
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow createRow(int)>(3);
if v == null goto label;
v = 0;
v = interfaceinvoke v.<java.util.List: java.util.Iterator iterator()>();
label:
v = interfaceinvoke v.<java.util.Iterator: boolean hasNext()>();
if v == 0 goto label;
v = interfaceinvoke v.<java.util.Iterator: java.lang.Object next()>();
v = v;
v = v + 1;
v = interfaceinvoke v.<org.apache.poi.ss.usermodel.Row: org.apache.poi.ss.usermodel.Cell createCell(int)>(v);
interfaceinvoke v.<org.apache.poi.ss.usermodel.Cell: void setCellValue(java.lang.String)>(v);
goto label;
label:
if v == null goto label;
v = 4;
v = lengthof v;
v = 0;
label:
if v >= v goto label;
v = v[v];
v = v.<org.apache.isis.subdomains.excel.applib.util.SheetPivoterTest: org.apache.poi.xssf.usermodel.XSSFSheet sourceSheet>;
v = v;
v = v + 1;
v = virtualinvoke v.<org.apache.poi.xssf.usermodel.XSSFSheet: org.apache.poi.xssf.usermodel.XSSFRow createRow(int)>(v);
v = 0;
v = interfaceinvoke v.<java.util.List: java.util.Iterator iterator()>();
label:
v = interfaceinvoke v.<java.util.Iterator: boolean hasNext()>();
if v == 0 goto label;
v = interfaceinvoke v.<java.util.Iterator: java.lang.Object next()>();
if v != null goto label;
v = v + 1;
goto label;
label:
v = virtualinvoke v.<java.lang.Object: java.lang.Class getClass()>();
if v != class "Ljava/lang/Integer;" goto label;
v = v;
v = v + 1;
v = interfaceinvoke v.<org.apache.poi.ss.usermodel.Row: org.apache.poi.ss.usermodel.Cell createCell(int)>(v);
v = virtualinvoke v.<java.lang.Integer: int intValue()>();
interfaceinvoke v.<org.apache.poi.ss.usermodel.Cell: void setCellValue(double)>(v);
goto label;
label:
v = virtualinvoke v.<java.lang.Object: java.lang.Class getClass()>();
if v != class "Ljava/lang/String;" goto label;
v = v;
v = v + 1;
v = interfaceinvoke v.<org.apache.poi.ss.usermodel.Row: org.apache.poi.ss.usermodel.Cell createCell(int)>(v);
interfaceinvoke v.<org.apache.poi.ss.usermodel.Cell: void setCellValue(java.lang.String)>(v);
goto label;
label:
v = v + 1;
goto label;
label:
v = v + 1;
goto label;
label:
return;
}
}