Package org.apache.poi.ss.usermodel

Examples of org.apache.poi.ss.usermodel.ConditionalFormattingRule

293
294
295
296
297
298
299
300
301
302
303
304
        }

        private void applyColorsThatConcealTheEmptyRows() {
            /* display the NA() values in light gray so they are less visible */
            SheetConditionalFormatting cf = s.getSheetConditionalFormatting();
            ConditionalFormattingRule rule = cf.createConditionalFormattingRule("ISNA(A1)");
            FontFormatting fontFmt = rule.createFontFormatting();
            fontFmt.setFontColorIndex(IndexedColors.GREY_25_PERCENT.index);
            String range;
            if (maxCol() != null) {
                range = String.format("A1:%s1048576", maxCol().toString(Utils.getCaf()));
            } else {
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.usermodel.ConditionalFormattingRule

  • output.ExcelFileFormulas$QuietSpreadsheetLayout
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.