Column.cs

/*
 * NanoXLSX is a small .NET library to generate and read XLSX (Microsoft Excel 2007 or newer) files in an easy and native way  
 * Copyright Raphael Stoeckli © 2025
 * This library is licensed under the MIT License.
 * You find a copy of the license in project folder or on: http://opensource.org/licenses/MIT
 */
 
using NanoXLSX.Exceptions;
using NanoXLSX.Styles;
using NanoXLSX.Utils;
 
namespace NanoXLSX
{
    public class Column
    {
        private int number;
        private string columnAddress;
        private float width;
        private Style defaultColumnStyle;

        public string ColumnAddress
        {
            get { return columnAddress; }
            set
            {
                if (string.IsNullOrEmpty(value))
                {
                    throw new RangeException("The passed address was null or empty");
                }
                number = Cell.ResolveColumn(value);
                columnAddress = ParserUtils.ToUpper(value);
            }
        }

        public bool HasAutoFilter { get; set; }
        public bool IsHidden { get; set; }

        public int Number
        {
            get { return number; }
            set
            {
                columnAddress = Cell.ResolveColumnAddress(value);
                number = value;
            }
        }

        public float Width
        {
            get { return width; }
            set
            {
                if (value < Worksheet.MinColumnWidth || value > Worksheet.MaxColumnWidth)
                {
                    throw new RangeException("The passed column width is out of range (" + Worksheet.MinColumnWidth + " to " + Worksheet.MaxColumnWidth + ")");
                }
                width = value;
            }
        }

        public Style DefaultColumnStyle
        {
            get { return this.defaultColumnStyle; }
        }

        public Style SetDefaultColumnStyle(Style defaultColumnStyle, bool unmanaged = false)
        {
            if (defaultColumnStyle == null)
            {
                this.defaultColumnStyle = null;
                return null;
            }
            if (unmanaged)
            {
                this.defaultColumnStyle = defaultColumnStyle;
            }
            else
            {
                this.defaultColumnStyle = StyleRepository.Instance.AddStyle(defaultColumnStyle);
            }
            return this.defaultColumnStyle;
        }

        private Column()
        {
            Width = Worksheet.DefaultWorksheetColumnWidth;
            defaultColumnStyle = null;
        }

        public Column(int columnCoordinate) : this()
        {
            Number = columnCoordinate;
        }

        public Column(string columnAddress) : this()
        {
            ColumnAddress = columnAddress;
        }

        internal Column Copy()
        {
            Column copy = new Column
            {
                IsHidden = this.IsHidden,
                Width = this.width,
                HasAutoFilter = this.HasAutoFilter,
                columnAddress = this.columnAddress,
                number = this.number,
                defaultColumnStyle = this.defaultColumnStyle
            };
            return copy;
        }
 
    }
}