I don't know if you can help me but:
I create an excel document using the instructions "spreadsheet" for ColdFusion 10.
There is, among the data to be added, a "hyperlink" formula that will contain the URL of a website
I therefore use the instruction "SpreadsheetSetCellFormula"
See the code:
<cfset SpreadsheetSetCellFormula(s, 'HYPERLINK("#Query.Field1#", "#qQuery.Field1#")', curRow, curCol)>
Explanation of different variables:
s : object representing the excel sheet
Query.Field1 : it is the data containing the URL (in a Query)
curRow : row number where the data will be write
curCol : Column number
When I execute the code on my computer and I open the file: the display is correct
When my colleague tries to create the file with the same code, he receives, not the internet link, but the number "0" is displayed in blue colour but and no formulas.
any ideas ?
I don't understand.
Thank you for you help
Copy link to clipboard
You call the query Query, then qQuery. That is confusing. I would suggest the following test for your colleague:
If this works, then the problem lies with your code and not with the ColdFusion engine.
I would like to thank you for your help.
About the name (query and Query), it is false name just for example.
The problem is (If I understood correctly) when it opens the document, it has not clicked on the "enable content" button.
This morning everything seems to work fine.
So thank you
Thanks. Please mark your answer as the correct one.