Results 1 to 8 of 8

Thread: Pivot Grid Exporter doesn't align headers correctly in .xlsx export

    Success! Looks like we've fixed this one. According to our records the fix was applied for EXTJS-23542 in 6.2.2.
  1. #1
    Sencha Premium User
    Join Date
    Jan 2017
    Posts
    13

    Default Pivot Grid Exporter doesn't align headers correctly in .xlsx export

    The pivot grid exporter plugin is not exporting the headers in the correct placement when exporting to .xlsx

    * INSTRUCTIONS TO REPRODUCE BUG *
    Drag/Drop "SELL" & "COST" into Values (aggregate)
    Drag/Drop "Name" into Row (leftAxis)
    Drag/Drop "Project" into Column (topAxis)
    Click the Export Button -> Open with Microsoft Excel
    -> Notice the Cost/Sell headers do not line up appropriately
    to their respective values on the 3rd row.They are shifted one column to the left.

    Instructions also commented in the Fiddle.

    Fiddle to test it here...

    Also a screenshot
    pgexportss.png

  2. #2

    Default

    Thanks for the report! I have opened a bug in our bug tracker.

  3. #3
    Sencha Premium User
    Join Date
    Sep 2012
    Posts
    28

    Default

    Looks to be the case on a regular grid export with grouped headers as well: https://fiddle.sencha.com/#view/editor&fiddle/1r4k

    Any updates on this?

  4. #4
    Sencha User
    Join Date
    Feb 2016
    Posts
    16

    Default

    I've encountered the same issue, any solutions so far?

  5. #5
    Sencha Premium User
    Join Date
    Sep 2012
    Posts
    28

    Default

    Support told me this is patched in the nightlies...however, the nightlies break other things for me..hopefully we can get a GA point release soon to resolve.

  6. #6
    Sencha Premium User
    Join Date
    Jan 2017
    Posts
    15

    Default

    Two additional problems with this component:
    - The export date format is different than the grid date format
    - The "Time" components is 1 second off from the exported value

    This is what I used:
    Code:
    xtype: 'datecolumn',
    exportStyle: [{format:  'm/d/YYYY h:mm:ss'}],
    text: 'Processed Time',
    dataIndex: 'processedTime',
    format: 'm/d/Y H:i:s'

  7. #7
    Sencha Premium User
    Join Date
    Dec 2009
    Location
    Iasi, Romania
    Posts
    159

    Default

    Quote Originally Posted by cbratz View Post
    The pivot grid exporter plugin is not exporting the headers in the correct placement when exporting to .xlsx

    * INSTRUCTIONS TO REPRODUCE BUG *
    Drag/Drop "SELL" & "COST" into Values (aggregate)
    Drag/Drop "Name" into Row (leftAxis)
    Drag/Drop "Project" into Column (topAxis)
    Click the Export Button -> Open with Microsoft Excel
    -> Notice the Cost/Sell headers do not line up appropriately
    to their respective values on the 3rd row.They are shifted one column to the left.

    Instructions also commented in the Fiddle.

    Fiddle to test it here...

    Also a screenshot
    pgexportss.png
    I have included a fix in your fiddle.

  8. #8
    Sencha Premium User
    Join Date
    Dec 2009
    Location
    Iasi, Romania
    Posts
    159

    Default

    Quote Originally Posted by keeper3000 View Post
    Two additional problems with this component:
    - The export date format is different than the grid date format
    - The "Time" components is 1 second off from the exported value

    This is what I used:
    Code:
    xtype: 'datecolumn',
    exportStyle: [{format:  'm/d/YYYY h:mm:ss'}],
    text: 'Processed Time',
    dataIndex: 'processedTime',
    format: 'm/d/Y H:i:s'
    Do you have a fiddle for this?

Similar Threads

  1. Replies: 5
    Last Post: 21 Dec 2016, 3:39 PM
  2. Replies: 5
    Last Post: 29 Sep 2016, 8:02 AM
  3. Pivot Grid and Exporter
    By vvanarasi in forum Ext JS 6.x Q&A
    Replies: 2
    Last Post: 26 Sep 2016, 7:06 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •