by MokasIT

Experts in Excel export. An export to Excel from any list, report or subpanel of SuiteCRM.

Cancel at any time!
Free Trial

#4417 - Cell with money value locked as text 'RS

Closed Bug? created by jcmoreno8 2 years ago

I'm testing the plugin here in Brazil, the format for representing the money is R$, when exporting a report to CSV the cells are recorded R$115.00 but when I generate the file to excel, the ' is inserted and the content is like this ' R $115.00 and I can't use it as a number to perform calculations, I need to rework the content to remove the '

Thanks for the support,

João Carlos Moreno Soluções em CRM SP - Brazil

  1. MokasIT member avatar

    MokasIT Provider Affiliate

    2 years ago

    220725-140820.png

    Hi João Carlos,

    I have reproduced Your situation under our testing environment and everything looks OK, there isn't any currency sign in amount column at all.

    • jcmoreno8 member avatar

      jcmoreno8

      2 years ago

      Hello, thanks for the feedback, below are images of the reports module and then the export to excel, I opened it in excel and then in librecalc in both the currency format is filled in and with the ' at the beginning of the value! img1 img2 img3

  2. MokasIT member avatar

    MokasIT Provider Affiliate

    2 years ago

    Oh - You mean Reports export, that is obvious, we doesn't replace during reports export currency symbol and thousands separator ar we do in listview export. We will fix it and new release of Suite2WExcel will be issued until August 10.

    before this date You could work around be replacing 'R$'->'' in particular column in excel with ctrl+H

    • jcmoreno8 member avatar

      jcmoreno8

      2 years ago

      Thanks for the feedback, waiting for the new version

  3. MokasIT member avatar

    MokasIT Provider Affiliate

    2 years ago

    Please download and install our latest version Suite2Excel20220808.zip

    • jcmoreno8 member avatar

      jcmoreno8

      2 years ago

      I installed the new version and the problem persists, will I need to remove the version and reinstall?

    • MokasIT member avatar

      MokasIT Provider Affiliate

      2 years ago

      Please download another version Suite2Excel20220809. Usually it's enough to instal new version on the top, but in some cases it's better to remove old version and install new one. Of course repair&rebuild do after installation.

    • jcmoreno8 member avatar

      jcmoreno8

      2 years ago

      I removed the installation, cleared the cache and reinstalled. The problem persists in the cells with the unit of money it still has the 'R$ which prevents excel from using it as a number for calculations

  4. jcmoreno8 member avatar

    jcmoreno8

    2 years ago

    Importantly, the problem only happens in the reports module, I exported the data directly from the opportunities module and the values came without the symbol of 'R$

  5. MokasIT member avatar

    MokasIT Provider Affiliate

    2 years ago

    Its litle bit strange.. We have double checked that 20220809 version replaces currency symbols in currency fields in reports. Could You attach a screenshot from module loader? Could You make test report with few filds - Opportunity name and amount? Could You try export opportunity in another currency? But we made new version with longing of this replaces. Log you could fount in /custom/modules/AOR_Reports/log.txt. Downlod version 20220812

    • jcmoreno8 member avatar

      jcmoreno8

      2 years ago

      Hello, I downloaded the new version, is it possible to extend the test serial for another week?

      a3b0626fefdb7f54696bf064b30a50fa

    • jcmoreno8 member avatar

      jcmoreno8

      2 years ago

      Please disregard the previous message

    • jcmoreno8 member avatar

      jcmoreno8

      2 years ago

      Log: Array ( [field] => sgnp_c [display] => 1 [function] => [module] => Opportunities [alias] => opportunities [params] => [type] => varchar

      )

      Image

    • MokasIT member avatar

      MokasIT Provider Affiliate

      2 years ago

      Could You make simple report - Opportunity with few fields Name | Amount

      We need to check it in the similar conditions as possible.

    • jcmoreno8 member avatar

      jcmoreno8

      2 years ago

      I installed the new version on a test instance and it worked extracting XLSX exiting the report correctly, I will remove the installation clear the cache and reinstall to test again

  6. MokasIT member avatar

    MokasIT Provider Affiliate

    2 years ago

    Download the latest version and test again. Let me know if the problem is solved. Thank you.

    • jcmoreno8 member avatar

      jcmoreno8

      2 years ago

      Problem solved, the customer will approve the data extraction to complete the purchase. Thank you for your support

    • jcmoreno8 member avatar

      jcmoreno8

      2 years ago

      There is one last detail to adjust, follow link to video demonstrating

      https://vimeo.com/742687172/af6357b6c1

    • MokasIT member avatar

      MokasIT Provider Affiliate

      2 years ago

      Thank for comment, we will fix it in few days.

  7. MokasIT member avatar

    MokasIT Provider Affiliate

    2 years ago

    Bug with reports filters is fixed. Please download latest S2E release.

    • jcmoreno8 member avatar

      jcmoreno8

      2 years ago

      Still does not work Video demo: https://vimeo.com/744623519/6493e7998d

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "New version exports 30K records from listview without any problems. We found very useful reports export to Excel. With report export to excel you..." - MD

    Read More Reviews