🐛 import - extract data from xls, ods, etc. with pandas instead of LO

1 files changed, 16 insertions, 0 deletions

diff --git a/ishtar_common/utils.py b/ishtar_common/utils.py
index 5cc5d0363..cf56ea705 100644
--- a/ishtar_common/utils.py
+++ b/ishtar_common/utils.py
@@ -30,6 +30,7 @@ import io
 from jinja2 import Template
 import locale
 import math
+import numpy
 import os
 import random
 import re
@@ -1223,6 +1224,21 @@ def _post_save_geo(sender, **kwargs):
     return
 
 
+def format_int_float(values):
+    """
+    Numpy array: format integer with not "."
+    """
+    new_values = []
+    for value in values:
+        if numpy.isnan(value):
+            new_values.append("")
+        elif int(value) == value:
+            new_values.append(str(int(value)))
+        else:
+            new_values.append(value)
+    return new_values
+
+
 def create_slug(model, name, slug_attr="slug", max_length=100):
     base_slug = slugify(name)
     slug = base_slug[:max_length]