Xlsx table: string to number formatter

Created on 19 March 2024, over 1 year ago
Updated 29 May 2025, about 1 month ago

Problem/Motivation

When exporting a table to excel, I have a decimal number field. After exporting to xlsx format, the numbers are displayed as text in my table. It is necessary to convert them into numbers each time. In the field formatter settings and export settings, I did not find an opportunity to specify that this field should be exported in the format of a numeric cell.

Proposed resolution

Add to the xlsx generation presets the ability to specify how to export a field (Override the fields configuration tab)

✨ Feature request
Status

Needs work

Version

4.1

Component

Code

Created by

πŸ‡·πŸ‡ΊRussia mr.pomelov Russia, Chelyabinsk

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Merge Requests

Comments & Activities

  • Issue created by @mr.pomelov
  • First commit to issue fork.
  • Merge request !24Issue #3432200 - Fix cell format β†’ (Open) created by AstonVictor
  • Pipeline finished with Canceled
    about 1 month ago
    Total: 88s
    #509173
  • Pipeline finished with Canceled
    about 1 month ago
    Total: 95s
    #509174
  • Pipeline finished with Success
    about 1 month ago
    Total: 214s
    #509176
  • πŸ‡ΊπŸ‡¦Ukraine AstonVictor

    Hi there,

    Please, check if the MR works for you.
    thanks in advance

  • πŸ‡·πŸ‡ΊRussia mr.pomelov Russia, Chelyabinsk

    I replaced the module files, cleaned the cache, and ran the database update script. I don't see an option in the presentation settings (field format or in the mass operation settings) for the cell to be displayed as a number. During normal uploading, it shows as usual in text format.

Production build 0.71.5 2024