Squirrel Release Notes

We are regularly improving and adding new features to Squirrel

Version 1.16.10013

  Hotfix for an issue with Excel and Google connectors When previewing or debugging your project with either of the Excel or Google connectors selected in the property panel; the selected oauth credentials were cleared out resulting in an Error: [Object object]...

Version 1.16.10013


Hotfix for an issue with Excel and Google connectors

When previewing or debugging your project with either of the Excel or Google connectors selected in the property panel; the selected oauth credentials were cleared out resulting in an Error: [Object object] message.

We have updated the flow, so that the credentials are not cleared during debug or preview.

Version 1.16.11

  Hotfix for the following issues introduced in v1.16.   Designer crashes when deleting a duplicate container Locally exported projects not loading images correctly (affects v.1.16.8) Main canvas background images not working in PWA (affects...

Version 1.14.7


Hotfix (optional) for a couple of issues


    • Fixed an issue with pie charts not displaying correctly. In some circumstances, they would appear as a vertical title. Only affected charts in containers that are made visible before their parent container.
    • Parameters were being passed to a DB query as undefined rather than null when the cell is empty

Version 1.14


Performance improvements – Faster loading projects

We’ve improved runtime load performance (the time it takes to load the published project) and reduced the length of time taken to open large projects in the designer. We’ve seen files open up to 14x quicker and published projects load up to 19x faster in the browser.

The spreadsheet is getting quicker too. We’ve optimised how the calculation engine runs to get the same results with less processing.


Scrollbars on containers

Make your projects more versatile with scrolling containers. The container component now includes an option to enable scrollbars. Turn this on to get scrollbars appearing.


Conditional logic for Dynamic Visibility

You can now choose to show or hide components based on more than just matching a value. Conditions include:

  • equal / not equal
  • gtr than / gtr than equal to
  • less than / less than equal to
  • is empty / is not empty

We’ve also added the option to ignore the case


Tableau Parameters

It’s now easier to set up and configure parameters for integrating with Tableau. The new Tableau Parameter function makes passing data into your embedded Squirrel projects a cinch.


We also squashed a bunch of bugs including:


      • Tooltips are back on the slider component
      • Clicking on the binding tooltip now changes the active sheet and scrolls the sheet to bring the active cell/range into view
      • Changed the abbreviation for values in charts to use B, rather than G, for billions
      • Fixed a scenario where the designer would crash when using Data Insertion on Bar Chart with sorting applied.

Learn more about the changes in 1.14 here.

Version 1.13.11


Hotfix to stop the designer crashing when adding a line component


      • Fixed an issue where the designer was crashing when adding a line component (only happened when adding it by drawing it to size)
      • Drop down was not setting the selected item in preview (or published output)
      • Radio button blocking selection in filtered rows mode.

Version 1.13.10


Hotfix (optional) to fix legend colours on charts and a couple of minor issues


      • Series colours were not always updating properly in the legend
      • Data table not honouring colours in the spreadsheet
      • Fixed an error where deleting columns or rows could on rare occasions break formulas
      • An issue with lowercase or mixed case named ranges not working properly in formulas
      • There was an issue with webi custom elements not handling single value parameters properly.

Version 1.13.6


Hotfix for an issue on import spreadsheet and charts flickering


      • There was an issue where users reported charts flickering after upgrading to 1.13.5
      • Fixed a prob where data was not coming into the Tableau extension properly
      • Importing spreadsheets could cause absolute cell references to be lost when importing a .xlsx if they were created with auto-fill (grab handle). Read more about this here.

Version 1.13.5


Hotfix for a few issues in 1.13


      • Some users reported blinking/wiggly charts after upgrading to 1.13, we’ve fixed this.
      • Fixed an issue where double clicking on a squirrel file to open the designer would open the wrong file if you already had the Squirrel designer open
      • Sorted a problem where external parameters with missing bindings would cause the designer to crash
      • Scorecard and datatable weren’t respecting column widths settings and column alignment was being ignored
      • Deleting a sheet could sometimes cause a crash>
      • Exporting as .xls where there was a #REF! in the spreadsheet would cause the file to be reported as corrupt.

Version 1.13


IMPORTANT ! – Sqrl file format change

As part of our spreadsheet engine improvements, the format of .sqrl files has changed between versions 1.12 and 1.13.

This means that a .sqrl file saved from 1.13 cannot be opened in 1.12 or earlier versions.

Before you start using version 1.13 we recommend that you take a copy of your sqrl files in their current format in case you need to revert to them at some point in the future. And if you are collaborating with other people on your Squirrel projects, all collaborators should upgrade to 1.13 at the same time so that everyone can open each other’s files without issue.

Launching locally published projects by double clicking on the index.html file will no longer work

In previous versions of Squirrel, locally exported projects could be run directly by opening their index.html file from disk directly in a browser. From 1.13 onward locally exported projects will only run when accessed from a Web server.


Chart improvements – Big changes under the hood

Charts have been updated. We’ve made some big changes behind the scenes which means that charts now draw or refresh faster. Great news for projects that are heavy on charts and it has also allowed us to add a few much-requested features:

  • Grouped bars (or clustering) – grouping series within a category to make charts easier to read
  • Overlay chart
  • Series re-ordering
  • value axis bands
  • log scale
  • legend reflects the series style

The charts have been given a slightly fresher feel by adjusting some of the default settings too. of course you can always style them however you like.


Smart Guides and snap-to

We’ve added Smart Guides (red lines) to help you line things up. Guidelines appear which show you when an object or group is aligned to the centre, top, middle, bottom, left or right of another object. The object will snap to edges and centres too.


Selection box and resizing

The selection box has been cleaned up a little to reduce clutter. When you select an object on the canvas just the corners of the object will have the resize handles but you can hover grab any part of the box (vertical or horizontal) to resize. When doing so a new size info box will appear to show you the dimensions making it easier to precisely size your components.

You might also notice that the components follow the cursor in full now when you drag them instead of only the outline box coming with you.


Groups get dynamic visibility

You can now set dynamic visibility on groups.


Multiple designer instances

We have added support for multiple instances of the designer (windows only).


We squished more bugs including:

      • COUNTIF() fixed to not treat blank as zero
      • Designer crashing in some cases when data insertion source bound to single cell
      • and 80 bugs relating to charts


Known Issue – zoom level reset


If you work with the canvas at a zoom level other than 100% then, when you come back to design mode from debug, you will find that while the canvas remains zoomed but the selection box reverts to a zoom level of 100%. This means that when you select an item its selection rectangle will not be in the correct place.

This can be fixed by reselecting the zoom level (tip: press Ctrl+ then Ctrl- to increase and immediately decrease the zoom level)

Version 1.12.9


Hotfix for an issue with number formatting (issue only present in v1.12.8)


      • Changing the number formatting option to Number, Percentage or Currency with 0 dp’s caused the decimal point to appear
      • Turning on the thousand separator option with 0 dp’s caused the value to disappear altogether.

Version 1.12.8


Hotfix for a few issues in 1.12


      • Fixed an issue with webi connector usage properties disappearing
      • Some people experienced issues changing the source on a webi connector
      • Bar charts had lost their tooltips. We’ve sorted that
      • Tooltips weren’t respecting number formatting with decimal places set to 0
      • Radio buttons were wrapping labels incorrectly in some cases.

Version 1.12


Quick Setup Properties – We’ve simplified setting up components

The new ‘Quick Setup’ panel is a curated set of properties that help you configure, and style, your component quickly and easily. No more wading through sections and subsections to complete the basic setup. Don’t worry though, all the fine control over how a component looks and behaves is still there under the ‘All Properties’ tab

The quick setup properties also include help on each section, accent colours (pick a colour and we take care of the rest including text colour contrast) and text styles.


More font choice and recent colours

We’ve extended the list of fonts available by adding popular google fonts such as Roboto, Montserrat and Ubunto. And the colour picker has been updated to include a list of recently used colours, making it easier to style your projects.


Object Browser – New and improved

When dealing with large numbers of components and groups, it could be hard to find the one you are looking for. We’ve added a search bar to make this easier.  While we were at it we flipped the order of the component list so it now works like other tools where objects at the top are the topmost layer. And a new right-click menu gives you access to perform common actions on one or more selected objects.


Chart enhancements – Abbreviate large numbers

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.


We also squashed a bunch of bugs including:


      • Issues with some currency symbols in charts causing a crash
      • Fixed the border on/off property not working for label based menu
      • Up/down arrows not always working on border-width property

Learn more about the changes in 1.12 here.