Spreadsheet functionality
This article covers the spreadsheet basics and functionality.
Last updated
This article covers the spreadsheet basics and functionality.
Last updated
Copyright © 2019 - 2024 InfoSol Ltd. All rights reserved.
When cells are selected, a blue box identifies the selection, and clicking and dragging will select a range of cells, highlighting the selected area in a larger blue box.
Rows and Columns can be added and removed from the spreadsheet in its entirety. This can be done in a few ways:
Select the Row - by right-clicking on any of the row numbers, a menu will appear to "Insert Row" or "Delete Row"
Select the Column - by right-clicking on any of the column letters, a menu will appear to "Insert Column" or "Delete Column"
Select the cell - by right-clicking in a cell, a menu will appear and give options to insert/delete a Row or insert/delete a Column.
Inserting a row or a column will insert before the selected range i.e. the selected row will shift down and a row will be added; the selected column will shift to the right and a column will be added
Cells can be copied (Ctrl+C) or cut (Ctrl+X) and pasted (Ctrl+V) throughout the spreadsheet.
If a cell contains a formula or is bound to a component, Copying and Cutting cells will have different behaviors when pasted into their destination.
Copying cells will keep the data in the original cell and move a copy of the information to the destination. This does not affect components bound to the original values. If the cells contain a formula, then the pasted formula will update cell references based on its new location
i.e. A1 has the formula =B1+1. If copied and pasted into A3, the pasted formula will be B3+1.
Cutting cells will clear the data in the original cell and paste it into its destination. Any future attempts at pasting will behave as though the original cell was copied. If a cell is cut, pasted formulas will retain their original cell references and any components bound to that cell will update to the new cell location.
Named ranges can be set in the Squirrel spreadsheet, very similar to Excel and Onedrive. A single cell or range can be selected and then can be labeled using the input at the top-left of the spreadsheet. After being entered, the named range will be added to the dropdown.
Once a named range has been made, it cannot be deleted or edited. Squirrel is exploring enhancements to named ranges in a future build.
The Squirrel spreadsheet offers basic formatting options that allow for easy customization of cells, including font size, color, borders, alignment, and number formatting.
Font - to apply a font to the spreadsheet cell, select the desired cell and expand the dropdown to adjust the font
At present, there is only one font available - Open Sans. This is subject to improvements in future iterations of Squirrel.
Font Size - applies and changes the font size of the data in the selected cell(s)
B I U - applies Bold, Italic, and Underline formatting to the selected cell(s)
Font Color - applies a font color to the selected cell(s). After selecting, Quick Apply is enabled by just selecting the option and not the dropdown
Cell Fill - applies a color fill to the selected cell(s). After selecting, Quick Apply is enabled by just selecting the option and not the dropdown
Cell Borders - applies border options to the selected cell(s). Select the dropdown for more border options.
Left/Centre/Right Alignment - applies left/right alignment to the data within the selected cell(s).
Top/Middle/Bottom Alignment - applies top/bottom alignment to the data within the selected cell(s)
Text Wrapping - enabled text wrapping for data within the selected cell(s).
Number Formatting - applies number formatting to the data within the selected cell(s).
Increase/ Decrease Decimals - increments/ decrements the number of decimal places for a number value in the selected cell(s).
As the basis of project calculations, the Squirrel spreadsheet has function and formula capabilities with over 300+ formulas available to use.
For more details on available functions and formulas in Squirrel, check out the Supported Spreadsheet Functions article.
Inserting a formula into a cell is very similar to other spreadsheet tools. To start writing a formula, enter "=" after selecting a cell. The formula bar has autofill capabilities with a dropdown populating as text is entered, offering a list of available functions.
After a formula has been entered, a tooltip will populate with steps and information required for the formula to be calculated.
Formulas can be entered either directly in the cell or by selecting the cell and entering with the formula bar above.
Squirrel has a feature that allows for easy identification of formulas within the spreadsheet. After a formula has been entered and completed, an arrow will appear in the top left corner to identify that this cell contains a formula:
If the referenced cells change and cause the formula to recalculate, this will be identified by the arrow turning blue:
If the spreadsheet refreshes and other formulas update, but this one doesn't, then it will revert to grey once more.
