Improvements and fixes

Improvements

• Improved the output of all MONTHSTO and related formulas to auto format as dates
• Improved performance 10x in workbooks with array operators and functions
• Improved handling of QuickBooks queried output when columns contain no information
• Improved formula evaluations on hover for formulas referencing infinity sheets
• Added REGEXEXTRACT formula
• Added DAYSTO/DAYSFROM formulas

Fixes

• Fixed an issue where queried data may return as a mixed type (string and number)
• Fixed an issue where editing colors in a chart may not apply
• Fixed an issue where QuickBooks results may be truncated due to API configuration
• Fixed an issue where folders may show “lose access” message to workbook owners
• Fixed an issue where dates from a query run may not be recognized as dates
• Fixed an issue with cell editor alignment in formulas
• Fixed an issue allowing for workspace dashboard only access to workbooks in folders
• Fixed an issue where tables may not be filtered to specific database in query builder
• Fixed an issue where SUMIFS formulas may require equals signs for date evaluations
• Fixed an issue where the refresh schema button was missing from Google Sheets connections
• Fixed an issue where charts may show version errors
• Fixed an issue where selecting columns via search would clear search values
• Fixed an issue where running a query on a copy of a connected sheet may crash workbook
• Fixed an issue where infinity sheets may not display the correct last updated timestamp in connections panel and dashboard
• Fixed an issue with pivot table calculated fields when blanks are present in dataset
• Fixed an issue where labeled line legends in charts may not display
• Fixed an issue with table browser UI details
• Fixed an issue with custom number formatting over dates being recognized in charts as dates
• Fixed an issue where conditional formatting may be removed upon refresh
• Fixed an issue where read only users could view but not select run query button