summaryrefslogtreecommitdiffhomepage
diff options
context:
space:
mode:
-rw-r--r--lib/axlsx/workbook/worksheet/pane.rb7
1 files changed, 7 insertions, 0 deletions
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(' ')