1. #201
    Sencha - Community Support Team Condor's Avatar
    Join Date
    Mar 2007
    Location
    The Netherlands
    Posts
    24,246
    Vote Rating
    97
    Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of

      0  

    Default


    Quote Originally Posted by mystix View Post
    translation: @hzwei would like to use the "Grid With Locking Column" ux with the GroupHeaderGrid plugin, but is unsure of how to proceed.
    The GroupHeaderGrid plugin doesn't work with locking columns. That is why I wrote a LockedGroupHeaderGrid plugin (it's based on an older version of the GroupHeaderGrid plugin, so it doesn't have all the features).

  2. #202
    Ext User
    Join Date
    Mar 2009
    Posts
    14
    Vote Rating
    0
    hzwei is on a distinguished road

      0  

    Default Thanks very much!Another Question?

    Thanks very much!Another Question?


    感谢您的答复!问题已经解决!
    因为我的英文水平不好,所以只能用中文,谢谢!
    还有两个问题:
    第一:EXT gridpanel导出excel有没有什么好的方法?我用过两种,一个类似这个:
    Code:
    var vExportContent = grid.getExcelXml();
        if (Ext.isIE6 || Ext.isIE7 || Ext.isSafari || Ext.isSafari2
          || Ext.isSafari3) {
         var fd = Ext.get('frmDummy');
         if (!fd) {
          fd = Ext.DomHelper.append(Ext.getBody(), {
           tag : 'form',
           method : 'post',
           id : 'frmDummy',
           action : 'exportexcel.jsp',
           target : '_blank',
           name : 'frmDummy',
           cls : 'x-hidden',
           cn : [{
            tag : 'input',
            name : 'exportContent',
            id : 'exportContent',
            type : 'hidden'
           }]
          }, true);
         }
         fd.child('#exportContent').set({
          value : vExportContent
         });
         fd.dom.submit();
        } else {
         document.location = 'data:application/vnd.ms-excel;base64,'
           + Base64.encode(vExportContent);
        },
    这钟方法可以导出,但同样的问题,不能导出多层表头的gridpanel数据,也就是当gridpanel有多层表头时候,用这种方法只能导出最底层表头的;
    还有种方法像这样:
    Code:
    window.clipboardData.setData("Text", tableHTML);
      try {
       var ExApp = new ActiveXObject("Excel.Application");
       var ExWBk = ExApp.workbooks.add();
       var ExWSh = ExWBk.worksheets(1);
       ExApp.DisplayAlerts = false;
       ExApp.visible = true;
      } catch (e) {
       if (e.number != -2146827859)
        alert("您的电脑没有安装Microsoft Excel软件!");
       return false;
      }
      ExWBk.worksheets(1).Paste;
    能导出多表头的,但不稳定,有的系统可以导出,有的系统导了后没反应;请问有没有什么好的解决方法可以很好的导出多层表头的?
    第二个问题:能不能给一个ext gridpanel直接打印的示例,支持多层表头的?即可以直接打印多层表头的gridpanel数据?
    Last edited by mystix; 18 Mar 2009 at 6:12 PM. Reason: POST CODE IN [CODE][/CODE] TAGS. see http://extjs.com/forum/misc.php?do=bbcode#code

  3. #203
    Sencha - Community Support Team mystix's Avatar
    Join Date
    Mar 2007
    Location
    Singapore
    Posts
    6,236
    Vote Rating
    5
    mystix will become famous soon enough

      0  

    Default


    Quote Originally Posted by hzwei View Post
    感谢您的答复!问题已经解决!
    因为我的英文水平不好,所以只能用中文,谢谢!
    还有两个问题:
    第一:EXT gridpanel导出excel有没有什么好的方法?我用过两种,一个类似这个:
    Code:
    // ... SNIP ...
    这钟方法可以导出,但同样的问题,不能导出多层表头的gridpanel数据,也就是当gridpanel有多层表头时候,用这种方法只能导出最底层表头的;
    还有种方法像这样:
    Code:
    // ... SNIP ...
    能导出多表头的,但不稳定,有的系统可以导出,有的系统导了后没反应;请问有没有什么好的解决方法可以很好的导出多层表头的?
    translation:
    thanks for taking the time to answer. i've managed to solve the problem.
    pardon me for typing only in chinese, as i'm not too good at english.

    i've got 2 more questions i hope you could help me with:
    Question 1) is there any recommended way to export a gridpanel to Excel? i've used 2 methods previously, the first being [ see 1st block of code ] which exports the gridpanel successfully, but doesn't export grouped headers (it only exports the group header at the lowest level). the other method i've tried is [ see 2nd block of code ] which manages to export the grouped headers, but doesn't work reliably across systems (browser??) -- on some the export is successful, on some nothing gets output. is there a reliable cross-system (browser??) way to export grids with multiple headers to excel?

    Quote Originally Posted by hzwei View Post
    第二个问题:能不能给一个ext gridpanel直接打印的示例,支持多层表头的?即可以直接打印多层表头的gridpanel数据
    Question 2) Could you post an example of a gridpanel which can be printed (i.e. one with grouped headers?)

  4. #204
    Sencha - Community Support Team mystix's Avatar
    Join Date
    Mar 2007
    Location
    Singapore
    Posts
    6,236
    Vote Rating
    5
    mystix will become famous soon enough

      0  

    Default


    @hzwei,
    please run your posts through google translate in future: http://translate.google.com/translate_t#
    i can't be translating everyone's posts.

  5. #205
    Ext User
    Join Date
    Mar 2009
    Posts
    14
    Vote Rating
    0
    hzwei is on a distinguished road

      0  

    Default I am so sorry!But I hope you can give me the answers

    I am so sorry!But I hope you can give me the answers


    [ see post #203 -- i've already translated it for you ]

  6. #206
    Ext User
    Join Date
    Mar 2009
    Posts
    2
    Vote Rating
    0
    yingwuhahaha is on a distinguished road

      0  

    Default I found 2 bugs

    I found 2 bugs


    hi,I use lockingGridPanel with Ext2.0.2,and I found 2 bugs.

    No.1ee the first image.
    when I resize the column to smaller (first scroll it to right),the header is not synch with the body.
    I have to use grid.on('columnresize',function(){grid.getView().syncScroll();}) to fix it.
    it's ok on Ext2.2.

    No2: see the second and the third image.
    I open the example in IE7 with Ext2.0.2,but there is nothing show in the grid body util I click the header sort it.
    I have to call grid.getView().refresh() after the grid rendered.
    it's ok on Ext2.2.

    Is any one else has the same problem?
    Attached Images

  7. #207
    Sencha - Community Support Team Condor's Avatar
    Join Date
    Mar 2007
    Location
    The Netherlands
    Posts
    24,246
    Vote Rating
    97
    Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of

      0  

    Default


    Quote Originally Posted by yingwuhahaha View Post
    hi,I use lockingGridPanel with Ext2.0.2,and I found 2 bugs.
    There was a major change in the GridPanel/GridView code between Ext 2.1 and 2.2. That is why I needed to create version 5 of the LockingGridPanel.
    As mentioned in the first post version 5 ONLY works for Ext 2.2 and not for previous versions and version 4 only works for Ext 2.1 and below.
    Unfortunately for you version 4 doesn't contain the extra bugfixes I also added to version 5 (so if you want those you have a little code comparing to do).

    ps. For Ext 2.3 (or 2.2.2) and Ext 3.0 I will need to create a version 6, because the GridView code has changed significantly again.

  8. #208
    Sencha - Community Support Team Condor's Avatar
    Join Date
    Mar 2007
    Location
    The Netherlands
    Posts
    24,246
    Vote Rating
    97
    Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of

      0  

    Default


    Quote Originally Posted by hzwei View Post
    ---chinese text---
    getExcelXml() doesn't know about grouped headers, so you'll have to modify the code yourself so it includes them.

  9. #209
    Ext User
    Join Date
    Mar 2009
    Posts
    14
    Vote Rating
    0
    hzwei is on a distinguished road

      0  

    Default I don not know how to modify it!

    I don not know how to modify it!


    I don not know how to modify the source code of getGridExcel(),so can you help me?

  10. #210
    Ext User
    Join Date
    Mar 2009
    Posts
    14
    Vote Rating
    0
    hzwei is on a distinguished road

      0  

    Default Question

    Question


    Can you give an example of upload video with ext?
    and can you give me an example of directly print of ext gridpanel?

Thread Participants: 139

  1. galdaka (2 Posts)
  2. Condor (47 Posts)
  3. mapo (1 Post)
  4. seno (1 Post)
  5. rmesser (2 Posts)
  6. mystix (5 Posts)
  7. fangzhouxing (1 Post)
  8. rarerules (6 Posts)
  9. Kalum78 (2 Posts)
  10. Fabyo (2 Posts)
  11. akannu (4 Posts)
  12. badgerd (1 Post)
  13. hanganum (1 Post)
  14. jlhs5 (3 Posts)
  15. zaunaf (1 Post)
  16. mjlecomte (1 Post)
  17. border9 (3 Posts)
  18. matt.hall (1 Post)
  19. justinfalk (1 Post)
  20. Air_Mike (1 Post)
  21. mbalusu (1 Post)
  22. wm003 (2 Posts)
  23. Plater (1 Post)
  24. ssmso (3 Posts)
  25. jitu (1 Post)
  26. durlabh (2 Posts)
  27. crpatrick (2 Posts)
  28. timezz (2 Posts)
  29. jfkelley (2 Posts)
  30. mankz (6 Posts)
  31. xbohdpukc (1 Post)
  32. orangehairedboy (1 Post)
  33. mbahl (2 Posts)
  34. cblin (3 Posts)
  35. vertigoMX (1 Post)
  36. bernd01 (1 Post)
  37. sanjshah (1 Post)
  38. tahlon (1 Post)
  39. nanich (3 Posts)
  40. tonedeaf (1 Post)
  41. gaspard (1 Post)
  42. ghutchens (3 Posts)
  43. wsn24x7 (1 Post)
  44. srikan999 (1 Post)
  45. lesul (2 Posts)
  46. NotChris (3 Posts)
  47. NeonMonk (3 Posts)
  48. surgi (3 Posts)
  49. lickui (2 Posts)
  50. sureshraja.crt (1 Post)
  51. herrjj (1 Post)
  52. minty (2 Posts)
  53. huixjan (2 Posts)
  54. archrajan (1 Post)
  55. milou (1 Post)
  56. bishoco (1 Post)
  57. deltron0 (1 Post)
  58. ravindra.tiwary1 (2 Posts)
  59. slava_k (1 Post)
  60. cjqcjq2008 (1 Post)
  61. srikanthnukala (1 Post)
  62. Kevin.Tan (3 Posts)
  63. xavierg (1 Post)
  64. ygl (1 Post)
  65. varsha.kothari (3 Posts)
  66. tinnt (6 Posts)
  67. sdileep (1 Post)
  68. rule3 (3 Posts)
  69. RobinOuyang (1 Post)
  70. lokiofragnar (1 Post)
  71. imran (1 Post)
  72. sachin_248 (1 Post)
  73. mogen9999 (2 Posts)
  74. faraway (1 Post)
  75. sircyaj (1 Post)
  76. tmaung (1 Post)
  77. wwwtd (1 Post)
  78. jamiro (1 Post)
  79. Frankatron (3 Posts)
  80. peacock (1 Post)
  81. NicoP (2 Posts)
  82. Raz_ (3 Posts)
  83. jchau (6 Posts)
  84. sanjaykanteti (1 Post)
  85. JSRobbie (1 Post)
  86. alvin (1 Post)
  87. Shmitt (1 Post)
  88. Nagiy (4 Posts)
  89. cooluser7 (1 Post)
  90. Angelina (1 Post)
  91. greeeg (2 Posts)
  92. hoanganhinfo (1 Post)
  93. duverma (1 Post)
  94. hawks2001 (1 Post)
  95. LoekieBoy (3 Posts)
  96. Bogdan Juszczak (1 Post)
  97. eversound (1 Post)
  98. priyanka_iknip (1 Post)
  99. xiespirit (1 Post)
  100. mmboy (1 Post)
  101. SMIRZA (1 Post)
  102. fmanrique (2 Posts)
  103. redzedi (1 Post)
  104. sham123456 (1 Post)
  105. digiprosoft (2 Posts)
  106. krmlmnstr (1 Post)
  107. abotero (1 Post)
  108. tomlobato (2 Posts)
  109. sramanna (2 Posts)
  110. kastanis (5 Posts)
  111. pingTeam (1 Post)
  112. cmschick (2 Posts)
  113. liulei (3 Posts)
  114. Xander75 (2 Posts)
  115. hhanna (2 Posts)
  116. hahacow (1 Post)
  117. janapol (1 Post)
  118. roderick.wu (5 Posts)
  119. saadus (1 Post)
  120. yingwuhahaha (2 Posts)
  121. liuzxtest (2 Posts)
  122. hzwei (5 Posts)
  123. azaqero (3 Posts)
  124. PCalvinClark (1 Post)
  125. arifali (1 Post)
  126. navdimri (2 Posts)
  127. dewoob (2 Posts)
  128. avia4us (1 Post)
  129. DirkWei (1 Post)
  130. setzor (1 Post)
  131. ancorgs (2 Posts)
  132. Sergii (1 Post)
  133. Kranthi1981 (1 Post)
  134. Patrick86 (1 Post)
  135. kamal.addicted (1 Post)
  136. chpsrinu (1 Post)
  137. brian.moeskau (2 Posts)
  138. priyapratheep (1 Post)
  139. cooper2014 (1 Post)