- July 23, 2020 at 9:07 am #31685VenomParticipant
When I try to export entries for a long numeric string over 16 digits. The value in downloaded CSV, HTML is displayed as scientific notation. It seems that is the issue of PhSpreadsheet .
I followed a workaround to add the following code to Exporter.php before 342 to set the cell style in TEXT format before storing the value.
$style = $sheet->getStyleByColumnAndRow($columnCount, $rowCount); $style->getNumberFormat()->setFormatCode('#');
Please let me know if there is other setting to config the value format for export.
VenomJuly 24, 2020 at 9:39 am #31686AllySupport StaffJuly 24, 2020 at 10:17 am #31694VenomParticipant
Agree. That will be great to add a hook for us to modify data before setting the value.
However, I am afraid of that is the issue of PhpExcel instead of your code.
May be the hook could be supplied with the format code and it will be passed to the cell style before writing into the CSV/Excel/Html?July 27, 2020 at 10:17 am #31704
- You must be logged in to reply to this topic.