adamhunter/spreadsheet — Issue #2: set_format don't work in existing workbook
Author: markd2lp
Created: 2012-01-31 19:26:51+00:00
State: open

I have this code:

book = Spreadsheet.open "#{Rails.root.to_s}/public/modelos/geral.xls"
sheet = book.worksheet 0

But when i try change some format, like border collumn, dont work.

format = Spreadsheet::Format.new(:border => true)
sheet.row(x).set_format(y, format)

I saw that font weight was change to bold, but it dont was in format, and dont create any border.

Spreadsheet: 0.6.8
Rails: 3.0.9
Ruby: 1.8.7