Copy link to clipboard
Copied
Hello,
I don't know if it is possible or not.
I generate and Excel document with ColdFusion 10.
I would like to activate the "Track Changes" with Coldfusion or how can I activate the track changes automatically?
Is it possible or not?
Thank you in advance for your support
Best regards
André
Copy link to clipboard
Copied
Hello, André,
I do not think this is possible. I have looked over all of the functions of SpreadsheetNew() and related functions, and I do not see anything, anywhere, that mentions this is possible. I also believe that cfspreadsheet cannot help with your request.
V/r,
^ _ ^
Copy link to clipboard
Copied
Hello,
Thank you for your answer. I thing so. Now, My idea is to use a template with the track changes already set and (via coldfusion) add the pages with the result.
In that case, how can open the template and add a page ?
Thank you
Best regards
Andre
Copy link to clipboard
Copied
André
All Spreadsheet functions in ColdFusion can be found here. Basically you would read your template and save it as a variable; this is your spreadsheet object. From there you can add sheets, remove sheets, input data (values or functions), format the output, and save it as a different .xls or .xlsx file.
I much prefer using the spreadsheet() functions in cfscript over the CFSPREADSHEET tag. But there are many ways to do it.
HTH,
^ _ ^