1. #41
    Sencha Premium Member
    Join Date
    Jan 2008
    Location
    Los Angeles
    Posts
    149
    Vote Rating
    1
    radtad is on a distinguished road

      0  

    Default


    Quote Originally Posted by DamienValentine View Post
    This problem is definitely in your ExportToExcel.js
    Try to replace your file with mine - my file works good for me except in certain grids which I do not code completely.
    Well I tried your js file with the example array grid. While I receive no errors now in gnumeric on the Linux side, it shows up with XML tags in the columns (see below).

    When I open this up in Excel 2000, it shows no data at all. If I open it up in notepad, I see all the tags which is good and the data, so I know the data is there. I attached a copy of this below.
    Attached Images
    Attached Files

  2. #42
    Ext User
    Join Date
    May 2007
    Location
    Budapest, Hungary
    Posts
    9
    Vote Rating
    0
    cocinerox is on a distinguished road

      0  

    Default


    Hi, I think you need Excel 2007 to read XML:
    http://en.wikipedia.org/wiki/Microso...l#File_formats

  3. #43
    Sencha Premium Member
    Join Date
    Jan 2008
    Location
    Los Angeles
    Posts
    149
    Vote Rating
    1
    radtad is on a distinguished road

      0  

    Default


    Quote Originally Posted by cocinerox View Post
    Hi, I think you need Excel 2007 to read XML:
    http://en.wikipedia.org/wiki/Microso...l#File_formats
    Well that would explain it. I should have Wiki'd the format for Excel. Thanks for the response which looks to be the reason.

  4. #44
    Ext User
    Join Date
    Apr 2008
    Posts
    18
    Vote Rating
    0
    DamienValentine is on a distinguished road

      0  

    Default


    It's OK. I saw your notepad.txt. It's looking good. I attached screenshot to this letter. It's your report but with my remark in first row - you should remove appropriate line in ExportToExcel.js. Please use search with "SEBN UA" parameter.
    Attached Images

  5. #45
    Ext JS Premium Member
    Join Date
    Mar 2007
    Posts
    216
    Vote Rating
    0
    Jul is on a distinguished road

      0  

    Default


    If you have Office 2000, Office XP or Office 2003, you can install the Compatibility Pack which will enable you to read and write the new Office 2007 XML based formats.

    Download link is here: Compatibility Pack

  6. #46
    Ext User
    Join Date
    Apr 2008
    Posts
    18
    Vote Rating
    0
    DamienValentine is on a distinguished road

      0  

    Default


    Quote Originally Posted by Jul View Post
    If you have Office 2000, Office XP or Office 2003, you can install the Compatibility Pack which will enable you to read and write the new Office 2007 XML based formats.

    Download link is here: Compatibility Pack
    File exported with Animal concept will open in Office 2003, I guess. It's working for me without Compatibility Packs. Or someone installed that software and I don't know about that

  7. #47
    Ext User
    Join Date
    Jun 2007
    Posts
    17
    Vote Rating
    0
    andreyz is on a distinguished road

      0  

    Default Bag

    Bag


    When unloading datetime fields detected a problem. No time to file excel. To address this problem need to change a few lines:
    Code:
                    '<ss:Style ss:Parent="odd" ss:ID="odddate">' +
                        '<ss:NumberFormat ss:Format="dd/mm/yy\ h:mm;@" />' +
                    '</ss:Style>' +
    
                   '<ss:Style ss:Parent="even" ss:ID="evenint">' +
                        '<ss:NumberFormat ss:Format="0" />' +
                    '</ss:Style>' +
    
     if (cellType[k] == 'DateTime') {
    	                            t += v.format('Y-m-d\\TH:i: s.000'); // no space betwen  i: s
    	                        } else {
    	                            t += v;
    	                        }
    Last edited by mystix; 13 May 2008 at 7:16 PM. Reason: use [code][/code] tags!

  8. #48
    Ext User krzak's Avatar
    Join Date
    May 2008
    Location
    Poland
    Posts
    62
    Vote Rating
    0
    krzak is on a distinguished road

      0  

    Default


    Quote Originally Posted by ghyster View Post
    One more thing : why don't you use a basic toolbar button for exporting, which will automatically refresh the data url like this :

    Code:
    bbar: new Ext.Toolbar({
                buttons: [{
                    id: 'grid-excel-button',
                    text: 'Excel',
                handler: function(){
                    document.location='data:application/vnd.ms-excel;base64,' +Base64.encode(grid.getExcelXml());
                }
                }]
        })
    I don't know why but seems this hung my IE7. The same code works fine with FF2.

  9. #49
    Ext User
    Join Date
    Feb 2008
    Posts
    6
    Vote Rating
    1
    calvouze is on a distinguished road

      0  

    Default


    Same here, hung up on IE7, perfect in FF.

    Anyone knows why ?

    Thanks in advance.


    Edit: not possible :

    Quote Originally Posted by Animal View Post
    This needs a browser that supports data URLs. FF, Opera and IE8 will support this.

    Tested on FF2 and Opera 9.

  10. #50
    Sencha User
    Join Date
    Dec 2007
    Location
    Aubagne, France
    Posts
    347
    Vote Rating
    1
    mask_hot is on a distinguished road

      0  

    Default


    Hi Animal,

    in my grid's ColumnModel I have a CheckBoxSelectionModel with no DataIndex.

    How do I ignore this column in the export?

    thx

Thread Participants: 140

  1. alexb (1 Post)
  2. galdaka (3 Posts)
  3. ghyster (1 Post)
  4. Condor (1 Post)
  5. TopKatz (1 Post)
  6. Jul (1 Post)
  7. mystix (3 Posts)
  8. Foggy (2 Posts)
  9. bloon (1 Post)
  10. fshort (1 Post)
  11. antimatter15 (1 Post)
  12. cocinerox (1 Post)
  13. tobiu (1 Post)
  14. ajaxE (2 Posts)
  15. andreyz (1 Post)
  16. devnull (4 Posts)
  17. mjlecomte (4 Posts)
  18. kevinwu8 (1 Post)
  19. rakesh (1 Post)
  20. hendricd (2 Posts)
  21. gelleneu (1 Post)
  22. isaac (1 Post)
  23. huling (1 Post)
  24. ckr (1 Post)
  25. roopa (1 Post)
  26. loveyeah (1 Post)
  27. zhfxu_cs (1 Post)
  28. Mthor (1 Post)
  29. johnlicy (1 Post)
  30. thoreking (2 Posts)
  31. csqjean (1 Post)
  32. mankz (1 Post)
  33. vietschv (1 Post)
  34. verbi (1 Post)
  35. sanjshah (2 Posts)
  36. mask_hot (1 Post)
  37. calavera (1 Post)
  38. vsmike (1 Post)
  39. vizcano (1 Post)
  40. lakehouse (1 Post)
  41. alaska (2 Posts)
  42. radtad (3 Posts)
  43. jmcneese (1 Post)
  44. Rafael (4 Posts)
  45. calvouze (1 Post)
  46. Joyfulbob (1 Post)
  47. angeldimitrov (2 Posts)
  48. Jack_S (2 Posts)
  49. g13013 (2 Posts)
  50. DamienValentine (5 Posts)
  51. Marcelo Delgado (1 Post)
  52. NoahK17 (8 Posts)
  53. anujg (1 Post)
  54. aproust94 (3 Posts)
  55. pokerking400 (1 Post)
  56. Ronhead (1 Post)
  57. krzak (3 Posts)
  58. cvieira (1 Post)
  59. Efex (5 Posts)
  60. gthe (2 Posts)
  61. miihiir (2 Posts)
  62. pops (1 Post)
  63. emredagli (12 Posts)
  64. larsa (2 Posts)
  65. maggiesnyder (3 Posts)
  66. sam.zhang (1 Post)
  67. kristalgic (1 Post)
  68. wiznia (3 Posts)
  69. frpucci (1 Post)
  70. tinakonda (1 Post)
  71. tBSTAR (1 Post)
  72. tdg2008 (1 Post)
  73. iwagon (1 Post)
  74. psarunkumar (1 Post)
  75. kimmking (1 Post)
  76. sKuD24 (1 Post)
  77. MartinL (2 Posts)
  78. BitPoet (2 Posts)
  79. snoir (3 Posts)
  80. naranda (1 Post)
  81. zhw511006 (1 Post)
  82. bobjbain (1 Post)
  83. korto (1 Post)
  84. wp.joju (1 Post)
  85. hastiok (6 Posts)
  86. dtondo (4 Posts)
  87. Dumas (1 Post)
  88. vvreddy@12 (4 Posts)
  89. TheBim (1 Post)
  90. whodat (2 Posts)
  91. Skunkerbr (2 Posts)
  92. stevenhzj (4 Posts)
  93. Naokai (1 Post)
  94. wayned@escc (2 Posts)
  95. MuadDib-DK (1 Post)
  96. jsundquist (1 Post)
  97. hardc0re (2 Posts)
  98. hzwei (4 Posts)
  99. Galileo_Galilei (1 Post)
  100. SantaBarbarian (4 Posts)
  101. stevieke (1 Post)
  102. megmefleg (1 Post)
  103. Boccara Jonathan (1 Post)
  104. Surinder singh (2 Posts)
  105. KrullWarKing (1 Post)
  106. brandnewdrew (1 Post)
  107. MrRoyce (1 Post)
  108. Spongerusher (1 Post)
  109. teraphy (2 Posts)
  110. Pekka Karalahti (3 Posts)
  111. Sergii (1 Post)
  112. Cassio11 (1 Post)
  113. myth (1 Post)
  114. spor (6 Posts)
  115. StagnantIce (2 Posts)
  116. shailendra (2 Posts)
  117. ext_user1 (1 Post)
  118. kenny_mk (1 Post)
  119. mpacheco (1 Post)
  120. Centurus (1 Post)
  121. andyfly (1 Post)
  122. darmandovargas@gmail.com (1 Post)
  123. zjuthhy (3 Posts)
  124. robshim (3 Posts)
  125. Tod (1 Post)
  126. bipen (2 Posts)
  127. alisyah (1 Post)
  128. Monz87 (1 Post)
  129. alssst (1 Post)
  130. aggie (1 Post)
  131. bradelsky (1 Post)
  132. lagrezd (1 Post)
  133. ma1986 (1 Post)
  134. Sabareesh (2 Posts)
  135. top_1 (1 Post)
  136. Vasanthoo7 (1 Post)
  137. garrek99 (2 Posts)
  138. opik (1 Post)
  139. shankar8rajah1 (1 Post)
  140. tdobberphul (4 Posts)

film izle

hd film izle

film sitesi

takipci kazanma sitesi

takipci kazanma sitesi

güzel olan herşey

takipci alma sitesi

komik eğlenceli videolar