Example usage for org.apache.poi.ss.usermodel BorderStyle MEDIUM

List of usage examples for org.apache.poi.ss.usermodel BorderStyle MEDIUM

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.ss.usermodel.*
  5. BorderStyle
  6. MEDIUM

Introduction

In this page you can find the example usage for org.apache.poi.ss.usermodel BorderStyle MEDIUM.

Prototype

BorderStyle MEDIUM

To view the source code for org.apache.poi.ss.usermodel BorderStyle MEDIUM.

Click Source Link

Document

Medium border

Usage

From source file:org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.ExcelCellStyleBuilderTest.java

License:Open Source License

@Test
public void testXls_BackgroundStyle() {
    when(workbook.createCellStyle()).thenReturn(xlsStyle);
    ExcelCellStyleBuilder builder = new ExcelCellStyleBuilder(workbook);

    CellBackground bg = getBackground();
    HSSFCellStyleProducer.HSSFCellStyleKey styleKey = getXlsKey();

    builder.xls_backgroundStyle(bg, styleKey);

    verify(xlsStyle, times(1)).setBorderBottom(eq(BorderStyle.MEDIUM_DASH_DOT));
    verify(xlsStyle, times(1)).setBottomBorderColor(eq((short) 116));
    verify(xlsStyle, times(1)).setBorderTop(eq(BorderStyle.MEDIUM_DASHED));
    verify(xlsStyle, times(1)).setTopBorderColor(eq((short) 118));
    verify(xlsStyle, times(1)).setBorderLeft(eq(BorderStyle.MEDIUM_DASH_DOT_DOT));
    verify(xlsStyle, times(1)).setLeftBorderColor(eq((short) 120));
    verify(xlsStyle, times(1)).setBorderRight(eq(BorderStyle.MEDIUM));
    verify(xlsStyle, times(1)).setRightBorderColor(eq((short) 122));
    verify(xlsStyle, times(1)).setFillForegroundColor(eq((short) 123));
    verify(xlsStyle, times(1)).setFillPattern(eq(FillPatternType.SOLID_FOREGROUND));
}

From source file:org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.ExcelCellStyleBuilderTest.java

License:Open Source License

private HSSFCellStyleProducer.HSSFCellStyleKey getXlsKey() {
    when(styleKey.getBorderStrokeBottom()).thenReturn(BorderStyle.MEDIUM_DASH_DOT);
    when(styleKey.getColorBottom()).thenReturn((short) 116);
    when(styleKey.getBorderStrokeTop()).thenReturn(BorderStyle.MEDIUM_DASHED);
    when(styleKey.getColorTop()).thenReturn((short) 118);
    when(styleKey.getBorderStrokeLeft()).thenReturn(BorderStyle.MEDIUM_DASH_DOT_DOT);
    when(styleKey.getColorLeft()).thenReturn((short) 120);
    when(styleKey.getBorderStrokeRight()).thenReturn(BorderStyle.MEDIUM);
    when(styleKey.getColorRight()).thenReturn((short) 122);
    when(styleKey.getColor()).thenReturn((short) 123);
    return styleKey;
}

From source file:org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.HSSFCellStyleProducer.java

License:Open Source License

/**
 * Tries to translate the given stroke width into one of the predefined excel border styles.
 *
 * @param widthRaw the AWT-Stroke-Width.
 * @return the translated excel border width.
 */// w  ww .  j  a v  a 2 s.  c  om
protected static org.apache.poi.ss.usermodel.BorderStyle translateStroke(
        final org.pentaho.reporting.engine.classic.core.style.BorderStyle borderStyle, final long widthRaw) {
    final double width = StrictGeomUtility.toExternalValue(widthRaw);

    if (org.pentaho.reporting.engine.classic.core.style.BorderStyle.NONE.equals(borderStyle)) {
        return BorderStyle.NONE;
    } else if (org.pentaho.reporting.engine.classic.core.style.BorderStyle.DASHED.equals(borderStyle)) {
        return width <= 1.5 ? BorderStyle.DASHED : BorderStyle.MEDIUM_DASHED;
    } else if (org.pentaho.reporting.engine.classic.core.style.BorderStyle.DOT_DOT_DASH.equals(borderStyle)) {
        return width <= 1.5 ? BorderStyle.DASH_DOT_DOT : BorderStyle.MEDIUM_DASH_DOT_DOT;
    } else if (org.pentaho.reporting.engine.classic.core.style.BorderStyle.DOT_DASH.equals(borderStyle)) {
        return width <= 1.5 ? BorderStyle.DASH_DOT : BorderStyle.MEDIUM_DASH_DOT;
    } else if (org.pentaho.reporting.engine.classic.core.style.BorderStyle.DOTTED.equals(borderStyle)) {
        return BorderStyle.DOTTED;
    } else if (org.pentaho.reporting.engine.classic.core.style.BorderStyle.DOUBLE.equals(borderStyle)) {
        return BorderStyle.DOUBLE;
    } else if (width == 0) {
        return BorderStyle.NONE;
    } else if (width <= 0.5) {
        return BorderStyle.HAIR;
    } else if (width <= 1) {
        return BorderStyle.THIN;
    } else if (width <= 1.5) {
        return BorderStyle.MEDIUM;
    } else {
        return BorderStyle.THICK;
    }
}

From source file:org.sysmodb.xml.XMLStyleGenerator.java

License:BSD License

private static Map<BorderStyle, String> createBorderMap() {
    Map<BorderStyle, String> result = new HashMap<BorderStyle, String>();
    result.put(BorderStyle.DASHED, "dashed 1pt");
    result.put(BorderStyle.DASH_DOT, "dashed 1pt");
    result.put(BorderStyle.DASH_DOT_DOT, "dashed 1pt");
    result.put(BorderStyle.DOTTED, "dotted 1pt");
    result.put(BorderStyle.DOUBLE, "double 3pt");
    result.put(BorderStyle.HAIR, "solid 1pt");
    result.put(BorderStyle.MEDIUM, "2pt solid");
    result.put(BorderStyle.MEDIUM_DASHED, "2pt dashed");
    result.put(BorderStyle.MEDIUM_DASH_DOT, "2pt dashed");
    result.put(BorderStyle.MEDIUM_DASH_DOT_DOT, "2pt dashed");
    result.put(BorderStyle.NONE, "none");
    result.put(BorderStyle.SLANTED_DASH_DOT, "dashed 2pt");
    result.put(BorderStyle.THICK, "solid 3pt");
    result.put(BorderStyle.THIN, "dashed 1pt");

    return Collections.unmodifiableMap(result);
}

From source file:uk.co.spudsoft.birt.emitters.excel.StyleManagerXUtils.java

License:Open Source License

/**
 * Converts a BIRT border style into a POI BorderStyle.
 * @param birtBorder// w ww  .  j  a v a2 s.c  o  m
 * The BIRT border style.
 * @param width
 * The width of the border as understood by BIRT.
 * @return
 * A POI BorderStyle object.
 */
private BorderStyle poiBorderStyleFromBirt(String birtBorder, String width) {
    if ("none".equals(birtBorder)) {
        return BorderStyle.NONE;
    }
    double pxWidth = 3.0;
    if (CSSConstants.CSS_THIN_VALUE.equals(width)) {
        pxWidth = 1.0;
    } else if (CSSConstants.CSS_MEDIUM_VALUE.equals(width)) {
        pxWidth = 3.0;
    } else if (CSSConstants.CSS_THICK_VALUE.equals(width)) {
        pxWidth = 4.0;
    } else {
        DimensionType dim = DimensionType.parserUnit(width);
        if (dim != null) {
            if ("px".equals(dim.getUnits())) {
                pxWidth = dim.getMeasure();
            }
        }
    }
    if ("solid".equals(birtBorder)) {
        if (pxWidth < 2.9) {
            return BorderStyle.THIN;
        } else if (pxWidth < 3.1) {
            return BorderStyle.MEDIUM;
        } else {
            return BorderStyle.THICK;
        }
    } else if ("dashed".equals(birtBorder)) {
        if (pxWidth < 2.9) {
            return BorderStyle.DASHED;
        } else {
            return BorderStyle.MEDIUM_DASHED;
        }
    } else if ("dotted".equals(birtBorder)) {
        return BorderStyle.DOTTED;
    } else if ("double".equals(birtBorder)) {
        return BorderStyle.DOUBLE;
    }

    log.debug("Border style \"", birtBorder, "\" is not recognised.");
    return BorderStyle.NONE;
}