[FIX] Error in excel export when sheet name > 31 characters

XLWT only accepts sheet names smaller than 31 characters because that's the
excel limit.

Fixes #2548
Fixes #3318

diff --git a/addons/web_graph/controllers/main.py b/addons/web_graph/controllers/main.py
index 320758e..0899fc7 100644 (file)
--- a/addons/web_graph/controllers/main.py
+++ b/addons/web_graph/controllers/main.py
@@ -21,7 +21,7 @@ class TableExporter(http.Controller):
         jdata = simplejson.loads(data)
         nbr_measures = jdata['nbr_measures']
         workbook = xlwt.Workbook()
-        worksheet = workbook.add_sheet(jdata['title'])
+        worksheet = workbook.add_sheet(jdata['title'][:30])
         header_bold = xlwt.easyxf("font: bold on; pattern: pattern solid, fore_colour gray25;")
         header_plain = xlwt.easyxf("pattern: pattern solid, fore_colour gray25;")
         bold = xlwt.easyxf("font: bold on;")