Example usage for org.apache.poi.ss.usermodel Cell setCellValue

List of usage examples for org.apache.poi.ss.usermodel Cell setCellValue

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.ss.usermodel.*
  5. Cell
  6. setCellValue

Introduction

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

Prototype

void setCellValue(boolean value);

Source Link

Document

Set a boolean value for the cell

Usage

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.TranslationProgressReportHelper.java

License:Apache License

private void writeLanguageInfo(Workbook p_workbook, Sheet sheet, String srcLang, String trgLang)
        throws Exception {
    Row localeRow = getRow(sheet, 4);//from w w  w .  j  a  v  a 2s .  c  o m
    Cell cell_A = getCell(localeRow, 0);
    cell_A.setCellValue(srcLang);
    cell_A.setCellStyle(getContentStyle(p_workbook));
    Cell cell_B = getCell(localeRow, 1);
    cell_B.setCellValue(trgLang);
    cell_B.setCellStyle(getContentStyle(p_workbook));
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.TranslationProgressReportHelper.java

License:Apache License

/**
 * add pages in a job//from w ww .j a  v  a  2s.  com
 * 
 * @param sheet
 * @param job
 * @param row
 * @param paramSourceLocales
 * @param paramTargetLocales
 * @throws Exception
 */
private void addJobPages(Workbook p_workbook, Sheet p_sheet, Job job, IntHolder row,
        String[] paramSourceLocales, String[] paramTargetLocales) throws Exception {
    // return if source locale are not selected
    GlobalSightLocale gsl = job.getSourceLocale();
    if (!(Long.toString(gsl.getId())).equals(paramSourceLocales[0]))
        return;

    // get basic parameters
    String jobName = job.getJobName();
    long jobId = job.getId();
    Workflow selectedWF = null;
    String tLocale = paramTargetLocales[0];
    for (Workflow wf : job.getWorkflows()) {
        String wfLocale = Long.toString(wf.getTargetLocale().getId());
        if (wfLocale.equals(tLocale)) {
            selectedWF = wf;
            break;
        }
    }

    if (selectedWF != null) {
        Vector<TargetPage> targetPages = selectedWF.getTargetPages();
        for (TargetPage tp : targetPages) {
            int c = 1;
            // 8.2 Job id
            Row tehRow = getRow(p_sheet, row.value);
            Cell cell_B = getCell(tehRow, c++);
            cell_B.setCellValue(jobId);
            cell_B.setCellStyle(getContentStyle(p_workbook));
            // 8.2 job name
            Cell cell_C = getCell(tehRow, c++);
            cell_C.setCellValue(jobName);
            cell_C.setCellStyle(getContentStyle(p_workbook));
            // 8.3 document name
            String fileName = tp.getSourcePage().getExternalPageId();
            // fileName = SourcePage.filtSpecialFile(fileName);
            Cell cell_D = getCell(tehRow, c++);
            cell_D.setCellValue(fileName);
            cell_D.setCellStyle(getContentStyle(p_workbook));
            // 8.4 total translated text
            double p = SegmentTuvUtil.getTranslatedPercentageForTargetPage(tp.getId()) / 100.0;
            Cell cell_E = getCell(tehRow, c++);
            cell_E.setCellValue(p);
            cell_E.setCellStyle(getPercentStyle(p_workbook));
            row.inc();
        }
    }
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.VendorPOXlsReport.java

License:Apache License

private void addTitle(Workbook p_workbook, Sheet p_sheet) throws Exception {
    // title font is black bold on white
    String EMEA = CompanyWrapper.getCurrentCompanyName();
    Font titleFont = p_workbook.createFont();
    titleFont.setUnderline(Font.U_NONE);
    titleFont.setFontName("Arial");
    titleFont.setFontHeightInPoints((short) 14);
    titleFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
    titleFont.setColor(IndexedColors.BLACK.getIndex());
    CellStyle titleStyle = p_workbook.createCellStyle();
    titleStyle.setWrapText(false);/*  w  ww. j  ava 2s. c  o m*/
    titleStyle.setFont(titleFont);

    Row titleRow = getRow(p_sheet, 0);
    Cell cell_A_Title = getCell(titleRow, 0);
    cell_A_Title.setCellValue(EMEA + " " + bundle.getString("lb_po"));
    cell_A_Title.setCellStyle(titleStyle);
    p_sheet.setColumnWidth(0, 20 * 256);
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.VendorPOXlsReport.java

License:Apache License

/**
 * Adds the table header for the Dell Matches sheet
 * // w w w  .  java2s  . com
 */
private void addHeaderForDellMatches(Workbook p_workbook, MyData p_data) throws Exception {
    Sheet theSheet = p_data.dellSheet;
    int c = 0;
    Row thirRow = getRow(theSheet, 2);
    Row fourRow = getRow(theSheet, 3);

    Cell cell_A = getCell(thirRow, c);
    cell_A.setCellValue(bundle.getString("lb_job_id"));
    cell_A.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    c++;
    Cell cell_B = getCell(thirRow, c);
    cell_B.setCellValue(bundle.getString("lb_job"));
    cell_B.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    c++;
    Cell cell_C = getCell(thirRow, c);
    cell_C.setCellValue(bundle.getString("lb_po_number_report"));
    cell_C.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    theSheet.setColumnWidth(c, 15 * 256);
    c++;
    Cell cell_D = getCell(thirRow, c);
    cell_D.setCellValue(bundle.getString("lb_description"));
    cell_D.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    theSheet.setColumnWidth(c, 15 * 256);
    c++;
    Cell cell_E = getCell(thirRow, c);
    cell_E.setCellValue(bundle.getString("lb_creation_date"));
    cell_E.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    c++;
    Cell cell_F = getCell(thirRow, c);
    cell_F.setCellValue(bundle.getString("lb_lang"));
    cell_F.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    c++;
    Cell cell_G_Header = getCell(thirRow, c);
    cell_G_Header.setCellValue(bundle.getString("lb_word_counts"));
    cell_G_Header.setCellStyle(getHeaderStyle(p_workbook));

    if (p_data.headers[0] != null) {
        theSheet.addMergedRegion(new CellRangeAddress(2, 2, c, c + 5));
        setRegionStyle(theSheet, new CellRangeAddress(2, 2, c, c + 5), getHeaderStyle(p_workbook));
    } else {
        theSheet.addMergedRegion(new CellRangeAddress(2, 2, c, c + 4));
        setRegionStyle(theSheet, new CellRangeAddress(2, 2, c, c + 4), getHeaderStyle(p_workbook));
    }

    Cell cell_G = getCell(fourRow, c++);
    cell_G.setCellValue(bundle.getString("jobinfo.tmmatches.wordcounts.internalreps"));
    cell_G.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_H = getCell(fourRow, c++);
    cell_H.setCellValue(bundle.getString("jobinfo.tmmatches.wordcounts.exactmatches"));
    cell_H.setCellStyle(getHeaderStyle(p_workbook));
    if (p_data.headers[0] != null) {
        Cell cell_InContext = getCell(fourRow, c++);
        cell_InContext.setCellValue(bundle.getString("jobinfo.tmmatches.wordcounts.incontextmatches"));
        cell_InContext.setCellStyle(getHeaderStyle(p_workbook));
    }
    Cell cell_FuzzyMatches = getCell(fourRow, c++);
    cell_FuzzyMatches.setCellValue(bundle.getString("jobinfo.tmmatches.wordcounts.fuzzymatches"));
    cell_FuzzyMatches.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_Newwords = getCell(fourRow, c++);
    cell_Newwords.setCellValue(bundle.getString("jobinfo.tmmatches.wordcounts.newwords"));
    cell_Newwords.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_Total = getCell(fourRow, c++);
    cell_Total.setCellValue(bundle.getString("lb_total"));
    cell_Total.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_Invoice = getCell(thirRow, c);
    cell_Invoice.setCellValue(bundle.getString("jobinfo.tmmatches.invoice"));
    cell_Invoice.setCellStyle(getHeaderStyle(p_workbook));

    if (p_data.headers[0] != null) {
        theSheet.addMergedRegion(new CellRangeAddress(2, 2, c, c + 5));
        setRegionStyle(theSheet, new CellRangeAddress(2, 2, c, c + 5), getHeaderStyle(p_workbook));
    } else {
        theSheet.addMergedRegion(new CellRangeAddress(2, 2, c, c + 4));
        setRegionStyle(theSheet, new CellRangeAddress(2, 2, c, c + 4), getHeaderStyle(p_workbook));
    }

    Cell cell_InternalReps = getCell(fourRow, c++);
    cell_InternalReps.setCellValue(bundle.getString("jobinfo.tmmatches.invoice.internalreps"));
    cell_InternalReps.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_ExactMatches = getCell(fourRow, c++);
    cell_ExactMatches.setCellValue(bundle.getString("jobinfo.tmmatches.invoice.exactmatches"));
    cell_ExactMatches.setCellStyle(getHeaderStyle(p_workbook));
    if (p_data.headers[0] != null) {
        Cell cell_InContext = getCell(fourRow, c++);
        cell_InContext.setCellValue(bundle.getString("jobinfo.tmmatches.invoice.incontextmatches"));
        cell_InContext.setCellStyle(getHeaderStyle(p_workbook));
    }

    Cell cell_FuzzyMatches_Invoice = getCell(fourRow, c++);
    cell_FuzzyMatches_Invoice.setCellValue(bundle.getString("jobinfo.tmmatches.invoice.fuzzymatches"));
    cell_FuzzyMatches_Invoice.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_NewWords_Invoice = getCell(fourRow, c++);
    cell_NewWords_Invoice.setCellValue(bundle.getString("jobinfo.tmmatches.invoice.newwords"));
    cell_NewWords_Invoice.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_Total_Invoice = getCell(fourRow, c++);
    cell_Total_Invoice.setCellValue(bundle.getString("lb_total"));
    cell_Total_Invoice.setCellStyle(getHeaderStyle(p_workbook));

    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getContentStyle(p_workbook));
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.VendorPOXlsReport.java

License:Apache License

/**
 * Adds the table header for the Trados Matches sheet
 * //from www  .ja  va 2 s  . co  m
 */
private void addHeaderForTradosMatches(Workbook p_workbook, MyData p_data) throws Exception {
    Sheet theSheet = p_data.tradosSheet;
    int c = 0;
    Row secRow = getRow(theSheet, 1);
    Row thirRow = getRow(theSheet, 2);
    Row fourRow = getRow(theSheet, 3);

    Cell cell_Ldfl = getCell(secRow, c);
    cell_Ldfl.setCellValue(bundle.getString("lb_desp_file_list"));
    cell_Ldfl.setCellStyle(getContentStyle(p_workbook));

    Cell cell_A = getCell(thirRow, c);
    cell_A.setCellValue(bundle.getString("lb_job_id"));
    cell_A.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    c++;
    Cell cell_B = getCell(thirRow, c);
    cell_B.setCellValue(bundle.getString("lb_job"));
    cell_B.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    c++;
    Cell cell_C = getCell(thirRow, c);
    cell_C.setCellValue(bundle.getString("lb_po_number_report"));
    cell_C.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    c++;
    Cell cell_D = getCell(thirRow, c);
    cell_D.setCellValue(bundle.getString("reportDesc"));
    cell_D.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    theSheet.setColumnWidth(c, 15 * 256);
    c++;
    Cell cell_E = getCell(thirRow, c);
    cell_E.setCellValue(bundle.getString("lb_creation_date"));
    cell_E.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    c++;
    Cell cell_F = getCell(thirRow, c);
    cell_F.setCellValue(bundle.getString("lb_lang"));
    cell_F.setCellStyle(getHeaderStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(2, 3, c, c));
    setRegionStyle(theSheet, new CellRangeAddress(2, 3, c, c), getHeaderStyle(p_workbook));
    c++;
    Cell cell_G_Header = getCell(thirRow, c);
    cell_G_Header.setCellValue(bundle.getString("jobinfo.tmmatches.wordcounts"));
    cell_G_Header.setCellStyle(getHeaderStyle(p_workbook));

    if (p_data.headers[0] != null) {
        theSheet.addMergedRegion(new CellRangeAddress(2, 2, c, c + 7));
        setRegionStyle(theSheet, new CellRangeAddress(2, 2, c, c + 7), getHeaderStyle(p_workbook));
    } else {
        theSheet.addMergedRegion(new CellRangeAddress(2, 2, c, c + 6));
        setRegionStyle(theSheet, new CellRangeAddress(2, 2, c, c + 6), getHeaderStyle(p_workbook));
    }

    Cell cell_G = getCell(fourRow, c++);
    cell_G.setCellValue(bundle.getString("jobinfo.tradosmatches.invoice.per100matches"));
    cell_G.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_H = getCell(fourRow, c++);
    cell_H.setCellValue(bundle.getString("lb_95_99"));
    cell_H.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_I = getCell(fourRow, c++);
    cell_I.setCellValue(bundle.getString("lb_85_94"));
    cell_I.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_J = getCell(fourRow, c++);
    cell_J.setCellValue(bundle.getString("lb_75_84") + "*");
    cell_J.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_K = getCell(fourRow, c++);
    cell_K.setCellValue(bundle.getString("lb_no_match"));
    cell_K.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_L = getCell(fourRow, c++);
    cell_L.setCellValue(bundle.getString("lb_repetition_word_cnt"));
    cell_L.setCellStyle(getHeaderStyle(p_workbook));
    if (p_data.headers[0] != null) {
        Cell cell_InContext = getCell(fourRow, c++);
        cell_InContext.setCellValue(bundle.getString("lb_in_context_tm"));
        cell_InContext.setCellStyle(getHeaderStyle(p_workbook));
    }
    Cell cell_Total = getCell(fourRow, c++);
    cell_Total.setCellValue(bundle.getString("lb_total"));
    cell_Total.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_Invoice = getCell(thirRow, c);
    cell_Invoice.setCellValue(bundle.getString("jobinfo.tmmatches.invoice"));
    cell_Invoice.setCellStyle(getHeaderStyle(p_workbook));
    if (p_data.headers[0] != null) {
        theSheet.addMergedRegion(new CellRangeAddress(2, 2, c, c + 7));
        setRegionStyle(theSheet, new CellRangeAddress(2, 2, c, c + 7), getHeaderStyle(p_workbook));
    } else {
        theSheet.addMergedRegion(new CellRangeAddress(2, 2, c, c + 6));
        setRegionStyle(theSheet, new CellRangeAddress(2, 2, c, c + 6), getHeaderStyle(p_workbook));
    }

    Cell cell_Per100Matches = getCell(fourRow, c++);
    cell_Per100Matches.setCellValue(bundle.getString("jobinfo.tradosmatches.invoice.per100matches"));
    cell_Per100Matches.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_95_99 = getCell(fourRow, c++);
    cell_95_99.setCellValue(bundle.getString("lb_95_99"));
    cell_95_99.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_85_94 = getCell(fourRow, c++);
    cell_85_94.setCellValue(bundle.getString("lb_85_94"));
    cell_85_94.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_75_84 = getCell(fourRow, c++);
    cell_75_84.setCellValue(bundle.getString("lb_75_84") + "*");
    cell_75_84.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_NoMatch = getCell(fourRow, c++);
    cell_NoMatch.setCellValue(bundle.getString("lb_no_match"));
    cell_NoMatch.setCellStyle(getHeaderStyle(p_workbook));

    Cell cell_Repetition = getCell(fourRow, c++);
    cell_Repetition.setCellValue(bundle.getString("lb_repetition_word_cnt"));
    cell_Repetition.setCellStyle(getHeaderStyle(p_workbook));
    if (p_data.headers[0] != null) {
        Cell cell_InContext = getCell(fourRow, c++);
        cell_InContext.setCellValue(bundle.getString("lb_in_context_match"));
        cell_InContext.setCellStyle(getHeaderStyle(p_workbook));
    }
    Cell cell_Total_Invoice = getCell(fourRow, c++);
    cell_Total_Invoice.setCellValue(bundle.getString("lb_total"));
    cell_Total_Invoice.setCellStyle(getHeaderStyle(p_workbook));
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.VendorPOXlsReport.java

License:Apache License

public void writeProjectDataForDellMatches(Workbook p_workbook, HashMap p_projectMap, IntHolder p_row,
        MyData p_data) throws Exception {
    Sheet theSheet = p_data.dellSheet;//from w ww  .  jav a 2 s . c  om
    ArrayList projects = new ArrayList(p_projectMap.keySet());
    SortUtil.sort(projects);
    Iterator projectIter = projects.iterator();

    while (projectIter.hasNext()) {
        String jobName = (String) projectIter.next();
        boolean isWrongJob = p_data.wrongJobNames.contains(jobName);
        HashMap localeMap = (HashMap) p_projectMap.get(jobName);
        ArrayList locales = new ArrayList(localeMap.keySet());
        SortUtil.sort(locales);
        Iterator localeIter = locales.iterator();
        BigDecimal projectTotalWordCountCost = new BigDecimal(BIG_DECIMAL_ZERO_STRING);
        while (localeIter.hasNext()) {
            int row = p_row.getValue();
            int col = 0;
            Row theRow = getRow(theSheet, row);
            String localeName = (String) localeIter.next();
            ProjectWorkflowData data = (ProjectWorkflowData) localeMap.get(localeName);
            CellStyle temp_dateStyle = getDateStyle(p_workbook);
            CellStyle temp_moneyStyle = getMoneyStyle(p_workbook);
            CellStyle temp_normalStyle = getContentStyle(p_workbook);
            // WritableCellFormat temp_wordCountValueRightFormat =
            // wordCountValueRightFormat;
            if (data.wasExportFailed) {
                temp_dateStyle = getFailedDateStyle(p_workbook);
                temp_moneyStyle = getFailedMoneyStyle(p_workbook);
                temp_normalStyle = getRedCellStyle(p_workbook);

            }
            Cell cell_A = getCell(theRow, col++);
            cell_A.setCellValue(data.jobId);

            Cell cell_B = getCell(theRow, col++);
            cell_B.setCellValue(data.jobName);
            if (isWrongJob) {
                cell_A.setCellStyle(getWrongJobStyle(p_workbook));
                cell_B.setCellStyle(getWrongJobStyle(p_workbook));
            } else {
                cell_A.setCellStyle(temp_normalStyle);
                cell_B.setCellStyle(temp_normalStyle);
            }
            theSheet.setColumnWidth(col - 2, 5 * 256);
            theSheet.setColumnWidth(col - 1, 50 * 256);
            Cell cell_C = getCell(theRow, col++);
            cell_C.setCellValue(data.poNumber);
            cell_C.setCellStyle(temp_normalStyle); // PO number

            Cell cell_D = getCell(theRow, col++);
            cell_D.setCellValue(data.projectDesc);
            cell_D.setCellStyle(temp_normalStyle);
            theSheet.setColumnWidth(col - 1, 22 * 256);
            /* data.creationDate.toString())); */
            Cell cell_E = getCell(theRow, col++);
            cell_E.setCellValue(data.creationDate);
            cell_E.setCellStyle(temp_dateStyle);
            theSheet.setColumnWidth(col - 1, 15 * 256);

            Cell cell_F = getCell(theRow, col++);
            cell_F.setCellValue(data.targetLang);
            cell_F.setCellStyle(temp_normalStyle);

            Cell cell_G = getCell(theRow, col++);
            cell_G.setCellValue(data.dellInternalRepsWordCount);
            cell_G.setCellStyle(temp_normalStyle);
            int numwidth = 10;
            theSheet.setColumnWidth(col - 1, numwidth * 256);
            Cell cell_H = getCell(theRow, col++);
            cell_H.setCellValue(data.dellExactMatchWordCount);
            cell_H.setCellStyle(temp_normalStyle);
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            if (p_data.headers[0] != null) {
                Cell cell_InContext = getCell(theRow, col++);
                cell_InContext.setCellValue(data.dellInContextMatchWordCount);
                cell_InContext.setCellStyle(temp_normalStyle);
                theSheet.setColumnWidth(col - 1, numwidth * 256);
            }

            Cell cell_FuzzyMatch = getCell(theRow, col++);
            cell_FuzzyMatch.setCellValue(data.dellFuzzyMatchWordCount);
            cell_FuzzyMatch.setCellStyle(temp_normalStyle);
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            Cell cell_NewWords = getCell(theRow, col++);
            cell_NewWords.setCellValue(data.dellNewWordsWordCount);
            cell_NewWords.setCellStyle(temp_normalStyle);
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            Cell cell_Total = getCell(theRow, col++);
            cell_Total.setCellValue(data.dellTotalWordCount);
            cell_Total.setCellStyle(temp_normalStyle);
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            int moneywidth = 12;
            Cell cell_InternalReps = getCell(theRow, col++);
            cell_InternalReps.setCellValue(asDouble(data.dellInternalRepsWordCountCost));
            cell_InternalReps.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_ExactMatch = getCell(theRow, col++);
            cell_ExactMatch.setCellValue(asDouble(data.dellExactMatchWordCountCost));
            cell_ExactMatch.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            if (p_data.headers[0] != null) {
                Cell cell_InContext = getCell(theRow, col++);
                cell_InContext.setCellValue(asDouble(data.dellInContextMatchWordCountCost));
                cell_InContext.setCellStyle(temp_moneyStyle);
                theSheet.setColumnWidth(col - 1, moneywidth * 256);
            }

            Cell cell_FuzzyMatch_Invoice = getCell(theRow, col++);
            cell_FuzzyMatch_Invoice.setCellValue(asDouble(data.dellFuzzyMatchWordCountCost));
            cell_FuzzyMatch_Invoice.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_NewWords_Invoice = getCell(theRow, col++);
            cell_NewWords_Invoice.setCellValue(asDouble(data.dellNewWordsWordCountCost));
            cell_NewWords_Invoice.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_Total_Invoice = getCell(theRow, col++);
            cell_Total_Invoice.setCellValue(asDouble(data.dellTotalWordCountCost));
            cell_Total_Invoice.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            p_row.inc();
        }
    }

    p_row.inc();
    p_row.inc();
    addTotalsForDellMatches(p_workbook, p_data, p_row, bundle);

}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.VendorPOXlsReport.java

License:Apache License

/** Adds the totals and sub-total formulas */
private void addTotalsForDellMatches(Workbook p_workbook, MyData p_data, IntHolder p_row, ResourceBundle bundle)
        throws Exception {
    Sheet theSheet = p_data.dellSheet;//from  w  ww. j a v  a 2s.com
    int row = p_row.getValue() + 1; // skip a row

    String title = bundle.getString("lb_totals");
    Row theRow = getRow(theSheet, row);
    Cell cell_A = getCell(theRow, 0);
    cell_A.setCellValue(title);
    cell_A.setCellStyle(getSubTotalStyle(p_workbook));

    theSheet.addMergedRegion(new CellRangeAddress(row, row, 0, 5));
    setRegionStyle(theSheet, new CellRangeAddress(row, row, 0, 5), getSubTotalStyle(p_workbook));
    int lastRow = p_row.getValue() - 2;

    // add in word count totals
    int c = 6;
    if (p_data.headers[0] != null) {
        // word counts
        Cell cell_G = getCell(theRow, c++);
        cell_G.setCellFormula("SUM(G5:G" + lastRow + ")");
        cell_G.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_H = getCell(theRow, c++);
        cell_H.setCellFormula("SUM(H5:H" + lastRow + ")");
        cell_H.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_I = getCell(theRow, c++);
        cell_I.setCellFormula("SUM(I5:I" + lastRow + ")");
        cell_I.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_J = getCell(theRow, c++);
        cell_J.setCellFormula("SUM(J5:J" + lastRow + ")");
        cell_J.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_K = getCell(theRow, c++);
        cell_K.setCellFormula("SUM(K5:K" + lastRow + ")");
        cell_K.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_L = getCell(theRow, c++);
        cell_L.setCellFormula("SUM(L5:L" + lastRow + ")");
        cell_L.setCellStyle(getSubTotalStyle(p_workbook));
        // word count costs
        Cell cell_M = getCell(theRow, c++);
        cell_M.setCellFormula("SUM(M5:M" + lastRow + ")");
        cell_M.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_N = getCell(theRow, c++);
        cell_N.setCellFormula("SUM(N5:N" + lastRow + ")");
        cell_N.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_O = getCell(theRow, c++);
        cell_O.setCellFormula("SUM(O5:O" + lastRow + ")");
        cell_O.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_P = getCell(theRow, c++);
        cell_P.setCellFormula("SUM(P5:P" + lastRow + ")");
        cell_P.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_Q = getCell(theRow, c++);
        cell_Q.setCellFormula("SUM(Q5:Q" + lastRow + ")");
        cell_Q.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_R = getCell(theRow, c++);
        cell_R.setCellFormula("SUM(R5:R" + lastRow + ")");
        cell_R.setCellStyle(getTotalMoneyStyle(p_workbook));
    } else {
        // word counts
        Cell cell_G = getCell(theRow, c++);
        cell_G.setCellFormula("SUM(G5:G" + lastRow + ")");
        cell_G.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_H = getCell(theRow, c++);
        cell_H.setCellFormula("SUM(H5:H" + lastRow + ")");
        cell_H.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_I = getCell(theRow, c++);
        cell_I.setCellFormula("SUM(I5:I" + lastRow + ")");
        cell_I.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_J = getCell(theRow, c++);
        cell_J.setCellFormula("SUM(J5:J" + lastRow + ")");
        cell_J.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_K = getCell(theRow, c++);
        cell_K.setCellFormula("SUM(K5:K" + lastRow + ")");
        cell_K.setCellStyle(getSubTotalStyle(p_workbook));
        // word count costs
        Cell cell_L = getCell(theRow, c++);
        cell_L.setCellFormula("SUM(L5:L" + lastRow + ")");
        cell_L.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_M = getCell(theRow, c++);
        cell_M.setCellFormula("SUM(M5:M" + lastRow + ")");
        cell_M.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_N = getCell(theRow, c++);
        cell_N.setCellFormula("SUM(N5:N" + lastRow + ")");
        cell_N.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_O = getCell(theRow, c++);
        cell_O.setCellFormula("SUM(O5:O" + lastRow + ")");
        cell_O.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_P = getCell(theRow, c++);
        cell_P.setCellFormula("SUM(P5:P" + lastRow + ")");
        cell_P.setCellStyle(getTotalMoneyStyle(p_workbook));
    }
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.VendorPOXlsReport.java

License:Apache License

public void writeProjectDataForTradosMatches(Workbook p_workbook, HashMap p_projectMap, IntHolder p_row,
        MyData p_data) throws Exception {
    Sheet theSheet = p_data.tradosSheet;
    ArrayList projects = new ArrayList(p_projectMap.keySet());
    SortUtil.sort(projects);//  w w  w.j a  va  2s .co  m
    Iterator projectIter = projects.iterator();

    while (projectIter.hasNext()) {
        String jobName = (String) projectIter.next();
        boolean isWrongJob = p_data.wrongJobNames.contains(jobName);
        HashMap localeMap = (HashMap) p_projectMap.get(jobName);
        ArrayList locales = new ArrayList(localeMap.keySet());
        SortUtil.sort(locales);
        Iterator localeIter = locales.iterator();
        BigDecimal projectTotalWordCountCost = new BigDecimal(BIG_DECIMAL_ZERO_STRING);
        while (localeIter.hasNext()) {
            int row = p_row.getValue();
            int col = 0;
            Row theRow = getRow(theSheet, row);
            String localeName = (String) localeIter.next();
            ProjectWorkflowData data = (ProjectWorkflowData) localeMap.get(localeName);

            CellStyle temp_dateStyle = getDateStyle(p_workbook);
            CellStyle temp_moneyStyle = getMoneyStyle(p_workbook);
            CellStyle temp_normalStyle = getContentStyle(p_workbook);
            // WritableCellFormat temp_wordCountValueRightFormat =
            // wordCountValueRightFormat;
            if (data.wasExportFailed) {
                temp_dateStyle = getFailedDateStyle(p_workbook);
                temp_moneyStyle = getFailedMoneyStyle(p_workbook);
                temp_normalStyle = getRedCellStyle(p_workbook);
            }

            Cell cell_A = getCell(theRow, col++);
            cell_A.setCellValue(data.jobId);

            Cell cell_B = getCell(theRow, col++);
            cell_B.setCellValue(data.jobName);
            if (isWrongJob) {
                cell_A.setCellStyle(getWrongJobStyle(p_workbook));
                cell_B.setCellStyle(getWrongJobStyle(p_workbook));
            } else {
                cell_A.setCellStyle(temp_normalStyle);
                ;
                cell_B.setCellStyle(temp_normalStyle);
            }
            theSheet.setColumnWidth(col - 2, 5 * 256);
            theSheet.setColumnWidth(col - 1, 50 * 256);
            Cell cell_C = getCell(theRow, col++);
            cell_C.setCellValue(data.poNumber);
            cell_C.setCellStyle(temp_normalStyle); // PO number

            Cell cell_D = getCell(theRow, col++);
            cell_D.setCellValue(data.projectDesc);
            cell_D.setCellStyle(temp_normalStyle);
            theSheet.setColumnWidth(col - 1, 22 * 256);
            /* data.creationDate.toString())); */
            Cell cell_E = getCell(theRow, col++);
            cell_E.setCellValue(data.creationDate);
            cell_E.setCellStyle(temp_dateStyle);
            theSheet.setColumnWidth(col - 1, 15 * 256);

            Cell cell_F = getCell(theRow, col++);
            cell_F.setCellValue(data.targetLang);
            cell_F.setCellStyle(temp_normalStyle);

            Cell cell_G = getCell(theRow, col++);
            cell_G.setCellValue(data.trados100WordCount);
            cell_G.setCellStyle(temp_normalStyle);
            int numwidth = 10;
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            Cell cell_H = getCell(theRow, col++);
            cell_H.setCellValue(data.trados95to99WordCount);
            cell_H.setCellStyle(temp_normalStyle);
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            Cell cell_I = getCell(theRow, col++);
            cell_I.setCellValue(data.trados85to94WordCount);
            cell_I.setCellStyle(temp_normalStyle);
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            Cell cell_J = getCell(theRow, col++);
            cell_J.setCellValue(data.trados75to84WordCount);
            cell_J.setCellStyle(temp_normalStyle);
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            Cell cell_K = getCell(theRow, col++);
            cell_K.setCellValue(data.tradosNoMatchWordCount + data.trados50to74WordCount);
            cell_K.setCellStyle(temp_normalStyle);
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            Cell cell_L = getCell(theRow, col++);
            cell_L.setCellValue(data.tradosRepsWordCount);
            cell_L.setCellStyle(temp_normalStyle);
            theSheet.setColumnWidth(col - 1, numwidth * 256);
            if (p_data.headers[0] != null) {
                Cell cell_InContext = getCell(theRow, col++);
                cell_InContext.setCellValue(data.tradosInContextMatchWordCount);
                cell_InContext.setCellStyle(temp_normalStyle);
                theSheet.setColumnWidth(col - 1, numwidth * 256);
            }

            Cell cell_Total = getCell(theRow, col++);
            cell_Total.setCellValue(data.tradosTotalWordCount);
            cell_Total.setCellStyle(temp_normalStyle);
            theSheet.setColumnWidth(col - 1, numwidth * 256);

            int moneywidth = 12;
            Cell cell_100Cost = getCell(theRow, col++);
            cell_100Cost.setCellValue(asDouble(data.trados100WordCountCost));
            cell_100Cost.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_95_99 = getCell(theRow, col++);
            cell_95_99.setCellValue(asDouble(data.trados95to99WordCountCost));
            cell_95_99.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_85_94 = getCell(theRow, col++);
            cell_85_94.setCellValue(asDouble(data.trados85to94WordCountCost));
            cell_85_94.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_75_84 = getCell(theRow, col++);
            cell_75_84.setCellValue(asDouble(data.trados75to84WordCountCost));
            cell_75_84.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_NoMatch = getCell(theRow, col++);
            cell_NoMatch.setCellValue(asDouble(data.tradosNoMatchWordCountCost));
            cell_NoMatch.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            Cell cell_Reps = getCell(theRow, col++);
            cell_Reps.setCellValue(asDouble(data.tradosRepsWordCountCost));
            cell_Reps.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            if (p_data.headers[0] != null) {
                Cell cell_InContext = getCell(theRow, col++);
                cell_InContext.setCellValue(asDouble(data.tradosInContextWordCountCost));
                cell_InContext.setCellStyle(temp_moneyStyle);
                theSheet.setColumnWidth(col - 1, moneywidth * 256);
            }

            Cell cell_TotalCost = getCell(theRow, col++);
            cell_TotalCost.setCellValue(asDouble(data.tradosTotalWordCountCost));
            cell_TotalCost.setCellStyle(temp_moneyStyle);
            theSheet.setColumnWidth(col - 1, moneywidth * 256);

            p_row.inc();
        }
    }

    p_row.inc();
    p_row.inc();
    addTotalsForTradosMatches(p_workbook, p_data, p_row, bundle);
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.VendorPOXlsReport.java

License:Apache License

/** Adds the totals and sub-total formulas */
private void addTotalsForTradosMatches(Workbook p_workbook, MyData p_data, IntHolder p_row,
        ResourceBundle bundle) throws Exception {
    Sheet theSheet = p_data.tradosSheet;
    int row = p_row.getValue() + 1; // skip a row

    String title = bundle.getString("lb_totals");

    Row theRow = getRow(theSheet, row);/*ww  w  .  j  av a  2s  .  com*/
    Cell cell_A = getCell(theRow, 0);
    cell_A.setCellValue(title);
    cell_A.setCellStyle(getSubTotalStyle(p_workbook));
    theSheet.addMergedRegion(new CellRangeAddress(row, row, 0, 5));
    setRegionStyle(theSheet, new CellRangeAddress(row, row, 0, 5), getSubTotalStyle(p_workbook));

    int lastRow = p_row.getValue() - 2;

    // add in word count totals
    int c = 6;
    if (p_data.headers[0] != null) {
        // word counts
        Cell cell_G = getCell(theRow, c++);
        cell_G.setCellFormula("SUM(G5:G" + lastRow + ")");
        cell_G.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_H = getCell(theRow, c++);
        cell_H.setCellFormula("SUM(H5:H" + lastRow + ")");
        cell_H.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_I = getCell(theRow, c++);
        cell_I.setCellFormula("SUM(I5:I" + lastRow + ")");
        cell_I.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_J = getCell(theRow, c++);
        cell_J.setCellFormula("SUM(J5:J" + lastRow + ")");
        cell_J.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_K = getCell(theRow, c++);
        cell_K.setCellFormula("SUM(K5:K" + lastRow + ")");
        cell_K.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_L = getCell(theRow, c++);
        cell_L.setCellFormula("SUM(L5:L" + lastRow + ")");
        cell_L.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_M = getCell(theRow, c++);
        cell_M.setCellFormula("SUM(M5:M" + lastRow + ")");
        cell_M.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_N = getCell(theRow, c++);
        cell_N.setCellFormula("SUM(N5:N" + lastRow + ")");
        cell_N.setCellStyle(getSubTotalStyle(p_workbook));
        // word count costs
        Cell cell_O = getCell(theRow, c++);
        cell_O.setCellFormula("SUM(O5:O" + lastRow + ")");
        cell_O.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_P = getCell(theRow, c++);
        cell_P.setCellFormula("SUM(P5:P" + lastRow + ")");
        cell_P.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_Q = getCell(theRow, c++);
        cell_Q.setCellFormula("SUM(Q5:Q" + lastRow + ")");
        cell_Q.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_R = getCell(theRow, c++);
        cell_R.setCellFormula("SUM(R5:R" + lastRow + ")");
        cell_R.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_S = getCell(theRow, c++);
        cell_S.setCellFormula("SUM(S5:S" + lastRow + ")");
        cell_S.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_T = getCell(theRow, c++);
        cell_T.setCellFormula("SUM(T5:T" + lastRow + ")");
        cell_T.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_U = getCell(theRow, c++);
        cell_U.setCellFormula("SUM(U5:U" + lastRow + ")");
        cell_U.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_V = getCell(theRow, c++);
        cell_V.setCellFormula("SUM(V5:V" + lastRow + ")");
        cell_V.setCellStyle(getTotalMoneyStyle(p_workbook));
    } else {
        // word counts
        Cell cell_G = getCell(theRow, c++);
        cell_G.setCellFormula("SUM(G5:G" + lastRow + ")");
        cell_G.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_H = getCell(theRow, c++);
        cell_H.setCellFormula("SUM(H5:H" + lastRow + ")");
        cell_H.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_I = getCell(theRow, c++);
        cell_I.setCellFormula("SUM(I5:I" + lastRow + ")");
        cell_I.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_J = getCell(theRow, c++);
        cell_J.setCellFormula("SUM(J5:J" + lastRow + ")");
        cell_J.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_K = getCell(theRow, c++);
        cell_K.setCellFormula("SUM(K5:K" + lastRow + ")");
        cell_K.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_L = getCell(theRow, c++);
        cell_L.setCellFormula("SUM(L5:L" + lastRow + ")");
        cell_L.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_M = getCell(theRow, c++);
        cell_M.setCellFormula("SUM(M5:M" + lastRow + ")");
        cell_M.setCellStyle(getSubTotalStyle(p_workbook));
        // word count costs
        Cell cell_N = getCell(theRow, c++);
        cell_N.setCellFormula("SUM(N5:N" + lastRow + ")");
        cell_N.setCellStyle(getSubTotalStyle(p_workbook));

        Cell cell_O = getCell(theRow, c++);
        cell_O.setCellFormula("SUM(O5:O" + lastRow + ")");
        cell_O.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_P = getCell(theRow, c++);
        cell_P.setCellFormula("SUM(P5:P" + lastRow + ")");
        cell_P.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_Q = getCell(theRow, c++);
        cell_Q.setCellFormula("SUM(Q5:Q" + lastRow + ")");
        cell_Q.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_R = getCell(theRow, c++);
        cell_R.setCellFormula("SUM(R5:R" + lastRow + ")");
        cell_R.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_S = getCell(theRow, c++);
        cell_S.setCellFormula("SUM(S5:S" + lastRow + ")");
        cell_S.setCellStyle(getTotalMoneyStyle(p_workbook));

        Cell cell_T = getCell(theRow, c++);
        cell_T.setCellFormula("SUM(T5:T" + lastRow + ")");
        cell_T.setCellStyle(getTotalMoneyStyle(p_workbook));
    }
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.VendorPOXlsReport.java

License:Apache License

private void writeParamsSheet(Workbook p_workbook, Sheet paramsSheet, MyData p_data,
        HttpServletRequest p_request) throws Exception {
    Row firRow = getRow(paramsSheet, 0);
    Row secRow = getRow(paramsSheet, 1);
    Row thirRow = getRow(paramsSheet, 2);
    Cell cell_A_Title = getCell(firRow, 0);
    cell_A_Title.setCellValue(bundle.getString("lb_report_criteria"));
    cell_A_Title.setCellStyle(getContentStyle(p_workbook));
    paramsSheet.setColumnWidth(0, 50 * 256);

    Cell cell_A_Header = getCell(secRow, 0);
    if (p_data.wantsAllProjects) {
        cell_A_Header.setCellValue(bundle.getString("lb_selected_projects") + " " + bundle.getString("all"));
        cell_A_Header.setCellStyle(getContentStyle(p_workbook));
    } else {//ww  w  .  j av  a 2 s  .  c  o  m
        cell_A_Header.setCellValue(bundle.getString("lb_selected_projects"));
        cell_A_Header.setCellStyle(getContentStyle(p_workbook));
        Iterator<Long> iter = p_data.projectIdList.iterator();
        int r = 2;
        while (iter.hasNext()) {
            Long pid = (Long) iter.next();
            String projectName = "??";
            try {
                Project p = ServerProxy.getProjectHandler().getProjectById(pid.longValue());
                projectName = p.getName();
            } catch (Exception e) {
            }
            String v = projectName + " (" + bundle.getString("lb_report_id") + "=" + pid.toString() + ")";
            Row theRow = getRow(paramsSheet, r);
            Cell cell_A = getCell(theRow, 0);
            cell_A.setCellValue(v);
            cell_A.setCellStyle(getContentStyle(p_workbook));
            r++;
        }
    }

    // add the date criteria
    String paramCreateDateStartCount = p_request.getParameter(JobSearchConstants.CREATION_START);
    //        String paramCreateDateStartOpts = p_request
    //                .getParameter(JobSearchConstants.CREATION_START_OPTIONS);
    String paramCreateDateEndCount = p_request.getParameter(JobSearchConstants.CREATION_END);
    //        String paramCreateDateEndOpts = p_request
    //                .getParameter(JobSearchConstants.CREATION_END_OPTIONS);
    Cell cell_B_Header = getCell(secRow, 1);
    cell_B_Header.setCellValue(bundle.getString("lb_from") + ":");
    cell_B_Header.setCellStyle(getContentStyle(p_workbook));
    //        String fromMsg = paramCreateDateStartCount
    //                + " "
    //                + getDateCritieraConditionValue(
    //                        paramCreateDateStartOpts);
    //        String untilMsg = paramCreateDateEndCount
    //                + " "
    //                + getDateCritieraConditionValue(
    //                        paramCreateDateEndOpts);
    Cell cell_B = getCell(thirRow, 1);
    cell_B.setCellValue(paramCreateDateStartCount);
    cell_B.setCellStyle(getContentStyle(p_workbook));

    Cell cell_C_Header = getCell(secRow, 2);
    cell_C_Header.setCellValue(bundle.getString("lb_until") + ":");
    cell_C_Header.setCellStyle(getContentStyle(p_workbook));

    Cell cell_C = getCell(thirRow, 2);
    cell_C.setCellValue(paramCreateDateEndCount);
    cell_C.setCellStyle(getContentStyle(p_workbook));

    // add the target lang criteria
    Cell cell_D_Header = getCell(secRow, 3);
    if (p_data.wantsAllTargetLangs) {
        cell_D_Header.setCellValue(bundle.getString("lb_selected_langs") + " " + bundle.getString("all"));
        cell_D_Header.setCellStyle(getContentStyle(p_workbook));
    } else {
        cell_D_Header.setCellValue(bundle.getString("lb_selected_langs"));
        cell_D_Header.setCellStyle(getContentStyle(p_workbook));
        Iterator<String> iter = p_data.targetLangList.iterator();
        int r = 2;
        LocaleManagerLocal manager = new LocaleManagerLocal();
        while (iter.hasNext()) {
            String lang = iter.next();
            Row theRow = getRow(paramsSheet, r);
            Cell cell_D = getCell(theRow, 3);
            cell_D.setCellValue(manager.getLocaleById(Long.valueOf(lang)).toString());
            cell_D.setCellStyle(getContentStyle(p_workbook));
            r++;
        }
        paramsSheet.setColumnWidth(3, 15 * 256);
    }
}