Changelog

# Change Log
All notable changes to this project will be documented in this file.

## [1.41] 2022-07-04

## [1.40] 2022-31-03

## [1.39] 2022-29-03

## [1.38] 2022-28-03

## [1.37] 2021-30-11

### Added
  - Excel#visible,displayalerts

## [1.36] 2021-29-10

### Added
  - Workbook.open: option if_blocked: :accept
  - ListRow#methods, respond_to?, alive?
  - Range#workbook, ListObject#workbook, ListRow#workbook
  - Workbook#writable=

### Changed
  - Workbook#open instead of Workbook#reopen


## [1.35] 2021-24-07

## [1.34] 2021-21-06

## [1.34] 2021-15-06

## [1.33] 2021-01-06

## [1.32] 2021-23-04

### Added
  - Excel#each  
  - ListObject#each, value, rows_number, position, ==
  - ListObject#[] extended with options
  - ListRow#to_h, to_a, values=, keys_values, ==  
  - RangeOwners#names
  - Worksheet#each_cell

### Changed  
  - Worksheet#[]: returning range values given address or defined name (instead of returning a cell when giving address)
  - Worksheet#each traversing row values instead of cells
  - Excel#excels_number renamed to #instance_count
  - Excel#known_excels_number renamed to #known_instance_count
  - Excel#known_excel_instance renamed to #known_running_instance
  - Excel#known_excel_instances renamed to #known_running_instances
  - RangeOwners#rename_range renamed to #rename_name
  
## [1.31] 2021-14-01

### Added
  - Worksheet#table

## [1.30] 2020-18-11

## [1.29] 2020-05-11

### Added
  - Workbook.open can also take a Pathname object
  - General#init_reo_for_win32ole

## [1.28] 2020-23-10

## [1.27] 2020-16-10

## [1.26] 2020-09-10

### Added
  - General#change_current_binding

## [1.25] 2020-10-09]

## [1.24] 2020-25-09

## [1.23] 2020-02-09

## [1.22] 2020-10-08

### Added
  - Range#set_value

## [1.21] 2020-05-08
  
### Added
  - Range#rows, columns

## [1.20] 2020-23-07

### Changed
  - using pry in console

### Added
  - ListObject

## [1.19] 2020-10-6

### Added
  - Workheet#values, each_rowvalue


## [1.18] 2020-30-4

### Added
  - Workbook#worksheets, worksheets_count
  - Worksheet#each_value
  - Range#value, value=
  - Range#initialize: optional paramter worksheet

## [1.17]

### Added
  - Excel#active_workbook

### Changed
  - Excel#namevalue, set_namevalue, namevalue_glob, set_namevalue_glob are being removed

## [1.16]

### Added
   - RangeOwners#set_namevalue, set_namevalue_glob, Worksheet#set_cellval: 
     optional parameter for color 
   
### Changed   
   - Workbook#color_if_modified removed   

## [1.15]

### Added
   - Workbook#unobtrusively, Workbook#for_reading, Workbook#for_modifying

### Changed
   - Workbook.unobtrusively: removed parameter :rw_change_excel
   
## [1.14]

  - no interface change

## [1.13]

  - no interface change

## [1.12]

### Added
   - Workbook.open: option :if_unsaved => :save
   - Workbook#color_if_modified

### Changed:
   - Workbook#save, save_as: removed parameter :discoloring
   - RangeOwners#set_namevalue, set_namevalue_glob, Worksheet#set_cellval: 
     removed optional parameter for color 
   - Workbook.open: removed option :excel => :reserved_new  


## [1.11]

### Added
  - Range#==, Worksheet#== 
  - Workbook.open: options :if_blocked is synonym to :if_obstructed
  - Simplified Code

## [1.10]

### Added
  - Range,Cell#v

## [1.9]

### Added
  - Workbook#create
  - Excel#workbooks, each_workbook, each_workbook_with_index
  - Address#int_range,#r1c1,#a1
  - ReoCommon::RangeOwners#add_name: allowing infinite ranges

## [1.6]

### Added
  - Range#copy: options values_only, transpose

## [1.5]

### Changed
  - Range,Cell#v
  - Range,Cell: lower-letter VBA methods allowed

## [1.4.1]

### Changed
  - renamed Worksheet#name2range to ReoCommon#range

## [1.4]

### Changed
  - renamed Book to Workbook, Sheet to Worksheet
  - General#to_reo
  - Range,Cell: lower-letter VBA methods not allowed

## [1.3.1]

### Added
  - Book#open: option :excel => :reserved_new
  - ReoCommon#name2range

## [1.2.2]

### Added
  - ReoCommon#add_name, rename_range, delete_name
  - Sheet#range
  - Range#copy

### Changed:
  - ReoCommon#namevalue, namevalue_glob, set_namevalue, set_namevalue_glob replace
    set_namevalue replaces set_rangeval, set_namevalue_glob, respectively

## [1.2.1] 2018-9-12

## [1.2] - 2018-11-8

## [1.1.6] - 2018-20-7

### Added
  - Sheet#cellval
  - Sheet#set_cellval

## [1.1.5] - 2018-10-7

### Added
  - Book#unobtrusively: 
    option :writable

### Changed
  - Book#unobtrusively:
    option :rw_change_excel instead :readonly_excel

### Added

## [1.1.4] - 2018-10-6

### Added
  - Book#open: for the options: simplifiction: :force can be left out
  - Excel#for_this_instance
  - Excel#for_all_workbooks
  - Book#for_this_workbooks
  - Book#reopen : wirth options

## [1.1.3] - 2018-13-5

## [1.1.2] - 2018-10-5

### Added
  - Excel, Sheet, Book #workbook

## [1.1.1] - 2018-20-4

### Added
  - Book#save, save_as: options: discoloring
  - Book#set_nameval, Sheet, Excel#set_nameval, set_rangeval: option :color

### Changed

  - renamed: Excel.known_excel_instances instead of excel_processes

## [1.1] - 2017-09-29

### Added

  - Book.save, save_as, close

## [1.0.4] - 2017-08-30

## [1.0.3] - 2017-08-27

## [1.0.2] - 2017-07-26

### Added

 - Excel#set_options
 - Excel#retain_saved_workbooks
 - Book#retain_saved

### Changed

 - Book#unobtrusively: option: :if_closed => 

## [1.0.1] - 2017-16-04

### Added
 
 - Book.open : options :calculation
 - Excel.new : options :calculation, :screen_updating
 - Excel#calculation, calculation=, screen_updating, screenupdating=

### Changed

 - Book#open : options: two levels: :default and :force
   example:  
   Book.open(:default =>  {:excel => :current, :visible => true}, {:force => {:excel => :new})

## [0.6.2] - 2016-04-11

### Changed
- Excel#focus (was Excel#activate)
- Book#focus (was Book#activate)

### Added

## [0.6.1] - 2016-04-09

### Changed
- error classes

### Added

- Excel#foremost_window

## [0.6] - 2016-03-08

## [0.5.2] - 2016-17-07

### Changed
- Book: open: option :update_links
- Book: open: options :default_excel, :force_excel => :current instead of :reuse
  (:active, :reuse as alias)
- Book: open: options: deleted :displayalerts
- Excel: create, current: with options :visible, :displayalerts

### Added
- Excel: create, current, new: new options-value :displayalerts => :if_visible

## [0.5.1] - 2016-18-06

### Added
- Book#open :force_excel => :active
- Excel#workbooks_visible

### Changed
- Book: open: :default_excel, :force_excel => :active, (:reuse as alias), bug fix in :default
		unobtrusively: :if_closed => :active (:reuse as alias)
- Excel: with_calculation: bug fix
- Sheet: [], []= broader implementation


## [0.5.0] - 2016-31-05

### Added
- Book: sheet, add_empty_sheet, copy_sheet
		rangeval, set_rangeval, nameval, set_nameval
		open: option check_compatibility
- Sheet: last_sheet, first_sheet, rangeval, nameval, [], []=
- Excel: with_calculaiton, rangeval, set_rangeval, nameval, set_nameval, [], []=

### Changed
- Book: book.sheet(<sheet_name>) replaces book[<sheet-name>]
        add_or_copy_sheet replaces add_sheet
        name_val, set_name_val replaces n_value, set_n_value
        [], []= via nameval, set_nameval

       
## [0.4] - 2016-03-16

### Added
- options visible, displayalerts in unobtrusively, for_reading, for_writing

## [0.3.8] - 2016-02-12

### Added
 - mark down comments
 - trace
 - Excel, Book: respond_to?, methods, special_methods, special_methods 

## [0.3.9] - 2016-03-03

### Added
- methods, respond_to?, own_methods in new module General
- yardopts option --legacy for ruby 1.8.6. such that class Book is included in the documentation

## [0.3.8] - 2016-02-12

### Added
 - mark down comments
 - trace
 - Excel, Book: respond_to?, methods, special_methods, special_methods
 
### Changed
  
## [0.3.7] - 2015-12-04

### Added
 - Book.new: includes lifting Win32Ole objects
 - Book: class synonym: Workbook
 - Book.open: can force_excel can contain an win32ole object
 - Book#excel_of
 - Book: consider Excel version for opening linked workbooks
 - Book#close: with keep_open
 - Excel.new: includes lifting Win32ole objects
 - Excel.close_all: with a little time out
 - Excel: sublassing for Books
 
### Changed
 - Excel.close_all: bug fix
 - Excel#recreate: reopening closed workbooks, restrict reopening, visible, displayalerts

 

## [0.3.6] - 2015-10-27

### Added
- Excel#recreate: reopening a closed Excel
- Excel.new(:reuse => <WIN32OLE_excel>): 
  uplifting an Excel represented as object of the class WIN32OLE to an object of the class Excel
- Excel#close, Excel.close_all: with managing unsaved workbooks
- Excel.kill_all
- Excel.excel_processes: yield Excel objects opened with RobustExcelOle
- Book.new: uplifting a WIN32OLE object to a Book object
- Subclassing for Sheet
- Method missing: error messages for dead objects
- trace to stdout or file

### Changed

## [0.3.5] - 2015-08-13

### Added
- Subclassing of Excel and Book
- Book#reopen: allows to reopen workbooks
- Book.inspect, Excel.inspect
- Excel#close
- Book_spec separated in managable pieces

### Changed
- removed cashing from Ranges.rb and Sheet.rb
- cells: (1,1) as origin (instead (0,0))
- bug fixes in application examples