class Xlsxrb::Ooxml::WorksheetWriter

# File lib/xlsxrb/ooxml/worksheet_writer.rb, line 14
def initialize(io)
  @io = io
  @builder = XmlBuilder.new(@io)
  @started = false
  @finished = false
end

# File lib/xlsxrb/ooxml/worksheet_writer.rb, line 388
def finish(drawing_rid: nil, sheet_protection: nil, auto_filter: nil,
           filter_columns: nil, sort_state: nil, merge_cells: nil,
           conditional_formats: nil, data_validations: nil,
           hyperlinks: nil, print_options: nil, page_margins: nil,
           page_setup: nil, header_footer: nil, row_breaks: nil,
           col_breaks: nil, tables: nil, table_start_rid: nil,
           legacy_drawing_rid: nil, sparkline_groups: nil)
  return if @finished

  start unless @started
  @finished = true
  @builder.close_tag("sheetData")

  # Elements must appear in OOXML specification order after sheetData
  write_sheet_protection(sheet_protection) if sheet_protection
  write_auto_filter(auto_filter, filter_columns, sort_state) if auto_filter
  write_merge_cells(merge_cells) if merge_cells && !merge_cells.empty?
  write_conditional_formatting(conditional_formats) if conditional_formats && !conditional_formats.empty?
  write_data_validations(data_validations) if data_validations && !data_validations.empty?
  write_hyperlinks(hyperlinks) if hyperlinks && !hyperlinks.empty?
  write_print_options(print_options) if print_options && !print_options.empty?
  write_page_margins(page_margins) if page_margins
  write_page_setup(page_setup) if page_setup && !page_setup.empty?
  write_header_footer(header_footer) if header_footer && !header_footer.empty?
  write_row_breaks(row_breaks) if row_breaks && !row_breaks.empty?
  write_col_breaks(col_breaks) if col_breaks && !col_breaks.empty?
  @builder.empty_tag("drawing", { "r:id": drawing_rid }) if drawing_rid
  @builder.empty_tag("legacyDrawing", { "r:id": legacy_drawing_rid }) if legacy_drawing_rid
  write_table_parts(tables, table_start_rid) if tables && !tables.empty?
  write_sparklines(sparkline_groups) if sparkline_groups && !sparkline_groups.empty?
  @builder.close_tag("worksheet")
end

# File lib/xlsxrb/ooxml/worksheet_writer.rb, line 28
def start(columns: [], sheet_properties: nil, freeze_pane: nil, split_pane: nil, selection: nil, sheet_view: nil)
  return if @started

  @started = true
  @builder.declaration
  @builder.open_tag("worksheet", { xmlns: SSML_NS, "xmlns:r": DOC_REL_NS })

  write_sheet_properties(sheet_properties) if sheet_properties && !sheet_properties.empty?
  write_sheet_views(freeze_pane: freeze_pane, split_pane: split_pane, selection: selection, sheet_view: sheet_view) if freeze_pane || split_pane || selection || (sheet_view && !sheet_view.empty?)
  write_columns(columns) unless columns.empty?

  @builder.open_tag("sheetData")
end

# File lib/xlsxrb/ooxml/worksheet_writer.rb, line 43
def write_row(row_index, cells, attrs: {}, unmapped: [], sst_index: nil)
  start unless @started

  row_num = row_index + 1
  row_num_str = row_num.to_s
  io = @io
  io.write("<row r=\"")
  io.write(row_num_str)
  io.write('"')
  if attrs[:height]
    io.write(' ht="')
    io.write(attrs[:height].to_s)
    io.write('" customHeight="1"')
  elsif attrs[:custom_height]
    io.write(' customHeight="1"')
  end
  io.write(' hidden="1"') if attrs[:hidden]
  if attrs[:outline_level]
    io.write(' outlineLevel="')
    io.write(attrs[:outline_level].to_s)
    io.write('"')
  end
  io.write(">")

  cells.each do |cell|
    if cell.is_a?(Hash)
      value = cell[:value]
      style_id = cell[:style_index]
      col_ref = cell[:ref] || "#{column_letter(cell[:column_index])}#{row_num_str}"
      formula = cell[:formula]
      formula_ca = cell[:formula_ca]
      cell_type_val = cell[:type]
    else
      value = cell.value
      style_id = cell.style_index
      col_ref = cell.ref || "#{column_letter(cell.column_index)}#{row_num_str}"
      formula = cell.formula
      formula_ca = false
      cell_type_val = nil
    end

    if value.nil? && formula.nil?
      io.write('<c r="')
      io.write(col_ref)
      io.write('"')
      if style_id
        io.write(' s="')
        io.write(style_id.to_s)
        io.write('"')
      end
      io.write("/>")
      next
    end

    if value.is_a?(String) && value.start_with?("=") && !formula
      formula = value
      value = nil
    end

    xml_val = value
    type = cell_type_val
    formula_expr = nil

    if formula
      if formula.is_a?(Xlsxrb::Elements::Formula)
        formula_expr = formula.expression
        formula_ca = formula.calculate_always
        xml_val = formula.cached_value || nil
      else
        formula_expr = formula
      end
      formula_expr = formula_expr[1..] if formula_expr.start_with?("=")
    end

    if !formula_expr && !type
      case value
      when String
        if sst_index && (idx = sst_index[value])
          xml_val = idx
          type = "s"
        else
          type = "inlineStr"
        end
      when Xlsxrb::Elements::RichText
        if sst_index && (idx = sst_index[value])
          xml_val = idx
          type = "s"
        else
          type = "inlineStr"
          xml_val = value
        end
      when true
        xml_val = "1"
        type = "b"
      when false
        xml_val = "0"
        type = "b"
      when Date
        xml_val = Xlsxrb::Ooxml::Utils.date_to_serial(value)
      when Time
        xml_val = Xlsxrb::Ooxml::Utils.datetime_to_serial(value)
      end
    end

    io.write('<c r="')
    io.write(col_ref)
    io.write('"')
    if style_id
      io.write(' s="')
      io.write(style_id.to_s)
      io.write('"')
    end
    if type
      io.write(' t="')
      io.write(type)
      io.write('"')
    end

    if type == "inlineStr"
      if xml_val.is_a?(Xlsxrb::Elements::RichText)
        io.write("><is>")
        xml_val.runs.each do |run|
          font = run[:font]
          if font && !font.empty?
            io.write("<r><rPr>")
            io.write("<b/>") if font[:bold]
            io.write("<i/>") if font[:italic]
            io.write("<strike/>") if font[:strike]
            if font[:underline]
              if font[:underline] == true
                io.write("<u/>")
              else
                io.write("<u val=\"#{font[:underline]}\"/>")
              end
            end
            io.write("<vertAlign val=\"#{font[:vert_align]}\"/>") if font[:vert_align]
            io.write("<sz val=\"#{font[:sz]}\"/>") if font[:sz]
            if font[:color]
              io.write("<color rgb=\"#{font[:color]}\"/>")
            elsif font[:theme]
              tint_attr = font[:tint] ? " tint=\"#{font[:tint]}\"" : ""
              io.write("<color theme=\"#{font[:theme]}\"#{tint_attr}/>")
            end
            io.write("<rFont val=\"#{escape_xml(font[:name])}\"/>") if font[:name]
            io.write("<family val=\"#{font[:family]}\"/>") if font[:family]
            io.write("<scheme val=\"#{font[:scheme]}\"/>") if font[:scheme]
            io.write("</rPr><t>")
          else
            io.write("<r><t>")
          end
          io.write(escape_xml(run[:text]))
          io.write("</t></r>")
        end
        io.write("</is></c>")
      else
        io.write("><is><t>")
        io.write(escape_xml(xml_val.to_s))
        io.write("</t></is></c>")
      end
    elsif formula_expr
      if formula_ca
        io.write('><f ca="1">')
      else
        io.write("><f>")
      end
      io.write(escape_xml(formula_expr))
      io.write("</f>")
      if xml_val
        io.write("<v>")
        io.write(xml_val.to_s)
        io.write("</v></c>")
      else
        io.write("</c>")
      end
    else
      io.write("><v>")
      io.write(xml_val.to_s)
      io.write("</v></c>")
    end
  end

  unmapped.each { |node| @builder.write_unmapped(node) }

  io.write("</row>")
end

# File lib/xlsxrb/ooxml/worksheet_writer.rb, line 230
def write_row_values(row_index, values, styles: nil, style_map: nil, sst: nil, sst_index: nil, attrs: nil)
  start unless @started

  row_num = row_index + 1
  row_num_str = row_num.to_s
  style_lookup_enabled = styles && style_map && (styles.is_a?(Array) || styles.is_a?(Hash))
  io = @io
  io.write("<row r=\"")
  io.write(row_num_str)
  io.write('"')
  if attrs
    if attrs[:height]
      io.write(' ht="')
      io.write(attrs[:height].to_s)
      io.write('" customHeight="1"')
    end
    io.write(' hidden="1"') if attrs[:hidden]
    if attrs[:outline_level]
      io.write(' outlineLevel="')
      io.write(attrs[:outline_level].to_s)
      io.write('"')
    end
  end
  io.write(">")

  col_index = 0
  while col_index < values.length
    value = values[col_index]
    style_id = nil
    if style_lookup_enabled
      style_name = styles[col_index]
      style_id = style_map[style_name] if style_name
    end

    col_ref = column_letter(col_index)

    if value.nil?
      if style_id
        io.write('<c r="')
        io.write(col_ref)
        io.write(row_num_str)
        io.write('" s="')
        io.write(style_id.to_s)
        io.write('"/>')
      end
      col_index += 1
      next
    end

    # Auto-convert string starting with '=' to formula
    if value.is_a?(String) && value.start_with?("=")
      formula_expr = value
      xml_val = nil
    else
      formula_expr = nil
      xml_val = value
    end

    type = nil
    formula_ca = false

    case value
    when Xlsxrb::Elements::Formula
      formula_expr = value.expression
      formula_ca = value.calculate_always
      xml_val = value.cached_value
      case value.cached_value
      when String
        type = "str"
      when true
        type = "b"
        xml_val = "1"
      when false
        type = "b"
        xml_val = "0"
      end
    when String
      if value.start_with?("=")
        # already set formula_expr
      else
        idx = sst_index[value]
        unless idx
          sst << value
          idx = sst.size - 1
          sst_index[value] = idx
        end
        xml_val = idx
        type = "s"
      end
    when Xlsxrb::Elements::RichText
      idx = sst_index[value]
      unless idx
        sst << value
        idx = sst.size - 1
        sst_index[value] = idx
      end
      xml_val = idx
      type = "s"
    when true
      xml_val = "1"
      type = "b"
    when false
      xml_val = "0"
      type = "b"
    when Date
      xml_val = Xlsxrb::Ooxml::Utils.date_to_serial(value)
    when Time
      xml_val = Xlsxrb::Ooxml::Utils.datetime_to_serial(value)
    when Xlsxrb::Elements::CellError
      xml_val = value.code
      type = "e"
    end

    formula_expr = formula_expr[1..] if formula_expr&.start_with?("=")

    io.write('<c r="')
    io.write(col_ref)
    io.write(row_num_str)
    io.write('"')
    if style_id
      io.write(' s="')
      io.write(style_id.to_s)
      io.write('"')
    end
    if type
      io.write(' t="')
      io.write(type)
      io.write('"')
    end
    if formula_expr
      if formula_ca
        io.write('><f ca="1">')
      else
        io.write("><f>")
      end
      io.write(escape_xml(formula_expr))
      io.write("</f>")
      if xml_val
        io.write("<v>")
        io.write(xml_val.to_s)
        io.write("</v></c>")
      else
        io.write("</c>")
      end
    else
      io.write("><v>")
      io.write(xml_val.to_s)
      io.write("</v></c>")
    end

    col_index += 1
  end

  io.write("</row>")
end