From 50a5d7c2026fb7847ab291894b15cdbe203ca1fb Mon Sep 17 00:00:00 2001
From: Jan-Hendrik Hühne <jan.huehne@googlemail.com>
Date: Wed, 6 Jun 2012 18:59:25 +0200
Subject: Compute top_left_cell if sheet is frozen.

---
 lib/axlsx/workbook/worksheet/pane.rb | 7 +++++++
 1 file changed, 7 insertions(+)

diff --git a/lib/axlsx/workbook/worksheet/pane.rb b/lib/axlsx/workbook/worksheet/pane.rb
index f658bc99..8403c9ec 100644
--- a/lib/axlsx/workbook/worksheet/pane.rb
+++ b/lib/axlsx/workbook/worksheet/pane.rb
@@ -128,6 +128,13 @@ module Axlsx
     # @param [String] str
     # @return [String]
     def to_xml_string(str = '')
+      if @state == :frozen && @top_left_cell.nil?
+        row = @y_split || 0
+        column = @x_split || 0
+        
+        @top_left_cell = "#{('A'..'ZZ').to_a[column]}#{row+1}"
+      end
+      
       str << '<pane '
       str << instance_values.map { |key, value| '' << key.gsub(/_(.)/){ $1.upcase } << 
         %{="#{[:active_pane, :state].include?(key.to_sym) ? value.to_s.gsub(/_(.)/){ $1.upcase } : value}"} unless value.nil? }.join(' ')
-- 
cgit v1.2.3