Version History

1.3:

  • Added ExcelWriterDataValidation class.
  • Fixed inserting pictures from Xojo objects (PNG) (broke in version 1.2 but worked in 1.1)
  • Fixed inserting pictures from Xojo objects (JPG) (broke in version 1.2 but worked in 1.1)
  • ExcelWriterChartFont.Size property is now double instead of Int16 to enable floating point fonts.
  • ExcelWriterFormat.FontSize property is now double instead of Int16 to enable floating point fonts.
  • Added ApplyDataValidation methods (2 variations) to the ExcelWriterWorksheet class.
  • Added new example project for data validation.

    1.2:

  • Added missing Console safe flag on ExcelWriterWorkbook.Create shared method (both variations).
  • Added missing Console safe flag on ExcelWriterSheet.NameToRow shared method.
  • Added missing Console safe flag on ExcelWriterSheet.NameToColumn shared method.
  • Added missing Console safe flag on ExcelWriterSheet.NameToLastColumn shared method.

    1.1:

  • Added ExcelWriterChartFont class.
  • Added ChartAreaSetPattern method to the ExcelWriterChart class.
  • Added PlotAreaSetPattern method to the ExcelWriterChart class.
  • Added SetNameFont method to the ExcelWriterChart class.
  • Added SetNameFont method to the ExcelWriterAxis class.
  • Added SetNumberFont method to the ExcelWriterAxis class.
  • Added SetLegendFont method to the ExcelWriterChart class.
  • Added HideSpecificSeries method to the ExcelWriterChart class.
  • Added InvertIfNegative property to the ExcelWriterSeries class.
  • Added DoughnutHoleSize property to the ExcelWriterChart class.
  • Added PrintingSetRepeatColumns method to the ExcelWriterWorksheet class.
  • Added PrintingSetRepeatRows method to the ExcelWriterWorksheet class.

    1.0:

  • This is the first version.