What’s new in Squirrel365 v1.14

by | Mar 29, 2023

Performance improvements

Runtime load performance

Load components on demand. There is a new option (on by default) to only load components when they become visible (and therefore active). As a result, any newly published projects should load in the browser much faster now.

File open times reduced

Large/complex projects now open in a fraction of the time.

Calculation engine improvements

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

In version 1.14 the container component now includes an option to enable scrollbars. Turn this on to get scrollbars appearing.

When positioning objects inside the container you need to re-size it, to be able to fit all the objects inside, then re-size it back down to the size you want the scrolling container to be.

Conditional Logic for Dynamic Visibillity

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

The new Tableau Parameter function makes passing data into your embedded Squirrel projects a cinch. You’ll find it under the list of functions.

Simply name your parameters and bind the destination range to the area in the squirrel project where you want the data to come in. They then appear in the list of parameters to be configured in the Squirrel365 add-on for Tableau.

Image fit option on images

Sometimes an image doesn’t fit nicely in the space you want it to occupy. To help with this we’ve added the Image fit option to the image component. Choose between Contain, Fill and Cover to manipulate the image within the dimensions of the component. Using the image fit option cover, the image keeps its aspect ratio and fills the component, clipping the image to fit.

Set the image position using the Image fit position option to control how it should be clipped.

 

Customise sankey styling

You can now change the colour of the text labels on a Sankey chart so that they are readable against a dark background.

There is also the option to stop the text truncating or to have it wrap. Plus you can select which node (From or To) controls the colour of the path.

 

 

That’s about it for our roundup of what’s new in version 1.14. To see these changes in action why not watch this 8 min video of the 1.14 release highlights  here