using System;

using ClosedXML.Excel;





namespace ClosedXML_Examples.Misc

{

    public class AdjustToContents : IXLExample

    {

        #region Variables



        // Public



        // Private





        #endregion



        #region Properties



        // Public



        // Private



        // Override





        #endregion



        #region Events



        // Public



        // Private



        // Override





        #endregion



        #region Methods



        // Public

        public void Create(String filePath)

        {

            var wb = new XLWorkbook();

            var ws = wb.Worksheets.Add("Adjust To Contents");



            // Set some values with different font sizes

            ws.Cell(1, 1).Value = "Tall Row";

            ws.Cell(1, 1).Style.Font.FontSize = 30;

            ws.Cell(2, 1).Value = "Very Wide Column";

            ws.Cell(2, 1).Style.Font.FontSize = 20;

            

            // Adjust column width

            ws.Column(1).AdjustToContents();



            // Adjust row heights

            ws.Rows(1, 2).AdjustToContents();



            // You can also adjust all rows/columns in one shot

            // ws.Rows().AdjustToContents();

            // ws.Columns().AdjustToContents();





            // We'll now select which cells should be used for calculating the

            // column widths (same method applies for row heights)

            

            // Set the values

            ws.Cell(4, 2).Value = "Width ignored because calling column.AdjustToContents(5, 7)";

            ws.Cell(5, 2).Value = "Short text";

            ws.Cell(6, 2).Value = "Width ignored because it's part of a merge";

            ws.Range(6, 2, 6, 4).Merge();

            ws.Cell(7, 2).Value = "Width should adjust to this cell";

            ws.Cell(8, 2).Value = "Width ignored because calling column.AdjustToContents(5, 7)";



            // Adjust column widths only taking into account rows 5-7

            // (merged cells will be ignored)

            ws.Column(2).AdjustToContents(5, 7);



            // You can also specify the starting row to start calculating the widths:

            // e.g. ws.Column(3).AdjustToContents(9);



            var ws2 = wb.Worksheets.Add("Adjust Widths");

            ws2.Cell(1, 1).SetValue("Text to adjust - 255").Style.Alignment.TextRotation = 255;

            for (Int32 co = 0; co < 90; co += 5)

            {

                ws2.Cell(1, (co / 5) + 2).SetValue("Text to adjust - " + co).Style.Alignment.TextRotation = co;

            }



            ws2.Columns().AdjustToContents();



            var ws4 = wb.Worksheets.Add("Adjust Widths 2");

            ws4.Cell(1, 1).SetValue("Text to adjust - 255").Style.Alignment.TextRotation = 255;

            for (Int32 co = 0; co < 90; co += 5)

            {

                var c = ws4.Cell(1, (co / 5) + 2);

                

                c.RichText.AddText("Text to adjust - " + co).SetBold();

                c.RichText.AddText(Environment.NewLine);

                c.RichText.AddText("World!").SetBold().SetFontColor(XLColor.Blue).SetFontSize(25);

                c.RichText.AddText(Environment.NewLine);

                c.RichText.AddText("Hello Cruel and unsusual world").SetBold().SetFontSize(20);

                c.RichText.AddText(Environment.NewLine);

                c.RichText.AddText("Hello").SetBold();

                c.Style.Alignment.SetTextRotation(co);

            }

            ws4.Columns().AdjustToContents();



            var ws3 = wb.Worksheets.Add("Adjust Heights");

            ws3.Cell(1, 1).SetValue("Text to adjust - 255").Style.Alignment.TextRotation = 255;

            for (Int32 ro = 0; ro < 90; ro += 5)

            {

                ws3.Cell((ro / 5) + 2, 1).SetValue("Text to adjust - " + ro).Style.Alignment.TextRotation = ro;

            }



            ws3.Rows().AdjustToContents();



            var ws5 = wb.Worksheets.Add("Adjust Heights 2");

            ws5.Cell(1, 1).SetValue("Text to adjust - 255").Style.Alignment.TextRotation = 255;

            for (Int32 ro = 0; ro < 90; ro += 5)

            {

                var c = ws5.Cell((ro / 5) + 2, 1);

                c.RichText.AddText("Text to adjust - " + ro).SetBold();

                c.RichText.AddText(Environment.NewLine);

                c.RichText.AddText("World!").SetBold().SetFontColor(XLColor.Blue).SetFontSize(10);

                c.RichText.AddText(Environment.NewLine);

                c.RichText.AddText("Hello Cruel and unsusual world").SetBold().SetFontSize(15);

                c.RichText.AddText(Environment.NewLine);

                c.RichText.AddText("Hello").SetBold();

                c.Style.Alignment.SetTextRotation(ro);

            }



            ws5.Rows().AdjustToContents();



            wb.SaveAs(filePath);

        }



        // Private



        // Override





        #endregion

    }

}