Sticky rows

[jurriaanschrofer]

Hi guys,

First of all, thanks for this awesome gem :-)

I have been looking for a way to implement sticky rows, unfortunately without success. If this is not a feature of the gem that's all fine of course, but if it is, could you please point me to the source code location?

Since I expected it to be a part of the gem I have been looking, alas to no avail.

Thanks in advance

[weshatheleopard]

@jurriaanschrofer Can you be more specific as of what "sticky rows" is?

Also, can you create a blank workbook, make these "sticky rows" in it and attach it here? Then I can look how to implement that.

[harsh183]

https://support.microsoft.com/en-us/office/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f - probably something like this?

[jurriaanschrofer]

@harsh183 indeed, exactly that. Thanks

[amamrenko]

any news about that feature?

[mheiligers-godaddy]

Edit: actually it's on the Wiki

The answer is in #312. I created a helper method for my purposes:

  def freeze_pane(row, col)
    worksheetview = RubyXL::WorksheetView.new
    worksheetview.pane = RubyXL::Pane.new(:top_left_cell => RubyXL::Reference.new(row, col),
                                          :x_split => col,
                                          :y_split => row,
                                          :state => 'frozenSplit')

    worksheetviews = RubyXL::WorksheetViews.new
    worksheetviews << worksheetview
    @sheet.sheet_views = worksheetviews
  end