View Issue Details

IDProjectCategoryView StatusLast Update
0003241mantisbtotherpublic2008-08-11 09:41
Reporterkhuypen Assigned Tovboctor  
PrioritynormalSeverityfeatureReproducibilityalways
Status closedResolutionfixed 
Fixed in Version1.2.0a2 
Summary0003241: On Excel, no column headings display.
Description

The excel report displays the details of the bugs selected but no column headings so that you understand what you are looking at.

TagsNo tags attached.

Relationships

has duplicate 0010574 closedvboctor Tableheader are not generated 
has duplicate 0005885 closedatrol Export to Excel without column headers 

Activities

aarjona

aarjona

2003-07-25 17:40

reporter   ~0004439

Confirming for the latest CVS version. With 0.18.0a4, however, it does not show any data.
Can you supply more details about your setup?

Mantis version
Server Platform
Webserver
PHP version
Browser used
etc, etc

KonHuypen

KonHuypen

2003-10-20 18:40

reporter   ~0004675

I have seen this issues with Apache 2.046 on Win2000 with IE 6, PHP 4.3.3, MySQL (Latest version) with 0.18.rc1. Although if you update your printing preferences they do show up.

zhuyunchuan

zhuyunchuan

2003-11-17 05:32

reporter   ~0004742

I removed a line in print_all_bug_page_excel.php, as following,
to display the headline .

<?php html_head_end() ?>
<?php html_body_begin() ?>

<div id="Classeur1_16681" align=center x:publishsource="Excel">
<table x:str border=0 cellpadding=0 cellspacing=0 width=100% style='border-collapse:
collapse'>

<tr>
<?php

titles desactivated for html pages

!   # if ( $f_type_page != 'html' ) 
    {
        for ( $i=0 ; $i &lt;$field_name_count ; $i++ ) {
            if ( isset( $t_prefs[$i] ) && ( 1 == $t_prefs[$i] ) ) {  ?>
&lt;td class=xl2316681 style='border-left:none'>&lt;?php echo $t_field_name_arr[$i] ?>&lt;/td>

<?php
} //if isset
} //for
} //if
?>
</tr>

zhuyunchuan

zhuyunchuan

2003-11-17 05:36

reporter   ~0004743

Last edited: 2003-11-17 09:30

I can't analyze the excel file which reported by mantis.
If I create a new excel file, I can insert a graph by analyzing the data in excel table, but I can't do it got from mantis.

edited on: 11-17-03 09:30

langis

langis

2005-11-16 12:16

reporter   ~0011624

Last edited: 2005-11-16 14:52

I have the same problem and it is related to the fact that the code tries to extract the user printing preferences but does not find any and therefore no headers are returned. This is simply resolved by removing a comment marker on line 171 of the file print_all_bug_page.php so that a new menu item will appear at the top of the page allowing you to set the printing options (i.e. choosing the fields that will be included in the report). Once a selection is made the Field Names appear in the first row of the resulting spreadsheet.

salmira

salmira

2005-11-28 03:01

reporter   ~0011662

Tried to followi in the note 0011624. But this change caused errors:

  1. Removed a comment marker near line 171 to show Print Options menu linked with the page:
    print_all_bug_options_page.php
  2. Entered to print_all_bug_page.php and found there a new menu item at the top of the page allowing to set the printing options.
  3. Pressed print options link and found page print_all_bug_options_page.php
  4. Set selected fields and pressed a button to apply selection
  5. Saw the page print_all_bug_options_page.php with error messages on each row instead of report data:

SYSTEM WARNING: Invalid argument supplied for foreach()

swellnuts

swellnuts

2008-06-19 22:05

reporter   ~0018143

This is a pretty serious bug - should I try one of the excel plugins instead?
http://bugtracker.morinie.fr/mantis/dokuwiki/doku.php?id=mantis:13:start

vboctor

vboctor

2008-06-21 01:26

manager   ~0018145

Has anyone verified this on 1.1.2 / 1.1.1 / 1.2.0a1? If I remember correctly, I've added this when I re-wrote Excel export code.

vboctor

vboctor

2008-06-21 23:00

manager   ~0018146

I've confirmed that this is fixed in the latest trunk code. I believe the fix is available in 1.2.0a1.