Contents

# frozen_string_literal: true

require_relative './xlsx-func-testcase'

class TestOptimize < XlsxWriterTestCase
  test('optimize01', constant_memory: true) do |wb|
    wb.add_worksheet
      .write_string(0, 0, 'Hello', nil)
      .write_string(0, 0, 'Hello', nil)
      .write_number(1, 0, 123, nil)
  end

  test('optimize02', constant_memory: true) do |wb|
    wb.add_worksheet
      .write_string(0, 0, 'Hello', nil)
      .write_number(1, 0, 123, nil)
      .write_string(0, 'G', 'World', nil)
    # G1 should be ignored since a later row has already been written.
  end

  test('optimize06', constant_memory: true) do |wb|
    ws = wb.add_worksheet
    ws.write_string(0, 0, '_x0000_', nil)
    (1..127).each { |i| ws.write_string(i, 0, i.chr, nil) unless i == 34 }
  end

  test('optimize21', constant_memory: true) do |wb|
    wb.add_worksheet
      .write_string(0, 'A', 'Foo', nil)
      .write_string(2, 'C', ' Foo', nil)
      .write_string(4, 'E', 'Foo ', nil)
      .write_string(6, 'A', "\tFoo\t", nil)
  end

  test('optimize22', constant_memory: true) do |wb|
    wb
      .add_format(:bold, bold: true)
      .add_worksheet
      .set_column(0, 0, width: 36, format: :bold)
  end

  test('optimize23', constant_memory: true) do |wb|
    wb
      .add_format(:bold, bold: true)
      .add_worksheet
      .set_row(0, height: 20, format: :bold)
  end

  test('optimize24', constant_memory: true) do |wb|
    wb
      .add_format(:bold, bold: true)
      .add_worksheet
      .set_row(0, height: 20, format: :bold)
      .write_string(0, 0, 'Foo')
  end

  test('optimize25', constant_memory: true) do |wb|
    wb
      .add_format(:bold, bold: true)
      .add_worksheet
      .set_row(0, height: 20, format: :bold)
      .write_string(2, 0, 'Foo')
  end

  test('optimize26', constant_memory: true) do |wb|
    wb.add_worksheet.write_string(2, 2, 'café')
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
xlsxwriter-0.2.0.pre	test/test-optimize.rb