CSV Export Doesn't Respect Formatting for Financial Type Fields

[ixipixi]

Describe the bug

CSV Export Doesn't Respect Formatting for Financial Type Fields

To Reproduce

• Use "orders" table from sample database
• In Table Metadata set "Discount" to a financial type and "Total" to either "Quantity" or "No Semantic Type"
• Create a question
• Display these two fields in a table
• Add custom formatting in the viz settings to add currency formatting to every cell in the table
• Export as CSV
• Note that formatting is not retained in the export for the financial type fields

Expected behavior

The formatting in the export should match the table visualization

Logs

No response

Information about your Metabase installation

{
  "browser-info": {
    "language": "en-US",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.23+9",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.23",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.23+9",
    "os.name": "Linux",
    "os.version": "5.15.133.1-microsoft-standard-WSL2",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "h2",
      "postgres"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "11.22 (Debian 11.22-1.pgdg110+1)"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.7.2"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2024-05-16",
      "tag": "v1.49.11",
      "hash": "b894f2d"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

Severity

Annoying

Additional context

Here is a quick Loom recording running through repro:
https://www.loom.com/share/d591d06d48e2425a833b9f09672d5145