diff options
| author | Jan-Hendrik Hühne <[email protected]> | 2012-06-06 18:59:25 +0200 |
|---|---|---|
| committer | Jan-Hendrik Hühne <[email protected]> | 2012-06-06 18:59:25 +0200 |
| commit | 50a5d7c2026fb7847ab291894b15cdbe203ca1fb (patch) | |
| tree | 2faf4558459f09bdc326a3b05ca3a1f8df2d51a0 /lib/axlsx/workbook/worksheet/pane.rb | |
| parent | 23f30075071dda294db547224e81e328f06cac39 (diff) | |
| download | caxlsx-50a5d7c2026fb7847ab291894b15cdbe203ca1fb.tar.gz caxlsx-50a5d7c2026fb7847ab291894b15cdbe203ca1fb.zip | |
Compute top_left_cell if sheet is frozen.
Diffstat (limited to 'lib/axlsx/workbook/worksheet/pane.rb')
| -rw-r--r-- | lib/axlsx/workbook/worksheet/pane.rb | 7 |
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(' ') |