diff options
| -rw-r--r-- | lib/axlsx/workbook/workbook.rb | 6 | ||||
| -rw-r--r-- | lib/axlsx/workbook/worksheet/worksheet.rb | 6 |
2 files changed, 10 insertions, 2 deletions
diff --git a/lib/axlsx/workbook/workbook.rb b/lib/axlsx/workbook/workbook.rb index 9bb63462..51f38b50 100644 --- a/lib/axlsx/workbook/workbook.rb +++ b/lib/axlsx/workbook/workbook.rb @@ -181,7 +181,11 @@ require 'axlsx/workbook/shared_strings_table.rb' xml.workbookPr(:date1904=>@@date1904) #<x:workbookProtection workbookPassword="xsd:hexBinary data" lockStructure="1" lockWindows="1" /> # Required to support rubyXL parsing as it requires sheetView, which requires this. - xml.bookViews { xml.workbookView :activeTab=>0 } + xml.bookViews { + worksheets.count.times do + xml.workbookView :activeTab=>0 + end + } xml.sheets { @worksheets.each_with_index do |sheet, index| xml.sheet(:name=>sheet.name, :sheetId=>index+1, :"r:id"=>sheet.rId) diff --git a/lib/axlsx/workbook/worksheet/worksheet.rb b/lib/axlsx/workbook/worksheet/worksheet.rb index bd2170a5..5284c475 100644 --- a/lib/axlsx/workbook/worksheet/worksheet.rb +++ b/lib/axlsx/workbook/worksheet/worksheet.rb @@ -298,7 +298,11 @@ module Axlsx # another patch for the folks at rubyXL as thier parser depends on this optional element. xml.dimension :ref=>dimension unless rows.size == 0 # this is required by rubyXL, spec says who cares - but it seems they didnt notice - xml.sheetViews { xml.sheetView :workbookViewId =>0 } + xml.sheetViews { + xml.sheetView(:tabSelected => 1, :workbookViewId => index) { + xml.selection :activeCell=>"A1", :sqref => "A1" + } + } if @auto_fit_data.size > 0 xml.cols { |