DisplayTag
  1. DisplayTag
  2. DISPL-648

Totals,subtotals not being exported to excel

    Details

    • Type: Bug Bug
    • Status: Open Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Decorators
    • Labels:
      None
    • Application server:
      Websphere v6.1

      Description

      When the list is being exported to excel,the totals,subtotals are not exported
      The following are the excel o/p:

      Employment Category SSNO Employee Name Account No Account Date Last Earn Date NC Fiscal Year Hours Fiscal year Earnings
      0 12345678 HUBBARD 0 12/31/93 00/00/00 0 10.00 $ 123

      <tr class="total"><td class="customer">Employment Category Total</td><td class="customer"></td><td class="customer"></td><td class="quantity"></td><td class="customer"></td><td class="customer"></td><td class="customer"></td><td class="lineItemTotal">10.00 $</td><td class="lineItemTotal">123</td></tr>"10" 12345678 BAMFORTH 1 12/31/92 00/00/00 0 176.00 $ 6780
      10 12345678 CADBURY 4 12/31/93 00/00/00 0 1232.00 $ 41694
      10 12345678 FRIES 5 12/31/93 00/00/00 0 1232.00 $ 29228
      10 12345678 GOLDSTEIN 3 12/31/93 00/00/00 0 1162.00 $ 67125

      <tr class="total"><td class="customer">Employment Category Total</td><td class="customer"></td><td class="customer"></td><td class="quantity"></td><td class="customer"></td><td class="customer"></td><td class="customer"></td><td class="lineItemTotal">3802.00 $</td><td class="lineItemTotal">144827</td></tr>"11" 12345678 GOLDSTEIN 3 12/31/93 00/00/00 0 1162.00 $ 67125
      11 12345678 GOLDSTEIN 2 12/31/93 00/00/00 0 1162.00 $ 67125
      11 12345678 GOLDSTEIN 4 12/31/93 00/00/00 0 1162.00 $ 67125
      11 12345678 GOLDSTEIN 5 12/31/93 00/00/00 0 1162.00 $ 67125
      11 12345678 GOLDSTEIN 7 12/31/93 00/00/00 0 1162.00 $ 67125

        Activity

        Hide
        Jeff Marek added a comment -
        The attached patch file refactors the way subtotaling works so that it can be applied to exports. The subtotal rows are now created as displaytag rows before the table is written. The full table is then processed by the writer or exporter. The export.decorated property must be set in order to see subtotals in an export.
        Show
        Jeff Marek added a comment - The attached patch file refactors the way subtotaling works so that it can be applied to exports. The subtotal rows are now created as displaytag rows before the table is written. The full table is then processed by the writer or exporter. The export.decorated property must be set in order to see subtotals in an export.

          People

          • Reporter:
            Sherin Louis
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: