Re: [web2py] Re: XLSM files converted to XLSX

2013-09-03 Thread Derek
Andrew, clear your IE cache and try downloading the file again, or rename the file and then try downloading it. IE < 9.0 will use the cache control headers, so the file will be cached if you don't use the attachment keyword. Look at line ~300 in the globals.py On Tuesday, August 27, 2013 3:38:4

Re: [web2py] Re: XLSM files converted to XLSX

2013-08-27 Thread Andrew Buchan
OK, I added the following MIME type as suggested by Derek application/vnd.ms-excel.sheet.macroEnabled.12 to gluon.py, which results in the file being opened/saved as xlsm, so it seems that is the correct one to use (gluon.py did have an entry for xlsm, but not the right one) However...the workbo

Re: [web2py] Re: XLSM files converted to XLSX

2013-08-27 Thread Niphlod
open gluon/contenttype.py . It's pretty much self-explanatory, but if you don't know the correct mime-type, its not going to be useful. BTW, if you find a mime-type that works out, tell us, we'll definitely include that. On Tuesday, August 27, 2013 10:40:38 PM UTC+2, Andrew Buchan wrote: > > Sor

Re: [web2py] Re: XLSM files converted to XLSX

2013-08-27 Thread Andrew Buchan
Sorry, was that request for me? My developments are all internal, not www so I've got no link to send... In terms of getting an immediate/temporary fix, how would I go about adding that mime/content type to the rocket server my web2py app runs on? On Mon, Aug 26, 2013 at 7:12 PM, Niphlod wrot

Re: [web2py] Re: XLSM files converted to XLSX

2013-08-26 Thread Niphlod
rotfl we miss a contenttype for xslm, but I can't find nowhere what is supposed to be the correct one. Can you point me to a link to an xslm file that it's working in IE8 ? On Monday, August 26, 2013 7:13:06 PM UTC+2, Andrew Buchan wrote: > > I tried adding "?attachment", and I get a Save As

Re: [web2py] Re: XLSM files converted to XLSX

2013-08-26 Thread Derek
xlsm mime type is: application/vnd.ms-excel.sheet.macroEnabled.12 from here: http://blogs.msdn.com/b/vsofficedeveloper/archive/2008/05/08/office-2007-open-xml-mime-types.aspx On Monday, August 26, 2013 10:13:06 AM UTC-7, Andrew Buchan wrote: > > I tried adding "?attachment", and I get a Save As

Re: [web2py] Re: XLSM files converted to XLSX

2013-08-26 Thread Andrew Buchan
I tried adding "?attachment", and I get a Save As dialog box..trying to save it as a xlsx file!! I'm just baffled by how something so basic can go so wrong... I can download xlsm files fine from other sites, using IE8, so it has to be something in the Rocket or web2py. Thanks for your help so

Re: [web2py] Re: XLSM files converted to XLSX

2013-08-26 Thread Niphlod
uhm. ok. if you don't know what a content-type is, please don't fiddle with it. It may be that ie8 wants to autoopen the file instead of saving it like all the other browsers. The solution to force a "save as" dialog is quite simple: just add *?attachment *to the generated URL. On Monday, Augus

Re: [web2py] Re: XLSM files converted to XLSX

2013-08-26 Thread Andrew Buchan
Hi Niphlod, If I save file as xlsb I get an "invalid request" upon clicking on the link... Seems the browser is trying to open the files whereas I want it to download. As for content-type and modifying default.py/download() function accordingly - can you provide an example of what alterations I s

[web2py] Re: XLSM files converted to XLSX

2013-08-26 Thread Niphlod
content-type if not provided is guessed by gluon/contenttype.py. for xslx is 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' If you need a different content-type, alter the default.py/download() function accordingly On Monday, August 26, 2013 2:13:58 PM UTC+2, Tim Richa

[web2py] Re: XLSM files converted to XLSX

2013-08-26 Thread Tim Richardson
As a workaround, try saving the file as .xlsb and see what happens. On Monday, 26 August 2013 21:06:33 UTC+10, Andrew Buchan wrote: > > > I'm having a strange issue with a static file download. In the static > folder I have a file with an xlsm extension, which I want users to be able > to downlo