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)