Experts in Excel export. An export to Excel from any list, report or subpanel of SuiteCRM.
#4417 - Cell with money value locked as text 'RS
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
-
"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
- Most Recent Love from Users
2 years ago
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.
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
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
2 years ago
Thanks for the feedback, waiting for the new version
2 years ago
Please download and install our latest version Suite2Excel20220808.zip
2 years ago
I installed the new version and the problem persists, will I need to remove the version and reinstall?
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.
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
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$
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
2 years ago
Hello, I downloaded the new version, is it possible to extend the test serial for another week?
a3b0626fefdb7f54696bf064b30a50fa
2 years ago
Please disregard the previous message
2 years ago
Log: Array ( [field] => sgnp_c [display] => 1 [function] => [module] => Opportunities [alias] => opportunities [params] => [type] => varchar
)
Image
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.
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
2 years ago
Download the latest version and test again. Let me know if the problem is solved. Thank you.
2 years ago
Problem solved, the customer will approve the data extraction to complete the purchase. Thank you for your support
2 years ago
There is one last detail to adjust, follow link to video demonstrating
https://vimeo.com/742687172/af6357b6c1
2 years ago
Thank for comment, we will fix it in few days.
2 years ago
Bug with reports filters is fixed. Please download latest S2E release.
2 years ago
Still does not work Video demo: https://vimeo.com/744623519/6493e7998d