Document Solutions for Excel, Java Edition | Document Solutions
Features / Worksheet / Range Operations / Set Default Values for Cell Range
In This Topic
    Set Default Values for Cell Range
    In This Topic

    When creating Excel documents or reports such as finance documents, sales reports, invoices, student status reports, forms, and others, it is often required to have cells with pre-filled text or fixed data rather than empty or blank cells that can be used in further processing and calculations.

    The default value can help in such a scenario and provides a value or formula to be displayed and used in calculations like a normal cell value. DsExcel provides setDefaultValue method in IRange interface that allows you to set the default value of a cell to avoid empty cell scenarios.

    The default value has certain characteristics that are listed below:

    Refer to the following example code to set the default value of cells:

    Java
    Copy Code
    // Initialize workbook.
    var workbook = new Workbook();
    
    // Open defaultValue.xlsx.
    workbook.open("defaultValue.xlsx");
    var worksheet = workbook.getActiveSheet();
                
    // Set default value for standard reduction.
    worksheet.getRange("C4:C8").setDefaultValue("=B4 - B4*0.12");
    
    // Set normal value for specific percent reduction.
    worksheet.getRange("C6").setFormula("=B6 - B6*0.08");
    worksheet.getRange("C8").setFormula("=B8 - B8*0.05");
    
    // Calculate total on default value and specific values.
    worksheet.getRange("C9").setFormula("=SUM(C4:C8)");
    
    // Save to an Excel file.
    workbook.save("DefaultValueOutput.xlsx");

    Limitations