Re: Xlsx code generated by the Productivity Tool does not work on Mac

Hello,

I'm using a code generated by the Productivity Tool to create an xlsx.
The worksheet in Excel 2007 opens normally, but when I try to open the same spreadsheet on the Mac (using Apple Pages 09 or Microsoft Excel 2008) it did not recognize the file.

Note: when I save the same file in Excel 2007 it opens normally on the Mac

Anybody know what is happening and any way to solve?

Thanks in advance,

Jabson

Hi Jabson

Take the file you said you saved in Excel 2007 (which consequently works on the Mac) and run the Productivity Tool's Compare against this and the generated document (which you know wont work on the Mac).  This should highlight the differences and hopefully you can spot the problematic discrepancy.

Beyond this I would suggest trying the sdk's OpenXmlValidator class.  And, failing that, you could then break the document you are generating down into simpler components to try identify what the incompatible component is - are there any specifically complex things on the document (e.g. background images, charts etc..) that you could try removing?

So I created a simple spreadsheet with a cell containing the value 10. I used the Productivity Tool to generate code that worksheet and try to open there in the Mac OS it does not even recognize the file format. If I get that same file and open it in Excel 2007 and only saved him, the Mac recognizes the file and opens normally.

I have tried to compare the files, but the biggest difference between them is a folder called Package on file with error, but the same programming code for this folder does not generate this problem happens. Using OpenXmlValidate it displays the same errors for both the file that functions as for what does not work.

I believe that when I save the file in Excel it corrects this problem, then it seems to me that this is a bug or Productivity Tool or the library that generates the file.

If you have any idea what can I do to try to solve this problem I would greatly appreciate it.

Sorry for the possible failure of English, I can read well, but writing is still a bit difficult.

Thanks in advance

Hi Jabson

Spreadsheet documents that I have created and saved in Excel 2010 do not seem to have the package folder you describe - but without a mac running Office I cannot test these documents there.

Would like to help you further but without a mac running Office I can't replicate your issue - maybe someone else here can?