Skip to main content

Spreadsheet Server v25.4 Release Notes

This topic describes the feature enhancements and resolved issues for Spreadsheet Server v25.4, released on December 10, 2025.

Spreadsheet Server v25.4 New Features and Enhancements

Title

Description

Direct Snowflake Integration

Spreadsheet Server now supports direct connection to Snowflake without requiring ODBC driver installation. Administrators establish connections once in the Application Configurator. All users can then access the connection. This eliminates the need to install and manage drivers on each workstation.

Prerequisites

  • Spreadsheet Server v25.4 or later
  • For Key Pair authentication, administrators must generate a Private Key or Encrypted Private Key

Key Points

  • Available for both Platform and License Key customers
  • Eliminates ODBC driver installation and management on each workstation
  • Administrators configure connections once in Application Configurator for all users
  • Two authentication methods available: Browser SSO and Key Pair
  • Connection appears in the left side menu once saved

For configuration steps, refer to the Application Configurator User Guide in the Spreadsheet Server v25 documentation.

AI Feature Controls

Administrators can now disable AI features within Spreadsheet Server. Organizations can control which AI features are enabled based on internal AI policies and requirements. The default behavior leaves AI features enabled.

Prerequisites

  • Spreadsheet Server v25.4 or later
  • Platform customers have both AI Doc Assist and AI Data Assist options
  • Regular Subscription License Key customers have AI Doc Assist only
  • Maintenance customers do not have AI features

Key Points

  • Default behavior leaves AI features enabled
  • Administrators can disable AI Doc Assist, AI Data Assist, or both features
  • Controls located in Application Security tab under Lineos AI Features Controls
  • Changes require closing and reopening Excel to take effect

For configuration steps, refer to the Application Configurator User Guide in the Spreadsheet Server v25 documentation.

Multiple ID Connection Support

Administrators can now configure specific Application Usernames for individual connections. Users can access data from multiple connections using different usernames for different roles or functions. Username fields left blank automatically use the default Application Username.

Prerequisites

  • Spreadsheet Server v25.4 or later
  • Works with Platform and license keys
  • Connections must already be created in the Connections tab

Key Points

  • Administrators configure specific Application Usernames for individual connections in User Management Security tab
  • Blank username fields automatically use the default Application Username
  • Connection-specific usernames apply to all databases under that connection

For configuration steps, refer to the Application Configurator User Guide in the Spreadsheet Server v25 documentation.

GXL Batch Execution

The new Batch Execution functionality allows GXL formulas to calculate in batches, optimizing performance across larger workbooks. This optional feature prevents SQL timeout warnings and reduces overall calculation time when processing multiple GXL formulas simultaneously.

Prerequisites

  • Spreadsheet Server version 25.4 or later
  • Custom GL configuration
  • GXL formulas in the workbook

Key Points

  • Available for both Platform and License Key customers
  • Boosts calculation performance for workbooks with multiple GXL formulas
  • Prevents SQL timeout warnings during simultaneous GXL calculations
  • Available as an optional setting, disabled by default
  • Optimizes query execution for larger workbooks
  • Provides consistent calculation performance across different workbook sizes

For limitations and troubleshooting steps, refer to the Spreadsheet Server User Guide.

Spreadsheet Server v25.4 Resolved Issues

Title Description
Profile Editor Segments Tab

The Profile Editor Segments tab now correctly loads and displays the segment SQL in the "SQL to retrieve distinct values" text box when selecting a segment. Previously, the SQL text box remained unchanged when switching between segments, preventing users from viewing or editing segment-specific SQL queries.

GEXD Fill Down Columns

Fill Down Columns data now remains in the specified column for ranges even when values in a fill down column are blank. Previously, formulas shifted left due to blank column values when executing GEXD formulas into a range.

Distribution Manager SMTP

Email messages sent through Distribution Manager using SMTP as the email delivery option now include the email body content. Previously, only the subject line and attachments were delivered, while the message body remained blank.

Account Filtering

The account filtering configuration now applies correctly to Excel reports.

JDE Connection Configuration

The <DEFAULT> Owner ID functionality now operates correctly when configuring JDE connections in the Application Configurator, even when the SQL Server database name contains a hyphen character. Previously, this prevented proper connection configuration and data access.

GXL JDE Balance Calculations

GXL SQL code now correctly handles NULL value testing for JDE connections, ensuring accurate balance calculations and optimal performance. Previously, incorrect application of RTRIM(LTRIM()) functions caused incorrect balance calculations and performance degradation due to inefficient NULL value handling.

GEXD Table Performance

GEXD processing logic has been optimized to improve performance when using table target types.

Drill Down with SharePoint

Drill Down to Journals now functions correctly when using prompts with SharePoint configurations. Previously, the operation failed with a file not found error even when the file was present.

Profile Editor Test Button

The Test button for SQL statements in the Balance tab and Drilldown tab now functions correctly, allowing users to validate queries. Previously, the Test button remained disabled, preventing users from testing balance queries with token replacement before saving.

 

 

Was this article helpful?

We're sorry to hear that.