Warning: array_splice() expects parameter 1 to be array,

Resolved Karen KISS WP Websites
(@mtgamberwesbitedesign)

11 years, 11 months ago

Hi Meitar,

Not sure whether I’m using the correct coding since the googlesheet I’m using is the new version.

WP 3.9.1
Plugin Version 0.4.6

I’m testing your plogin to see if it’ll load the spreadsheet and be searchable.

[gdoc key=”186J1mGrwxbr3v4Br1DLsU9Fd8S8TR_yAQkE2NEvCMvU”]

I receive the following error:

Warning: array_splice() expects parameter 1 to be array, null given in public_html/mountgambierwebsitedesign.com.au/dummy/wp-content/plugins/inline-google-spreadsheet-viewer/inline-gdocs-viewer.php on line 99

Warning: Invalid argument supplied for foreach() in /public_html/mountgambierwebsitedesign.com.au/dummy/wp-content/plugins/inline-google-spreadsheet-viewer/inline-gdocs-viewer.php on line 119

Warning: Invalid argument supplied for foreach() in /public_html/mountgambierwebsitedesign.com.au/dummy/wp-content/plugins/inline-google-spreadsheet-viewer/inline-gdocs-viewer.php on line 132

Warning: array_splice() expects parameter 1 to be array, null given in public_html/mountgambierwebsitedesign.com.au/dummy/wp-content/plugins/inline-google-spreadsheet-viewer/inline-gdocs-viewer.php on line 99

Warning: Invalid argument supplied for foreach() in /public_html/mountgambierwebsitedesign.com.au/dummy/wp-content/plugins/inline-google-spreadsheet-viewer/inline-gdocs-viewer.php on line 119

Warning: Invalid argument supplied for foreach() in /public_html/mountgambierwebsitedesign.com.au/dummy/wp-content/plugins/inline-google-spreadsheet-viewer/inline-gdocs-viewer.php on line 132

Any idea what I can do to fix this?

I saw that someone else had this with new version of google docs but that was using an older version of your plugin.

Thanks for your help,
Karen

https://ww.wp.xz.cn/plugins/inline-google-spreadsheet-viewer/

Viewing 4 replies - 1 through 4 (of 4 total)

Plugin Author Meitar
(@meitar)

11 years, 11 months ago

Nope. For new Google Spreadsheets, use the full URL. Like it says in the plugin description:

After setting the appropriate Sharing setting, copy the URL you use to view the Spreadsheet from your browser’s address bar into the shortcode. For example, to display the spreadsheet at https://docs.google.com/spreadsheets/d/ABCDEFG/edit, use the following shortcode in your WordPress post or page:

[gdoc key=”https://docs.google.com/spreadsheets/d/ABCDEFG/edit”%5D

Thread Starter Karen KISS WP Websites
(@mtgamberwesbitedesign)

11 years, 11 months ago

Thanks I knew I was doing something wrong.

Thread Starter Karen KISS WP Websites
(@mtgamberwesbitedesign)

11 years, 11 months ago

Okay I have the spreadsheet displaying now.

Are the tables are searchable using the search box?
I’m not finding anything on the spreadsheet.

I’m assuming that the search may not work since it’s just displaying the spreadsheet rather than ‘importing it’.

johnaq
(@johnaq)

11 years, 10 months ago

I have a similar problem.

I can view the default sheet of my new Google spreadsheet using the full address, but cannot view another sheet either by using the full address or gid option.

thanks for any help

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Warning: array_splice() expects parameter 1 to be array,’ is closed to new replies.