# File lib/spreadsheet/excel/writer/worksheet.rb, line 456 def write_from_scratch # ● BOF Type = worksheet (➜ 5.8) write_bof # ○ UNCALCED ➜ 5.105 # ○ INDEX ➜ 4.7 (Row Blocks), ➜ 5.59 # ○ Calculation Settings Block ➜ 4.3 write_calccount write_refmode write_iteration write_saverecalc # ○ PRINTHEADERS ➜ 5.81 # ○ PRINTGRIDLINES ➜ 5.80 # ○ GRIDSET ➜ 5.52 # ○ GUTS ➜ 5.53 write_guts # ○ DEFAULTROWHEIGHT ➜ 5.31 write_defaultrowheight # ○ WSBOOL ➜ 5.113 write_wsbool # ○ Page Settings Block ➜ 4.4 # ○ Worksheet Protection Block ➜ 4.18 write_proctection # ○ DEFCOLWIDTH ➜ 5.32 write_defcolwidth # ○○ COLINFO ➜ 5.18 write_colinfos # ○ SORT ➜ 5.99 # ● DIMENSIONS ➜ 5.35 write_dimensions # ○○ Row Blocks ➜ 4.7 write_rows # ● Worksheet View Settings Block ➜ 4.5 # ● WINDOW2 ➜ 5.110 write_window2 # ○ SCL ➜ 5.92 (BIFF4-BIFF8 only) # ○ PANE ➜ 5.75 # ○○ SELECTION ➜ 5.93 # ○ STANDARDWIDTH ➜ 5.101 # ○○ MERGEDCELLS ➜ 5.67 write_merged_cells # ○ LABELRANGES ➜ 5.64 # ○ PHONETIC ➜ 5.77 # ○ Conditional Formatting Table ➜ 4.12 # ○ Hyperlink Table ➜ 4.13 write_hyperlink_table # ○ Data Validity Table ➜ 4.14 # ○ SHEETLAYOUT ➜ 5.96 (BIFF8X only) # ○ SHEETPROTECTION Additional protection, ➜ 5.98 (BIFF8X only) # ○ RANGEPROTECTION Additional protection, ➜ 5.84 (BIFF8X only) # ● EOF ➜ 5.36 write_eof end