Spreadsheet Server v24.2 Release Notes

This release introduces an improved user interface for the Query Designer, enhancing efficiency and maintaining consistency with Spreadsheet Server’s Excel functions.

Spreadsheet Server now uses an updated message box to show information, warnings, and errors throughout the application.

When executing a GEXD formula, the application retains columns without data. Empty columns are not overwritten for cell, range, or table target types.

When using query formulas, you can now filter by HSegment ad hocs using the Locate Segment function. By default, it uses the HSegment file associated with the profile.

To use the Spreadsheet Connect function, you must now select the Enable Beta Features check box in the Spreadsheet Server Settings panel. This feature is no longer available by default.

The About tab in Spreadsheet Server Settings, Query Designer Settings, and Application Configurator Settings now displays whether you are using the Legacy or Platform version of the application.

This version creates a separate log file for each user in C:\Users\username\AppData\Local\insightsoftware\Spreadsheet Server Suite\Logs to address any logging delays with large database files.

The Spreadsheet Server installer and the Register Addin app now place the SSServer.xll OPEN entry at the top of the list of Excel add-ons in the Registry Editor. This adjustment resolves any issues related to opening Spreadsheet Server in Excel.

The InstalledPath and AcceptedEula settings have been moved from the DotNetSecurity and PersonalSettings files to the registry for effective management.

To reduce the calculation time for larger workbooks, you can now uncheck the Enable full calculation option in the Distribution Manager Settings panel.

The Distributor Formula Assistant now functions correctly within the Word add-in.

• The GEXD formula successfully returns results for blank parameters, just as when you run the query in Query Designer.
• The GEXD formula no longer runs into an ODBC error when selecting the query in Formula Builder or when executing the report.
• Data in the rows underneath GEXD target type ranges is now maintained.

This version resolves the issue of incorrect balances being returned for Movex customers.

JDE users can now group by segments containing an @ field in the summary drill down results panel.

The Spreadsheet Server context menu (right-click menu) now functions correctly when the Excel Page Break Preview mode is active.

If the JDE security is required for this configuration checkbox is selected while adding the JDE connection in Application Configurator > Application Settings, Spreadsheet Server will not retrieve data in Excel unless the user’s Application User Name is listed in JDE security.

Users can successfully export records to Excel and PDF from the Result Viewer panel after executing queries.

This version resolves the following issues encountered with the Distribution Manager:

• The Hide zero lines and Ignore GEXQ checkboxes in the Specify Worksheets section of the Maintain Specifications panel now function correctly.
• The One email for all recipients checkbox in the Email tab also functions correctly.

The Profile Scheduler successfully distributes reports at the scheduled time. Spreadsheet Server automatically logs into SAP, ensuring that the generated reports include the updated data.

This release resolves the database connection issue related to the connection string configuration that Epicor customers encountered within Query Designer. As a result, users can now successfully view tables and run queries.

When drilling down on a GXL formula, all the configured account segments now appear correctly in the Drill Down panel. There are no missing segments, allowing users to successfully perform both first and second-level drill down functions.

This release resolves the issue of Excel becoming unresponsive when executing a GXE formula. Users can now successfully execute the GX formula with the target type set to row, table, or range.

The option to clear cache and recalculate when Excel starts has been removed from the Spreadsheet Server Settings panel to resolve performance degradation issues.

The compatibility issue encountered with Excel 2016 32-bit is resolved, ensuring smoother performance for legacy users.

The PersonalSettings file copies over correctly to a user’s AppData folder, ensuring that the formulas and reports run without any issues.

Users will no longer experience Excel freezing or PC slowdowns when drilling down into a formula.

Spreadsheet Server updated the doc assist chat window’s default size to fix the width issue.

Users with a DSN connection to the ComputerEase database can now use partial wildcard and range syntax to retrieve account segments in GXL formulas without any errors.

In v24.2, Formula Builder accurately loads account segments, displays designer GLs in the Source field, and enables users to drill down into formulas by establishing a successful connection to the Lawson database.

In this version, the second-level drill down no longer converts the KEY2 value to lower case. Lawson and Viewpoint ERP users can drill down to journal from within the Drill Down panel, rather than solely from the ribbon.

This version resolves the issue related to expanding GL rows and drilling down on GXL balances for SAP users. The application now correctly identifies the number of account segments for different ledgers during the drill down process.

SAP users can adjust the Drill Down Timeout field in the Spreadsheet Server Settings panel based on data volume to ensure successful drill down actions for the CO ledger. It is recommended to set the timeout to 60 seconds.

The Enable Beta Features checkbox in the Spreadsheet Server Settings panel provides users access to the new interface for all the settings panels. v24.2 resolves the following issues associated with the new UI.

• This version fixes ad hoc query display issues in the Spreadsheet Server Settings panel.
• The Delimiter for separating from/to values in a range field in the Spreadsheet Server Settings panel now correctly displays the options as radio buttons, rather than an input field.
• Other enhancements to the Spreadsheet Server Settings panel include improved textbox styling, adjustments to the default panel size, and refined content placement.

When setting up a new SAP connection in the Application Settings tab, the Connection Type drop-down list now defaults to SAP NetCo 3.0 and not Legacy SAP GUI.