From: Alan <alan@roojs.com>
Date: Fri, 15 Jul 2022 06:13:19 +0000 (+0800)
Subject: Fix #7312 - issue with wide gnumeric / excel sheets
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=04ae6e8f7dd52b97fc5eef9dd6bdb90004b39125

Fix #7312 - issue with wide gnumeric / excel sheets
---

diff --git a/GnumericToExcel.php b/GnumericToExcel.php
index 5a23e4a1..feb940c3 100644
--- a/GnumericToExcel.php
+++ b/GnumericToExcel.php
@@ -30,7 +30,7 @@ class Pman_Core_GnumericToExcel extends Pman
 
     function get($v, $opts=array())
     {
-        
+         
     }
     function post($fname) {
         
diff --git a/Pman.Gnumeric.js b/Pman.Gnumeric.js
index d5cf6b1b..a346fba7 100644
--- a/Pman.Gnumeric.js
+++ b/Pman.Gnumeric.js
@@ -218,7 +218,7 @@ Roo.extend(Pman.Gnumeric, Roo.util.Observable, {
         // we wil only support AA not AAA
         var top = Math.floor(c/26);
         var bot = c % 26;
-        var cc = top > 0 ? String.fromCharCode('A'.charCodeAt(0) + top) : '';
+        var cc = top > 0 ? String.fromCharCode('A'.charCodeAt(0) + (top-1)) : '';
         cc += String.fromCharCode('A'.charCodeAt(0)  + bot);
         return cc+'' +r;