cfspreadsheet 2007 xlsx files

2011-07-17 Thread Richard White
Hi, Does MS Excel 2007 need to be installed on the server to generate xlsx files. My tests points to yes but was wondering if there was another way round this, as would like to keep the apps down to a minimum on the production server? thanks for any suggestions Richard

Re: cfspreadsheet 2007 xlsx files

2011-07-17 Thread Pradeep Viswanathan
Well if that is the case, what does someone do on a unix box ? Thanks and Regards, Pradeep Viswanathan R On 17 July 2011 17:47, Richard White rich...@j7is.co.uk wrote: Hi, Does MS Excel 2007 need to be installed on the server to generate xlsx files. My tests points to yes but was

Re: cfspreadsheet 2007 xlsx files

2011-07-17 Thread Dave Watts
Does MS Excel 2007 need to be installed on the server to generate xlsx files. My tests points to yes but was wondering if there was another way round this, as would like to keep the apps down to a minimum on the production server? Well, according to the docs, CF doesn't use MS Office for

Re: cfspreadsheet 2007 xlsx files

2011-07-17 Thread Pradeep Viswanathan
This page says xlsx is supported... http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-747b.html Thanks and Regards, Pradeep Viswanathan R On 17 July 2011 20:06, Dave Watts dwa...@figleaf.com wrote: Does MS Excel 2007 need to be installed on the server

Re: cfspreadsheet 2007 xlsx files

2011-07-17 Thread Richard White
yes your right it is supported, and the issues i was getting turned out to be in relation to the cfcontent; i had to update the mime type to: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet thanks for the replies This page says xlsx is supported...

Re: cfspreadsheet 2007 xlsx files

2011-07-17 Thread Pradeep Viswanathan
Interesting.. what's the difference for the end user ? So if the end user does not have office installed, we got to force the cfcontent... right ? Thanks and Regards, Pradeep Viswanathan R On 17 July 2011 20:43, Richard White rich...@j7is.co.uk wrote: yes your right it is supported, and the

Re: cfspreadsheet 2007 xlsx files

2011-07-17 Thread Richard White
trade-offs i suppose, it would be great if we could detect what version of office the user had installed and then act accordingly. We could ask them what version they have and then tailor the software functions accordingly, but they would have to change these options each time they change

Re: cfspreadsheet 2007 xlsx files

2011-07-17 Thread Richard White
in fact you mention a good point, there are only a few scenarios that would require the functionality of 2007, instead of getting it to output in xlsx for everything we should only get it to export to that format if it requires it, else it exports it to xls. do you export to a different

Re: cfspreadsheet 2007 xlsx files

2011-07-17 Thread Pradeep Viswanathan
because that XLSX being the latest format, i would want to go that way. I think at this time, pretty much everyone has a MS Office 2k7 installed or at least they got the addons to make office 2k3 to open 2k7 files. If my memory is right, the file size of XLSX file are lesser by more than 50%,

Re: cfspreadsheet 2007 xlsx files

2011-07-17 Thread Wil Genovese
I believe that all the MS document types are be handled by the OpenOffice document engine. In the CF Admin there is a sections in Server Settings - Document that asked you for the location of your OpenOffice Directory. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF

Re: cfspreadsheet 2007 xlsx files

2011-07-17 Thread Richard White
i have done some research about the use of openoffice in coldfusion although i cannot get my head around how it would be utilized. can you provide any direction? for example, another scenario is opening an existing word document, and adding some content to it, the only way i have found to get

Re: cfspreadsheet 2007 xlsx files

2011-07-17 Thread Richard White
to elaborate on my previous point the docs say that when cfspreadsheet is used it searches for an installation of OpenOffice first and if so it uses it libraries. i dont have an installation of OpenOffice at present but also havent noticed any limitations in cfspreadsheet, therefore would

Re: cfspreadsheet 2007 xlsx files

2011-07-17 Thread Leigh
docs say that when cfspreadsheet is used it searches for an installation of OpenOffice first and if so it uses it libraries. When they mention OpenOffice they are usually talking about _converting_ office files, not generating them from scratch. AFAIK OpenOffice is not used at all to

Re: cfspreadsheet 2007 xlsx files

2011-07-17 Thread Richard White
ok thanks Leigh docs say that when cfspreadsheet is used it searches for an installation of OpenOffice first and if so it uses it libraries. When they mention OpenOffice they are usually talking about _converting_ office files, not generating them from scratch. AFAIK OpenOffice is