Page 1 of 1

We found the spreadsheet, but were unable to parse it.

Posted: Fri Aug 25, 2017 10:52 am
by Digiconomist
So I have a few charts that were working just fine, and then I decided to add a little theme to them. This actually works perfectly too. I still see the chart, I see the theme, only the editor claims the following with regard to the used Google sheet: "We found the spreadsheet, but were unable to parse it. If your data grid is not positioned in the top left corner, try setting start row and start column below."

The notification is removed if I remove my custom code, and pops up again regardless what part I add back in. It kind of looks like a bug in the editor since everything does seem to work, but I still want to check it here - wouldn't want this to turn out to be a real problem later on.

I'm running different charts, but for example I've added the following to an area chart:

Code: Select all

/**
 * (c) 2010-2017 Torstein Honsi
 *
 * License: www.highcharts.com/license
 * 
 * Sand-Signika theme for Highcharts JS
 * @author Torstein Honsi
 */

'use strict';

/* global document */


Highcharts.theme = {
   colors: ['#f45b5b', '#8085e9', '#8d4654', '#7798BF', '#aaeeee', '#ff0066', '#eeaaee',
      '#55BF3B', '#DF5353', '#7798BF', '#aaeeee'],
   chart: {
      backgroundColor: null
   },
   title: {
      style: {
         color: 'black',
         fontWeight: 'bold'
      }
   },
   subtitle: {
      style: {
         color: 'black'
      }
   },
   tooltip: {
      borderWidth: 0
   },
   xAxis: {
      labels: {
         style: {
            color: '#6e6e70'
         }
      }
   },
   yAxis: {
      labels: {
         style: {
            color: '#6e6e70'
         }
      }
   },
   plotOptions: {
      series: {
         shadow: true
      },
      candlestick: {
         lineColor: '#404048'
      },
      map: {
         shadow: false
      }
   },


   // General
   background2: '#E0E0E8'

};

// Apply the theme
Highcharts.setOptions(Highcharts.theme);


// Sample of extending options:
Highcharts.extend(options, Highcharts.merge(options, {
    plotOptions: {
 area: {
                fillColor: {
                    linearGradient: {
                        x1: 0,
                        y1: 0,
                        x2: 0,
                        y2: 1
                    },
                    stops: [
                        [0, Highcharts.getOptions().colors[0]],
                        [1, Highcharts.Color(Highcharts.getOptions().colors[0]).setOpacity(0).get('rgba')]
                    ]
                },
                marker: {
                    radius: 2
                },
                lineWidth: 1,
                states: {
                    hover: {
                        lineWidth: 1
                    }
                },
                threshold: null
            }
    },
          chart: {
            zoomType: 'x'
        },
          subtitle: {
            text: document.ontouchstart === undefined ?
                    'Click and drag in the plot area to zoom in' : 'Pinch the chart to zoom in'
        }
}));

Re: We found the spreadsheet, but were unable to parse it.

Posted: Wed Aug 30, 2017 8:59 am
by kamil
Hi Digiconomist,

Thank you for reporting this problem. It seems that it doesn't occur anymore. Please let my me know if this issue still happens to your charts.

Best regards!