Squirrel Release Notes
Hotfix for an issue with sliders
As part of the work done on the slider component in 1.7, .sqrl files containing sliders that were created in earlier versions of Squirrel were automatically converted. In some cases, this conversion process caused problems in the file. This hotfix addresses that issue by correcting the file (if it contains the problem) and ensuring that the conversions are correct going forward.
Hotfix for a few issues in 1.7
- Added dynamic visibility to labels automatically created for older spinner and slider components.
- Fixed an issue we introduced in 1.7 where absolute references ($) were not being preserved in conjunction with cut/paste operations or deleting columns/rows.
- Squished a bug where chart data that was bound to a range beyond column Z (AA onwards) caused a crash.
- Undoing an action to add a new series caused a crash.
- Local publishing was crashing for users on a trial license. We’ve fixed that!!
Important information relating to the Slider component
In 1.7 support for the ‘enable range’ option to turn a single slider into a dual slider has been temporarily removed. This capability will be re-introduced in a later version. If this is a requirement for you please let us know and stay on version 1.6 for the time being.
Also, in this release, we have fixed a number of issues that were causing issues with the sizing and alignment of sliders. The result of this is that when a project saved from an earlier version of Squirrel is opened in 1.7 positions of sliders may have changed slightly and may need to be manually repositioned.
Additionally in 1.7 support for “end values” has changed. In previous releases the “end value” option for a slider would add a text label outside the bounds on the slider to indicate the currently selected value, as in the image below:
As a result, 1.7 no longer has the option for the slider to display an integrated end value. If you need to display an end value for a slider this can be done by adding a separate text label and binding it to the same cell as the slider.
Projects which were created in previous versions of Squirrel will be automatically updated when opened in 1.7 to split the end value into a separate text label. You may need to make small adjustments to the position of this label to make the project look exactly as it appeared in the previous release.
Important information relating to the Value Input component
We have added the ability to style the numbers in the input field.
However, support for “labels” has changed. In previous releases, the “label” option for a value input would add a text label to the left of the main component.
However, similar to sliders (above), this caused issues for sizing and alignment of components. As a result 1.7 no longer has the option to add an integrated label. If you need to display a label for a slider this can be done by adding a separate text label and positioning it appropriately.
Projects which were created in previous versions of Squirrel will be automatically updated when opened in 1.7 to split any value input labels which were present into a separate text label. You may need to make small adjustments to the position of this label to make the project look exactly as it appeared in the previous release.
Add-on Components and Functions
We’ve introduced the framework for add-on components and functions for Squirrel. You’ll see this in the designer in the form of both a new icon in the component library and a new function. For now, it’s just the plumbing required to make these things work, but watch this space as we further roll this capability out over the coming weeks and months.
Let us know If there is a particular component you would like to see as an add-on or if you are interested in joining our component developer program.
Designer workflow improvements
Undo/redo extended to bindings and the spreadsheet
Undo and redo (both from the edit menu options and the keystrokes ctrl-z, ctrl-y) have been extended to cover bindings and spreadsheet activity.
Note: all actions are managed in a single list. So whether actions take place on the canvas, in the property sheets or the spreadsheet they are all undone in turn in the reverse order to originally taking place.
Size matching actions available from the “align” toolbar
The “Make same width”, “Make same height” and “Make same size” actions are now available from the rightmost icon on the toolbar at the top of the property sheet as well as from the “Arrange” menu.
- Added styling and formatting for the Value Input (spinner)
- We’ve made it possible to change the orientation of the X-Axis labels on a bar chart.
- All charts (except pie charts) now have animation options to control if, when and for how long animation occurs. The options are available via a new ANIMATION sub-section of the GENERAL settings
- There’s a new option to “Update value real-time” on Text Input controls. Turning this on will cause the spreadsheet cell to be updated with each keystroke, not just when the whole entry is complete or the field loses focus. The setting is available in the DATA INSERTION section of the property sheet.
Trigger a data mover when a spreadsheet cell changes (previously it was only possible when a cell was set to a particular value)
We’ve added support for removing and changing password protection on generated PDF’s these include:
- Password to open
- Password to edit
- Allowing editing
- Allowing copying
Spreadsheet workflow enhancements
To make working with the Squirrel spreadsheet easier we’ve been fine-tuning added a number of enhancements and new features including:
- Improved Rebind workflow (get straight to the bind screen to rebind or clear the input field and confirm to remove)
- Added support for Page Up, Page Down and Ctrl+Home navigation keystrokes in the spreadsheet
- Delete sheet warning
Copy spreadsheet data from Debug mode
You can now copy (ctrl+c) data from the spreadsheet to the clipboard during debug.
Copied values can then be pasted (ctrl+v) into the spreadsheet in design view (useful for grabbing sample data from a connector).
Spreadsheet Formula helper
Typing in the formula bar now pops up a list of matching functions.Use the cursor keys or a single click to select an item in the dropdown to see a description
With the required function highlighted you can double click or press “tab” or “return” to insert it and display the syntax/arguments. No more popping back into excel to remind yourself how to structure a VLOOKUP!!
This new connector lets you retrieve data from your SAP BusinessObjects system using “Query as a web Service” (QaaWS).
Revised start page and improved onboarding
An all-new start page experience. From here you can access recent files, browse a list of available templates, select from popular pre-canned sizes for your project or app. Get easy access to help and tutorials and discover what’s new in Squirrel365.
We squished over 190 bugs including:
- Column and bar charts scale truncated with negative numbers
- Scorecard – editing cells with thousand separators enters a bad number
- Listbox selected item does not work if the items are numbers
- Listbox selected item not working if “Include ALL item” selected
- ROW and COLUMN functions not working
- EOMONTH function not working properly
- Data table not inheriting some formatting in the first row of the table
- Line component does not always update its position when x and y are dynamically bound
- Dropdown near bottom of a project (not in container) scrolls the whole canvas
- Bar/Column Chart series opacity doesn’t work
- BIWS crashes when invalid WSDL entered
- Unable to Export Spreadsheet due to colour formatting
- Crosshairs remain visible when the “Chart cursor” option is disabled
Hotfix for a few issues including a problem where the app would sometimes crash on startup
- Updated the order of stuff when Squirrel fires up. It should now be much more robust on startup.
- Squished a bug where some cell references weren’t updated at design time, after copying and pasting in the spreadsheet.
- Fixed an issue with the list box where binding the selected item to multiple cells was causing an ‘Ooops screen’.
Hotfix for issues when publishing locally
- We’ve restored the ability to double click on index.html and launch the project locally
- Fixed an issue where the exported projects wouldn’t run on Linux webservers
- EULA updated.
For the initial release of Squirrel 1.6 exported projects will only work when they are accessed via a web server. This means that unlike previous version it will not be possible to run a Squirrel project exported from 1.6 by double clicking on “index.html” of a project stored on a file store. We plan to release an update in the near future which will restore this capability.
New and enhanced components
We’ve added 2 new components; Data Table and Hotspot.
Data Table lets you pull the formatting from your spreadsheet through into the table component on the canvas. That means cell-based formatting!!
Hotpsot is an invisible component that allows your project to respond to “mouse over” and “mouse out” events. This means your project can now respond as the user drags their mouse across the screen, perhaps to provide a pop-up help bubble or to change a related aspect of the project elsewhere on the screen.
We’ve also made significant improvements to the line component which now easily allows horizontal, vertical and diagonal lines to be added to a project.
Enhancements to other components
- added the ability to optionally turn off the tooltip on a slider
- added number formatting for the slider
- added an “ALL” option to a multi-select listbox
- stopped containers from blocking mouse interaction with components underneath them.
Autosave and preventing designer restarts
It is very frustrating when Squirrel encounters an issue which means that you have to restart the designer potentially losing work you have done on your project. To counter this we have fixed over 30 issues which lead to this situation and in addition, we have added an autosave feature which will recover your project if the designer needs to be restarted. No action is required on your part, if the designer does need to restart then after it does you will be prompted with a message asking you if you want to recover the latest version of your project.
We have added support for a couple of new spreadsheet functions, namely, IFERROR, IFS and LOG and overhauled spreadsheet date handling. Additionally, we have made enhancements and fixes to a number of others, including:
TODAY, HOUR, MINUTE, SECOND, DATE
IFERROR, ISERR, ISNA, IFNA
Spreadsheet workflow enhancements
To make working in the Squirrel spreadsheet more natural and closer in operation to other spreadsheets we have added a number of enhancements which should make things flow more smoothly, including:
- Cursor keys can be used to create formulas
- Cursor keys are now active when binding cells in the spreadsheet
- Hitting the return key now actions a bind operation
- Cut and paste of cells and insertion and deletion of rows and columns updates dependent formulas and component bindings
- Ctrl-r and ctrl-d will respectively copy the first cell across or down a selected range
- Holding down the control key modifies the cursor keys to move the selected cell to the beginning or end of the next block of data (this also works whilst holding down the shift key to extend the selected range)
Designer Workflow Enhancements
To help save you time in the designer we have added the following enhancements to streamline your workflow:
- ability to select multiple objects in the canvas using click and drag
- ability to size a component as you place it on the canvas
- shift-click and ctrl-click selects multiple components in the object browser
- multiple objects can be moved together in the object browser
- holding shift when dragging objects on the canvas constrains their movement to horizontally or vertically
- holding shift when re-sizing a component on the canvas maintains the ratio of height and width
- menu items on the “Arrange” menu to move components backwards and forwards on the canvas.
Prior to 1.6 the fullscreen scaling option when applied to exported project meant that the project would anly scale if the browser window was larger than the original project canvas size. From 1.6 onwards scaling will also happen when the browser window is smaller than the original project
We obliterated 100+ bugs including:
table columns not sorting correctly
exporting a spreadsheet could leave #REF references in formulas
exporting a spreadsheet mapped all named ranges to the first sheet
number formatting to zero decimal places not working in pie chart labels and tooltips
High DPI improvements
- We’ve fixed an issue where larger projects viewed on high DPI screens (retina, 3k, 4k, etc) were not rendering properly.
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.
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.
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.
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.
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.
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.