Squirrel Release Notes
Version 1.11
Scenarios – Save and retrieve snapshots of your published model
The new scenario component lets you define ranges in the spreadsheet that can be saved and restored by the end-user. Choose whether this should be saved locally (on the end-users machine) or in the cloud for all viewers of the published project to access.
New Help Centre – In product help…
Get access to help articles, tutorials and guides from within the Squirrel designer. Complete with a nifty search feature that lets you find the help you need.
Installer improvements – non-admin install and notarized mac installer
The Mac version is now fully notarized (great news for all the mac users out there!) and we’ve made it possible to install on windows without needing admin privileges.
Chart enhancements – Messy tooltips are a thing of the past
Our new single tooltip cleans up your charts so that you don’t need a separate tooltip for every series. And we’ve added vertical gridlines too, giving you more control over how you style your charts.
70+ bugs fixed including:
-
-
- Delete and duplicate items went missing from the right-click menu after a datasheet was added
- Spreadsheet export fails with an off-screen error when functions have the wrong number of arguments
- Chart alerting colours not updating properly when bound to the spreadsheet
- Date picker rendering issues
- INT function does not treat Boolean values like Excel
- Crash when data mover is bound to a single cell
- Default setting not always working on Toggle switch
- Value input does not display its value when selected and text colour bound to a cell.
-
Version 1.5.12
High DPI improvements
-
-
- We’ve fixed an issue where larger projects viewed on high DPI screens (retina, 3k, 4k, etc) were not rendering properly.
-
Version 1.5
Loading performance
Larger projects’ outputs could take a while to load. We’ve made some big changes to the way we are generating the exported/published content. As a result, any newly generated outputs should load in the browser much quicker now.
And for those really huge projects, a loading indicator has been added so that the user knows something is still happening.
Value input changes
We’ve made some changes to the way percentages are handled. With number formatting set to percentage, we now insert the value as a decimal instead of a whole number. This makes sure we are handling percentages consistently across all our components and prevents the need to manipulate the value (by dividing by 100) in the spreadsheet.
Note: Projects that were created with Value Input (formatted as a percentage) may function differently as a result. Consider undoing any workarounds you had in place to handle percentages.
New Timer function
Timer is our latest small but powerful function. It can be used to loop something a set number of times or until a certain condition is met. It also allows you to insert a ‘delay’ into your project by deferring data insertion by the number of milliseconds specified.
We squished 56 bugs including:
-
-
-
An annoying issue where the changes indicator (asterisk) didn’t always go away after a save.
-
If you wanted to import a spreadsheet you had to make sure you didn’t have it open in Excel. This is now sorted so you don’t have to close it first.
-
Added number formatting to the y-axis on charts.
-
Dragging to copy/paste (fill) formulas in the spreadsheet resulted in #ERROR if the formula referenced a different sheet. We fixed that.
-
-
Version 1.4.6
More of a ‘tune-up’ than a hotfix
-
-
- We’ve been working on optimising when and how we update formulas in response to data changes.
- Fixed a bug where Squirrel crashed on exiting debug under a specific set of conditions.
-
Version 1.4
Web View
The new Web View component is a versatile component. First and foremost, it allows you to embed web content into your Squirrel project; secondly, multiple people can work on one project at the same time; and thirdly, you can create reusable components that can be used in multiple projects.
External Parameters
We’ve added outbound parameters. So, you can now send and receive data using the external parameters function. This opens up a world of possibilities for passing data into, and out of, your projects.
Spreadsheet binding
You can now type directly in the ‘Select your range’ field when binding. It’s a small enhancement that should make your binding workflow a bit easier. You no longer have to click and drag to select the range each time which means you can make small adjustments easily to your copy and paste ranges.
XLF migration removed
We squished 51 bugs including:
-
-
-
Charts and horizontally structured data had a bit of a fall out.. We’ve patched things up and they’re best of friends again.
-
Dates in the spreadsheet were converting back to UTC for different timezones. This is now fixed.
-
Unexpected responses from database queries and writeback connectors were causing Squirrel to crash. We’ve stopped this from happening and we’ve improved error handling for connectors.
-
Writeback queries weren’t working properly when parameters contained ‘&’. This is now fixed.
-
-
Version 1.3.16
Hotfix for a number of issues present in some projects
-
-
- Deleting objects that had a bindings cleared/modified could sometimes cause a crash
- Adding a series to an area chart was causing squirrel to crash.
- Lots of gauges in a dashboard could slow things right down.
-
Version 1.3.11
Hotfix for a couple of issues that were found in v1.3
-
-
- Data insertion for Data Mover was only firing for the first series.
- Charts that were bound to data block containing a single series didn’t display as they should.
-
Version 1.3
Spreadsheet enhancements
We’ve added another way to copy and paste: you can now grab the fill handle and drag it over the range that you want to copy to. It will fill based on the active cell and will automatically insert formulas with relative references. It just makes it a bit easier to work with the spreadsheet.
We’ve also enabled the option to export your spreadsheet so you can take it out of Squirrel and do what you want with it.
Zoom zoom
Grid overlay
To help you line things up, you can now switch on (and configure) a grid overlay. It’s visible in Design mode to really help you get the pixel-perfect layout you’re after.
Charts and the new Schedule Viz component
We’re always looking to give you more control over your components: this month we’ve added more functionality to charts, including sorting options on Column and Bar. We’ve also fixed some bugs along the way.
Looking for a way to display data with start and end dates or times? The new Schedule component is just the job! It’s a Gantt ‘style’ chart allowing you to plot date and time ranges against categories or tasks. It’s a useful component that could, for example, help you visualise task/project management or resource allocation.
Export to Excel and PDF
We fixed a bunch more bugs and made further improvements.
Version 1.2
Spreadsheet enhancements
Connectors
More multi-select
Charts
External Parameters function
We fixed a bunch of bugs:
-
-
- Data insertion for Data Mover was not always triggering when status = value. This is fixed.
- You can now scroll through the sheets to get to those that are outside the visible area of the spreadsheet.
- Improved handling of negative numbers and decimals in the properties panel.
- Stopped Squirrel from crashing when binding scorecard headers to a different row.
-
Version 1.1
Spreadsheet enhancements
Squirrel’s spreadsheet capabilities are growing all the time. You can now insert and delete columns and rows from a right-click context menu.
Start page options
99 bugs fixed including:
-
-
- Fixed an issue where the tooltips on charts sometimes displayed ‘NaN’.
- Slider component now lets you set a max value greater than 100.
- Some decimal values were being converted to dates in the spreadsheet. We’ve stopped that from happening.
- Binding the selected item property on the scorecard is now working as it should.
- Fixed some problems where data insertion was not always triggering after updating the selected item.
-
Version 1.0
Squirrel V 1.0 officially released!
After working hard for the past 18 months and going through a rigorous Beta phase we are bursting with pride to officially launch Squirrel to the public.