@Test
public void testPivoting_decovalues() throws Exception {

    // given
    List<String> annotations = Arrays.asList("deco", "row", "value", "column");
    List<Integer> orderNumbers = Arrays.asList(1, 0, 1, 1);
    List<String> typeList = Arrays.asList(null, null, "SUM", null);
    List<String> fieldNameList = Arrays.asList("fn1", "fn2", "fn3", "fn4");
    List<?> v1 = Arrays.asList("deco used", "l1", 1, "c1");
    List<?> v2 = Arrays.asList(null, "l1", 1, "c2");
    List<?> v3 = Arrays.asList("deco not used", "l1", 1, "c3");
    sourceSheetBuilder(annotations, orderNumbers, typeList, fieldNameList, v1, v2, v3);
    // when
    p.pivot(sourceSheet, targetSheet);
    // then
    Assertions.assertThat(targetSheet.getLastRowNum()).isEqualTo(3);
    testRow(0, null, "fn4", "c1", "c2", "c3");
    testRow(1, "fn2", "fn1", "fn3 (sum)", "fn3 (sum)", "fn3 (sum)");
    testRow(2, "l1", "deco used", 1, 1, 1);
}