=== modified file 'local/vn/dhis-web-spreadsheet-reporting/src/main/java/org/hisp/dhis/reportsheet/exporting/action/GenerateReportOrgGroupListingAction.java' --- local/vn/dhis-web-spreadsheet-reporting/src/main/java/org/hisp/dhis/reportsheet/exporting/action/GenerateReportOrgGroupListingAction.java 2011-07-28 09:50:39 +0000 +++ local/vn/dhis-web-spreadsheet-reporting/src/main/java/org/hisp/dhis/reportsheet/exporting/action/GenerateReportOrgGroupListingAction.java 2011-10-25 07:52:27 +0000 @@ -152,8 +152,8 @@ if ( reportItem.getItemType().equalsIgnoreCase( ExportItem.TYPE.ORGANISATION ) && (!organisationUnits.isEmpty()) ) { - ExcelUtils.writeValueByPOI( rowBegin, reportItem.getColumn(), String.valueOf( organisationUnitGroup - .getName() ), ExcelUtils.TEXT, sheet, this.csText12BoldCenter ); + ExcelUtils.writeValueByPOI( rowBegin, reportItem.getColumn(), organisationUnitGroup.getName(), + ExcelUtils.TEXT, sheet, this.csText12BoldCenter ); } else if ( reportItem.getItemType().equalsIgnoreCase( ExportItem.TYPE.SERIAL ) && (!organisationUnits.isEmpty()) ) @@ -210,8 +210,8 @@ } } - if ( (reportItem.getItemType().equalsIgnoreCase( ExportItem.TYPE.DATAELEMENT ) || reportItem - .getItemType().equalsIgnoreCase( ExportItem.TYPE.INDICATOR )) + if ( (reportItem.getItemType().equalsIgnoreCase( ExportItem.TYPE.DATAELEMENT ) || reportItem.getItemType() + .equalsIgnoreCase( ExportItem.TYPE.INDICATOR )) && !totalFormula.equals( PREFIX_FORMULA_SUM ) ) { totalFormula = totalFormula.substring( 0, totalFormula.length() - 1 ) + ")"; === modified file 'local/vn/dhis-web-spreadsheet-reporting/src/main/java/org/hisp/dhis/reportsheet/importing/action/ViewDataOrganizationGroupAction.java' --- local/vn/dhis-web-spreadsheet-reporting/src/main/java/org/hisp/dhis/reportsheet/importing/action/ViewDataOrganizationGroupAction.java 2011-10-24 05:42:25 +0000 +++ local/vn/dhis-web-spreadsheet-reporting/src/main/java/org/hisp/dhis/reportsheet/importing/action/ViewDataOrganizationGroupAction.java 2011-10-25 07:52:27 +0000 @@ -94,6 +94,8 @@ private void setUpImportItems( ImportReport importReport, OrganisationUnit selectedUnit, List importItemsSource, List importItemsDest ) { + int row = 0; + for ( OrganisationUnitGroup organisationUnitGroup : importReport.getOrganisationUnitGroups() ) { List organisationUnits = new ArrayList( getOrganisationUnits( @@ -101,14 +103,14 @@ Collections.sort( organisationUnits, new OrganisationUnitNameComparator() ); - int row = 0; - + row += 2; + for ( OrganisationUnit o : organisationUnits ) { for ( ImportItem importItem : importItemsSource ) { ImportItem item = new ImportItem(); - + item.setSheetNo( importItem.getSheetNo() ); item.setRow( importItem.getRow() + row ); item.setColumn( importItem.getColumn() ); @@ -117,7 +119,7 @@ importItemsDest.add( item ); } - row++; + row ++; } } }