Spreadsheet Reader

Added offline fallback system for spreadsheet data fetching. If the Google Sheets API request fails and no fresh cache is available, the plugin will automatically serve the last successfully fetched data stored in the database. This ensures better reliability during external service downtimes.

Users can now perform a live test of the spreadsheet data by clicking a "Live Test" button. This will fetch the spreadsheet data without cache and display it in real-time, making it easier to test the integration directly on the website.

Added no_cache attribute to the shortcode, allowing users to fetch data directly from the Google Sheets API without using cached data. This attribute helps ensure real-time data fetching and is especially useful for testing or situations where fresh data is required. By default, no_cache is set to false, but setting it to true will bypass cache and fetch the data again from the source.

Refined Clear Cache and Remove buttons.

Corrected row_limit and col_limit behavior to properly respect the sort attribute and work consistently whether pagination (limit) is enabled or not.

Resolved PHP Warning in EDD_SL_Plugin_Updater under certain conditions.

Added pagination in [spreadsheet_table] shortcode.

Added support for setting a data limit in Bricks Query Loop when pulling from the spreadsheet.

Editing a shortcode now automatically clears its previous cache.

Shortcode's table UI.

Validation message on form when adding new Shortcode.

Add notification message when user has not set Google API Key.

Resolved a bug when clearing cache using the "Clear Cache" button in the shortcode table.

Fixed an issue where the Spreadsheet ID field did not immediately appear when enabling "Show Spreadsheet ID" in settings.

Downgraded to SweetAlert2 v11.4.8 to avoid vulnerabilities present in newer versions.

Enhanced code security by improving input validation, sanitization, and proper escaping of user data.

Some bugs.

Update EDD_SL_Plugin_Updater to v1.9.4.

Some typo in Shortcode usage.

Changed the AJAX name on the plugin to avoid possible conflicts.

Add shortcode bug.

Shortcode ID field bug.

User Interface - using Bulma CSS Library.

Some bugs.

Initial Release