Results 1 to 4 of 4

Thread: Hidden column with hideMode: offsets no longer exports

    You found a bug! We've classified it as EXTJS-25802 . We encourage you to continue the discussion and to find an acceptable workaround while we work on a permanent fix.
  1. #1
    Sencha Premium User
    Join Date
    May 2016
    Posts
    20

    Default Hidden column with hideMode: offsets no longer exports

    In my grid I have some boolean columns that display information as icons. But I have ignoreExport: true on those icons so that they don't get exported. At the same time, I have a grid column with information from the icon columns in text format that is hidden by default on the grid. But it gets exported to Excel. I was able to do this before by setting the gridcolumn hidden: true and hideMode: offsets. After Ext. 6.5 update, this no longer works. My grid column is no longer getting exported with this config. The grid column gets exported only if the hidden: false and does not take the hideMode: offsets into consideration.


    Code:
    {
                xtype: 'gridcolumn', // I want this column to not show on grid but gets exported to Excel
                hidden: true,
                hideMode: 'offsets',
                width: 250,
                enableColumnHide: false,
                align: 'left',
                dataIndex: 'servicesConvert',
                text: 'Services'
            },
            {
                xtype: 'booleancolumn', // Icon column that is visible on grid but does not get exported
                maxWidth: 55,
                minWidth: 55,
                enableColumnHide: false,
                dataIndex: 'electric',
                hideable: false,
                ignoreExport: true,
                falseText: '<span class="x-fa fa-bolt" style="color:#bdc3c7"></span>',
                trueText: '<span class="x-fa fa-bolt" style="color:#2ecc71"></span>',
                bind: {
                    text: '{serviceTypeConfig.electric.iconText}'
                }
            }
    grid.jpgexcel.PNG

  2. #2
    Sencha Premium User evant's Avatar
    Join Date
    Apr 2007
    Location
    Sydney, Australia
    Posts
    19,241

    Default

    Sounds like a bug in the old version, sounds as though it wasn't correctly interrogating the hidden state.

    I'll open a feature request to allow for greater control of exporting.
    Twitter - @evantrimboli
    Former Sencha framework engineer, available for consulting.
    As of 2017-09-22 I am not employed by Sencha, all subsequent posts are my own and do not represent Sencha in any way.

  3. #3
    Sencha Premium User
    Join Date
    May 2016
    Posts
    20

    Default

    That'll be really helpful. We have many grids that have hidden columns that need to be included in the export. Thanks

  4. #4
    Sencha User
    Join Date
    Jun 2017
    Location
    Pune, Maharashtra, India
    Posts
    1

    Default

    Is it resolved ?

Similar Threads

  1. hideMode: 'offsets' not working
    By ben.gillis in forum Ext: Q&A
    Replies: 0
    Last Post: 9 Apr 2012, 7:15 AM
  2. hideMode: 'offsets' causing problems in IE
    By forumuser1080 in forum Ext 3.x: Help & Discussion
    Replies: 1
    Last Post: 5 Jul 2011, 12:34 PM
  3. TabPanel with hideMode:'offsets'
    By srajakaruna in forum Ext 2.x: Help & Discussion
    Replies: 1
    Last Post: 21 May 2009, 3:32 AM
  4. hideMode 'offsets' HtmlEditor
    By Tobsen in forum Ext 2.x: Help & Discussion
    Replies: 0
    Last Post: 9 Apr 2008, 1:08 AM

Tags for this Thread

Posting Permissions

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