RE: cfheader/cfheader not working as expected
I don't remember if you posted any code, but I get by this with the following: Before All that I build the spreadsheet and put it into Variables.mySpreadsheetVar. What version of CF are you on? Are you using HTML, CFSpreadsheet, or some other method to generate the spreadsheet? I had an issue similar to what you had before, but I started building the spreadsheets using POI then when they get pushed to the browser they are in true spreadsheet format instead of html pretending to be xls (or xlsx). Sometimes the browser would see the xls extension but would then check the content and see html and act weirdly. By using the poi I not only get rid of those problems but it also got rid of the Excel "Not in the same format" popup. If you can consider this option let me know and I may be able to help a little. Also, do you have access to the server itself? I upgraded the POI that comes with ColdFusion to the latest version and I can do a lot more extra stuff. Steve -Original Message- From: Robert Gallagher [mailto:robert.gallag...@honeywell.com] Sent: Tuesday, November 09, 2010 5:35 PM To: cf-talk Subject: Re: cfheader/cfheader not working as expected I truly understand what you're saying but how these things work it not consistent which is frustrating. What's really crazy is we have dozens of Excel download links in our various apps like this example and some work perfectly with "value=inline" but most have the undesirable behavior (code name and read-only) which actually still works. Why "inline" provides the dialog box option of remembering the download decision but using "attachment" does not give that option (at least in IE) is very inconsistent but not surprising. Since this is not earth shattering I will chalk this up to browser inconsistency and move on. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339075 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader/cfheader not working as expected
I truly understand what you're saying but how these things work it not consistent which is frustrating. What's really crazy is we have dozens of Excel download links in our various apps like this example and some work perfectly with "value=inline" but most have the undesirable behavior (code name and read-only) which actually still works. Why "inline" provides the dialog box option of remembering the download decision but using "attachment" does not give that option (at least in IE) is very inconsistent but not surprising. Since this is not earth shattering I will chalk this up to browser inconsistency and move on. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339055 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader/cfheader not working as expected
> Let me refine this a little more. IE6 (the company browser) treats "inline" > versus "attachment" slightly different as far as the Open/Save dialog > box is concerned. "Attachment" *FORCES* the user to always choose open or > save. "Inline" allows the user to permanently select Open for > example, but then opens it with the wrong name and Read-Only. That last part > is the irritating part. If IE handled it like Firefox then this > discussion would be moot. Right. But you don't have any control over that from the server in either case. The "inline" behavior makes sense - you download HTML pages all the time in a browser and you can't change their name (without Save As ...) or edit them on the server by default. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or on ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338991 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader/cfheader not working as expected
> On 11/8/2010 9:55 AM, Robert Gallagher wrote: > > Using "attachment" forces the user to make a selection on a dialog > box and I wanted to bypass that dialog box and have the file open > every time. > > > You do not get to make that choice. It is *MY* computer and *MY* > browser and *I* get to say what happens to any content you choose to > send me. > > > > Let me refine this a little more. IE6 (the company browser) treats "inline" versus "attachment" slightly different as far as the Open/Save dialog box is concerned. "Attachment" *FORCES* the user to always choose open or save. "Inline" allows the user to permanently select Open for example, but then opens it with the wrong name and Read-Only. That last part is the irritating part. If IE handled it like Firefox then this discussion would be moot. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338990 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader/cfheader not working as expected
You don't get such a granular level of control in the web environment, only in the desktop arena. On Mon, Nov 8, 2010 at 12:55 PM, Robert Gallagher < robert.gallag...@honeywell.com> wrote: > > > > > > > Change "inline" to "attachment" so that the browser knows this is a > > separate, attached file to view OR download AND NOT an inline part of > > the currently viewed file: test.cfm. > > Using "attachment" forces the user to make a selection on a dialog box and > I wanted to bypass that dialog box and have the file open every time. > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338958 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader/cfheader not working as expected
On 11/8/2010 9:55 AM, Robert Gallagher wrote: > Using "attachment" forces the user to make a selection on a dialog box and I > wanted to bypass that dialog box and have the file open every time. You do not get to make that choice. It is *MY* computer and *MY* browser and *I* get to say what happens to any content you choose to send me. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338957 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader/cfheader not working as expected
> Using "attachment" forces the user to make a selection on a dialog box and I > wanted to bypass that dialog box and have the file open every > time. For obvious security reasons, you generally can't make things happen on a client's machine from the web server. You can provide suggestions to the client (such as the proper disposition of content) but that's it. If you need programs to automatically open, etc, you need client-side functionality (ActiveX, Java, AIR, etc) to make that happen. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338956 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader/cfheader not working as expected
> > > Change "inline" to "attachment" so that the browser knows this is a > separate, attached file to view OR download AND NOT an inline part of > the currently viewed file: test.cfm. Using "attachment" forces the user to make a selection on a dialog box and I wanted to bypass that dialog box and have the file open every time. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338954 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader/cfheader not working as expected
Change "inline" to "attachment" so that the browser knows this is a separate, attached file to view OR download AND NOT an inline part of the currently viewed file: test.cfm. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338882 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfheader/cfheader not working as expected
I want to do simple download of a web page to Excel. I am using CF7, browser is IE6SP2 and Excel 2007. The single standalone file is test.cfm. Here is the code: Hello 1 Column 2 Column 3 Excel open as expected but the filename in Excel is "test.cfm" rather than "download.xls" and is opened in [Read-Only] mode. Any ideas? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338877 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm