Error opening xlsx file with a bar chart

[Jeejaj]

This is:

• a bug report

What is the expected behavior?

File should open with out any warnings and should display the bar chart with specified custom colors.

What is the current behavior?

File opens with a warning

What are the steps to reproduce?

  $spreadsheet->setActiveSheetIndex($sheet_index);
  $sheet = $spreadsheet->getActiveSheet();
  $sheet->setTitle('Chart');
  $dataSeriesLabels = [
      new DataSeriesValues(DataSeriesValues::DATASERIES_TYPE_STRING, 'Summary_report!$D$8', null, 1, [$report_config['legend'][2]['legend']], null, 'ff0000'),
      new DataSeriesValues(DataSeriesValues::DATASERIES_TYPE_STRING, 'Summary_report!$D$9', null, 1, [$report_config['legend'][1]['legend']], null, '70ad47'),
      new DataSeriesValues(DataSeriesValues::DATASERIES_TYPE_STRING, 'Summary_report!$D$10', null, 1, [$report_config['legend'][0]['legend']], null, 'ffff00'),
             ];
  $xAxisTickValues = [
        new DataSeriesValues(DataSeriesValues::DATASERIES_TYPE_STRING, 'Summary_report!$E$7:$'.$col.'$7', null, $colNumber),
             ];
  $dataSeriesValues = [
        new DataSeriesValues(DataSeriesValues::DATASERIES_TYPE_NUMBER, 'Summary_report!$E$8:$'.$col.'$8', null, $colNumber),
        new DataSeriesValues(DataSeriesValues::DATASERIES_TYPE_NUMBER, 'Summary_report!$E$9:$'.$col.'$9', null, $colNumber),
        new DataSeriesValues(DataSeriesValues::DATASERIES_TYPE_NUMBER, 'Summary_report!$E$10:$'.$col.'$10', null, $colNumber),
             ];     
 $series = new DataSeries(
                 DataSeries::TYPE_BARCHART, // plotType
                 DataSeries::GROUPING_STACKED, // plotGrouping
                 range(0, count($dataSeriesValues) - 1), // plotOrder
                 $dataSeriesLabels, // plotLabel
                 $xAxisTickValues, // plotCategory
                 $dataSeriesValues        // plotValues
             );
             $layout1 = new Layout();
             $layout1->setShowVal(TRUE);
             $plotArea = new PlotArea($layout1 , [$series]);
            
             $legend = new Legend(Legend::POSITION_BOTTOM, null, false);
             $title = new Title('Submission Report');
             $yAxisLabel = new Title('Count');
             $xAxisLabel = new Title('period');
             $yaxis = new Axis();
             $yaxis->setAxisOptionsProperties('low', null, null, null, null, null, 0, null, null, null);

//	Create the chart
             $chart = new Chart(
                 'chart1', // name
                 $title, // title
                 $legend, // legend
                 $plotArea, // plotArea
                 true, // plotVisibleOnly
                  'gap',// displayBlanksAs
                 $xAxisLabel , // xAxisLabel
                 $yAxisLabel,  // yAxisLabel
                 null,
                 $yaxis
             );
                                                                                                                                      

This above code results on the chart with specified custom color code, but the warning will be displayed during file opens.
If the last argument (color code) in the $dataSeriesLabels is not passed the warning will not appear but the chart displayed with different color.
The issue exist from 1.24.0v onwards.

What features do you think are causing the issue

• Charts

Which versions of PhpSpreadsheet and PHP are affected?

PhpSpreadsheet - 1.27.1 (from 1.24.0 onwards)
php - 8.2

[oleibman]

All of $report_config, $col, and $colNumber are undefined when they are first used in your code. Can you please tell me their values so that I can investigate further.

[Jeejaj]

$report_config =
Array
(
    [legend] => Laminas\Config\Config Object
        (
            [allowModifications:protected] => 
            [data:protected] => Array
                (
                    [0] => Laminas\Config\Config Object
                        (
                            [allowModifications:protected] => 
                            [data:protected] => Array
                                (
                                    [days] => 0
                                    [time] => 10:00 AM
                                    [color] => Green
                                    [code] => #e3ffe6
                                    [legend] => On or before 10:00 AM ET on 1st business day
                                )

                            [skipNextIteration:protected] => 
                        )

                    [1] => Laminas\Config\Config Object
                        (
                            [allowModifications:protected] => 
                            [data:protected] => Array
                                (
                                    [days] => 1
                                    [time] => 10:00 AM
                                    [color] => Yellow
                                    [code] => #fff4d6
                                    [legend] => On or before 10:00 AM ET on 2nd business day (Grace Period)
                                )

                            [skipNextIteration:protected] => 
                        )

                    [2] => Laminas\Config\Config Object
                        (
                            [allowModifications:protected] => 
                            [data:protected] => Array
                                (
                                    [days] => 2
                                    [time] => 10:00 AM
                                    [color] => Red
                                    [code] => #ffe5e3
                                    [legend] => After 10:00 AM ET on 2nd business day, or Not submitted
                                )

                            [skipNextIteration:protected] => 
                        )

                    [include_weekends_and_holidays] => 1
                )

            [skipNextIteration:protected] => 
        )

)

$col = J;

$colNumber = 7;

[oleibman]

Thank you. I can now get the program to run, but ... I need the data on your Summary_report worksheet in order to populate the chart. It looks like I need cells D8-D10 and E7-J10.

[oleibman]

Never mind about the data, I can use some random numbers to investigate further.

[Jeejaj]

@oleibman This works fine in my environment. Thanks for your contribution.

[oleibman]

@Jeejaj Thank you for confirming. I will merge this change some time this week.