Formatted/Unformatted Option Missing for .xlsx Email Subscriptions

[dvanndfl]

Hello,

We are running Metabase v54 and seeing apparently missing options for the Formatted/Unformatted .xslx Dashboard Subscription options.

Steps to reproduce:

1. Create dashboard, attach Question to dashboard.
2. Navigate to Sharing->Subscription Menu, choose Email option.
3. Add Subscription to Dashboard, choose .xlsx Excel file type to attach. Formatted or Unformatted toggle is not available. This causes formatting applied to columns to be lost in the attached file.
   
   

For reference, the option is available when choosing a .csv file type:

Metabase instance details below:

{
  "browser-info": {
    "language": "en-US",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "iseries",
      "sqlserver"
    ],
    "run-mode": "prod",
    "plan-alias": "",
    "version": {
      "date": "2025-04-18",
      "tag": "v54",
      "hash": "aab5552"
    },
    "settings": {
      "report-timezone": "US/Eastern"
    },
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "16.3 (Debian 16.3-1.pgdg120+1)"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.7.5"
      }
    }
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "21.0.6+7-LTS",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "21.0.6",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "21.0.6+7-LTS",
    "os.name": "Linux",
    "os.version": "5.15.0-134-generic",
    "user.language": "en",
    "user.timezone": "America/New_York"
  }
}

[dvanndfl]

Hello,

Thank you for the reply. Prior to the upgrade to Metabase v54 - sending .xlsx format Dashboard Subscription emails could retain the original formatting. The loss of this functionality seems to be a regression with the introduction of the Formatted/Unformatted option becoming available.

Also, the Formatted/Unformatted toggle is available for .xlsx files when manually downloading Question results directly to Excel. Seems counterintuitive to lose that option in an email Dashboard Subscription when it is possible to format those Excel files properly.