From ab2c3a8ffecec2997c29b5a907d5b632c1b64af2 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Sun, 22 Mar 2009 23:26:09 +0000 Subject: [PATCH] Bad thousand/decimal formatting in XLS reports.(OpenOffice) --- CHANGELOG.txt | 4 ++++ reporting/includes/excel_report.inc | 8 +++++--- 2 files changed, 9 insertions(+), 3 deletions(-) diff --git a/CHANGELOG.txt b/CHANGELOG.txt index 42e8664a..e9b94c19 100644 --- a/CHANGELOG.txt +++ b/CHANGELOG.txt @@ -19,6 +19,10 @@ Legend: ! -> Note $ -> Affected files +23-Mar-2009 Joe Hunt +# Bad thousand/decimal formatting in XLS reports.(OpenOffice) +$ /reporting/including/excel_report.inc + 22-Mar-2009 Janusz Dobrowolski/Joe Hun rerun, didn't work (empty file when inserting) # Fixed item picture display after upload, fixed item image filenames. Option to remove image. $ /inventory/manage/items.php diff --git a/reporting/includes/excel_report.inc b/reporting/includes/excel_report.inc index 0f25ea0c..e565552b 100644 --- a/reporting/includes/excel_report.inc +++ b/reporting/includes/excel_report.inc @@ -142,10 +142,12 @@ class FrontReport extends Spreadsheet_Excel_Writer_Workbook { if (!isset($this->formatAmount[$dec])) { - global $thoseps,$decseps; + //global $thoseps,$decseps; $dec = (int)$dec; - $tsep = $thoseps[user_tho_sep()]; - $dsep = $decseps[user_dec_sep()]; + //$tsep = $thoseps[user_tho_sep()]; + //$dsep = $decseps[user_dec_sep()]; + $tsep = ','; + $dsep = '.'; $format = "###{$tsep}###{$tsep}###{$tsep}##0"; if ($dec>0) $format .= "{$dsep}".str_repeat('0',$dec); -- 2.30.2