Hyperlink to bug id in Excel export
Moderators: Developer, Contributor
Hyperlink to bug id in Excel export
Does anyone know how to change the Excel import that the column with the 'id' wil export a hyperlink instead of the number?
SOLVED Re: Hyperlink to bug id in Excel export
Figured that one out my self years ago.
Change function in core/excel_api.php
Change function in core/excel_api.php
Code: Select all
# Changed to export a link to Excel
function excel_format_id( $p_bug ) {
$t_url = config_get( 'path' );
$t_url = htmlspecialchars( $t_url );
$t_value = "<Cell ss:HRef=\"" . $t_url . "view.php?id=" . $p_bug->id . "\">" . "<Data ss:Type=\"String\">". $p_bug->id . "</Data></Cell>\n";
return $t_value;
// return excel_prepare_string( bug_format_id( $p_bug->id ) );
}