Apply style for entire column without rows added

[csenszike]

I have to generate template XLSX with preformatted but empty cells (columns), so when a number is entered in such a cell my formatting applies.

As the example states it's not possible until rows are actually added to the sheet as I tried:

  wb.add_worksheet(name: 'Points') do |sheet|
    sheet.add_row [
      'Section [m]',
      'X',
      'Y',
      'Z',
      ], style: header
 
    sheet.col_style 0, s_number_section, row_offset: 1
  end

But adding N thousands of empty rows and generating a very big template file seems a bit ugly to me and will cause issues at the N*1000+1st row. Is there any reason it's not possible with the current library?

Thank you!

[sbpipb]

curious if a format column functionality is added. If not how did you resolve this problem. @csenszike

[lbraun]

@randym, is this kind of column formatting possible with the current implementation?

[souzagab]

+1

[luchhh]

+1

[luisgmartins]

+1

[simi]

Would anyone mind to por this to https://github.com/caxlsx/caxlsx if still needed?

[luisgmartins]

Opened in https://github.com/caxlsx/caxlsx/issues/159