Spreadsheet Server v22.4 Release Notes
This article describes feature enhancements, resolved issues, and important information for Spreadsheet Server v22.4, released on November 15, 2022.
Important Notices
This is the first release of the Spreadsheet Server documentation using a unified UI from insightsoftware. The documentation reflects the standardized look and feel of all insightsoftware products going forward.
forward.
Spreadsheet Server v22.4.1 Feature Enhancements
| Title | Description |
|---|---|
| Web Logs | Web LogsYou are now able to extract logs from the Log Viewer even if you do not have access to Outlook.From any log page, select Export All. Spreadsheet Server creates a log file on your computer. You can then email that log file using your own client. |
Spreadsheet Server v22.4.1 Resolved Issues
| Title | Description |
|---|---|
| Query Designer: Views | You now can see the Views and Synonyms in Query Designer after upgrading to the Oracle R12.2.x database. |
| SageX3/Sage300 | Customers using Sage300 and SageX3 can now use the Expand GL Rows by Segment without getting an error message. |
| Logs | You can now view logs in your Profile Scheduler and Distribution Manager without seeing an error message. |
| Installation | You can now uninstall and reinstall Spreadsheet Server v22.4 normally, without being continually asked to reboot your computer. |
| SQLite/Cloud Connector | NetSuite customers with Desktop replication can now successfully use the Cloud Connector to connect to their SQLite database. |
| Convert Formulas | Convert All Formulas on Distribution Manager now works when you have Cells referencing Other sheets. |
| GEXD | You can now successfully run a GEXD in Excel, where the connection is a SQL server type set to prompt for input and the username and password field are both blank in the application configurator. |
| Distribution Manager | Documents are now distributed if they contain leading spaces. Spreadsheet Server now uses auto-trimming to remove extra blank spaces. |
| Error Logs | Spreadsheet Server customers can now clear logs using the Clear Logs option in the View Logs drop down menu. |
Spreadsheet Server v22.4 Feature Enhancements
| Title | Description |
|---|---|
| Expand and Collapse Segments | In version 22.3, you were provided the ability to expand segments, including columns using the Ribbon. With this enhancement, you can now collapse the segments by selecting the Collapse Segment icon. |
| Spreadsheet Server and Click-To-Run Office | Spreadsheet Server is now compatible with Click-To-Run Office. |
Print Updates |
You can now print from Drill down, Ad hoc, and Sub-query drill down screens. You can also select cells and customize how they can be printed. |
| Epicor Installation Updates | If you are a new Epicor customer, you will get base/default installation and configuration files when you run the installer. |
| Sign Out Functionality | You are now able to Log Out of the platform functionality in insightsoftware desktop applications. |
| Performance Update | You can now access your Performance configuration from your Tools. |
| Ribbon Update |
New icons have been added to the Spreadsheet Server Ribbon. |
| Query Designer: Alias | You can now use Alias as a number in Query Designer. |
| Query Designer: Shell Commands | You can now use a Shell command to view file system images. |
| Query Designer: Printing | You can now use the Print Previewer in the Query Designer results container. |
| Query Designer: Test Query | Your Query Designer Run and Test Query buttons will be dimmed until you have an actual SQL statement available. |
| Query Designer: Home Page | We have updated the Query Designer home page UI. |
| Query Designer: Data Type | We have added a new Data Type column (called Type) in the Query Designer. If you select a data type for a parameter, Query Designer saves it in the query logic and it will be parsed as the data type you select. If you right-click on a field and add a smart parameter, and if the value is something other than "unknown," Query Designer will use the same datatype. The default parameter type will be blank. |
| Spreadsheet Server Installations | New users now see a Ledger Selection Screen in the Excel add-in with a list matching what was set up during the install. |
| Excel as a Datasource | You can now use Excel Workbooks and the data in worksheets and cells as data used in operations. You can enter the data or copy it from an external source. You can use this feature to perform analysis on custom pieces of data that do not necessarily require a specific structure--besides columns and rows--and does not require a connection to your local machine. |
| View Log | When you elect to view logs from your Spreadsheet Server, you are now brought to a View Log Web UI, instead of an Excel sheet containing the logs. |
Spreadsheet Server v22.4 Resolved Issues
| Title | Description |
|---|---|
| Query Designer: Messaging | If you input operators in criteria, or, if you edit SQL manually (or with auto-generate off) to include operators, Query Designer now provides an error message describing the issue: |
| Distribution Manager | If you do not select a worksheet in the Distribution Manager, Spreadsheet Server now sends all worksheets without displaying an error message. |
| Information Button | You can now select the information button on drill down to view SQL code, instead of a blank Notepad session. |
| Leading Spaces | Spreadsheet Server now generates reports with accurate results when you use leading spaces during report creation. |
| Profile Scheduler | Profile scheduler now can distribute multiple macro-enabled workbooks in a single job. |
| Formula Builder | GSXSales parameters now appear correctly when you enter criteria, highlight the field, and select Formula Builder. Also, you can now select a parameter value, change it, and insert the formula with the changed value present. |
| Distribution Manager | Distribution now works correctly after you convert all formulas to values. |
| Distribution Manager | Documents are now distributed if they contain leading spaces, Spreadsheet Server now uses auto-trimming to remove extra blank spaces. |
| Query Designer | Table lists now load in a reasonable amount of time at first load when the schema is first populated or when you select Refresh. |
| Query Designer | Query Designer no longer changes field text £ to ? with a resultant SQL failure when you open it. |
| GEXD | You can now run and distribute queries that have a date parameter formatted as a date. |
| Query Designer | You can now save changes to .NET files and your Oracle connection will be shown, the DotNetConnection.xml file will now show the changes you have made. |
| Query Designer | The limit rows function for GEXD now works as expected. |
| Drill Down | You can now run GXE with @ field As Summary and multi cell drill down works as expected. |