[Erp5-report] r24638 - in /erp5/trunk/products/ERP5Type: Utils.py __init__.py

[nobody at svn.erp5.org]

Author: nicolas
Date: Wed Nov 19 16:56:30 2008
New Revision: 24638

URL: http://svn.erp5.org?rev=24638&view=rev
Log:
add function to convert int to letters

Modified:
    erp5/trunk/products/ERP5Type/Utils.py
    erp5/trunk/products/ERP5Type/__init__.py

Modified: erp5/trunk/products/ERP5Type/Utils.py
URL: http://svn.erp5.org/erp5/trunk/products/ERP5Type/Utils.py?rev=24638&r1=24637&r2=24638&view=diff
==============================================================================
--- erp5/trunk/products/ERP5Type/Utils.py [utf8] (original)
+++ erp5/trunk/products/ERP5Type/Utils.py [utf8] Wed Nov 19 16:56:30 2008
@@ -259,6 +259,15 @@
     return path.split('/')
   return path
 
+def int2letters(i):
+  """
+  Convert an integer to letters, to generate spreadsheet column id
+  A, B, C ..., Z, AA, AB, ..., AZ, BA, ..., ZZ, AAA ...
+  """
+  if i < 26:
+    return (chr(i + ord('A')))
+  d, m = divmod(i, 26)
+  return int2letter(d - 1) + int2letter(m)
 
 #####################################################
 # Globals initialization

Modified: erp5/trunk/products/ERP5Type/__init__.py
URL: http://svn.erp5.org/erp5/trunk/products/ERP5Type/__init__.py?rev=24638&r1=24637&r2=24638&view=diff
==============================================================================
--- erp5/trunk/products/ERP5Type/__init__.py [utf8] (original)
+++ erp5/trunk/products/ERP5Type/__init__.py [utf8] Wed Nov 19 16:56:30 2008
@@ -107,7 +107,8 @@
 allow_module('Products.ERP5Type.Cache')
 ModuleSecurityInfo('Products.ERP5Type.Utils').declarePublic(
     'sortValueList', 'convertToUpperCase', 'UpperCase',
-    'convertToMixedCase', 'cartesianProduct', 'sleep', 'getCommonTimeZoneList')
+    'convertToMixedCase', 'cartesianProduct', 'sleep', 'getCommonTimeZoneList',
+    'int2letters',)
 
 allow_module('Products.ERP5Type.Message')
 ModuleSecurityInfo('Products.ERP5Type.Message').declarePublic('translateString')