Spreadsheet Reader Changelogs

Version 1.1.6
April 27, 2025
New
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.
Feature
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.
Feature
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.
Improve
Refined Clear Cache and Remove buttons.
Fix
Corrected 'row_limit' and 'col_limit' behavior to properly respect the sort attribute and work consistently whether pagination (limit) is enabled or not.
Fix
Resolved PHP Warning in EDD_SL_Plugin_Updater under certain conditions.
Version 1.1.5
April 20, 2025
Feature
Added pagination in [spreadsheet_table] shortcode.
Feature
Added support for setting a data limit in Bricks Query Loop when pulling from the spreadsheet.
Improve
Editing a shortcode now automatically clears its previous cache.
Improve
Shortcode's table UI.
Improve
Validation message on form when adding new Shortcode.
Improve
Add notification message when user has not set Google API Key.
Fix
Resolved a bug when clearing cache using the "Clear Cache" button in the shortcode table.
Fix
Fixed an issue where the Spreadsheet ID field did not immediately appear when enabling "Show Spreadsheet ID" in settings.
Security
Downgraded to SweetAlert2 v11.4.8 to avoid vulnerabilities present in newer versions.
Security
Enhanced code security by improving input validation, sanitization, and proper escaping of user data.
Version 1.1.4
April 7, 2025
Fix
Some bugs.
Improve
Update EDD_SL_Plugin_Updater to v1.9.4.
Version 1.1.3
April 4, 2025
Fix
Some typo in Shortcode usage.
Improve
Changed the AJAX name on the plugin to avoid possible conflicts.
Version 1.1.2
April 2, 2025
Fix
Add shortcode bug.
Version 1.1.1
April 1, 2025
Fix
Shortcode ID field bug.
Version 1.1.0
March 31, 2025
Improve
User Interface - using Bulma CSS Library.
Fix
Some bugs.
Version 1.0.0
March 23, 2025
Initial Release