Now available on Add-ons store
There are new features and improvements on the original Dicers standard version, and there are are also some great new features available by upgrading to the Pro version.
Here's a quick summary and some screenshots for new features in the standard edition, and a video summary below
The previous version had two modes for specifying the data to consider for Dicers. Now you can also specify a specific range.
Now you can specify "allow scrolling" for Dicers. Previously you could not extend the dimensions of Dicers beyond the add-on sidebar. Enabling this feature allows you to extend them beyond those limits.
Previously you could not have leading blank rows or columns, and the table would need to start at A1 to be considered if 'Wholesheet' was selected in Data Settings.
These are now allowed.
They will automatically be assigned unique names
You may want to Pause the showing and hiding of rows while you update the sheet to prevent them from being hidden till you are finished. You can use the Pause button for this.
Previously sorting of numeric values was done on the display format, and would therefore be alphabetic. This means that some numbers and dates would be out of order. Now sorting is done with reference to the underlying real values, so will be in a sensible order irrespective of the display formats applied in the Sheet.
To manage the Pro version subscription, there is now an account page. Note that no personal information is stored by the add-on. If you are using the standard edition, your account page will look like this. Occasionally you will get a reminder about subscribing to the Pro version, especially if you are a Pro user and your subscription will soon run out.. You can turn this off completely with the Reminders option.
The Pro version has a number of unique features, not available in Excel Slicers (upon which Dicers are based). See the video below for the main features
Unlock access to the Pro version by subscribing on the UPGRADE Tab.
This will take you through a subscription dialog, which uses the Stripe payment system, where you pay a one off fee for 1 years access to Pro features. Your credit card or email address is not stored or accessible by Google Sheets or the Dicers add-on.
Once subscribed, the UPGRADE page will show the expiration date. You can extend the subscription (add another year) at any time with the EXTEND button.
Your settings and account are available via these SETTINGS pages
If subscribed, your account will show you account status, and payment reference like this
Trial subscription is available via a coupon code. This will give access for some period of time. Coupons can be redeemed via the Account tab. If you'd like a trial coupon, contact me.
For convenience you can enable/disable pro features through the Pro Plan Settings page
When you start a new session of Dicers, the settings applied will depend on how you've set up the initial settings to be retrieved from via the Save page. Pro settings are no different than any other settings so to enable them to persist across sessions, either for this document or for all your documents, you should Apply the relevant options them via the SAVE page when you make changes to any add-on settings to make them persistent.
The pro version introduces automatic, sheet level settings. When enabled, any dicers you have set up, including their selected values are maintained so that when you switch between pages, the previous selections for that page are automatically stored. There is also an option for preserving these sheet level settings across sessions, so when you restart the add-on, it either clears or restores its state the last time it was accessed.
If you have a sheet with multiple tables on it, or with leading blank columns or rows, and you have selected "wholesheet" from the Data selection page, these blanks will be all be included in the dicers list of values.
Consider a messy sheet like this
In this case we really want the table with the yellow headings, but when considering the wholesheet, the standard version of Dicers sees these columns.
One way to pick the desired table would be using the specific range option
Which would correctly give this
By default it will find the biggest block of data that looks like a table in a sheet, and will tolerate up to 1 blank row in a table to deal with this kind of formatting.
But you can find by position (the n'th block in a sheet) using the mode and rank settings
And you can also modify the tolerable blank columns and rows
to be able to even find tables with this kind of formatting
But the defaults should work for most cases.
You'll notice a number of new Icons associated with each Dicer.
These are grayed out in the Standard edition, but become active when you have a current Pro Subscription.
To select filtering by color, select this icon.
and this happens
This example, which has some colors selected in one Dicer, but nothing in another
If a value is selected as well
Giving this result
You can convert back to an And Dicer with this icon
Normally rows that match selected values are shown. However you can change Dicer behaviors to hide (as opposed to show) matching rows with this icon.
So this selection and options
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Add-ons >