A new type of sheet for your Excel Online and Googles Sheets connectors, Datasheets grow with your data so you no longer need to guess the size of your destination range. They also allow you to fetch data at design time, making it quicker and easier to design and build projects.
When you configure either of these connectors you now have an additional option to create a new “data sheet” to contain the data.
Datasheets are specifically designed and optimised to hold dynamic data read in from connectors. They work in much the same way as any other sheet but are auto-generated. You don’t have to select a fixed range for the data as the full dataset is always read into the sheet.
It’s important to note that Datasheets are read-only. This means that you can reference them in formulas and components, the same way as you would for standard sheets, but It is not possible to insert data into them from a component. Nor can you edit their contents directly. The Datasheets are slightly greyed out to serve as a reminder of this.
Syncing/fetching data at design time
Drop shadow option for shape components
These are controlled by the Effects section of the Styling drawer in the property sheet.
Selecting “Drop Shadow” from the dropdown displays various options to control the styling of the shadow.
The X and Y offsets are used to alter the position of the shadow, positive values move the shadow right and down, negative values move it left and up.
Navigation key combinations (PgUp, PgDn, Ctrl-Home) now active in the binding dialog
It is now possible to use the PgUp, PgDn and Ctrl-Home keystrokes to move around the spreadsheet when choosing a binding range for a property.
Faster loading of the project manager
The main view in the Project Manager could be really slow to load when rendering lots of projects. This has been significantly improved and loads in a fraction of the time.
Over 70 bugs were fixed in this latest release including:
- Errors preventing spreadsheet export
- Scorecard can crash when entering data using different column headers
- Rebinding a data mover source can cause a crash
- Data mover in column mode does not always move the correct column
- Removing components from a container and attempting to group caused sqrl to crash
- Scorecard Appears Different in Preview and Runtime
- Data table is not always showing values
- Boolean values not treated as in Excel
- Scaling issues with sliders
- Slider sometimes wrongly shows 0 in preview
- Deleting rows/columns sometimes inserts them and vice versa (due to reverse selection)
- Fill operations should not work in the bind spreadsheet
- SUM function is adding string values to the total