Number Stored as Text

[sdahlbac]

Using the following code:

require 'axlsx'

Axlsx::Package.new do |p|
  p.workbook.add_worksheet(name: 'Numbers as text') do |sheet|
    sheet.add_row %w(Number As\ text)
    sheet.add_row([42, 42], types: [nil, :string])
  end
  p.serialize('numbers_as_text.xlsx')
end

At least Excel for Mac 15.33 shows "Number Stored as Text" warning for the second column. For my purpose, the numbers should be stored as text, but I would like to get rid of the warning. Is it possible?

axlsx-2.0.1

[vinayverghese]

@randym Is there a solution for this? I tried playing around with num_fmt and format_code but the warning always appears.

[chaskett]

I am also experiencing this problem.