It is currently Fri Sep 22, 2017 7:06 pm Advanced search

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

Support and discussion for cloud.highcharts.com.

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

Postby Digiconomist » Fri Aug 25, 2017 12:52 pm

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'
        }
}));
Digiconomist
 
Posts: 1
Joined: Fri Aug 25, 2017 12:25 pm

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

Postby kamil » Wed Aug 30, 2017 10:59 am

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!
Kamil Kulig
Highcharts Developer
kamil
 
Posts: 371
Joined: Tue May 30, 2017 11:12 am


Return to Highcharts Cloud

Who is online

Users browsing this forum: No registered users and 0 guests