Contrib.social

Large numbers shown with scientific notation

Open on Drupal.org →
Created on 23 May 2019, over 5 years ago
Updated 8 July 2021, over 3 years ago

Hi,

Large numbers (10+ symbols) in the exported XLS files are displayed with E+ notation (see example here https://github.com/PHPOffice/PhpSpreadsheet/issues/681).

I found a workaround that works just fine for my case (see patch below). I saw a @todo comment in formatValue method to make formatting configurable so I believe we need more generic solution.

🐛 Bug report
Status

Closed: outdated

Version

1.0

Component

Code

Created by

🇪🇸Spain kalabro

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

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • Comment 11 months ago →
    🇺🇸United States dbouman

    This is still an issue, I just applied patch #4 and it works for me.

  • Status changed to Active about 1 month ago
  • Comment about 1 month ago →
    🇺🇸United States dbouman

    This is still an issue and patch needs to be re-rolled to work with latest version of module.

  • Comment about 1 month ago →
    🇫🇷France mably

    Would be an interesting feature to have, but I think it should not be enabled by default, we could use a custom settings for that.

    We have recently added two new settings to allow trimming whitespaces and stripping html, it could be added there.

    Related issue : 🐛 Make the formatValue filters configurable Needs work

    Feel free to open an MR for this.

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024