Ext.ux.Exporter icon indicating copy to clipboard operation
Ext.ux.Exporter copied to clipboard

Fixed ExcelFormatter XML output to load correctly into Excel

Open tobysmith opened this issue 13 years ago • 8 comments

This removed the "Problems came up during load" message for me..

I changed the namespace of the ExcelWorkbook tags from ss: (xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet") to x: (xmlns:x="urn:schemas-microsoft-com:office:excel").

I also removed the CDATA from the cells to be able to get the cell data to display, otherwise they were coming up blank.

tobysmith avatar Nov 10 '11 15:11 tobysmith

What's the difference between ss: (xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet") and x: (xmlns:x="urn:schemas-microsoft-com:office:excel"?? I have no idea what the difference may be, have you had problems with the previous implementation? The code for the excel xml comes from edspencer's plugin so I don't really know what's going on there.... Will the change make this not compatible with non excel spreadsheet programs (openoffice, etc)?

iwiznia avatar Nov 10 '11 16:11 iwiznia

I had the same problem as in issue #8..

Problems came up in the following ares during load: *Uknown *Style

Checking the Excel log files have shown this:

XML ERROR in ExcelWorkbook description REASON: Missing Tag FILE: download.xls:users:stotes:desktop:download.xls GROUP: Styles TAG: Style ATTRIB: ID

I checked though and couldn't seem to find anything wrong with the styles tags.

I haven't checked it with openoffice or anything else either, I'll do that and report back soon.

-----EDIT------

Okay this doesn't work in LibreOffice, get an "input/output error"

tobysmith avatar Nov 10 '11 16:11 tobysmith

ok, thanks. Also, the example was outdated and didn't work because it was written for edspencer's plugin. I have to update the readme and create and example.. I'll do that when I find some spare time... The strange think is that I'm using this with no rpoblems on excel and openofice (and it's variation libreoffice)....

iwiznia avatar Nov 10 '11 17:11 iwiznia

I'm still experiencing this error in Ext 3.2.1. Problems came up in the following ares during load: *Uknown *Style

Any ideas on how I may resolve this?

stotes avatar Dec 01 '11 07:12 stotes

Stotes, this plugin is for Ext 4. It won't work for Ext 3, use edspencer's version for compatibility.

iwiznia avatar Dec 01 '11 10:12 iwiznia

Is it possible to use a different image file for downloadify? I made a change in the code for my application to use a .png file that I have for an excel download. It flickers and then it disappears and the download doesn't work. When I use the .png file that comes with the exporter everything works fine. Not sure what the issue could be.

lisaWriteJava avatar Dec 01 '11 11:12 lisaWriteJava

If you open the provided image, you can see it has 4 states. Your image has to be like that too. Also, if your image has different size, you should set the width and height in the button config.

iwiznia avatar Dec 01 '11 12:12 iwiznia

Thanks.

lisaWriteJava avatar Dec 01 '11 14:12 lisaWriteJava