From e2e3349da4ebf4a4d09ffa3cba1a5a6a036e8bf0 Mon Sep 17 00:00:00 2001 From: Alan Date: Fri, 15 Jul 2022 14:13:01 +0800 Subject: [PATCH] Changed GnumericToExcel.phpPman.Gnumeric.js --- GnumericToExcel.php | 2 +- Pman.Gnumeric.js | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) 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; -- 2.39.2