Hyperlink to bug id in Excel export

Post about your customizations to share with others.

Moderators: Developer, Contributor

Post Reply
TomR
Posts: 55
Joined: 01 Aug 2006, 10:22

Hyperlink to bug id in Excel export

Post by TomR »

Does anyone know how to change the Excel import that the column with the 'id' wil export a hyperlink instead of the number?
TomR
Posts: 55
Joined: 01 Aug 2006, 10:22

SOLVED Re: Hyperlink to bug id in Excel export

Post by TomR »

Figured that one out my self years ago.

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 ) );
}
Post Reply