[adamParticipant]

This one works though.
http://jsfiddle.net/apreston/JP59m/1/

This one doesn’t work
http://jsfiddle.net/apreston/3Pzhj/6/

The only difference is a special character in the xml.

[adamParticipant]

Hello,

I am seeing this problem again. I have provided sample code demonstrating this problem here:
http://jsfiddle.net/apreston/3Pzhj/3/

Please advise.

[adamParticipant]

I looked into this further and found that in jqxdataexport:

This is why everything is being set to String? Is this right?

[adamParticipant]

Hi

I am having a similar problem. I am using the number type on the data field as mentioned above but MS Excel 2011 still complains that this is a text field.

...	
{ name: 'fieldone', type: 'number' }
...

I opened this file in text editor and the XML seems to indicate the same:

<Row ss:AutoFitHeight="0">
..
 <Cell ss:StyleID="s67"><Data ss:Type="String">0</Data></Cell>
...

When I go in a manually update this ss:Type field it Excel doesn’t prompt me to convert this cell. Is this working in other versions of Excel?

[adamParticipant]

That was it. Thanks!!!!!!

[adamParticipant]

A quick update: after looking at the source code I found that before 2.7.0 the export server is set to http://www.jqwidgets.com/export_server/save-file.php, which no longer seems to exist. In version 2.7.0 the default export server was updated to http://jquerygrid.net/export_server/save-file.php, which is there.

can this old server url be restored? I am planning on upgrading at some point, but I am not there yet.

Thanks,

Adam

[adamParticipant]

A quick update: after looking at the source code I found that before 2.7.0 the export server is set to http://www.jqwidgets.com/export_server/save-file.php, which no longer seems to exist. In version 2.7.0 the default export server was updated to http://jquerygrid.net/export_server/save-file.php, which is there.

can this old server url be restored? I am planning on upgrading at some point, but I am not there yet.

Thanks,

[adamParticipant]

Thanks Peter, I will upgrade.

Also, in reference to the other problem, does this file still exist on your server: http://www.jqwidgets.com/export_server/save-file.php

Until I upgrade I am hoping to at least your server for exporting.

Thanks again

[adamParticipant]

Now, I can’t seem to use the default functionality. When I try using the save-file.php on the jqwidgets.com server I get a 404.

Please help.

[adamParticipant]

So, to be clear, this was known to not work in 2.6.0? Also, as you can see from my code I included the url as the last parameter as described in the documentation. I think this is right, but I haven’t seen this work yet.

[adamParticipant]

Has this issue been resolved in version 2.6.0. Reason is I ask is that I am still unclear how I can call using my own server

$("#exportButton").click(function () {     
		var exportType = jQuery("#export_dropdown_list").jqxDropDownList('getSelectedItem').value   ;
		$("#envision_report").jqxGrid('exportdata', exportType, 'treatment_report', true, null, false, "http://local-server/save-file.php");             
	 });

Do I have this syntax right?

[adamParticipant]

Actually, my hack doesn’t work, at least when trying to export this grid to excel. This is the error I get when trying to open the resulting file (obviously because of the line breaks)

XML PARSE ERROR:  Missing end-tag
  Error occurs at or below this element stack:
    <ss:Workbook>
     <ss:Worksheet>
      <ss:Table>
       <ss:Row>
        <ss:Cell>
         <ss:Data>
          <ss:br>

Any more thoughts on word wrapping column headers?

[adamParticipant]

Sounds good.

Thanks

[adamParticipant]

The autorowheight is working great for me for the rows. Is there a solution for the column headers? Right now I am just manually putting in HTML line breaks where needed.

[adamParticipant]

Sounds good. In future posts I will be sure to include the source. As far as this problem goes, I have learned to accept this behavior. Also I discovered the autoClose attribute which may work as well.

Thanks for your help.

Adam

[Author]

Posts