Spreadsheet Server v23.1 Release Notes

As you drill down on a new or existing formula, the values in the second level drill down now display the thousands separator commas. This is in consistency with the first and third level drill down function.

When you create a one-word Alias, without space or any numbers, the field name no longer displays in upper case.

GXL formulas now run successfully as the JD Edwards connection types SQL Server, Oracle, and iSeries correctly use LTRIM(RTRIM()).

As you drill down on a new or existing formula, the values in the second level drill down now display the thousands separator commas. This is in consistency with the first and third level drill down function.

When you create a one-word Alias, without space or any numbers, the field name no longer displays in upper case.

GXL formulas now run successfully as the JD Edwards connection types SQL Server, Oracle, and iSeries correctly use LTRIM(RTRIM()).

This release modifies the errors in the display of text and values in the Drill Down Result Viewer and Query Designer.

Running a GEXD formula no longer displays the ‘Connection not found’ error in the View Log. The query runs successfully in Excel as the connection exists in the Application Configurator and the query works in the Query Designer.

To seamlessly work with the Formula Builder in Excel, you can now Shift-click to display the context menu and then select Move to move the window on your screen. The context menu does not display by default as enabling it can disable resizing. This feature remains similar to moving error logs, settings, and other windows on your screen.

You can successfully run a GEXQ formula in Excel and receive the correct result. It works without errors, just like running the summary for a query in the Query Designer.

When you select the JD Edwards Ledger in the Formula Builder, you can now successfully create a GXL. The segments display correctly.

You can now view the Segment Values for the JD Edwards Ledger in Locate Segment even as you set Oracle JDE configuration as the default connection in the Application Configurator.

As you sign in and load a BPCS Local Database in Spreadsheet Server Settings, reporting from the Local BPCS Database does not result in an error with the first level drill down.

The ‘Error Initialize SSApp’ error no longer displays when installing and configuring the v23.1 Application Configurator. This error was specific to the Application Configurator install only and not the installation alongside Spreadsheet Server.

Fresh installs no longer error out when the install does not successfully create SSSettings.xml.

You can now successfully create new training and production environments in the Application Configurator. This fix is specific to non-Platform customers.

When upgrading to v23.1, the scheduled tasks created in an older version remain unaffected. You will not receive an error message related to the update of scheduled tasks during the installation process, the Profile Scheduler runs these tasks successfully post the upgrade.

When you run a query in the Query Designer, the parameter that passes into the auto-generated SQL code no longer removes single quotes around ‘&PARMXX’.

As you upgrade from v20.2 to the later versions, workbooks that were previously running now return accurate data when you clear cache and recalculate. There is no discrepancy in the data post the upgrade.

When you close an Excel workbook with data retrieved from Spreadsheet Server, a blank workbook does not reopen. The application closes as usual.

This version of Spreadsheet Server provides an efficient method of executing the GXLs to improve the performance for Custom GLs by reducing the initial calculation time when opening a workbook.

Running a GEXD formula no longer displays the ‘Connection not found’ error in the View Log. The query runs successfully in Excel as the connection exists in the Application Configurator and the query works in the Query Designer.

To seamlessly work with the Formula Builder in Excel, you can now Shift-click to display the context menu and then select Move to move the window on your screen. The context menu does not display by default as enabling it can disable resizing. This feature remains similar to moving error logs, settings, and other windows on your screen.

You can successfully run a GEXQ formula in Excel and receive the correct result. It works without errors, just like running the summary for a query in the Query Designer.

When you select the JD Edwards Ledger in the Formula Builder, you can now successfully create a GXL. The segments display correctly.

You can now view the Segment Values for the JD Edwards Ledger in Locate Segment even as you set Oracle JDE configuration as the default connection in the Application Configurator.

As you sign in and load a BPCS Local Database in Spreadsheet Server Settings, reporting from the Local BPCS Database does not result in an error with the first level drill down.

The ‘Error Initialize SSApp’ error no longer displays when installing and configuring the v23.1 Application Configurator. This error was specific to the Application Configurator install only and not the installation alongside Spreadsheet Server.

Fresh installs no longer error out when the install does not successfully create SSSettings.xml.

You can now successfully create new training and production environments in the Application Configurator. This fix is specific to non-Platform customers.

When upgrading to v23.1, the scheduled tasks created in an older version remain unaffected. You will not receive an error message related to the update of scheduled tasks during the installation process, the Profile Scheduler runs these tasks successfully post the upgrade.

When you run a query in the Query Designer, the parameter that passes into the auto-generated SQL code no longer removes single quotes around ‘&PARMXX’.

As you upgrade from v20.2 to the later versions, workbooks that were previously running now return accurate data when you clear cache and recalculate. There is no discrepancy in the data post the upgrade.

When you close an Excel workbook with data retrieved from Spreadsheet Server, a blank workbook does not reopen. The application closes as usual.

This version of Spreadsheet Server provides an efficient method of executing the GXLs to improve the performance for Custom GLs by reducing the initial calculation time when opening a workbook.

You can now dynamically add new license types to the product. This is specific to Platform customers.

You can now select multiple rows on the View Logs page by using your Ctrl option on the Keyboard.

You can now select the rows on the View Logs page by using Shift and then down arrow option on your Keyboard.

You may now view seconds on the logs page in addition to date, time, and minutes.

You can now view the advanced columns, Method and Class, by enabling the Advanced View option on the logs page.

You can now select the multiple rows on the View Logs page by using your Ctrl option on the Keyboard.

You can now select the rows on the View Logs page by using Shift and then down arrow option on your Keyboard.

You may now view seconds on the logs page in addition to date, time, and minutes.

You can now view the advanced columns, Method and Class, by enabling the Advanced View option on the logs page.

Date Conversion dropdown has been added back to the Expression Builder window.

You can now save the resized SQL and parameters windows in Query Designer from Query Designer Settings.

You can now use Graphic Type as a parameter in excel while using Query Formulas.

You will be notified through email if a distribution is complete, when you enable Send email notification for task failures available under Notifications.

Using Profile Scheduler, you can now distribute only selected rows instead of the entire worksheet.

You will now be notified if you try to turn off your computer while the Profile Scheduler tasks are still running.

You can now distribute the reports from the desired email ID by selecting the destination type as email on the Maintain Specifications page.

You can now export the logs to the desired location local machine using the Export All button available on the Log Viewer page.

While upgrading Spreadsheet Server, select Modify Install to abort the upgrade process if the following files are running:

• Excel.exe
• Application Configurator.exe
• GSI_Sched.exe (Profile Scheduler)
• QueryDesigner.exe
• Spreadsheet Server Control Panel.exe

If you click Locate Segment to look for segment values for the GL Ledger Type: BPCS 6.04, the description field returns the description for the code value.

Date Conversion dropdown has been added back to the Expression Builder window.

You can now save the resized SQL and parameters windows in Query Designer from Query Designer Settings.

You can now use Graphic Type as a parameter in excel while using Query Formulas.

You will be notified through email if a distribution is complete, when you enable Send email notification for task failures available under Notifications.

Using Profile Scheduler, you can now distribute only selected rows instead of the entire worksheet.

You will now be notified if you try to turn off your computer while the Profile Scheduler tasks are still running.

You can now distribute the reports from the desired email ID by selecting the destination type as email on the Maintain Specifications page.

You can now export the logs to the desired location local machine using the Export All button available on the Log Viewer page.

While upgrading Spreadsheet Server, select Modify Install to abort the upgrade process if the following files are running:

• Excel.exe
• Application Configurator.exe
• GSI_Sched.exe (Profile Scheduler)
• QueryDesigner.exe
• Spreadsheet Server Control Panel.exe

If you click Locate Segment to look for segment values for the GL Ledger Type: BPCS 6.04, the description field returns the description for the code value.

Data pulled using Journal drill down now contains thousands separator.

You can now change the location and size of the query designer window.

You can now insert a graph in a workbook and distribute the workbook without running into any errors.

Data pulled using Journal drill down now contains thousands separator.

You can now change the location and size of the query designer window.

You can now insert a graph in a workbook and distribute the workbook without running into any errors.