Forums | Admin Discussion Forums: help Start New Thread Nested Flat Threaded Ultimate Show 25 Show 50 Show 75 Show 100   By: Tetsuya Takahashi RE: Cant seem to get Font format to work. [ reply ]   2012-02-14 05:39 Create a new book case is OK. [code] book = Spreadsheet::Workbook.new sheet = book.create_worksheet :name => 'Sheet1' sheet[0,0] = 'Test' format = Spreadsheet::Format.new :color=> :blue, :pattern_fg_color => :red, :pattern => 1,:size => 18 sheet.row(0).set_format(0, format) [/code] But The case using a　template file was not ok. [code] book = Spreadsheet.open('public/excel/template.xls') sheet = book.worksheet('Sheet1') sheet[0,0] = 'Test' format = Spreadsheet::Format.new :color=> :blue, :pattern_fg_color => :red, :pattern => 1,:size => 18 sheet.row(0).set_format(0, format) #NG [/code] please help me,thanks. By: Tetsuya Takahashi Cant seem to get Font format to work. [ reply ]   2012-02-14 02:57 My code doesn't work. I am using Spreadheet 0.6.5.9 and ruby 1.9.2 on Rails 3.0.9 and Windows XP sp3. [code] sheet[0,0] = 'Test' #OK format = Spreadsheet::Format.new :color=> :blue, :pattern_fg_color => :red, :pattern => 1,:size => 18 sheet.row(0).set_format(0, format) #NG [/code] please help me,thanks.